Please solve using Excel for the correct answer.

Year Revenue Fixed costs Variable costs Add. investment in NWC Add. investment in operating long-term assets Depreciation Interest expenses Newly issued debt Principle repayments Market value of the firm: Short-term debt Long-term debt Common stock Cost of equity (Rs) Tax rate Growth rate per year from year I through year Growth rate after year 5 630.00 120.00 200.00 10.00 70.00 60.00 35.00 25.00 15.00 Price per share No. of shares Market value 200.00 600.00 1 uo.oc 200.00 18.00 0.1400 0.12 0.05 Based on the equity free cash flow model, what is the price per share for the common stock? Select one: 16.39 a. 14.34 10.98 x . 1245 The correct answer is: 16.39