Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel Online Structured Activity: Adjusted Present Value Schwarzentraub Industries' expected free cash flow for the year is $ 5 5 0 , 0 0 0

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 8%. The company currently has no debt, and its cost of equity is 12%. Its tax rate is 40%.(Hint: Use the equations mentioned below.)
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.
"Adjusted Present Value
Expected free cash flow, CF $550,000
FCF growth rate, g 8.00%
Cost of equity, rsU 12.00%
Tax rate, T 40.00%
Debt, D $8,000,000
Cost of debt, rd 9.00%
No Debt Case: Formulas
VU = #N/A
With Debt Case:
VL = #N/A
S = #N/A
rsL = #N/A
MM Model (With Taxes)
VL = #N/A
S = #N/A
rsL = #N/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.
$ fill in the blank ______ million
Find VL if Schwarzentraub uses $8 million in debt with a cost of 9%. 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.
$ fill in the blank _____ million
Find rsL. Do not round intermediate calculations. Round your answer to one decimal place.
fill in the blank ____%
Based on VU from part a, find VL using the MM model (with taxes) if Schwarzentraub uses $8 million in 9% 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.
$ fill in the blank ____ million
Find rsL. Do not round intermediate calculations. Round your answer to one decimal place.
fill in the blank ___%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cases In Healthcare Finance

Authors: Louis Gapenski

5th Edition

1567936113, 978-1567936117

More Books

Students also viewed these Finance questions

Question

Explain all drawbacks of application procedure.

Answered: 1 week ago

Question

Is the style consistent?

Answered: 1 week ago

Question

Does your strategic intent play to your strengths?

Answered: 1 week ago