Select Page
QuestionsCategory: Financials QuadrantFinancial Analysis Excel Sheet
Amanda Ong asked 2 years ago

Hi, with respect to the excel sheet, when inputting the share price values for years 1-10, should we use the share price values of the last date of each financial year from years 1-10?

3 Answers
Jieren Zheng answered 2 years ago

You can use the share price of the date of the financial reporting for the annual report etc, which is usually the last date of the financial year.
Hope it helps.

Victor Chng replied 2 years ago

Thanks JR

Victor Chng answered 2 years ago

Hi Amanda,
you can also use the average price of the year. 

Adeline Ling answered 1 year ago

Hi Victor, when you say use the average price of the year, does it mean I need to find the closing price of each day and divide the number of trading days in that year? Thank you.

Victor Chng replied 1 year ago

Hi Adeline,

Yes, you are right.