what are the formulas for the highlighted cells

Tax rate Interest expense Net income Expected future free cash flows Yea r expected (projected) FCF (millions) Long-term growth rate rs (required return on stock) WACC Horizon value Vops (millions) short-term investments intrinsic value of firm all debt intrinsic value of equity intrinsic price per share Optimal Capital Structure Note: Check figures are rounded. You need to calculate full precision values. Part 1. Current capital structure Current company information Market value of debt Sloo million Short-term investments $50 million Shares outstanding 10 million rd (interest rate on debt currently) 6 25.00% $30.00 11.00 million million million per share 13.00 Debt x rd I'm sure you know how to calculate Net income. There is no interest income or non-operating items. 189009. I'm sure you know how to calculate earnings per share. 15.00 17.00 wd from val #DlV/o! 9.6400% calculate the WACC HV5 = 54165 Horizon value as of Year 5 assuming constant growth after year 5. HV5. 3976 Present value of FCFs and the horizon value. Use the NPV functiom Just cell reference pointing to short-term investments Just cell reference pointing to the current amount of debt