Calculate return on investment with annualized ROI, payback period, and risk-adjusted scenario analysis
You are an investment analyst with deep expertise in evaluating the financial performance of projects, assets, and strategic initiatives across industries. You understand that return on investment is one of the most widely used financial metrics, yet most people apply only the basic formula and miss the nuances that separate a useful ROI analysis from a misleading one. Your role is to take raw investment data, compute multiple ROI metrics, and deliver a thorough evaluation that accounts for time value, risk, opportunity cost, and real-world conditions. I need a complete ROI analysis for a [INVESTMENT_TYPE:select:marketing campaign,real estate,business project,equipment purchase,software implementation,employee training,stock investment,other] with an initial investment of [INITIAL_INVESTMENT] in [CURRENCY:select:USD,EUR,GBP,CAD,AUD]. The investment period is [INVESTMENT_PERIOD:select:monthly,quarterly,annual,multi-year], and the total revenue or value generated from this investment is [REVENUE_GENERATED]. If there are additional ongoing costs beyond the initial outlay such as maintenance fees, operational expenses, or financing costs, they are [ADDITIONAL_COSTS?]. Start by calculating the basic ROI percentage using the standard formula: net profit divided by total investment cost, multiplied by 100. Net profit is the total revenue generated minus the initial investment and any additional costs. Present this as a clear percentage and explain what it means in plain terms. Next, calculate the annualized ROI to normalize the return over time. Use the compound annual growth rate approach: take the final value divided by the initial investment, raise it to the power of one divided by the number of years, and subtract one. Present both the simple annualized ROI and the CAGR figure, and explain when each metric is more appropriate for the investment duration selected. Compute the payback period, which is the time required for cumulative returns to equal the initial investment. Express this in the same time unit as the investment period chosen. A shorter payback period generally indicates lower risk because the invested capital is recovered faster. Perform a risk-adjusted return analysis. Estimate a risk factor based on the investment type selected, since marketing campaigns carry higher uncertainty than equipment purchases or real estate in stable markets. Apply a discount rate appropriate to the risk level and present the pre-discount and post-discount ROI figures side by side so the gap representing the risk premium is immediately visible. Build a scenario analysis table with three projections. The optimistic scenario assumes revenue exceeds expectations by 20%, the base scenario uses the figures provided, and the conservative scenario assumes revenue falls short by 20%. For each scenario, recalculate the basic ROI, annualized ROI, and payback period in a comparison table. If comparison investments are available at [COMPARISON_INVESTMENTS?], run the same calculations for each alternative and present a side-by-side ranking table. Compare basic ROI, annualized ROI, payback period, and risk-adjusted return across all options. Highlight which investment delivers the highest absolute return, which has the shortest payback, and which offers the best risk-adjusted performance. Include an opportunity cost assessment comparing your investment ROI against a low-risk benchmark such as a treasury bond or market index fund to show whether the extra return justifies the additional risk. Close with a summary that states the total profit or loss in absolute currency terms, the percentage return, the recovery timeline, and whether the risk-adjusted return exceeds the opportunity cost of capital. If the investment underperforms its risk profile, flag this directly and suggest what conditions would need to change, whether that means reducing costs, increasing revenue targets, or shortening the investment timeline.
Use this prompt anywhere
10,000+ expert prompts for ChatGPT, Claude, Gemini, and wherever you use AI.
Get Early AccessReturn on investment is one of the most quoted financial metrics in business, yet a single percentage rarely tells the full story. The basic ROI formula divides net profit by total cost, but it ignores time, risk, and opportunity cost. An investment that returns 40% over five years looks very different from one that returns 25% in twelve months, and comparing them without annualization leads to poor decisions. A proper ROI analysis normalizes returns across time periods, applies discount rates for uncertainty, and benchmarks against what the same capital could earn elsewhere.
This ROI calculator template generates a complete investment evaluation from a single set of inputs. Enter your [INITIAL_INVESTMENT], [REVENUE_GENERATED], and [INVESTMENT_PERIOD] to get basic ROI, annualized ROI using compound annual growth rate, payback period, and a three-scenario projection table that models optimistic, base, and conservative outcomes. The prompt also produces a risk-adjusted return figure and an opportunity cost comparison against standard benchmarks. Try it in the Dock Editor to run multiple scenarios instantly without re-entering your data.
For a complete financial picture, connect your ROI results with a profit and loss statement to see how investment returns flow into overall business performance. If you are evaluating capital expenditures against operating budgets, a budget template helps map those investment costs into your spending plan for the period. To track how investment gains appear on your company books, the financial statement template organizes assets, liabilities, and equity into a standard reporting format.
Paste this prompt into ChatGPT, Claude, Gemini, or the Dock Editor. Select your [INVESTMENT_TYPE] from the dropdown and enter the [INITIAL_INVESTMENT] amount in your chosen [CURRENCY]. Choose the [INVESTMENT_PERIOD] that matches the duration of the investment.
Provide the total [REVENUE_GENERATED] from the investment. If there are ongoing expenses beyond the initial outlay, add them in the [ADDITIONAL_COSTS] field. The calculator uses both figures to compute net profit accurately.
If you are choosing between multiple opportunities, enter details in [COMPARISON_INVESTMENTS]. The output will produce a side-by-side table ranking each option by ROI, annualized return, payback period, and risk-adjusted performance.
Check the optimistic, base, and conservative projections. Each scenario recalculates all core metrics so you can see how sensitive your return is to revenue fluctuations of plus or minus 20%.
Compare the risk-adjusted ROI against the opportunity cost benchmark. If the adjusted return exceeds the benchmark, the investment justifies the risk. If it falls short, the summary section explains what conditions would need to change.
Evaluate whether a new equipment purchase, marketing campaign, or expansion project will generate sufficient returns to justify the capital outlay. Use the scenario analysis to stress-test assumptions before committing funds.
Calculate the return on marketing spend across campaigns and channels. Compare annualized ROI for short-term ad campaigns against longer content marketing investments to allocate budget toward the highest-performing strategies.
Analyze stock, real estate, or other personal investment returns with annualized metrics that account for holding period. Benchmark against index fund performance to confirm whether active investment choices are outperforming passive alternatives.
Build client-ready investment evaluations with risk-adjusted returns and multi-scenario modeling. Present side-by-side comparisons of competing capital allocation options to support executive decision-making.
Discover more prompts that could help with your workflow.
Track daily and monthly expenses with categorized spending logs, trend analysis, and budget alerts for personal or business finances
Generate pro forma financial statements with revenue projections, expense forecasts, and multi-scenario analysis
Project how your savings grow over time with compound interest, regular contributions, and inflation adjustments
10,000+ expert-curated prompts for ChatGPT, Claude, Gemini, and wherever you use AI. Our extension helps any prompt deliver better results.