Question 2 OR

Two mutually exclusive projects: payback, NPV, PI and IRR

15 marks

Time to write
About 30 minutes

From an older CBCS paper

Question

Question 2 OR · 15 marks

A firm with a cost of capital of 10% is considering two mutually exclusive projects, A and B, whose details are below:

ItemsYearProject AProject B
Cost0₹ 60,000₹ 60,000
Cash Inflows1₹ 6,000₹ 30,000
2₹ 12,000₹ 24,000
3₹ 18,000₹ 12,000
4₹ 27,000₹ 6,000
5₹ 36,000₹ 6,000

For both projects, compute the Pay Back Period, the Net Present Value at 10%, the Profitability Index, and the Internal Rate of Return. Which of the two project you would recommend, and why?

Reworded from the university paper: names and figures differ, the task is the same. The original paper belongs to the University of Delhi. See DU's question bank.

Before you write

Read off the question and its marks

30 minfor 15 marks

Read from the question

  • and whyEach answer needs its reason, not just the answer.
  • Pay Back PeriodCash flows year by year in one table, then discount, then a one-line decision.

Write it in this order

  1. Read the data; note exactly what is asked 2 min
  2. 1 Payback periods 3 marks 5 min
  3. 2 NPVs 4 marks 7 min
  4. 3 Profitability indexes 2 marks 4 min
  5. 4 IRRs 4 marks 7 min
  6. 5 Recommendation with reasons 2 marks 3 min
  7. Check: arithmetic, units (₹, %), final answer underlined 2 min

Short on time? End with step 5's one-line decision, whatever happens: never leave the figures without it.

Try it first. About 30 minutes for 15 marks. Write it out, then open the solution.

Solution

Hover or tap a marked figure, like 72,000, to see how it is made and where else it appears.

Payback period (cumulative cash inflows)

Picture itTwo mutually exclusive projects: payback, NPV, PI and IRR

1Rekha puts her savings into a juice cart—the jar on the counter starts empty.

Payback periodThe number of years a project takes to recover its initial investment from its cash inflows.

2Orange by orange, the jar fills back towards what the cart cost her.

Why it is a measure of liquidityHow quickly the funds locked in a project come back and can be put to other uses.

3The jar full, the counting stops—the measure never looks at all the selling still to come.

Why it is not a measure of profitabilityIt ignores the cash inflows after the payback period, however large.

YearProject ACumulative AProject BCumulative B
16,0006,00030,00030,000
212,00018,00024,00054,000
318,00036,00012,00066,000
427,00063,0006,00072,000
536,00099,0006,00078,000
  • A: 3 + (60,000 − 36,000) ÷ 27,000 = 3.89 years.
  • B: 2 + (60,000 − 54,000) ÷ 12,000 = 2.50 years.

NPV at 10% and profitability index

YearPVF @ 10%PV (A)PV (B)
10.9095,45427,270
20.8269,91219,824
30.75113,5189,012
40.68318,4414,098
50.62122,3563,726
Total PV69,68163,930
ParticularsProject AProject B
Less: cost (₹)60,00060,000
NPV (₹)9,6813,930
PI (PV ÷ cost)1.16141.0655

IRR (trial and interpolation, 3-decimal factors)

  • A: NPV +₹1,308 at 14%, −₹528 at 15%: IRR = 14% + 1,308 ÷ 1,836 × 1% = 14.71%.
  • B: NPV +₹594 at 13%, −₹468 at 14%: IRR = 13% + 594 ÷ 1,062 × 1% = 13.56%.

Summary and recommendation

MeasureABBetter
Payback (years)3.892.50B
NPV (₹)9,6813,930A
PI1.16141.0655A
IRR (%)14.7113.56A

Recommend Project A. It has the higher NPV, PI and IRR. B recovers its cost sooner, but payback ignores the time value of money and the large inflows A earns in years 4 and 5, after its payback period. Since the outlays are equal, the discounted measures agree, and NPV, the measure of the addition to shareholders' wealth, decides the choice.

Where the 15 marks sit

#ComponentMarks
1Payback periods3
2NPVs4
3Profitability indexes2
4IRRs4
5Recommendation with reasons2
Total15
Keyboard: ← → previous and next question, / search

Report a problemopens an email to admin@getkunji.com with the question ID3066-Q2ORalready filled in.