I Video Excel Online Structured Activity: Adjusted Present Value Schwarzentraub Industries' expected free cash flow for the year is $500,000, in the future, free cash flow is expected to grow at a rate of 10%. The company currently has no debt, and its cost of equity is 14 The tax rate is 40%. (Hint: Use the equations mentioned below.) TD % Vu 4 TALPA + PU- 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. Open spreadsheet Find Vor Enter your answer in millions. For example, an answer of s1.21 million should be entered at 1.21, not 1.220,000. Do not round intermediate calculations, Round your answer to two decimal places $ million b. Find V If Schwarzentroubutes 54 million in debt with a cost of 7%. Use the APV model that allows for growth. Enter your answer in milions, 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 Findful Do not round intermediate calculations. Round your answer to one decimal place. 6. Based on V, from part a, find using the MM model (with taxes) If Schwarzantraub uses 54 million in 75 debt. Inter your answer in milions. For example, Open spreadsheet a. Find Vu 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 $ mation b. Find V If Schwarzentraub uses 54 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 raDo not round Intermediate calculations. Round your answer to one decimal place c. Based on Vy from parta, find using the MM model (with taxes) Schwarzentrauduses 54 million in 7% debt. 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 Find . Do not round Intermediate calculations. Round your answer to one decimal place. 5 Check My Work Reset