Select Page
QuestionsCategory: Financials QuadrantFinancial Analysis Excel Sheet
Amanda Ong asked 1 year 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 1 year 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 1 year ago

Thanks JR

Victor Chng answered 1 year ago

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

Adeline Ling answered 3 months 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 3 months ago

Hi Adeline,

Yes, you are right.