Bridgesheet

IRR and MOIC calculator

Free

Calculates the IRR, MOIC and NPV of an investment from its annual cash flows: equity invested, dividends, exit. The Excel file uses the IRR function, with a check that the NPV is zero at the IRR.

Download the example file (.xlsx)
  • 5 sheets
  • IRR, MOIC and NPV
  • 2 checks and 3 alerts
  • Input
  • Calculation

01 — Investment cash flows

Step 1 of 1
%

Tip: copy a block of cells in Excel or Google Sheets, then paste it into a table cell. Rows and columns fill in from that cell; rows are added when needed.

RowLabelCash flowActions
1
2
3
4
5
6
6 rows · from 2 to 40 · Amounts in k€

Live preview

Recalculating…

Download

Summary, charts and sensitivities, ready to drop into a presentation.

File language

Independent of the interface: for instance, generate a French or German model for a client abroad.

Model currencyEUReditable in the General step

Free plan: files carry a “Free version” notice.

Method

Cash flows are annual: the first is period 0, then one per year. Outflows are negative, inflows positive.

MOIC divides total inflows by total outflows. NPV discounts each cash flow at the required rate of return.

IRR is the rate at which the NPV is zero, calculated with Excel's IRR function. It is unique when cash flows change sign only once; otherwise an alert flags it.

What's in the file

  1. 01CoverInvestment, date, currency, checks status, contents and disclaimer.
  2. 02InputsYear of the first cash flow, required rate of return and the cash flow table.
  3. 03IRRPeriods, years, cash flows, cumulative, discount factors, present values, sign changes.
  4. 04OutputsAmounts invested and returned, net gain, MOIC, IRR and NPV.
  5. 05ChecksTwo integrity checks and three alerts kept out of the total.