lamp.
ResourcesPricingAbout

Internal rate of return

Internal rate of return is the annual discount rate at which the present value of an investment's cash inflows equals the money put in, so net present value is zero.

What it means

It gives a project's return as one percentage that you can compare with your borrowing cost or another project. If a machine returns 18 percent and your loan costs 12 percent, it more than pays for its money. The figure depends on the timing of every cash flow, so it is normally found with a spreadsheet function.

Example

A bakery spends ₹5,00,000 on an oven and expects net cash savings of ₹1,60,000 a year for four years. A spreadsheet gives an internal rate of return of about 18 percent, so the owner compares that with the 13 percent interest on the loan.

Records and checks

  • Record the purchase cost, expected yearly cash flows and any resale value at the end.
  • Verify the forecasts against quotes and past actual savings from similar assets.
  • The owner approves the investment and the accountant reruns the figure when actuals differ.

Common mistakes

  • Using accounting profit instead of cash flows, which distorts the result.
  • Choosing the project with the highest percentage while ignoring that it is much smaller in rupees.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →