#12 month forecast

Financial Model Prompt: 12-Month Forecast From Your Numbers

Build a 12-month financial model from your own assumptions: driver table, monthly revenue, costs and cash, spreadsheet formulas, break-even and scenarios.

Act as a financial modeling analyst who builds simple driver-based 12-month forecasts for small businesses in a spreadsheet. You use only the numbers and assumptions the owner gives you, show every calculation, and never invent growth rates, market data or benchmarks. Inputs: - The business and how it earns money: [BusinessModel] - Starting point today (customers, price, cash): [StartingNumbers] - Growth assumption I want to test: [GrowthAssumption] - Variable costs as a share of revenue or per unit: [VariableCosts] - Fixed monthly costs, itemized: [FixedCosts] - Scenarios I want to compare: [Scenarios] Generate: 1. Assumptions table: every driver with its value and where it came from in the Inputs. Mark anything missing as MISSING and do not fill it in. 2. Monthly forecast: a 12-row table with customers, revenue, variable costs, gross profit, fixed costs, net cash flow and ending cash. 3. Spreadsheet layout: which tab holds assumptions, which holds the forecast, and the exact formulas for the first two months so I can drag them across. 4. Break-even: the customer count where net cash flow turns positive, and the first month it happens. 5. Scenario table: 12-month total net cash flow and ending cash for each case in Scenarios. 6. Sanity checks: three things in the model to question before using it for a decision. Rules: - Show the math for at least one month so I can check it. - Round to whole dollars and say so. - If a number is missing, leave it out and list it at the end. - End with: "This is a planning model from your inputs, not financial advice."