Please complete all of the following fields with formulas in excel..

FINA 4001 Professor Altnkl Assignment 1. CAPM and WACC in valuation CHATGLOBAL's has perpetual earnings before interest and taxes of $450, the corporate tax rate is 40%. CHATGLOBAL uses a debt-to-equity ratio of 0.75. The debt is priced to yield the risk-free rate of interest. CHATGLOBAL's depreciation expenses are not tax deductible and just offset capital expenditures in each year, and changes in working capital are zero. CHATGLOBAL has a 100% payout policy. The risk-free interest rate is 8% and the \"market premium\" (market rate less the risk-free rate) is 8.5%. We don't know CHATGLOBAL's asset beta, but we believe Comp Co.'s assets have the same risk as CHATGLOBAL. We know the following about Comp Co.: it debt value is $13,945, its market value of equity value is $7,000, its tax rate is 36%, its debt beta is 0.3725, and its equity beta is 1.80. (Note: The expected return on any asset i can be measured using the CAPM, R i RF [R M RF ] , where RM - RF is the \"market premium\".) A. Complete the following table entries (Excel is available on the course web page). 1 FINA 4001 Professor Altnkl 0 End of year 1 2 3 4 annual cash flows EBIT interest EBT Taxes NI Dep CAPEX Change in WC Avail cash flow Equity cash flow annual debt schedule Beginning debt Principal payments Debt terminal value estimates Firm Value Debt Equity annual discounting Debt/capital Equity/capital Asset beta All equity W ACC Debt beta Equity beta Cost of equity Cost of debt W ACC-cost of capital $450.00 $450.00 $450.00 $450.00 2 Valuation problem End of year 0 1 2 3 4 annual cash flows EBIT interest EBT Taxes NI Dep CAPEX Change in WC Avail cash flow Equity cash flow annual debt schedule Beginning debt Debt terminal value estimates Firm Value Debt Equity 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 $450.00 $450.00 $450.00 $450.00