/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Q32PGA Henderson Manufacturing, Inc. ha... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

Henderson Manufacturing, Inc. has a manufacturing machine that needs attention. The company is considering two options. Option 1 is to refurbish the current machineat a cost of \(1,200,000. If refurbished, Henderson expects the machine to last anothereight years and then have no residual value. Option 2 is to replace the machine at acost of \)4,600,000. A new machine would last 10 years and have no residual value.Henderson expects the following net cash inflows from the two options:

YearRefurbish CurrentPurchase New

MachineMachine

1 \( 350,000 \) 3,780,000

2 340,000 510,000

3 270,000 440,000

4 200,000 370,000

5 130,000 300,000

6 130,000 300,000

7 130,000 300,000

8 130,000 300,000

9 300,000

10 300,000

Total \( 1,680,000 \) 6,900,000

Henderson uses straight-line depreciation and requires an annual return of 10%.

Requirements

1. Compute the payback, the ARR, the NPV, and the profitability index of these twooptions.

2. Which option should Henderson choose? Why?

Short Answer

Expert verified

NPV for refurbishing:$19,810

NPV for new machine:$732,930

Step by step solution

01

Computation of capital budgeting ratios

For refurbishing the current Machine

InitialInvestment=Cashflowinyear1+Cashflowinyear2+Cashflowinyear3+Cashflowinyear4+partialcashflowinyear5=$350,000+$340,000+$270,000+$200,000+$40,000=$1,200,000

PaybackPeriod=Totalyearcountandpartialyearcount=1+1+1+1+$40,000$130,000=1+1+1+1+0.31=4.31Years

AverageOperatingIncome=Totalcashinflow-TotalDepreciationNo.ofyears=$1,680,000-$1,200,0008=$60,000

ARR=AverageOperatingIncomeAverageInvestment=$60,000$1,200,0002=$60,000$600,000=0.1or10%

Year

Cash Inflow

PV factor

Present Value

1

$350,000

0.909

$318,150

2

340,000

0.826

280,840

3

270,000

0.751

202,770

4

200,000

0.683

136,600

5

130,000

0.621

80,730

6

130,000

0.564

73,320

7

130,000

0.513

66,690

8

130,000

0.467

60,710

Total

$1,219,810

NPV=Presentvalueofallcashflow-InitialInvestment=$1,219,810-$1,200,000=$19,810

ProfitabilityIndex=PresentValueofallcashinflowsInitialInvestment=$1,219,810$1,200,000=1.017

For purchasing new Machine

InitialInvestment=Cashflowinyear1+Cashflowinyear2+partialcashflowinyear3=$3,780,000+$510,000+$310,000=$4,600,000

PaybackPeriod=Totalyearcountandpartialyearcount=1+1+$310,000$440,000=1+1+0.705=2.7Years

AverageOperatingIncome=Totalcashinflow-TotalDepreciationNo.ofyears=$6,900,000-$4,600,00010=$230,000

ARR=AverageOperatingIncomeAverageInvestment=$230,000$4,600,0002=$230,000$2,300,000=0.1or10%

Year

Cash Inflow

PV factor

Present Value

1

$ 3,780,000

0.909

$ 3,436,020

2

510,000

0.826

421,260

3

440,000

0.751

330,440

4

370,000

0.683

252,710

5

300,000

0.621

186,300

6

300,000

0.564

169,200

7

300,000

0.513

153,900

8

300,000

0.467

140,100

9

300,000

0.424

127,200

10

300,000

0.386

115,800

Total

$ 5,332,930

NPV=Presentvalueofallcashflow-InitialInvestment=$5,332,930-$4,600,000=$732,930

ProfitabilityIndex=PresentValueofallcashinflowsInitialInvestment=$5,332,930$4,600,000=1.16
02

Recommended Option

Based on the above analysis, the payback period for refurbishing the current machine is higher than for purchasing a new machine. Furthermore, the NPV is also lower for refurbishing g current machine than for purchasing a new machine.

So the recommended option would be to purchase the new machine.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Your grandfather would like to share some of his fortune with you. He offers to give you money under one of the following scenarios (you get to choose):

1. \(7,250 per year at the end of each of the next eight years

2. \)49,650 (lump sum) now

3. $98,650 (lump sum) eight years from now

Requirements

1. Calculate the present value of each scenario using an 8% discount rate. Which scenario yields the highest present value? Round to nearest whole dollar.

2. Would your preference change if you used a 10% discount rate?

Question: Defining capital investment terms

Fill in each statement with the appropriate capital investment analysis method:

Payback, ARR, NPV, or IRR. Some statements may have more than one answer.

  1. _____ is (are) more appropriate for long-term investments.
  2. _____ highlights risky investments.
  3. _____ shows the effect of the investment on the company’s accrual-based income.
  4. _____ is the interest rate that makes the NPV of an investment equal to zero.
  5. _____ requires management to identify the discount rate when used.
  6. _____ provides management with information on how fast the cash invested will be recouped.
  7. _____ is the rate of return, using discounted cash flows, a company can expect to earn by investing in the asset.
  8. _____ does not consider the asset’s profitability.
  9. _____ uses accrual accounting rather than net cash inflows in its computation.

Describe the capital budgeting process.

Hudson Manufacturing is considering three capital investment proposals. At this time, Hudson only has funds available to pursue one of the three investments.

Equipment A

Equipment B

Equipment C

Present value of net cash inflows

\(1,647,351

\)1,969,888

\(2,064,830

Initial investment

(1,484,100)

(1,641,573)

(1,764,812)

NPV

\)163,251

\(328,315

\)300,018

Which investment should Hudson pursue at this time? Why?

Hayes Company is considering two capital investments. Both investments have an initial cost of \(10,000,000 and total net cash inflows of \)17,000,000 over 10 years. Hayes requires a 12% rate of return on this type of investment. Expected net cash inflows are as follows:

Year

Plan Alpha

Plan Beta

1

\( 1,700,000

\) 1,700,000

2

1,700,000

2,300,000

3

1,700,000

2,900,000

4

1,700,000

2,300,000

5

1,700,000

1,700,000

6

1,700,000

1,600,000

7

1,700,000

1,200,000

8

1,700,000

800,000

9

1,700,000

400,000

10

1,700,000

2,100,000

Total

\( 17,000,000

\) 17,000,000

Requirements

  1. Use Excel to compute the NPV and IRR of the two plans. Which plan, if any, should the company pursue?

  2. Explain the relationship between NPV and IRR. Based on this relationship and the company’s required rate of return, are your answers as expected in Requirement 1? Why or why not?

  3. After further negotiating, the company can now invest with an initial cost of $9,500,000 for both plans. Recalculate the NPV and IRR. Which plan, if any, should the company pursue?

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.