Bill wants to purchase a machine to help improve the quality of the product his
ID: 2651919 • Letter: B
Question
Bill wants to purchase a machine to help improve the quality of the product his company manufactures. The information needed to answer this question is provided below:
INFORMATION NEW MACHINE:
Purchase Price $200,000.00
Estimated Life 4 YEARS
Use Straight Line Depreciation Method
Estimated Salvage Value $20,000.00
Estimated Net Operating Cash Flow Increase/Decrease (Prior to Depreciation and Taxes)
End of Year 1 $60,000.00
End of Year 2 $80,000.00
End of Year 3 $80,000.00
End of Year 4 $90,000.00
ASSUMPTIONS:
Working Capital Addition $40,000
Tax Rate 40%
WACC Rate 10%
Based on this information calculate the NPV if Bill decides to purchase the new machine. Round your answer to the nearest whole number and do not include dollar signs or commas. (20123.34 would be entered as 20123) If the amount is negative, include a "-" sign (-20123)
You can use the Simple Capital Purchasd Excel spreadsheet as an example. You will need to modify the spreadsheet since this question is based on a 4 year life asset, not a 5 year life.
90 points
QUESTION 2
Based on the correct calculation, Bill
should not buy this machine since the NPV is negative and the company would not be getting a sufficient return.
should buy this machine since the NPV is positive and the company would getting a sufficient return above the required amount.
A.should not buy this machine since the NPV is negative and the company would not be getting a sufficient return.
B.should buy this machine since the NPV is positive and the company would getting a sufficient return above the required amount.
Explanation / Answer
Answer:
1
Calculation of NPV
Year 0
Year 1
Year 2
Year 3
Year 4
Net Operating Cash Flow (Prior to Depreciation and Taxes)
$ 60,000.00
$ 80,000.00
$ 80,000.00
$ 90,000.00
Less: Depreciation (200000-20000)/4
$ (45,000.00)
$ (45,000.00)
$ (45,000.00)
$ (45,000.00)
Profits Before tax
$ 15,000.00
$ 35,000.00
$ 35,000.00
$ 45,000.00
Less: Tax @ 40%
$ (6,000.00)
$ (14,000.00)
$ (14,000.00)
$ (18,000.00)
Profits after tax
$ 9,000.00
$ 21,000.00
$ 21,000.00
$ 27,000.00
Add: Depreciation
$ 45,000.00
$ 45,000.00
$ 45,000.00
$ 45,000.00
Net Operating Cash Flow after tax (A)
$ 54,000.00
$ 66,000.00
$ 66,000.00
$ 72,000.00
Initial Purchase Price (B)
$ (200,000.00)
Estimated Salvage Value (Net of tax) =20000*(1-0.40) ©
$ 12,000.00
Working Capital (D)
$ (40,000.00)
Net cash flows (E) =A+B+C+D
$ (240,000.00)
$ 54,000.00
$ 66,000.00
$ 66,000.00
$ 84,000.00
PVF(10%) (F)
1.00000
0.90909
0.82645
0.75131
0.68301
1/(1+0.10)^0
1/(1+0.10)^1
1/(1+0.10)^2
1/(1+0.10)^3
1/(1+0.10)^4
PV = E*F
$ (240,000.00)
$ 49,090.91
$ 54,545.45
$ 49,586.78
$ 57,373.13
Net Present value =Sum of PVs
$ (29,403.73)
2
Should not buy this machine since the NPV is negative and the company would not be getting a sufficient return.
1
Calculation of NPV
Year 0
Year 1
Year 2
Year 3
Year 4
Net Operating Cash Flow (Prior to Depreciation and Taxes)
$ 60,000.00
$ 80,000.00
$ 80,000.00
$ 90,000.00
Less: Depreciation (200000-20000)/4
$ (45,000.00)
$ (45,000.00)
$ (45,000.00)
$ (45,000.00)
Profits Before tax
$ 15,000.00
$ 35,000.00
$ 35,000.00
$ 45,000.00
Less: Tax @ 40%
$ (6,000.00)
$ (14,000.00)
$ (14,000.00)
$ (18,000.00)
Profits after tax
$ 9,000.00
$ 21,000.00
$ 21,000.00
$ 27,000.00
Add: Depreciation
$ 45,000.00
$ 45,000.00
$ 45,000.00
$ 45,000.00
Net Operating Cash Flow after tax (A)
$ 54,000.00
$ 66,000.00
$ 66,000.00
$ 72,000.00
Initial Purchase Price (B)
$ (200,000.00)
Estimated Salvage Value (Net of tax) =20000*(1-0.40) ©
$ 12,000.00
Working Capital (D)
$ (40,000.00)
Net cash flows (E) =A+B+C+D
$ (240,000.00)
$ 54,000.00
$ 66,000.00
$ 66,000.00
$ 84,000.00
PVF(10%) (F)
1.00000
0.90909
0.82645
0.75131
0.68301
1/(1+0.10)^0
1/(1+0.10)^1
1/(1+0.10)^2
1/(1+0.10)^3
1/(1+0.10)^4
PV = E*F
$ (240,000.00)
$ 49,090.91
$ 54,545.45
$ 49,586.78
$ 57,373.13
Net Present value =Sum of PVs
$ (29,403.73)
2
Should not buy this machine since the NPV is negative and the company would not be getting a sufficient return.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.