Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Existing Paint System New Paint System Current Book Value 120,000 Current Market Value 100,000 Acquisition Cost 250,000 Remaining Depreciation Life 3 years 5 years Annual
Existing Paint System | New Paint System | |||||
Current Book Value | 120,000 | |||||
Current Market Value | 100,000 | |||||
Acquisition Cost | 250,000 | |||||
Remaining Depreciation Life | 3 years | 5 years | ||||
Annual Labor Expense | 150,000 | 80,000 | ||||
Utilities Expense | 10,000 | 20,000 | ||||
Materials Expense | 20,000 | 10,000 | ||||
Extra Cost Savings | 5,000 | |||||
Tax Rate | 25% | |||||
Inflation | 3% | |||||
WACC | 10% | |||||
Existing Paint System Cash Flows | ||||||
Year | 0 | 1 | 2 | 3 | ||
Acquisition Cost | ||||||
Salvage Value | ||||||
Labor Expense | ||||||
Depreciation Expense | ||||||
Utilities Expense | ||||||
Materials Expense | ||||||
Extra Cost Savings | ||||||
Pre-Tax Cash Flow | ||||||
Taxes | ||||||
After-Tax Cash Flow | ||||||
New Paint System Cash Flows | ||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 |
Acquisition Cost | ||||||
Salvage Value | ||||||
Labor Expense | ||||||
Depreciation Expense | ||||||
Utilities Expense | ||||||
Materials Expense | ||||||
Extra Cost Savings | ||||||
Pre-Tax Cash Flow | ||||||
Taxes | ||||||
After-Tax Cash Flow |
You are consulting with a company that is considering replacing their current paint system with a | ||||||||
new paint system. The exisiting paint system has a current book value of $120,000 with 3 years of remaining | ||||||||
depreciable life. Annual labor costs to operate the existing paint system are $150,000, annual utilities expenses | ||||||||
are 10,000 and the annual materials expenses are 20,000. | ||||||||
The new paint system would require an initial investment of $250,000, including shipping and installation and | ||||||||
would be derpeciated over 5 years. Annual labor expenses with the new paint system would be $80,000, the | ||||||||
annual utilities expenses would be $20,000 and the annual materials expense would be $10,000. Additionally, | ||||||||
the new paint system would create after-tax savings in other areas of the factory that amount to $5,000 annually. | ||||||||
The company has realized that they can sell the existing paint system today for $100,000. Thus, if they purchase the | ||||||||
new paint system, they will immediately sell the exisiting system and realize the salvage value which will | ||||||||
offset the initial acquision cost of the new system. | ||||||||
The company's tax rate is 25% and inflation is expected to be 3%. You estimate the WACC for this analysis at 10% | ||||||||
Your assistant has provided the framework to the left to help you organize your work. However, he was unable | ||||||||
to complete the cash flow estimation. Thus, he simply listed all the expense items that he THOUGHT might apply. | ||||||||
Some will apply and some might not. You have to make the determination as to what applies to each option | ||||||||
(i.e. you have to determine which items go with the Existing Paint System and which go with the New Paint System) | ||||||||
Using the data provided, determine whether the company should keep the existing paint system or | ||||||||
purchase the new one. Justify your answer using the appropriate analytical tools we have discussed | ||||||||
in class for analyzing mutually exclusive investment opportunities with unequal lives. |
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