Financial Planning Prompt: Assumptions and Simple Scenarios
Create an educational business-planning model with visible formulas, consistent periods and clearly labeled assumptions. Verify figures before decisions.
Illustrative cover; not a verified result from this prompt.
Read the full prompt
Help build an educational financial-planning worksheet for [BUSINESS MODEL] using only these supplied figures: [INPUTS AND PERIODS]. Separate revenue, variable costs, fixed costs, capital spending and cash timing. Show formulas and units, identify missing assumptions and compare clearly labeled scenarios. Distinguish accounting profit from cash balance. Do not invent industry benchmarks, financing terms, taxes or measured performance. Do not claim professional qualifications or recommend investments. Explain which inputs need review by the business owner and an appropriate professional.
Keep the model small enough to check
Start with one month and state whether figures include taxes, owner pay and equipment purchases. Mixing a monthly rent with yearly sales can make a plausible-looking table unusable.
Worked educational example
Assume a fictional workshop sells 100 items at ₹500 each. Variable cost is ₹200 per item and fixed monthly costs are ₹20,000. Revenue is ₹50,000; variable costs total ₹20,000; the remaining ₹10,000 follows after fixed costs. This simplified result excludes any costs not stated.
Contribution per item is ₹300. Covering ₹20,000 of fixed costs would require 66.67 items, so at least 67 whole items under these assumptions. Ask the prompt to show what changes at 60 sales without presenting either case as a forecast.
Check cash separately
Customers paying next month can leave cash short even when the worksheet shows a surplus. Verify collection dates, supplier payments and opening cash. Use this template to organize questions and calculations; have financial, accounting and tax decisions reviewed for the actual business.