Australia version. Set to Australia: A$ and the Office of Impact Analysis convention of a 7% real discount rate, tested at 3% and 10%. US version
NPV and IRR Calculator (Australia)
Net present value and IRR in A$ at the 7% real discount rate the Office of Impact Analysis requires, with the 3% and 10% sensitivity tests for a business case.
The interactive tool loads here when JavaScript runs.
About this toolWhat is the NPV and IRR Calculator?
Australian Government cost-benefit analysis uses a fixed convention. Treasury's evaluation guide says the Office of Impact Analysis requires net present values at an annual real discount rate of 7%, with sensitivity calculations at 3% and 10%. This version opens at 7% in A$; run it again at 3% and 10% to complete the three results an impact analysis expects.
Enter yearly net flows in real terms, with the upfront cost as a negative number. You get NPV, IRR, MIRR, payback, discounted payback and the profitability index. When all the cost falls in year 0, the profitability index is the same number as the benefit-cost ratio in Treasury's guide (present value of benefits divided by present value of costs); when costs are spread over years, work the BCR out from the discounted table.
The guide also lists what to leave out: sunk costs, depreciation and interest, because discounting already accounts for the cost of money.
- NPV with period 0 undiscounted, as in finance textbooks
- Every IRR found by grid scan plus safeguarded Newton and bisection
- Clear messages for no IRR and multiple IRRs
- MIRR with separate finance and reinvestment rates
- Simple and discounted payback, profitability index
- NPV profile chart and a table of discounted and cumulative flows
Updated
How to use the NPV and IRR Calculator
- Type the cash flows one per line, starting with the period 0 amount (usually the negative investment). Commas, semicolons and brackets for negatives also work.
- Enter the discount rate, which is your required return or cost of capital, and choose whether each period is a year, a quarter or a month.
- Optionally set separate finance and reinvestment rates for MIRR; blank uses the discount rate.
- Read NPV, IRR, MIRR, payback, discounted payback and the profitability index, and any note about multiple or missing IRRs.
- Use the NPV profile chart and the cash flow table to see how sensitive the decision is to the rate.
Worked examples
A proposal that fails the 10% test
Input
-A$3,000,000 now, then A$450,000 a year for 10 years, real terms
Output
NPV A$160,611.69 at 7%; A$838,591.28 at 3%; -A$234,944.80 at 10%; IRR 8.144%
Positive at the central 7% rate, negative at 10%. Reporting all three shows decision makers that the case depends on the discount rate as well as the benefits.
Reading the benefit-cost ratio
Input
Same flows at 7%
Output
Profitability index 1.054; discounted payback 9.30 years
With the whole cost up front, the BCR is 1.054: A$1.054 of discounted benefit for every A$1 of cost. The discounted payback comes only months before the end of the 10-year appraisal.
Background and insight
Net present value discounts every cash flow back to period 0 at the discount rate r and adds them: NPV = Σ CFₜ ÷ (1 + r)ᵗ. A positive NPV means the project returns more than r after paying back the investment, in present-day money. Note that the NPV function in Excel and Google Sheets discounts its first argument by one period, so the period 0 investment must be added outside it. This calculator does not discount period 0, which matches the textbook definition.
The internal rate of return is the discount rate that makes NPV exactly zero. There is no closed formula, so it has to be found numerically. Simple solvers start from a guess and apply Newton's method, which can wander off or converge to only one of several answers. This tool first evaluates NPV across a fine grid of rates to find every interval where it changes sign, then narrows each one with Newton steps that fall back to bisection whenever a step would leave the interval. Descartes' rule of signs says the number of IRRs is at most the number of sign changes in the cash flows, which is why mining, nuclear and other projects with closing costs can have two.
MIRR fixes two weaknesses of IRR. It discounts the outflows at a finance rate and compounds the inflows to the final period at a reinvestment rate, then finds the single rate that links the two: MIRR = (FV of inflows ÷ PV of outflows)^(1/n) − 1. It always has exactly one answer, and it does not assume interim cash is reinvested at the IRR itself. Payback period counts how long until cumulative cash flow turns positive; discounted payback does the same with present values, and both interpolate within the period.
Common use cases
Capital budgeting
Decide whether equipment, a new product line or an expansion earns more than the cost of capital.
Comparing projects
Rank mutually exclusive options by NPV and see on the profile chart where their ranking would flip.
Real estate and private deals
Evaluate a property or private investment from its purchase, yearly net income and sale proceeds.
Corporate finance coursework
Check NPV, IRR, MIRR and payback answers, including the tricky multiple-IRR textbook cases.
Tips and limitations
- Use real values (today's prices) with the 7% real rate. Do not discount nominal forecasts at a real rate.
- Leave out sunk costs, depreciation and interest, as Treasury's guide says; including depreciation double counts the capital cost.
- The IRR tells you the rate at which the NPV crosses zero: here 8.144%, between the 7% central case and the 10% test.
- For a private investment, discount at the business's own cost of capital; the OIA convention is for government proposals.
Sources and further reading
- Cost-Benefit Analysis (CBA), Australian Treasury (evaluation.treasury.gov.au). OIA 7% real rate with 3% and 10% sensitivity; NPV and BCR; items to exclude. Last updated 2 July 2025
- Valuing the Future: the social discount rate in cost-benefit analysis, Productivity Commission (Mark Harrison, 2010). Visiting researcher paper proposing an 8% base rate tested over 3% to 10%
Frequently asked questions
What discount rate does the Australian Government use for cost-benefit analysis?
Treasury's evaluation guide states that the Office of Impact Analysis requires NPVs at an annual real discount rate of 7%, with sensitivity analysis at 3% and 10%. The rates are real, so cash flows should be in real terms.
How do I calculate a benefit-cost ratio?
Divide the present value of benefits by the present value of costs. A BCR above 1 means benefits outweigh costs. If the only cost is the year-0 outlay, the calculator's profitability index is the BCR; otherwise discount costs and benefits separately using the cash flow table.
Should I include depreciation or interest in the cash flows?
No. Treasury's guide excludes depreciation because the capital cost is already counted when it is spent, and interest because discounting already reflects the cost of money. Sunk costs are left out too.
Why run 3% and 10% as well as 7%?
Because the choice of rate is uncertain and can change the answer. The OIA requires the two sensitivity tests so readers see whether a proposal's NPV stays positive across a reasonable range.
Where does the 7% rate come from?
Treasury's guide states the requirement without deriving it. A 2010 Productivity Commission paper by Mark Harrison reviewed the choice and proposed a base rate of 8% tested over 3% to 10%; the current OIA requirement, as Treasury's guide states it, is 7% with tests at 3% and 10%.
Is NPV in A$ any different from NPV in US dollars?
The formula is identical; only the currency and the rate convention differ. Set the currency to A$ so copied results and reports show Australian dollars.
Is there an in-depth guide to the NPV and IRR Calculator?
Yes. “Time Value of Money: PV, FV, NPV, IRR, CAGR and ROI Explained” covers the background, how it works, common pitfalls and worked examples. Read the full guide.
Related Tools You May Like
Free, in-browser tools that pair well with this one.