In: Accounting
Hearne Company has a number of potential capital investments. Because these projects vary in nature, initial investment, and time horizon, management is finding it difficult to compare them. Assume straight line depreciation method is used. Project 1: Retooling Manufacturing Facility This project would require an initial investment of $4,950,000. It would generate $883,000 in additional net cash flow each year. The new machinery has a useful life of eight years and a salvage value of $1,024,000. Project 2: Purchase Patent for New Product The patent would cost $3,470,000, which would be fully amortized over five years. Production of this product would generate $468,450 additional annual net income for Hearne. Project 3: Purchase a New Fleet of Delivery Trucks Hearne could purchase 25 new delivery trucks at a cost of $125,000 each. The fleet would have a useful life of 10 years, and each truck would have a salvage value of $5,200. Purchasing the fleet would allow Hearne to expand its customer territory resulting in $421,900 of additional net income per year. 3. Using a discount rate of 10 percent, calculate the net present value of each project. (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of $1.) (Use appropriate factor(s) from the tables provided. Round your intermediate calculations to 4 decimal places and final answers to 2 decimal places.) 4. Determine the profitability index of each project and prioritize the projects for Hearne. (Round your intermediate calculations to 2 decimal places. Round your final answers to 4 decimal places.)
Solution:
Project 2 - Annual amortiztion on patent = $3,470,000 / 5= $694,000
Annual income from new product = $468450
Annual cash inflow from new product = $468,450 + $694,000 = $1,162,450
Project 3 - Initial investment = 25*$125,000 = $3,125,000
Salvage value = $5,200 *25 = $130,000
Annual depreciation = ($3,125,000 - $130,000)/10 = $299,500
Additional net income per year from project = $421,900
Annual cash inflows from project = $421,900 + $299,500 = $721,400
Computation of NPV - Hearne Company | ||||||||||||
Project 1 | Project 2 | Project 3 | ||||||||||
Particulars | Period | PV Factor | Amount | Present Value | Period | PV Factor | Amount | Present Value | Period | PV Factor | Amount | Present Value |
Cash outflows: | ||||||||||||
Cost of Equipment | 0 | 1 | $4,950,000.00 | $4,950,000.00 | 0 | 1 | $3,470,000.00 | $3,470,000.00 | 0 | 1 | $3,125,000.00 | $3,125,000.00 |
Present Value of Cash outflows (A) | $4,950,000.00 | $3,470,000.00 | $3,125,000.00 | |||||||||
Cash Inflows | ||||||||||||
Annual cash flows | 1-8 | 5.33490 | $883,000.00 | $4,710,716.70 | 1-5 | 3.7908 | $1,162,450.00 | $4,406,615.46 | 1-10 | 6.1446 | $721,400.00 | $4,432,714.44 |
Salvage Value | 8 | 0.46650 | $1,024,000.00 | $477,696.00 | 5 | 0.6209 | $0.00 | $0.00 | 10 | 0.3855 | $130,000.00 | $50,115.00 |
Present Value of Cash Inflows (B) | $5,188,412.70 | $4,406,615.46 | $4,482,829.44 | |||||||||
Net Present Value (NPV) (B-A) | $238,412.70 | $936,615.46 | $1,357,829.44 |
Solution 4:
Computation of NPV - Profitability Index and Priority of Project | |||
Particulars | Project 1 | Project 2 | Project 3 |
Initial Investment | $4,950,000.00 | $3,470,000.00 | $3,125,000.00 |
PV of cash inflows | $5,188,412.70 | $4,406,615.46 | $4,482,829.44 |
Profitability Index | 1.0482 | 1.2699 | 1.4345 |
Ranking | 3 | 2 | 1 |