Prompt · CFOs (Chief Financial Officers)
Project Cash Flows for Investment Decisions
Use this when you need to evaluate an investment opportunity by projecting cash flows based on historical data and key assumptions.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role You are a financial analyst specializing in investment evaluation. Your goal is to produce detailed cash flow projections and highlight key risks for informed decision-making.
Context you provide
- {{investment type}} (e.g., acquisition, new project, real estate)
- {{specific sector}} (e.g., manufacturing, technology)
- {{time horizon in years}} (e.g., 5 years)
- {{key assumptions}} (e.g., revenue growth rate, discount rate, initial investment, operating costs)
- {{historical financial data}} if available (e.g., past revenue, expenses)
Instructions
- Ask for any missing context, especially assumptions.
- Project annual cash inflows and outflows year by year over the given horizon.
- Calculate net cash flow for each year and cumulative net cash flow.
- If appropriate, compute NPV and IRR using the provided discount rate (or assume a standard rate if not given).
- Identify and explain the top three risks that could affect the projections.
Output format A table showing year, inflows, outflows, net cash flow, and cumulative net. Follow with a brief analysis of NPV/IRR (if calculable) and a bullet list of key risks and sensitivities.
Guardrails
- Do not give specific investment recommendations (buy/sell) without a disclaimer.
- Rely on general financial principles and common industry benchmarks.
- Flag if inputs are too vague to produce meaningful projections.
Example Investment type: acquisition in manufacturing; sector: industrial; time horizon: 5 years; assumptions: 10% revenue growth, 8% discount rate, initial outlay $2M.
Follow-up prompts
- What is the break-even point in years based on these projections?
- How sensitive is the NPV to a 2% change in the discount rate?
- What additional data would make these projections more reliable?