Canada version. Set to Canada: Canadian dollars and the Treasury Board Secretariat's 7% discount rate, with the 3% social discount rate to test against. US version

NPV and IRR Calculator (Canada)

Net present value and IRR in Canadian dollars, starting at the 7% rate the Treasury Board Secretariat recommends for cost-benefit analysis, with the 3% social rate.

The interactive tool loads here when JavaScript runs.

About this tool

What is the NPV and IRR Calculator?

Federal cost-benefit analysis in Canada starts from a fixed rate. The Treasury Board of Canada Secretariat recommends that present values be estimated using a 7% discount rate, based on a weighted average of foreign and domestic sources of capital, and allows a social discount rate of 3% where benefits and costs do not crowd out or create private investment. The Policy on Cost-Benefit Analysis adds that even when the social rate is used, results at the opportunity cost of capital must also be reported. This version opens at 7% in Canadian dollars.

Enter the yearly flows with the upfront cost as a negative number, and the calculator returns NPV, IRR, MIRR, payback and discounted payback. Changing the rate between 7% and 3% shows how much of a project's case rests on the discount rate rather than on its cash flows.

A business deciding on its own investment would use its own cost of capital; the math is identical.

  • 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
Read the guide: Time Value of Money: PV, FV, NPV, IRR, CAGR and ROI Explained

Updated

How to use the NPV and IRR Calculator

  1. 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.
  2. 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.
  3. Optionally set separate finance and reinvestment rates for MIRR; blank uses the discount rate.
  4. Read NPV, IRR, MIRR, payback, discounted payback and the profitability index, and any note about multiple or missing IRRs.
  5. 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 passes only at the social rate

Input

-CA$5,000,000 now, then CA$700,000 a year for 10 years

Output

NPV -CA$83,492.92 at 7%; CA$971,141.99 at 3%; IRR 6.637%

The IRR sits between the two federal rates, so the answer depends on which rate applies. Under the policy, a case that uses 3% must still report the 7% result, which here is negative.

A shorter, stronger case

Input

-CA$5,000,000, then CA$900,000 a year for 8 years

Output

NPV CA$374,168.66 at 7%; CA$1,317,722.97 at 3%; IRR 8.899%; payback 5.56 years

Positive at both rates, so the conclusion does not hang on the choice. Payback ignores discounting; discounted payback at 7% is longer.

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

  • TBS reports express figures in one base year's dollars to remove inflation before discounting, so enter flows in constant dollars when using the TBS rates.
  • The social rate of 3% is meant for proposals that mainly affect private consumption or have impacts over 50 years or more, according to the policy.
  • An IRR between 3% and 7% is the warning zone: the decision depends on the rate you are told to use.
  • For quarterly or monthly flows, change "Each period is one"; the annual rate is converted to the matching period rate.

Sources and further reading

  1. Policy on Cost-Benefit Analysis, Treasury Board of Canada Secretariat. Opportunity cost of capital by default; social discount rate cases; reporting both
  2. Annual Report for the 2023 to 2024 Fiscal Year: Federal Regulatory Management Initiatives, Treasury Board of Canada Secretariat. 7% recommended rate and its basis; 3% social discount rate; constant dollars

Frequently asked questions

What discount rate does the Government of Canada use for cost-benefit analysis?

The Treasury Board of Canada Secretariat recommends a 7% discount rate for present values, based on a weighted average of foreign and domestic sources of capital funding. A social discount rate of 3% may be appropriate where costs and benefits do not crowd out or create private investment.

When can I use the 3% social discount rate?

The Policy on Cost-Benefit Analysis allows it when a regulatory proposal primarily affects private consumption of goods and services, or when its impacts occur over 50 years or more. Even then, results at the opportunity cost of capital must also be reported.

Should my NPV use real or nominal dollars?

Use real (constant) dollars with the federal rates: TBS reports express figures in a base year's dollars to remove inflation before discounting. If you only have nominal forecasts, use a nominal discount rate instead; do not mix the two.

What does an IRR of 6.6% mean against a 7% rate?

The project earns slightly less than the rate you are discounting at, so the NPV at 7% is negative. At any rate below the IRR, including the 3% social rate, the NPV turns positive.

Is NPV in Canadian dollars different from US dollars?

No, the formula is the same. Only the currency shown and the discount rate convention change. Switch the currency to CA$ so reports and copied results read correctly.

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.