Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 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
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

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_2

Step: 3

blur-text-image_3

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

More Books

Students also viewed these Finance questions

Question

Is it fair? Will my action unfairly discriminate against anyone?

Answered: 1 week ago