New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line. The...

Free

90.2K

Verified Solution

Question

Finance

New-Project Analysis
The Campbell Company is considering adding a robotic paintsprayer to its production line. The sprayer's base price is$1,150,000, and it would cost another $16,000 to install it. Themachine falls into the MACRS 3-year class (the applicable MACRSdepreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and itwould be sold after 3 years for $654,000. The machine would requirean increase in net working capital (inventory) of $18,000. Thesprayer would not change revenues, but it is expected to save thefirm $435,000 per year in before-tax operating costs, mainly labor.Campbell's marginal tax rate is 35%.
What is the Year 0 net cash flow?
$

What are the net operating cash flows in Years 1, 2, and 3? Donot round intermediate calculations. Round your answers to thenearest dollar.
Year 1 $
Year 2 $
Year 3 $

What is the additional Year 3 cash flow (i.e, the after-taxsalvage and the return of working capital)? Do not roundintermediate calculations. Round your answer to the nearestdollar.
$

If the project's cost of capital is 10 %, what is the NPV ofthe project? Do not round intermediate calculations. Round youranswer to the nearest dollar.
$

Should the machine be purchased?

Answer & Explanation Solved by verified expert

4.1 Ratings (605 Votes)

Time line		0	1	2	3



Cost of new machine		-1166000
Initial working capital		-18000
=a. Initial Investment outlay		-1184000

3 years MACR rate			33.33%	44.45%	14.81%	7.41%

Savings			435000	435000	435000


-Depreciation	=Cost of machine*MACR%		-388627.8	-518287	-172684.6	86400.6	=Salvage Value

=Pretax cash flows			46372.2	-83287	262315.4
-taxes	=(Pretax cash flows)*(1-tax)		30141.93	-54136.55	170505.01
+Depreciation			388627.8	518287	172684.6
=b. after tax operating cash flow			418770	464151	343190

reversal of working capital					18000

+Proceeds from sale of equipment after tax	=selling price* ( 1 -tax rate)				425100
+Tax shield on salvage book value	=Salvage value * tax rate				9600
=c. Terminal year after tax cash flows					452700

Total Cash flow for the period		-1184000	418769.73	464150.45	795889.61
Discount factor=	(1+discount rate)^corresponding period	1	1.1	1.21	1.331
Discounted CF=	Cashflow/discount factor	-1184000	380699.7545	383595.41	597963.64
d. NPV=	Sum of discounted CF=	178259

e. Buy machine as NPV is positive

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

New-Project AnalysisThe Campbell Company is considering adding a robotic paintsprayer to its production line. The sprayer's base price is$1,150,000, and it would cost another $16,000 to install it. Themachine falls into the MACRS 3-year class (the applicable MACRSdepreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and itwould be sold after 3 years for $654,000. The machine would requirean increase in net working capital (inventory) of $18,000. Thesprayer would not change revenues, but it is expected to save thefirm $435,000 per year in before-tax operating costs, mainly labor.Campbell's marginal tax rate is 35%.What is the Year 0 net cash flow?$What are the net operating cash flows in Years 1, 2, and 3? Donot round intermediate calculations. Round your answers to thenearest dollar.Year 1$Year 2$Year 3$What is the additional Year 3 cash flow (i.e, the after-taxsalvage and the return of working capital)? Do not roundintermediate calculations. Round your answer to the nearestdollar.$If the project's cost of capital is 10 %, what is the NPV ofthe project? Do not round intermediate calculations. Round youranswer to the nearest dollar.$Should the machine be purchased?