Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please assist with solving problem in excel: Year 0 1 Revenue 630.00 Fixed costs 120.00 Variable costs 200.00 Add. investment in NWC 10.00 Add. investment
Please assist with solving problem in excel:
Year | 0 | 1 | |
Revenue | 630.00 | ||
Fixed costs | 120.00 | ||
Variable costs | 200.00 | ||
Add. investment in NWC | 10.00 | ||
Add. investment in operating long-term assets | 70.00 | ||
Depreciation | 60.00 | ||
Interest expenses | 35.00 | ||
Newly issued debt | 25.00 | ||
Principle repayments | 15.00 | ||
Market value of the firm: | Price | ||
per share | No. of shares | Market value | |
Short-term debt | 100.00 | ||
Long-term debt | 600.00 | ||
Preferred stock | 10.00 | 10 | 100.00 |
Common stock | 18.00 | 100 | 1,800.00 |
Total | 2,600.00 | ||
Cost of equity (Rs) | 0.1400 | ||
Tax rate | 0.40 | ||
Growth rate per year from year 1 through year 5 | 0.12 | ||
Growth rate after year 5 | 0.05 |
Based on the equity free cash flow model, what is the price per share for the common stock?
Select one:
a. 10.98
b. 14.34
c. 12.45
d. 16.39
Correct answer is 16.39
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started