How this instrument works
Percentage return takes two numbers — what something was worth at the start and what it is worth at the end — and reports the change between them as a share of the starting figure. It is the same arithmetic behind a stock's simple return, a savings balance's growth, a subscriber count's rise, or a markup on a wholesale price; nothing in the formula knows or cares what the two values represent, only that one came before the other.
This is the number a brokerage app, a crypto wallet, or a crowdfunding dashboard displays beside a balance without further explanation — a plain '+15%' next to an account that opened the period at one figure and closed it at another. Read that way it is a snapshot, not a certified performance figure. Return on investment customarily implies a deliberate purchase — money committed once, then realized once — while percentage return gets applied to any running number: a balance that may have grown partly from a fresh deposit and partly from an actual gain, sources this raw formula has no way to separate.
The formula also carries no sense of elapsed time. A 15% percentage return earned in a single month and the identical 15% spread across five years produce the same output here, so comparing two percentage returns side by side without checking how long each took is the most common way this figure gets misread — a fast 15% and a slow 15% are not equally good outcomes, even though this sheet reports them identically. Fees, taxes on any gain, and cash paid out along the way are left for the reader to account for separately.
- Enter what the holding or balance was worth at the start in Starting value, $.
- Enter what it is worth now, or what it sold for, in Ending value, $.
- Read Percentage return, % — the change between the two, measured against the starting figure.
- Try an Ending value, $ smaller than Starting value, $ to see the same arithmetic report a loss as a negative percentage.
Worked example — $1,000 growing to $1,150
Set Starting value, $ to 1,000 and Ending value, $ to 1,150. The change is 1,150 minus 1,000, which is 150. Dividing 150 by the starting figure of 1,000 gives 0.15, and multiplying by 100 turns that fraction into the answer the readout shows: Percentage return, % of 15.0.
That 15.0% is the entire answer this formula gives, whether the move from 1,000 to 1,150 took one month or five years — a 15% return earned in a month implies a far faster pace than the identical 15% spread across five years, and this sheet has no month or year field to tell the two apart. Pair the figure with the actual holding period, in your head or with a separate annualizing step, before setting it next to a return that already carries a time stamp.
Questions
What does percentage return actually measure?
The share of the starting value gained or lost by the time you reach the ending value, nothing more. It reads Starting value, $ and Ending value, $, subtracts one from the other, and divides by the starting figure, so the answer is always relative to where the number began, never to some outside benchmark or average.
How is percentage return different from ROI?
The arithmetic is identical — a change divided by a starting figure, times 100. What differs is customary use: ROI usually labels the inputs cost and final value and implies one deliberate investment, while percentage return gets applied more loosely to any before-and-after pair, from an account balance to an exchange rate, whether or not money was formally invested.
Does this include dividends, interest, or rent received along the way?
No. Starting value, $ and Ending value, $ are the only two inputs, so cash paid out during the period counts only if it is already folded into Ending value, $. A separate measure, holding period return, adds income to price change explicitly; leave income out here and the percentage understates what the position actually returned.
Can percentage return be negative?
Yes, whenever the ending value sits below the starting value. A balance falling from 1,000 to 850 reports a percentage return of −15%, the same size as the golden 15% gain above with the sign flipped — the formula does not treat losses specially, it simply divides a negative change by a positive starting figure.
What is the most common mistake people make reading this figure?
Treating it as investment performance when the ending value includes money that was added or withdrawn, not earned. A savings balance that grew from 1,000 to 1,150 purely because 100 was deposited midway shows the same 15% this sheet reports for a genuine market gain — the formula cannot tell a deposit apart from a return, so it only tells the truth when nothing but the underlying value's own movement separates the two figures.
Why does Starting value, $ have to be greater than zero?
Because the formula divides by it, and dividing by zero has no defined answer. The check on this sheet blocks a zero or negative Starting value, $ outright; Ending value, $ carries no such restriction, since a position is free to fall to zero or climb back from it without breaking the arithmetic.
References
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.