Question: Please show the steps in excel! Nm 2 Year 3 1995 4 1996 5 1997 6 1998 7 1999 8 2000 9 2001 10 2002
Please show the steps in excel!

Nm 2 Year 3 1995 4 1996 5 1997 6 1998 7 1999 8 2000 9 2001 10 2002 11 12 Share price, end of 2002 13 Number of shares 14 Cinema Market Value 15 16 Dividend compound growth rate 17 Cost of equity, le 18 Dividend Total per share dividends 0.25 $1,075,000.00 0.25 $1,075,000.00 0.3 $1,255,500.00 0.31 $1,297,350.00 0.35 $1,394,750.00 0.37 $1,430,050.00 0.39 $1,507,350.00 0.42 $1,623,300.00 Number of Payments share from share Total payments repurchases repurchases to shareholders 0 $0.00 $1,075,000.00 115,000 $140,000.00 $1,215,000.00 0 $0.00 $1,255,500.00 200,000 $260,000.00 $1,557,350.00 120,000 $180,000.00 $1,574,750.00 0 $0.00 $1,430,050.00 0 $0.00 $1,507,350.00 120,000 $220,000.00 $1,843,300.00 1.83 3,745,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
