a. Find Vy. 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 $ 13.75 million b. Find Schwarzentraub uses $8 million in debt with a cost of 6%. 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 . Do not round intermediate calculations. Round your answer to one decimal ploce. 5 c. Based on Vy from parta, find using the MM model (with taxes) Swarzentraub unes i milioni 6% debt Enter your answer in ons. For example, answer of $1.21 million should be entered as 1.21, not 1,210,000. Do not round intermediate calculations. Round your awer to two decals $ million Find Do not found intermediate calculations. Round your answer to one decimal place Check My Work Reset Problem B D D $550,000 9.00% 13.00% 40.00% $8,000,000 6.00% A 1 Adjusted Present Value 2 3 Expected free cash flow, CF 4 FCF growth rate, g 5 Cost of equity, su 6 Tax rate, T 7 Debt, D 8 Cost of debt, rd 9 10 No Debt Case: 11 Vu= 12 13 With Debt Case: 14 VL= 15 S = 16 ISL 17 18 MM Model (With Taxes) 19 VE 20 S = Formulas #N/A #N/A #N/A #N/A #N/A #N/A 21 TL = #N/A 22 1 Video Excel Online Structured Activity: Adjusted Present Value Schwarzentraub Industries' expected free cash flow for the year is $550,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.) TTD V. V + EU- Tatu+ - 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 spreadshe Find V. Enter your answer in milliona. Por 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 5 13,75 million b. Find Vf Schwarzentraub uses 58 million in debt with a cost of 6%. Use the APV model that allows for growth. Enter your answer in millions. For example, an unswer of $1.21 million should be entered as 1.21. not 1,210,000. Do not round intermediate calculations. Round your answer to two decal places
