Projection assumptions
Scenario adjustments automatically modify revenue, growth, and cost assumptions while preserving your base inputs.
Sample Business Projection
Revenue, expenses, and net profit
Financial summary
| Total revenue | $375,645.14 |
|---|---|
| Total COGS | $131,475.80 |
| Gross profit | $244,169.34 |
| Gross margin | 65.0% |
| Operating expenses | $0.00 |
| Interest expense | $0.00 |
| Estimated taxes | $3,130.40 |
| Average monthly expenses | $10,956.32 |
Monthly projection table
| Month | Revenue | COGS | Gross Profit | Operating Expenses | Interest | Tax | Net Profit | Ending Cash | Loan Balance |
|---|---|---|---|---|---|---|---|---|---|
| 1 | $25,000.00 | $8,750.00 | $16,250.00 | $18,000.00 | $0.00 | $0.00 | $-1,750.00 | $48,250.00 | $0.00 |
| 2 | $26,000.00 | $9,100.00 | $16,900.00 | $18,240.00 | $0.00 | $0.00 | $-1,340.00 | $46,910.00 | $0.00 |
| 3 | $27,040.00 | $9,464.00 | $17,576.00 | $18,484.80 | $0.00 | $0.00 | $-908.80 | $46,001.20 | $0.00 |
| 4 | $28,121.60 | $9,842.56 | $18,279.04 | $18,734.54 | $0.00 | $0.00 | $-455.50 | $45,545.70 | $0.00 |
| 5 | $29,246.46 | $10,236.26 | $19,010.20 | $18,989.38 | $0.00 | $4.16 | $16.66 | $45,562.35 | $0.00 |
| 6 | $30,416.32 | $10,645.71 | $19,770.61 | $19,249.47 | $0.00 | $104.23 | $416.91 | $45,979.27 | $0.00 |
| 7 | $31,632.98 | $11,071.54 | $20,561.43 | $19,514.96 | $0.00 | $209.29 | $837.18 | $46,816.45 | $0.00 |
| 8 | $32,898.29 | $11,514.40 | $21,383.89 | $19,786.03 | $0.00 | $319.57 | $1,278.29 | $48,094.74 | $0.00 |
| 9 | $34,214.23 | $11,974.98 | $22,239.25 | $20,062.85 | $0.00 | $435.28 | $1,741.12 | $49,835.86 | $0.00 |
| 10 | $35,582.80 | $12,453.98 | $23,128.82 | $20,345.59 | $0.00 | $556.65 | $2,226.58 | $52,062.44 | $0.00 |
| 11 | $37,006.11 | $12,952.14 | $24,053.97 | $20,634.44 | $0.00 | $683.91 | $2,735.62 | $54,798.06 | $0.00 |
| 12 | $38,486.35 | $13,470.22 | $25,016.13 | $20,929.60 | $0.00 | $817.31 | $3,269.22 | $58,067.28 | $0.00 |
How Financial Projections Help Business Planning
Financial projections turn business assumptions into a structured view of future performance. They help founders, managers, and investors understand how revenue, expenses, financing, and taxes may interact over time. A projection does not guarantee future results, but it creates a practical planning framework. Start by entering realistic sales and cost assumptions based on current performance, market research, or a clearly documented business plan. Conservative inputs are often useful when testing whether a business can survive slower growth or higher costs.
Build projections from clear assumptions
Revenue forecasts normally begin with current monthly sales and an expected growth rate. Cost of goods sold should reflect the direct cost of delivering products or services. Fixed expenses include items such as rent, software, insurance, administration, and professional services. Payroll should be entered separately when staffing is a major expense. Variable expenses can represent payment fees, commissions, fulfilment costs, and other costs that rise with revenue. Funding, loan payments, and startup purchases should also be included because they can strongly affect cash even when the business appears profitable.
Compare profit with cash flow
Profit and cash are related but they are not identical. A business may show accounting profit while still experiencing cash pressure from debt repayments, inventory purchases, or large upfront costs. This generator therefore tracks both net profit and ending cash. The break-even indicator estimates when cumulative projected profit becomes positive. Scenario planning is equally important. The conservative scenario lowers sales expectations and raises costs, while the optimistic scenario assumes stronger revenue and improved cost efficiency. Comparing these outcomes helps reveal how sensitive the plan is to changing conditions.
Use projections as a living model
Update projections whenever real results become available. Replace assumptions with actual sales, costs, hiring changes, or financing decisions. Regular updates can improve budgeting, identify funding gaps earlier, and support better conversations with lenders or investors. Exporting the table to CSV makes further spreadsheet analysis easy, while the PDF report provides a convenient snapshot for meetings. Always review important financial decisions with a qualified accountant or financial adviser when necessary.
Example financial assumptions
| Assumption | Example | Purpose |
|---|---|---|
| Starting monthly revenue | $25,000 | Creates the base sales level. |
| Monthly growth | 4% | Projects future revenue expansion. |
| COGS | 35% | Estimates direct delivery costs. |
| Fixed expenses | $9,000 | Represents recurring overhead. |
| Payroll | $7,000 | Captures staff compensation. |
| Tax rate | 20% | Estimates tax on positive pre-tax profit. |
Frequently Asked Questions
What is a financial projection?
A financial projection is an estimate of future revenue, expenses, profit, cash flow, and financial position based on stated assumptions.
How many months should I project?
Twelve months is useful for operational planning, while three to five years is more common for long-term business plans and funding discussions.
What is the difference between COGS and operating expenses?
COGS covers direct costs tied to delivering sales. Operating expenses cover overhead such as payroll, rent, software, marketing, and administration.
How is break-even calculated here?
The tool identifies the first month when cumulative projected net profit becomes zero or positive after any one-time startup cost.
Why should I use multiple scenarios?
Scenarios show how the plan changes when revenue growth, sales levels, or costs perform better or worse than expected.
Can I use the CSV file in Excel?
Yes. The CSV download can be opened in Excel, Google Sheets, LibreOffice Calc, and most spreadsheet applications.
Is this a substitute for professional financial advice?
No. The tool is for planning and educational purposes. Important tax, investment, lending, or accounting decisions should be reviewed professionally.