Answered step by step
Verified Expert Solution
Question
1 Approved Answer
From the information below provides a thorough and detailed synthesis of the purpose of their report, the results of their financial analysis of the company's
From the information below provides a thorough and detailed synthesis of the purpose of their report, the results of their financial analysis of the company's short- and long-term capital budget needs, and their recommendations for how the company can raise money in the short-term and long-term to continue to add value to the organization.
CAPM and Required Return | |
Market Beta | 1.0 |
Required Return | 11% |
Risk-Free Rate | 4.50% |
Market Premium | 6.50% |
EARLS BR | |
Risk-Free Rate | 4.50% |
Market Premium | 6.50% |
Company Beta | 1.1 |
Required Return | 11.65% |
Closet Competitor F BREWERY | |
Risk-Free Rate | 4.50% |
Market Premium | 6.50% |
Competitor's Beta | 0.30 |
Required Return | 6.45% |
Difference in Required Return | |
5.20% |
Constant Growth Valuation | |
Expected Dividend | $1.80 |
Constant Growth | 4% |
Required Rate of Return | 10% |
Current Value per Share | $30.00 |
Weighted Average Cost of Capital | |
Debt | 35% |
Common Equity | 65% |
Cost of Debt | |
Tax Rate | |
Current Stock Price | |
Last Dividend Paid | |
Expected Constant Growth | |
Next Dividend | |
Internal Equity | |
WACC |
Capital Budgeting Criteria | ||||||||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ||||||
Project A | ($300) | ($387) | ($193) | ($100) | $600 | $600 | $850 | ($180) | ||||||
Project B | ($405) | ($134) | $134 | $134 | $134 | $134 | $134 | $0 | ||||||
Difference | ($105) | ($521) | ($327) | ($234) | $466 | $466 | $716 | ($180) | ||||||
WACC | 11% | WACC | 18% | |||||||||||
NPV @ 11% | NPV @ 18% | |||||||||||||
Project A | $240.64 | Project A | $2.66 | |||||||||||
Project B | ($79.55) | Project B | ($163.44) | |||||||||||
IRR @ 11% | ||||||||||||||
Project A | 18.10% | |||||||||||||
Project B | ||||||||||||||
MIRR @ 11% | MIRR @ 18% | |||||||||||||
Project A | 14.59% | Project A | 18.05% | |||||||||||
Project B | 16.46% | Project B | 0.2049 | |||||||||||
Discount Rate | NPV-A | NPV-B | ||||||||||||
0.0% | $890 | $399 | ||||||||||||
10.0% | $283 | $179 | ||||||||||||
11.0% | $241 | $162 | ||||||||||||
18.1% | $3 | $64 | ||||||||||||
20.0% | ($49) | $41 | ||||||||||||
24.0% | ($138) | $0 | ||||||||||||
30.0% | ($238) | ($257) | ||||||||||||
Crossover Rate | 20.49% | |||||||||||||
Reference:
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