Question
Project L: This project requires an initial investment of $2,000,000 in equipment which will cost an additional $75,000 to install. The firm will use the
Project L: This project requires an initial investment of $2,000,000 in equipment which will cost an additional $75,000 to install. The firm will use the attached MACRS depreciation schedule to expense this equipment. Once the equipment is installed, the company will need to increase net working capital by $100,000. The project will last 6 years at which time the market value for the equipment will be $180,000. The project will project a product with a sales price of $32.00 per unit and the variable cost per unit will be $11.00. The fixed costs would be $110,000 per year. Because this project is very close to current products sold by the business, management wants you to apply the WACC as the discount rate to the project. Years 2014 2015 2016 2017 2018 2019 Forecasted Units Sold 32,000 45,000 48,000 58,000 75,000 90,000
Bonds | 60,000 | Preferred Stock | Common Stock | ||
Periods left until Maturity | 15 years | Stock Par Value | $ 100.00 | Current market price per share | $ 17.00 |
Coupon Rate | 10% | Dividend Per Share | $ 9.00 | Last Dividend paid | $ 0.65 |
Semiannual Payment | $ 50.00 | Current market price per share | $ 90.00 | Dividend Growth Rate | 10% |
Current Price | $ 874.78 | Risk free rate | 6% | ||
Face Value | $ 1,000.00 | Stock market return | 13% | ||
Firm's Beta | 1.22 | ||||
Tax Rate | 40.0% | Cost of Equity: CAPM Method | 14.54% | ||
Cost of Debt (BT) | 11.80% | Cost of Preferred Stock | Cost of Equity: DDM Method | 14.21% | |
Cost of Common Equity (Avg) | 14.38% | ||||
Market Values | Market Weights | ||||
Total Bonds | $ 52,486,800 | 0.36% | Weighted Average Cost of Capital | 11.50% | |
Total Preferred Stock | $ 85,000,000 | 0.58% | |||
Total Common Stock | $ 9,000,000 | 0.06% | |||
Total Firm Value | $ 146,486,800 | 1 |
ORIGINAL SCENARIO | |||||||
Initial Cost | $ 2,000,000 | Price | $ 32.00 | Tax Rate | 40% | ||
Installation Cost | $ 75,000 | Variable Cost | $ 11.00 | Required Return | 0.00% | ||
Increase in NWC | $ 100,000 | Fixed Cost | $ 110,000 | ||||
Salvage Value | $ 180,000 | ||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | ||
Units sold | 32,000 | 45,000 | 48,000 | 58,000 | 75,000 | 90,000 | |
Depreciation Rate | 20% | 32% | 19% | 12% | 11% | 6% | |
Years | 1 | 2 | 3 | 4 | 5 | 6 | |
Sales | |||||||
Variable Cost | |||||||
Fixed Cost | |||||||
EBITDA | |||||||
Depreciation | |||||||
EBIT | |||||||
Tax Expense | |||||||
Net Income | |||||||
Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | |
Operating Cash Flow | |||||||
Capital Spending Cash Flow | |||||||
Net Working Capital Cash Flow | |||||||
Total Cash Flows | |||||||
Total Cumulative Cash Flows | |||||||
Internal Rate of Return | Payback Period | ||||||
Net Present Value | Profitability Index | ||||||
PRICE REDUCTION SCENARIO | |||||||
Initial Cost | Price | Tax Rate | |||||
Installation Cost | Variable Cost | Required Return | |||||
Increase in NWC | Fixed Cost | ||||||
Salvage Value | |||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | ||
Units sold | |||||||
Depreciation Rate | |||||||
Years | 1 | 2 | 3 | 4 | 5 | 6 | |
Sales | |||||||
Variable Cost | |||||||
Fixed Cost | |||||||
EBITDA | |||||||
Depreciation | |||||||
EBIT | |||||||
Tax Expense | |||||||
Net Income | |||||||
Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | |
Operating Cash Flow | |||||||
Capital Spending Cash Flow | |||||||
Net Working Capital Cash Flow | |||||||
Total Cash Flows | |||||||
Total Cumulative Cash Flows | |||||||
Internal Rate of Return | Payback Period | ||||||
Net Present Value | Profitability Index | ||||||
VOLUME REDUCTION SCENARIO | |||||||
Initial Cost | Price | Tax Rate | |||||
Installation Cost | Variable Cost | Required Return | |||||
Increase in NWC | Fixed Cost | ||||||
Salvage Value | |||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | ||
Original Volume Sold | |||||||
Reduced Volume Sold | |||||||
Depreciation Rate | |||||||
Years | 1 | 2 | 3 | 4 | 5 | 6 | |
Sales | |||||||
Variable Cost | |||||||
Fixed Cost | |||||||
EBITDA | |||||||
Depreciation | |||||||
EBIT | |||||||
Tax Expense | |||||||
Net Income | |||||||
Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | |
Operating Cash Flow | |||||||
Capital Spending Cash Flow | |||||||
Net Working Capital Cash Flow | |||||||
Total Cash Flows | |||||||
Total Cumulative Cash Flows | |||||||
Internal Rate of Return | Payback Period | ||||||
Net Present Value | Profitability Index |
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