Schweinstes espected free cash flow to the years $500,000 in the future, rush is expected the greater The company and cont of the lowest mentioned below TD V: 16+ The data astronoted in the Microsoft Excel Online.com the end to them to the western Opera ried to your wer in the Forecast ft.2 million to be seed 1.2, 1.0.0.0 fet round were station. Found yw weet wat rad Schwarzerwandelt with the throwi wynowe, antrent te ww. stron . Den rond de teid vower to decimal Con trompetes de totes and 13. rund Intermediate, and your owe to we decimal 1 Dodaten dute 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%. Its tax rate is 40%. (Hint: Use the equations mentioned below.) TATD V m Vu + Tiu 9 TL TU + + (ru---)? 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 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. $ million b. Find Vit Schwarzentraub uses $4 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 HAR 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. $ million b. Find V, if Schwarzentraub uses $4 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 Est Do not round intermediate calculations. Round your answer to one decimal place. 96 c. Based on Vy from part a, find V, using the MM model (with taxes) if Schwarzentraub uses $4 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 Horimal hlarac Alnut O
