Handled by Morning Book a free look

Was it worth the money?

A return on investment calculator for one purchase, and a project calculator for money that comes back over several years: net present value, internal rate of return and the payback period. It is plain arithmetic that runs in your browser. Nothing you type leaves this page.

Simple return on investment

The numbers already in the boxes are an example. Type over them.

A project over several years

Net cash back each year

What the project brings in that year, minus what it costs to run that year. Put a minus sign or brackets on a year that costs more than it brings in.

The numbers already in the boxes are an example. Type over them. Pasted numbers fill year 1 onward. If the first pasted number is below zero, it is taken as the upfront cost.

Year by year

Want the cost side checked too?

The margin and markup calculator shows what a price change or a cost rise does to the profit on each sale.

Want to know what last year's spending actually returned?

I connect your books read-only and send one page each morning with what was spent and what came in, checked against your own totals. A free 30-minute look shows what your systems could answer today.

This sends your email address and nothing else. Nothing you put into the tool is sent.

Book a free look

The formulas

ROI = (what came back − what it cost) ÷ what it cost

yearly rate = (what came back ÷ what it cost)1 ÷ years − 1

Spend $20,000 and get $26,000 back three years later: the gain is $6,000 and the ROI is 30%. Spread over three years with each year building on the last, that is 9.14% a year, not 10%.

NPV = cash in year 0 + cash in year 1 ÷ (1 + rate) + cash in year 2 ÷ (1 + rate)2 + …

Net present value turns every year's cash into today's dollars and adds them up. A dollar next year is worth less than a dollar today, because today's dollar could be earning the discount rate in the meantime. Spend $1,000 today and get $600 back at the end of each of the next two years. At 10% a year the $600 next year is worth $545.45 today and the $600 the year after is worth $495.87. Together that is $1,041.32, so the net present value is $41.32. Above zero means the project beats the discount rate.

IRR = the rate at which NPV = 0

The internal rate of return is the yearly rate the project earns on its own. There is no direct formula, so the calculator tries rates until the net present value comes to zero. For the same $1,000 project it is 13.07%, which is higher than the 10% discount rate, as the positive net present value already said.

payback = years before the running total turns positive + (what is still owed ÷ the next year's cash)

After year 1 of that project, $400 is still to be covered, and year 2 brings $600. The payback is 1 + 400 ÷ 600 = 1.67 years. Discounted payback does the same with the values in today's dollars and comes to 1.92 years.

When to use which

Use the simple ROI when the money goes out once and comes back once, like stock bought and sold, or equipment bought and later sold. Add the years to compare it fairly with a savings rate or a loan rate.

Use net present value to decide whether a project is worth doing at all: above zero, it earns more than your discount rate. It is also the one to trust when comparing projects of different sizes, because it is in dollars.

Use the internal rate of return to compare projects in a single percentage, or to set against what you pay to borrow. It can mislead when the cash turns between in and out more than once, or when one project is much bigger than another.

Use payback when getting the cash back quickly matters more than the total, for example when cash is tight. It ignores everything after the payback year, so use it next to net present value, not instead of it.

Questions

What discount rate should I use?

Use the yearly return you could get by putting the money somewhere else of similar risk, or the interest rate you pay on the money you would borrow for the project. If you are unsure, try a few rates and see whether the answer changes.

Why does it say there is no rate of return?

An internal rate of return needs money going out and money coming in. If every year is a cost, or every year is income, no rate brings the net present value to zero.

Why can there be more than one internal rate of return?

When the cash changes between in and out more than once, for example a big cleanup cost in the last year, the net present value can cross zero at two or more rates. The calculator shows the one nearest zero and lists the others. Net present value at your own discount rate gives one clear answer in that case.

Does it assume cash comes at the end of each year?

Yes. The upfront cost is today, and each year's cash is counted at the end of that year. Payback assumes the cash comes in evenly during the year.

Is anything I type sent anywhere?

No. The arithmetic runs in your browser. This is plain arithmetic, not AI.

Who made this?

Handled by Morning sets up private reporting and AI on a company's own books for businesses of about 10 to 100 people. This is one of its free tools.