Blog · Finance metrics and formulas · Finance and FP&A teams
Annualized ROI converts a total project return into an equivalent compound yearly rate. Follow a business project from its cost and terminal receipt to the annual rate, distinguish it from a simple yearly average, and check when cash-flow timing requires a different method.
ROI per annum is the compound annual rate that turns a business project's initial investment into its terminal value over the stated duration. With one initial payment and one final receipt, divide the terminal receipt by the initial investment, raise the result to one divided by years, and subtract one. Keep intermediate cash flows separate because this shortcut does not preserve their timing.
Total ROI = (Terminal receipt − Initial investment) / Initial investment
Annualized ROI = (Terminal receipt / Initial investment)^(1 / Years) − 1
Equivalently: Annualized ROI = (1 + Total ROI)^(1 / Years) − 1
Use a positive initial investment and a positive terminal receipt for this compound-growth interpretation. The terminal receipt includes the recovery of the initial investment; it is not just the profit. Entering the profit alone as the terminal receipt changes the calculation.
The result is an equivalent annual rate. It does not claim that the business earned the same amount each year or actually reinvested a payment at that rate. The mathematical structure is the same as compound annual growth, but the business inputs here are project outlays and proceeds rather than a sales series.
A hypothetical US manufacturer undertakes a custom tooling project. It pays the initial design and production costs immediately. The customer pays at acceptance two years later, and the manufacturer pays its remaining closeout costs at that same time. There are no intermediate receipts, additional capital contributions, or remaining asset values.
The project controller supplies this schedule. Export the cost register and customer payment schedule with project ID, payment date, signed amount, currency, and actual-or-expected status. Reconcile them by project before reducing the schedule to initial and terminal amounts; the duration here is measured in whole calendar years.
| Input or step | Amount or calculation | Result (USD unless otherwise labeled) |
|---|---|---|
| Initial project outlay (USD) | Approved cost schedule | 500,000 |
| Customer acceptance receipt (USD) | Contract payment schedule | 800,000 |
| Closeout payment at acceptance (USD) | Remaining project costs | 80,000 |
| Terminal net receipt (USD) | 800,000 − 80,000 | 720,000 |
| Duration (years) | Initial payment to acceptance | 2 |
| Total project gain (USD) | 720,000 − 500,000 | 220,000 |
| Terminal multiple (times) | 720,000 / 500,000 | 1.44 |
| Total ROI | 220,000 / 500,000 | 44.00% |
| Annualized ROI | 1.44^(1 / 2) − 1 | 20.00% |
| Simple yearly average | 44.00% / 2 | 22.00% |
Percentages are displayed to two decimal places. Calculate with the underlying values and round only for presentation.
The project earns $220,000 across its full life. Its total return is 44.00%, but its compound annual return is 20.00%. Calling the simple average of 22.00% an annualized compound return would fail the reconstruction check below.
Keep the project boundary explicit. This schedule uses the supplied project receipts and costs without a separate income-tax adjustment. A comparison against an after-tax proposal requires a consistent tax basis. For the broader distinction between project returns and operating capital returns, see ROI vs ROIC.
Use one row per project with these columns. The second row changes only duration, illustrating how the annual rate reacts when the same money returns sooner.
| Project | B: Initial outlay (USD) | C: Terminal receipt (USD) | D: Years | E: Total ROI | F: Annualized ROI |
|---|---|---|---|---|---|
| Tooling, base case | 500,000 | 720,000 | 2 | 44.00% | 20.00% |
| Tooling, earlier acceptance | 500,000 | 720,000 | 1 | 44.00% | 44.00% |
With the base case in row 2, enter the following formulas. Format E2 and F2 as percentages.
E2 =(C2-B2)/B2
F2 =(C2/B2)^(1/D2)-1
G2 =B2*(1+F2)^D2-C2
G2 is the reconciliation difference and should be zero within the workbook's rounding tolerance. Fill the formulas down for the earlier-acceptance case. The total dollar gain stays the same, but the annualized return rises because the wait is shorter.
Excel also offers =RRI(D2,B2,C2). Microsoft's RRI documentation defines its inputs as the number of periods, present value, and future value. Enter years as the period count when you want an annual rate. Covirage is not affiliated with Microsoft.
An annualized rate is useful only if it reconstructs the terminal amount:
| Check | Calculation | Reconstructed amount (USD) |
|---|---|---|
| Base case, compound annual rate | 500,000 × 1.20^2 | 720,000 |
| Earlier acceptance, annual rate | 500,000 × 1.44^1 | 720,000 |
| Base case, simple average compounded incorrectly | 500,000 × 1.22^2 | 744,200 |
The simple-average reconstruction overshoots by $24,200: $744,200 minus $720,000. That proves why dividing total ROI by years answers a different question. The first two reconstructions match their terminal receipts exactly.
Also reconcile the outlay and terminal receipt to the project cash schedule. A mathematically correct rate built from an omitted supplier payment remains a wrong business result. Retain the contract, cost schedule, acceptance assumption, and any excluded items alongside the calculation.
Many equipment, expansion, and process-improvement projects produce benefits during their lives. Adding those benefits together and pretending they all arrive at the end discards timing. Use the actual receipts and payments instead.
Microsoft's XIRR documentation describes a return calculation for cash flows that need not be periodic and uses a 365-day year. With signed cash flows in B2:B8 and their actual dates in A2:A8, its syntax is:
=XIRR(B2:B8,A2:A8)
Keep initial outflows negative and receipts positive. The IRR financial schedule guide covers that separate calculation and its limitations. A net present value comparison adds the finance-approved discount rate; annualizing a return does not supply that rate or settle the investment decision.
Upload a project workbook with initial costs, terminal receipts, durations, and any dated intermediate payments; Covirage maps the columns, and its tools compute and check figures from the supplied inputs. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for spreadsheet analysis for the supporting workflow.
No. Dividing total ROI by the number of years gives a simple yearly average. Annualized ROI uses compounding, so applying the annual rate repeatedly to the initial amount reproduces the terminal amount. Label the convention when comparing project proposals.
Yes, if the initial and terminal amounts fit the formula and you state the year fraction. The calculation expresses an equivalent yearly rate; it does not show that the project can be repeated or that the same return will continue.
Keep each receipt and payment on its actual date. Use a dated cash-flow return calculation rather than treating all receipts as terminal proceeds. Moving an early receipt to the final date changes the timing assumption and can change the investment comparison.
Only after checking their definitions. Annualized project ROI here is a compound return on a dated initial outlay and terminal receipt. ROIC uses after-tax operating earnings and an invested-capital base. Similar percentage labels do not make their scope, taxes, or timing equivalent.