please use excel with formulas to solve problems. thank you!

Valuation Methods - Equivalence of WACC, APV, CCF 1. Calculate the WACC and the firm value based on the WACC method. It will be necessary to calculate the firm value (and hence the debt ratio) and the WACC for each year. 2. Calculate the unlevered cost of equity, ku, and the firm value based on the APV method, assuming ITS has the same risk as the unlevered firm. 3. Calculate the firm value based on the APV method, assuming ITS has the same risk as the debt. 4. Calculate the CCF and the firm value based on the CCF method. 5. Confirm that the results from the three methods in i), iii), and iv) are identical