Input Area: $ CO g1 92 From Year 1 to Year 5, we have g1, 11%, after Year 5, we have 92, 4%. Current cash flow from assets Initial growth rate in CFA Terminal CFA growth rate Orca WACC Shark WACC Shares outstanding Debt value 6,800,000 11% 4% 12% 10% 2.300.000 50,000,000 WACC Number of shares outstanding Debt $ Output Area: C1 CO"(1.91) CO*(1+91)^2 C2 Cash flows: Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 C3 C4 C5 C6 C5' (1.92) TV5 - C6/(WACC.92) P5 D6(R.9) Teminal value Value of company today Value of equity =npv(wacc,D76:E75 NPV use the NPV function, rate is the WACC, Cash flows are from C1, C2, C3, C4, C5. TV Equity = NPV - debt Share price Equity / Number of shares outstanding