founder.curiosta.com

The ladder / Level 4 · New products and services/ Business math

Payback, NPV, IRR and break-even with development cost

Simple payback, discounting and net present value, IRR as a check value, and how many units recover a one-time development cost.

How numbers are rounded on these pages. Calculations are done at full precision and rounded only at the end, half up. Rupee amounts are rounded to the nearest rupee unless shown with paise, in which case to the nearest paisa. Percentages are shown to two decimal places, months to one decimal place, years and ratios (such as LTV : CAC) to two, and discount factors to four. Discounting assumes cash flows at the end of each year, compounded yearly. IRR has no exact formula: it is found by repeated trial and shown to two decimal places as a check value. Break-even quantities are rounded up to the next whole unit. All examples and quiz questions are Hypothetical: they show the method, not real prices or rates.

Simple payback, NPV and IRR

A new product usually needs money now (design, tooling, launch) and pays back over several years. Three standard measures help you judge it.

Simple payback: how many years until the cash coming in equals the money put in. Easy, but it ignores the timing of money and anything after payback.

Net present value (NPV): a rupee next year is worth less than a rupee today, because today's rupee could earn a return meanwhile. So each future year's cash is discounted back to today at your required rate of return (the return you need, often your cost of capital), and the investment is subtracted. A positive NPV means the project earns more than that rate.

Internal rate of return (IRR): the discount rate at which NPV is exactly zero, in effect the project's own yearly return. There is no simple formula; it is found by trial. Accept if IRR is above your required rate. Here IRR is shown only as a check value. When projects differ in size or timing, rely on NPV.

The standard formulas

PaybackSimple payback = Initial investmentYearly cash inflow (equal inflows)
DiscountingDiscount factor for year t = 1(1 + r)tPresent value = Cash flow × Discount factor
Net present valueNPV = Σ Cash flowt(1 + r)t − Initial investment
Internal rate of returnIRR = the rate r at which NPV = 0 (found by trial)

Terms used

Cash flow
Money actually received or paid in a period (not profit after depreciation).
Required rate of return
The minimum yearly return you need from the project; also called the discount rate or hurdle rate.
Discount factor
What ₹1 received in year t is worth today at rate r.
Present value (PV)
A future amount converted into today's money.
Net present value (NPV)
Sum of the present values of all cash flows, including the initial investment as a negative.
Internal rate of return (IRR)
The discount rate that makes NPV zero.

Worked examples

HypotheticalBasicSimple payback

A new product needs ₹20,00,000 for design, tooling and launch, and is expected to bring ₹6,00,000 of net cash a year for 5 years.

  • Payback = ₹20,00,000 ÷ ₹6,00,000 = 3.33 years

HypotheticalIntermediateNPV at a 12% required return

Same project; discount each year's cash at 12%.

  • Year 1: ₹6,00,000 ÷ 1.121 = ₹5,35,714.29
  • Year 2: ₹6,00,000 ÷ 1.122 = ₹4,78,316.33
  • Year 3: ₹6,00,000 ÷ 1.123 = ₹4,27,068.15
  • Year 4: ₹6,00,000 ÷ 1.124 = ₹3,81,310.85
  • Year 5: ₹6,00,000 ÷ 1.125 = ₹3,40,456.11
  • Total present value = ₹21,62,865.72; NPV = ₹21,62,865.72 − ₹20,00,000 = ₹1,62,865.72

Positive, so the project earns more than 12% a year. (The total adds the unrounded values, so it can differ by a paisa from adding the rounded lines.)

HypotheticalAdvancedIRR as a check value

Try higher rates until NPV crosses zero.

  • NPV at 15% = ₹11,293.06; at 16% = −₹35,423.81
  • So IRR lies between 15% and 16%; by repeated trial it is about 15.24%
  • IRR 15.24% is above the 12% required return, which agrees with the positive NPV.

Break-even for a new product, including development cost

A new product carries one-time costs before the first sale: design, prototypes, tooling, testing, certification, launch. These are fixed costs that must be recovered from contribution, on top of the ongoing fixed costs of making and selling the product.

Work out how many units recover the one-time cost, how long that takes at the expected sales rate, and what price is needed to recover everything within a target volume. This is the same break-even logic as on the trader break-even page, with the development cost added to fixed costs.

The standard formulas

Units to recover one-time cost = One-time development costContribution per unit
Including running fixed costsBreak-even units for a period = One-time cost + Fixed costs for the periodContribution per unit
Time to recoverMonths to recover = One-time costMonthly contribution − Monthly fixed costs
Price for a target volumePrice needed = Variable cost per unit + One-time cost + Fixed costsTarget units

Terms used

One-time (development) cost
Spending before launch that does not repeat: design, tooling, testing, certification.
Tooling
Moulds, dies and fixtures made for a specific product.
Break-even point
Units (or sales) at which total contribution equals the costs to be recovered.

Worked examples

HypotheticalBasicRecovering the development cost

One-time costs for a new product:

  • Design: ₹6,00,000
  • Tooling: ₹9,00,000
  • Testing and certification: ₹3,00,000
  • Total = ₹18,00,000
  • Price ₹2,500, variable cost ₹1,600: contribution ₹900 a unit
  • Units to recover = ₹18,00,000 ÷ ₹900 = 2,000 units

HypotheticalIntermediateHow many months to recover it?

Running the product line also costs ₹50,000 a month in fixed costs; sales are expected at 400 units a month.

  • Monthly contribution = 400 × ₹900 = ₹3,60,000; after fixed costs ₹3,10,000
  • Months to recover = ₹18,00,000 ÷ ₹3,10,000 = 5.81, so the cost is recovered during month 6

HypotheticalAdvancedPrice needed to recover everything in year 1

Target: recover the ₹18,00,000 and first-year fixed costs of ₹6,00,000 from 3,000 units in year 1.

  • Price needed = ₹1,600 + (₹18,00,000 + ₹6,00,000) ÷ 3,000 = ₹1,600 + ₹800 = ₹2,400
  • At the planned ₹2,500, year-1 break-even = ₹24,00,000 ÷ ₹900 = 2,666.67, so 2,667 units

Quiz: payback, NPV, IRR and break-even with development cost

Pick an answer to see at once whether it is right, with a short explanation. Each question takes one try; your score appears at the end. No answers are sent anywhere. (Without JavaScript, open “Show answer” under each question.)

  1. Payback, NPV and IRR · BasicYou invest ₹12,00,000 and expect ₹3,00,000 of cash a year. Simple payback?
    Show answer

    Answer: (b) 4.00 years

    ₹12,00,000 ÷ ₹3,00,000 = 4.00 years.

    Why the other options are wrong:

    • (a) That divides the wrong way round.
    • (c) That subtracts in lakh.
    • (d) A slip of ten.
  2. Payback, NPV and IRR · BasicWhat is the discount factor for year 2 at 10% a year?
    Show answer

    Answer: (a) 0.8264

    1 ÷ 1.102 = 1 ÷ 1.21 = 0.8264.

    Why the other options are wrong:

    • (b) That takes off 20% (simple), not compounding.
    • (c) That is the growth factor; the discount factor is 1 ÷ 1.21.
    • (d) That is year 1.
  3. Payback, NPV and IRR · Intermediate₹1,10,000 will arrive in one year. Your required return is 10%. Present value today?
    Show answer

    Answer: (b) ₹1,00,000

    ₹1,10,000 ÷ 1.10 = ₹1,00,000.

    Why the other options are wrong:

    • (a) That takes 10% off; discounting divides by 1.10.
    • (c) That grows the amount instead of discounting it.
    • (d) That ignores the time value of money.
  4. Payback, NPV and IRR · IntermediateInvest ₹5,00,000 today; receive ₹3,00,000 at the end of year 1 and again at the end of year 2. Required return 10%. NPV?
    Show answer

    Answer: (c) ₹20,661.16

    ₹3,00,000 ÷ 1.1 + ₹3,00,000 ÷ 1.21 = ₹2,72,727.27 + ₹2,47,933.88 = ₹5,20,661.16; minus ₹5,00,000 = ₹20,661.16.

    Why the other options are wrong:

    • (a) That ignores discounting.
    • (b) That discounts year 2 with simple interest (÷ 1.20).
    • (d) That is the present value of the inflows; NPV subtracts the investment.
  5. Payback, NPV and IRR · AdvancedWhat does a project's IRR mean?
    Show answer

    Answer: (a) The discount rate at which its NPV is zero

    Accept if IRR is above your required rate of return.

    Why the other options are wrong:

    • (b) That is a profit margin.
    • (c) That is your borrowing cost, which may be part of your required return.
    • (d) That ignores timing.
  6. Payback, NPV and IRR · AdvancedInvest ₹10,00,000; receive ₹4,00,000 a year for 3 years. Your required return is 10%. Which is true?
    Show answer

    Answer: (a) NPV is about −₹5,259, so the IRR is below 10%

    PV of inflows = ₹4,00,000 × (1 ÷ 1.1 + 1 ÷ 1.21 + 1 ÷ 1.331) = ₹9,94,740.80; NPV = −₹5,259.20. IRR is about 9.70%.

    Why the other options are wrong:

    • (b) ₹2,00,000 is the undiscounted surplus; discounting turns it negative.
    • (c) NPV at 10% is not zero.
    • (d) Discounted, the inflows are worth less than ₹10,00,000.
  7. Break-even with development cost · BasicDevelopment cost is ₹12,00,000 and contribution ₹400 a unit. Units to recover the development cost?
    Show answer

    Answer: (b) 3,000 units

    ₹12,00,000 ÷ ₹400 = 3,000 units.

    Why the other options are wrong:

    • (a) A slip of ten.
    • (c) A slip of ten the other way.
    • (d) Not ₹12,00,000 ÷ ₹400.
  8. Break-even with development cost · BasicPrice ₹1,000, variable cost ₹650, development cost ₹7,00,000. Units to recover it?
    Show answer

    Answer: (c) 2,000 units

    Contribution ₹350. ₹7,00,000 ÷ ₹350 = 2,000 units.

    Why the other options are wrong:

    • (a) That divides by price, not contribution.
    • (b) That divides by variable cost.
    • (d) A slip of ten.
  9. Break-even with development cost · IntermediateDevelopment cost ₹10,00,000; fixed costs ₹4,00,000 a year; contribution ₹350 a unit. Units needed in year 1 to recover both?
    Show answer

    Answer: (c) 4,000 units

    (₹10,00,000 + ₹4,00,000) ÷ ₹350 = 4,000 units.

    Why the other options are wrong:

    • (a) That recovers only the development cost.
    • (b) That covers only the fixed costs.
    • (d) A slip of ten.
  10. Break-even with development cost · IntermediateBreak-even is 2,500 units and you sell 300 a month. In which month do you reach break-even?
    Show answer

    Answer: (b) Month 9

    2,500 ÷ 300 = 8.33, so break-even comes during month 9.

    Why the other options are wrong:

    • (a) After 8 months you have sold 2,400: not yet.
    • (c) Too early: 2,100 sold.
    • (d) A slip of ten.
  11. Break-even with development cost · AdvancedTo recover ₹15,00,000 development and ₹5,00,000 first-year fixed costs on 4,000 units in year 1, with variable cost ₹900, what is the minimum price?
    Show answer

    Answer: (d) ₹1,400

    ₹900 + ₹20,00,000 ÷ 4,000 = ₹900 + ₹500 = ₹1,400.

    Why the other options are wrong:

    • (a) That leaves out fixed costs.
    • (b) That leaves out development cost.
    • (c) That is only the cost to recover per unit.
  12. Break-even with development cost · AdvancedContribution ₹600 a unit, development cost ₹9,00,000. A redesign adds ₹2,00,000 of development cost but cuts variable cost by ₹100. New units to recover development cost?
    Show answer

    Answer: (d) 1,572 units

    ₹11,00,000 ÷ ₹700 = 1,571.43, so 1,572 units (round up), against 1,500 before.

    Why the other options are wrong:

    • (a) That is the old figure.
    • (b) That adds the cost but forgets the higher contribution.
    • (c) That uses the higher contribution but forgets the extra cost.