Hill Company operates a chain of sandwich shops. The company is considering two possible expansion plans. Plan A would open eight smaller shops at a cost of\(8,700,000. Expected annual net cash inflows are \)1,550,000 for 10 years, with zeroresidual value at the end of 10 years. Under Plan B, Hill Company would open threelarger shops at a cost of \(8,340,000. This plan is expected to generate net cash inflowsof \)990,000 per year for 10 years, the estimated useful life of the properties. Estimatedresidual value for Plan B is $1,200,000. Hill Company uses straight-line depreciationand requires an annual return of 10%.

Requirements

1. Compute the payback, the ARR, the NPV, and the profitability index of thesetwo plans.

2. What are the strengths and weaknesses of these capital budgeting methods?

3. Which expansion plan should Hill Company choose? Why?

4. Estimate Plan A’s IRR. How does the IRR compare with the company’s requiredrate of return?

Short Answer

Expert verified

NPV for project A:$824,130

NPV for Project B:-$1,793,646

Step by step solution

01

Computation of CB ratios

Computation for Project A

Payback period

Payback=AmountInvestedAnnualnetcashinflow=$8,700,000$1,550,000=5.613years

ARR

AnnualDepreciation=Cost-ResidualValueUsefulLife=$8,700,000-$010=$870,000

Averageannualoperatingincome=Annualnetcashinflow-AnnualDepreciation=$1,550,000-$870,000=$680,000

Averageinvestedamount=TotalInvestment2=$8,700,0002=$4,350,000

ARR=AverageannualoperatingincomeAverageamountinvested=$680,000$4,350,000=0.156or15.6%

NPV

Presentvalueofannualnetcashinflow=AnnualcashInflow×[1-11+rnr]=$1,550,000×[1-11+0.1100.1]=$1,550,000×6.1446=$9,524,130

NetPresentValue=PresentValueofinflows-Costofinvestment=$9,524,130-$8,700,000=$824,130

Profitability index

ProfitabilityIndex=PresentvalueofnetcashinflowInitiaInvestment=$9,524,130$8,700,000=1.095

Computation for Project B

Payback period

Payback=AmountInvestedAnnualnetcashinflow=$8,340,000$990,000=8.4242years

ARR

AnnualDepreciation=Cost-ResidualValueUsefulLife=$8,340,000-$1,200,00010=$714,000

Averageannualoperatingincome=Annualnetcashinflow-AnnualDepreciation=$990,000-$714,000=$276,000

Averageinvestedamount=TotalInvestment2=$8,340,0002=$4,170,000

ARR=AverageannualoperatingincomeAverageamountinvested=$276,000$4,170,000=0.0662or6.62%

NPV

Presentvalueofannualnetcashinflow=AnnualcashInflow×[1-11+rnr]=$990,000×[1-11+0.1100.1]=$990,000×6.145=$6,083,550

Presentvalueofresidualamount=ResidualAmount×[11+r]n=$1,200,000×[11+0.1]10=$1,200,000×0.386=$463,200

NetPresentValue=PresentValueofinflows-Costofinvestment=$6,083,154+$463,200-$8,340,000=-$1,793,646

Profitability index

ProfitabilityIndex=PresentvalueofnetcashinflowInitialInvestment=$6,083,154+$463,200$8,340,000=0.785

02

 Step 2: Strength and weaknesses of Capital Budgeting

Strength of capital budgeting methods

1. Payback –i) Simplest method

ii) Helpful in determine g the risk in terms of cost recovery period

2. ARR –i) Uses the accounting profit

ii) Measures the profitability over asset’s life

3. NPV–i) Provides the time value of money

ii) Measures the earning capability against the minimum required rate of return

4. IRR–i) Computes the actual rate of return

ii) Considers net cash flow over assets entire life

Weaknesses of capital budgeting methods

1. Payback –i) Ignores time value of money

ii) Do not take consideration of cash flow after payback period

2. ARR –i) Do not use time value of money

ii) Only takes accounting profit concept

3. NPV–i) Complex method

ii) Requires specialized skill for the use of the method

4. IRR–i) Complex and difficult method

ii) Not relevant in all conditions

03

Recommendation

Based on the above analysis, project A provides a good positive NPV of $824,130. Whereas, project B provides a negative NPV. The payback period for project B is also high in comparison to project A. Furthermore, there is also a risk of the collection period.

So, based on these facts and figures project A is recommended

04

Computation of IRR

IRR

IRR is the rate at which the present value of cash inflow equals initial investment.

Let’s say IRR = R%

Then,

InitialInvestment=PresentValueofnetcashinflows$8,700,000=AnnualcashInflow×[1-11+rnr]$8,700,000=$1,550,000×[1-11+R10R]5.6129=[1-11+R10R]

By hit and trial method if R is taken 12.25% for 10 years then,

5.6=[1-11+0.1225100.1225]5.6=5.59

So the IRR = 12.25%

As compared to required rate of return, IRR is only 2% above the RRR. It means that the project’s NPV would be positive but with lesser degree.

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 Vaia!

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

What is the internal rate of return?

What is the decision rule for IRR?

How is the present value of a lump sum determined?

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.

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

Year

Plan Alpha

Plan Beta

1

\(1,600,000

\)1,600,000

2

\(1,600,000

2,200,000

3

\)1,600,000

2,800,000

4

\(1,600,000

2,200,000

5

\)1,600,000

1,600,000

6

\(1,600,000

1,500,000

7

\)1,600,000

1,300,000

8

\(1,600,000

1,100,000

9

\)1,600,000

900,000

10

\(1,600,000

800,000

Total

\)16,000,000

\(16,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 \)6,500,000. 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.

Sign-up for free