New Project Analysis
Madison Manufacturing is considering a new machine that costs $350,000 and would reduce pre-tax manufacturing costs by $110,000 annually. Madison would
use the 3-year MACRS method to depreciate the machine, and management thinks the machine would have a value of $33,000 at the end of its 5-year
operating life. The applicable depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%. Working capital would increase by $35,000 initially, but it
would be recovered at the end of the project’s 5-year life. Madison’s marginal tax rate is 40%, and a 9% WACC is appropriate for the project.
Calculate the project’s NPV. Round your answer to the nearest dollar.
$
Calculate the project’s IRR. Round your answer to two decimal places
%
Calculate the project’s MIRR. Round your answer to two decimal places
%
Calculate the project’s payback. Round your answer to two decimal places
Assume management is unsure about the $110,000 cost savings – this figure could deviate by plus 20%. Calculate the NPV over the
five-year period. Round your answer to the nearest dollar.
$
Calculate the NPV over the five-year period if this figure could deviate by minus 20%. Round your answer to the nearest dollar.
$
Suppose the CFO wants you to do a scenario analysis with different values for the cost savings, the machine’s salvage value, and the
working capital (WC) requirement. She asks you to use the following probabilities and values in the scenario analysis:
Scenario
Probability Cost
Savings Salvage
Value
WC
Worst case 0.30 $ 88,000 $28,000 $40,000
Base case 0.40 110,000 33,000 35,000
Best case 0.30 132,000 38,000 30,000
Calculate the project’s expected NPV. Round your answer to the nearest dollar.
$
Calculate the project’s standard deviation. Round your answer to the nearest dollar.
$
Calculate the project’s coefficient of variation. Round your answer to two decimal places
New Project Analysis
You must evaluate the purchase of a spectrometer for the R&D department. The
base price is $140,000, and it would cost another $30,000 to modify the equipment
for special use by the firm. The equipment falls into the MACRS 3-year class and
would be sold after 3 years for $60,000. The applicable depreciation rates are 33%,
45%, 15%, and 7% as discussed in Appendix 12A. The equipment would require an
$8,000 increase in net operating working capital (spare parts inventory). The project
would have no effect on revenues, but it should save the firm
$50,000 per year in before-tax labor costs. The firm%u2019s marginal federal-plus-state tax
rate is 40%.
a. What is the initial investment outlay for the spectrometer, that is, what is the Year 0 project cash flow?
b. What are the project%u2019s annual cash flows in Years 1, 2, and 3?
c. If the WACC is 12%, should the spectrometer be purchased? Explain.
a.
Cost of investment at t = 0:
Base price (140,000)
Modification (30,000)
Increase in NWC (8,000)
Cash outlay for new machine (178,000)
b.
Annual cash flows:
Year 1 Year 2 Year 3
After-tax savings
Depreciation tax savings
Salvage value
Tax on SV
Return of NWC
Project cash flows 0 0 0
c.
Year Cash Flow PV
0
1
2
3
Mcgraw-hill connect finance: avg collection,receivable turnover, and average receivables
Next PostHow do you write off an uncollectible account that exceeds the allowance for doubtful accounts?
Holmes Manufacturing is considering a new machine that costs $250,000 and would reduce pretax manufacturing costs by $90,000 annually. Holmes would use the 3 Year
MACRS method to depreciate the machine, and management thinks the machine would have a value of $23,000 at the end of its 5-year operating life. The applicable
depreciation rates are 33%, 45%, 15% and 7%. Net Operating working capital would increase by $25,000 initially, but it would be recovered at the end of the
projects 5-year life. Holmes’s marginal tax rate is 40%, and a 10% WACC is appropriate for the project.
Calculate the projects NPV, IRR, MIRR and payback.
Document Preview:
Instructions:
The assignment is problem 12-22 on pp.428 and 429 of your text.
You are to answer parts a-e only
**The answer has 11 key outputs. **
Each will have a point value of 2 for a total of 22 points.
12-22 NEW PROJECT ANALYSIS – You must analyze a potential new product—a caulking compound that Cory Materials’ R&D people developed for use in the residential construction industry. Cory’s marketing manager thinks they can sell 115,000 tubes per year at a price of $3.25 each for 3 years, after which the product will be obsolete. The required equipment would cost $150,000, plus another $25,000 for shipping and installation. Current assets (receivables and inventories) would increase by $35,000, while current liabilities (accounts payable and accruals) would rise by $15,000. Variable costs would be 60% of sales revenues, fixed costs (exclusive of depreciation) would be $70,000 per year, and fixed assets would be depreciated under MACRS with a 3-year life. (Refer to Appendix 12A for MACRs depreciation rates.) When production ceases after 3 years, the equipment should have a market value of $15,000. Cory’s tax rate is 40%, and it uses a 10% WACC for average-risk projects.
a. Find the required Year 0 investment and the project’s annual cash flows. Then calculate the project’s NPV, IRR, MIRR, and payback. Assume at this point that the project is of average risk.
e. Unrelated to the new product, Cory is analyzing two mutually exclusive machines that will upgrade its manufacturing plant. These machines are considered average-risk projects, so management will evaluate them at the firm’s 10% WACC. Machine X has a life of 4 years, while Machine Y has a life of 2 years. The cost of each machine is $60,000; however, Machine X provides after-tax cash flows of $25,000 per year for 4 years and Machine Y provides after-tax cash flows of $42,000 per year for 2 years. The manufacturing plant is very successful, so the machines will be repurchased at the end of each…
Attachments:
FM.22-2-extra….docx
I have gotten the rest of the question excpet “in year 3” part…I am stuck here….? (the rest of it is correct, I have already checked it on our homework website.)
New project analysis
You must evaluate a proposed spectrometer for the R&D department. The base price is $200,000, and it would cost another $50,000 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $60,000. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require an $5,000 increase in net operating working capital (spare parts inventory). The project would have no effect on revenues, but it should save the firm $72,000 per year in before-tax labor costs. The firm’s marginal federal-plus-state tax rate is 40%.
What is the initial investment outlay for the spectrometer, that is, what is the Year 0 project cash flow? Round your answer to the nearest cent.
$
What are the project’s annual cash flows in Years 1, 2, and 3? Round your answers to the nearest cent.
in Year 1 $
in Year 2 $
in Year 3 $ ????
If the WACC is 14%, should the spectrometer be purchased?
-Select-yesnoItem 5
