Payback Period & Internal Rate of Return (IRR) Template

1 Excel Sheet

Easily calculate the Payback Period and Internal Rate of Return (IRR) of an investment or a project. Excel template created by ex-McKinsey & Deloitte Consultants and JP Morgan Investment Bankers. Don’t reinvent the wheel. Download this Excel Template in a couple of clicks.

Licensing for:


Content Details

Expand all
This Excel template includes:
  1. Cells where you can easily input your initial investment and future cash flows
  2. A formula to automatically calculate your cumulative cash flows, payback period and internal rate of return
  3. A Chart that will be automatically updated based on your input

Additional features

Customer reviews

4.7 out of 5 stars (101 votes)

Write a review >

Did you know?

The average daily rate of a McKinsey consultant is $4,000? A lot more expensive than purchasing our Business & Consulting Toolkits.