60.1K

Verified Solution

Link Copied!

please solve using excel and show formulas! thank you!

Please solve using excel with formulas! Thank you! Valuation Methede-Equlvalence 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. Please solve using excel with formulas! Thank you! Valuation Methede-Equlvalence 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

Answer & Explanation Solved by verified expert

See Answer