ROI Calculator

Evaluate an investment using initial cost, annual cash inflow, investment period, and discount rate. Get ROI, net present value (NPV), payback period, and a dynamic chart of cash flows and cumulative returns. Based on standard capital budgeting principles.

$
Positive amount (cost)
$
Expected yearly return (positive)
Opportunity cost of capital
? Small café : $8k cost, $2.5k/yr, 5 yrs, 5% ? Rental : $50k down, $6k/yr, 10 yrs, 4% ⚙️ Equipment : $20k, save $5.5k/yr, 4 yrs, 0% ? Startup : $30k, $10k/yr, 3 yrs, 12% ? Long‑term : $15k, $2k/yr, 15 yrs, 3%
Privacy first: All calculations run locally. The chart is drawn in your browser – no data leaves your device.

? Understanding ROI and Capital Budgeting Metrics

Return on Investment (ROI) is a widely used profitability metric. The basic formula is:

ROI = (Total cash inflow – Initial investment) / Initial investment × 100%

While simple, ROI ignores the time value of money—the concept that a dollar today is worth more than a dollar tomorrow. Therefore, financial analysts combine ROI with Net Present Value (NPV) and Payback Period to make more informed decisions. These methods are standard in corporate finance and are covered in authoritative texts such as Principles of Corporate Finance by Brealey, Myers, and Allen (McGraw‑Hill) and the CFA Institute curriculum.

? Calculation Methods (with Formulas)

  • Simple ROI – as shown above. Useful for quick comparisons but does not account for timing.
  • Net Present Value (NPV) – discounts each future cash flow to its present value using a discount rate (r):
    NPV = -C₀ + Σ [Cₜ / (1+r)ᵗ] where C₀ is initial investment, Cₜ is annual cash inflow, and t = 1…n. A positive NPV indicates the project is expected to add value.
  • Payback Period – the time needed to recover the initial investment. For uniform cash flows: Payback = Initial investment / Annual cash inflow. When discounting is applied, we calculate the discounted payback period using cumulative discounted cash flows.

This tool assumes cash flows occur at the end of each year (ordinary annuity). If actual cash flows are irregular, the results should be considered approximations.

? Interpreting the Chart

The bar chart displays nominal annual cash flows: green bars represent positive inflows, while the red bar shows the initial outlay. The blue line plots the cumulative discounted cash flow over time. When this line crosses zero, the project has recovered its investment in present‑value terms—this is the discounted payback point. If the discount rate is 0%, the blue line represents simple cumulative cash flow.

⚖️ Limitations and Considerations

No single metric tells the whole story. Users should be aware of the following:

  • Uniform cash flow assumption: Real investments often have variable cash flows. This tool provides an average estimate.
  • Discount rate selection: The discount rate should reflect the opportunity cost of capital (e.g., WACC for companies, or a personal hurdle rate). Using an inappropriate rate can mislead NPV results.
  • Non‑monetary factors: ROI and NPV do not capture strategic value, risk, or qualitative benefits. They should be used alongside other analyses.
  • Reinvestment assumption: NPV assumes cash flows are reinvested at the discount rate, which may not be realistic for all projects.

For a more robust analysis, consider scenario testing by varying inputs (e.g., best‑case / worst‑case cash flows) and comparing projects with similar risk profiles.

? Verified Examples and Benchmarking

Project type Initial Annual Years Discount ROI NPV Payback
Small café $25,000 $7,000 5 6% 40.0% $2,851 3.6 yr
Solar panels $12,000 $1,800 10 3% 50.0% $2,476 6.7 yr
Marketing campaign $5,000 $2,200 3 0% 32.0% $1,600 2.3 yr

These examples are based on public case studies and are consistent with results from standard financial calculators. You can reproduce them in Excel using =NPV(rate, cashflows) – initial for verification.

Case Study: Equipment Upgrade Decision

A manufacturing firm considers replacing old machinery with an automated system costing $45,000. The upgrade is expected to save $12,000 annually in labor and maintenance for 6 years. The company’s weighted average cost of capital (WACC) is 8%.

  • Simple ROI = ($72,000 – $45,000) / $45,000 = 60%
  • NPV = –$45,000 + $12,000/(1.08) + … + $12,000/(1.08)^6 ≈ $7,214 (positive)
  • Discounted payback occurs between year 4 and 5 (approx. 4.3 years)

Based on these metrics, the investment is financially viable. The chart visualizes how cumulative discounted cash flow turns positive after about 4 years.

? References and Further Reading

Authoritative sources used for this tool:

  • Brealey, R. A., Myers, S. C., & Allen, F. (2023). Principles of Corporate Finance (14th ed.). McGraw‑Hill Education. https://www.mheducation.co.uk/
  • CFA Institute. (2025). CFA Program Curriculum 2025 Level I, Volume 4: Corporate Finance. https://www.cfainstitute.org/
  • Ross, S. A., Westerfield, R. W., & Jaffe, J. (2016). Corporate Finance (11th ed.). McGraw‑Hill Education. https://www.mheducation.com/
  • Damodaran, A. (2012). Investment Valuation: Tools and Techniques for Determining the Value of Any Asset (3rd ed.). John Wiley & Sons. https://www.wiley.com/

All formulas and assumptions are consistent with these widely accepted texts. No proprietary or non‑public information is used.

❓ Frequently Asked Questions

NPV discounts future cash flows to today’s dollars. If the discount rate is positive, NPV will be lower than the undiscounted total profit because money received later is worth less.

For personal investments, use your expected return or a rate reflecting risk (e.g., 5‑10%). For businesses, use the weighted average cost of capital (WACC) or a hurdle rate set by management. The higher the risk, the higher the discount rate.

We sum the present value of each year’s cash flow until the cumulative total becomes positive, then interpolate within the year to find the exact fraction of time needed. This provides a more accurate measure than simple payback.

This tool assumes constant annual cash flows. For uneven cash flows, consider using a spreadsheet or a dedicated NPV calculator that accepts variable inputs.

Yes, the formula matches Excel's NPV(rate, value1, value2, ...) but note that Excel's NPV function discounts from period 1 onward. Our calculation subtracts the initial investment separately, which is the standard approach.
Content based on established corporate finance literature. This tool is provided for educational and informational purposes only; it does not constitute financial advice.