Find:

• NPV
• APV
• FTE
• CCF
• NPVF

Of the following company's excel sheet using formulas on excel.

Valuation problem End of year 0 1 2 3 4 annual cash flows Avail cash flow 450 67.71 382.29 152.916 229.374 0 0 0 229.374 450 67.71 382.29 152.916 229.374 0 0 0 229.374 450 67.71 382.29 152.916 229.374 0 0 0 229.374 450 67.71 382.29 152.916 229.374 0 0 0 229.374 Equity cash flow 229.374 229.374 229.374 229.374 Beginning debt 846.39 846.39 846.39 846.39 Debt 846.39 846.39 846.39 846.39 EBIT interest EBT Taxes NI Dep CAPEX Change in WC annual debt schedule terminal value estimates Firm Value Debt Equity 1974.92 1974.92 1974.92 1974.92 846.394286 846.394286 846.394286 846.394286 1128.52571 1128.52571 1128.52571 1128.52571 annual discounting Debt/capital Equity/capital Asset beta All equity WACC Debt beta Equity beta Cost of equity Cost of debt WACC-cost of capital 0.42857143 0.42857143 0.42857143 0.42857143 0.57142857 0.57142857 0.57142857 0.57142857 1 2 3 4 0.165 0.165 0.165 0.165 0 1.45 0.20325 0 2.45 0.20325 0 3.45 0.20325 0 4.45 0.20325 0.08 0.13671 0.08 0.13671 0.08 0.13671 0.08 0.13671 total capital 8.0% 8.5% 40% 0.75 1 0.75 1.75 equity beta 0 k Free Rate of Interest Market Premium Corporate Tax Rate Debt to Equity Ratio if equity Debt