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. (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.)

Project 1: Retooling Manufacturing Facility This project would require an initial investment of $4,850,000. It would generate $865,000 in additional net cash flow each year. The new machinery has a useful life of eight years and a salvage value of $1,000,000.
Project 2: Purchase Patent for New Product The patent would cost $3,400,000, which would be fully amortized over five years. Production of this product would generate $425,000 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 $115,000 each. The fleet would have a useful life of 10 years, and each truck would have a salvage value of $5,000. Purchasing the fleet would allow Hearne to expand its customer territory resulting in $200,000 of additional net income per year.

Required:

a. Determine each project's accounting rate of return. (Round your answers to 2 decimal places.)
b. Determine each project's payback period. (Round your answers to 2 decimal places.)
c. 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 final answersto 2 decimal places.)
d. 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.)

Respuesta :

Answer:

Hearne Company

                                                      Project 1         Project 2          Project 3

Initial investment cost                $4,850,000    $3,400,000     $2,875,000

Annual cash inflows                        865,000        1,105,000          475,000

PV annuity  (5.335/3.791/6.145)    4,614,775       4,189,055      $2,918,875

Useful life                                      8 years            5 years              10 years

Salvage Value                               1,000,000       0                        125,000

PV (0.467/0/0.386                          467,000       0                          48,250

Depreciable/Amortization amount $3,850,000  $3,400,000    $2,750,000

Annual depreciation/amortization 481,250       680,000            275,000

Annual Returns                              383,750       425,000           200,000

Average annual investment cost 606,250       680,000           287,500

a. Accounting rate of return          63.30%        62.50%             69.57%

b. Payback period                      5.61 years    3.08 years            6.05 years

Total PV of cash inflows              5,081,775    4,189,055         2,967,125

c. NPV                                          $231,775    $789,055            $92,125

d. Profitability Index                       1.0478          1.2321              1.0320

Prioritization of Projects:

Project 2

Project 1

Project 3

Based on NPV, Profitability Index, and Payback Period.

Explanation:

a) Data and Calculations:

                                                      Project 1         Project 2          Project 3

Initial investment cost                $4,850,000    $3,400,000     $2,875,000

Annual cash inflows                        865,000        1,105,000          475,000

PV annuity  (5.335/3.791/6.145)    4,614,775       4,189,055      $2,918,875

Useful life                                      8 years            5 years              10 years

Salvage Value                               1,000,000       0                        125,000

PV (0.467/0/0.386                          467,000       0                          48,250

Depreciable/Amortization amount $3,850,000  $3,400,000    $2,750,000

Annual depreciation/amortization 481,250       680,000            275,000

Annual Returns                              383,750       425,000           200,000

Average annual investment cost 606,250       680,000           287,500

Accounting rate of return               63.30%        62.50%             69.57%

Payback period                           5.61 years    3.08 years            6.05 years

Total PV of cash inflows              5,081,775    4,189,055         2,967,125

NPV                                               $231,775    $789,055            $92,125

Profitability Index                              1.0478          1.2321              1.0320

Key Calculation Formulas:

Annual cash flows = Annual Depreciation Plus Annual Net Income

Present of annual cash flows = Annuity factor * Annual cash flows

PV of Salvage value = Salvage value * Discount Factor

The Depreciable or Amortization amount = Initial investment cost Minus Salvage value

Annual Returns = Annual Cash inflow Minus Depreciation

Average annual investment cost = Initial investment cost/useful life

Accounting rate of return =  average annual returns/average annual investment cost

Payback period = Initial investment/Annual cash inflows

Total PV of cash flows = PV of annual cash inflows + PV of Salvage value

NPV = Total PV of cash flows Minus Initial Investment Cost

Profitability Index = Total PV of cash flows/Initial Investment Cost