Excel Online Structured Activity: Adjusted Present Value Schwarzentraub Industries' expected free cash Now for the year is $650,000; in the future, free cash flow is expected to grow at a rate of 9%. The company currently has no debt, and its cost of equity is 13%. Its tax rate is 40%. (Hint: Use the equations mentioned below.) V. V + TATD TU - 9 TL Tau + The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. HIHI Open spreadsheet a. Find Vy. Enter your answer in millions. For example, an answer of 51.21 million should be entered as 1.21, not 1,210,000. Do not round intermediate calculations. Round your answer to two decimal places, million million b. Find V If Schwarzentraub uses $7 million in debt with a cost of 7%. Use the APV model that allows for growth. Enter your answer in millions. For example, an answer of $1.21 million should be entered as 1.21, not 1,210,000. Do not round intermediate calculations. Round your answer to two decimal places. million Find rs. Do not round intermediate calculations. Round your answer to one decimal place. % C. Based on Vy from part a, find using the MM modet (with taxes) ir Schwarzentraub uses $7 million in 7% debt. Enter your answer in millions. For example, an answer of $1.21 million should be entered as 1.21, not 1,210,000. Do not round Intermediate calculations. Round your answer to two decimal places. $ million Find You. Do not round Intermediate calculations. Round your answer to one decimal place. 94 Check My Work Reset Problem $650,000 9.00% 13.00% 40.00% $7,000,000 7.00% 2 3 Expected free cash flow, CF 4 FCF growth rate, 9 5 Cost of equity, 6 Tax rate, T 7 Debt, D 8 Cost of debt, 9 10 No Debt Case: 11 V- 12 13 With Debt Case: 14 V 15 16 TAL 17 11 MM (with Taxes) 19 V 20 S Formulas NNIA WNIA WAS MNIA WNIA WNIA Sheet1