Select Page

Financial Analysis Excel Sheet

Questions › Category: Financials Quadrant › Financial Analysis Excel Sheet
0 Vote Up Vote Down
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?
Thanks!

3 Answers
0 Vote Up Vote Down
Jieren Zheng answered 2 years ago

Hi,
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

0 Vote Up Vote Down
Victor Chng answered 2 years ago

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

0 Vote Up Vote Down
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.