Learning how to create financial projections is less about building a complicated spreadsheet and more about making the business understandable before the next decision. A useful projection connects what you expect to sell with the costs, staffing, cash timing, and capacity required to deliver that work. It gives an owner a practical view of what may happen next.
Request a Strategy Session to turn your assumptions into an accountable operating plan.
Answer capsule: To create financial projections, define the decision and time horizon, gather reliable historical results, forecast revenue from measurable drivers, map direct costs and overhead, model when cash will move, and test realistic scenarios. Review the projection against actual results each month, then update the assumptions that changed instead of hiding the variance.
The goal is not to predict every dollar perfectly. The goal is to make the logic behind your numbers visible so you can decide whether to hire, spend, expand, borrow, or slow down. The process below is designed for owner-led small and medium-sized businesses that need a useful planning tool, not a finance exercise that nobody maintains.
Why Should a Small Business Create Financial Projections?
A projection turns a business plan into a set of operating questions. If revenue grows, what delivery costs rise with it? If a customer pays in 45 days, how much cash is available before that payment arrives? If you add an employee, when does the cost begin and what volume must that person support? Those connections are more useful than a single annual sales goal.
Financial projections can also support a business plan or a funding conversation. The U.S. Small Business Administration describes a business plan as a roadmap for structuring, running, and growing a company. It also notes that financial information can help when seeking funding or bringing on business partners. Read the SBA’s business plan guidance for the broader planning context.
For internal management, keep the purpose specific. A projection built to evaluate a hire may need monthly labor, capacity, and cash detail. A projection for an expansion decision may need several scenarios and a longer horizon. A projection prepared for a lender may need clear support for its assumptions and a consistent connection to the business plan.
What Should a Financial Projection Include?
A practical projection includes the financial views needed for the decision, but it does not need every possible line item. Start with a monthly operating view, then add detail only when it changes an action. At minimum, connect the following parts:
| Projection area | What it answers | Typical inputs |
|---|---|---|
| Revenue | What may the business sell? | Customers, jobs, units, price, close timing, renewals |
| Direct costs | What does each sale require? | Materials, subcontractors, delivery labor, payment fees |
| Overhead | What does it cost to operate? | Payroll, rent, software, insurance, marketing, professional fees |
| Cash timing | When does money enter and leave? | Payment terms, collections, payroll dates, supplier terms, debt |
| Scenarios | What changes if assumptions move? | Volume, price, timing, hiring, costs, capacity |
This is different from a sales forecast alone. A sales forecast estimates expected revenue. A financial projection carries that revenue through costs, operating results, and cash timing so you can see whether the plan is workable. CCG’s sales forecast spreadsheet guide covers the revenue-driver portion in more detail.
How Do You Create Financial Projections Step by Step?
1. Define the decision, audience, and time horizon
Start by writing one sentence that explains why you are building the projection. For example: “I need to decide whether the business can add one delivery employee in January without creating a cash shortfall.” That sentence prevents unnecessary detail and gives you a test for every line in the spreadsheet.
Next, choose the time horizon. A 12-month monthly projection is a practical starting point for many established small businesses because it shows near-term timing while covering a full operating cycle. If the business is seasonal, include enough history and forward view to see the relevant season. If you are evaluating a large investment, extend the horizon far enough to show when the decision should pay back. Use monthly detail when timing matters, not because more columns automatically make the projection better.
2. Separate verified facts from assumptions
Gather the most recent income statement, sales records, payroll information, recurring bills, debt schedule, payment terms, and bank or bookkeeping reports available to you. Mark each input as a verified fact, a management assumption, or an item that still needs confirmation. Add the source, date, owner, and confidence level for any assumption that materially affects the result.
Verified facts might include a signed contract, an established rent payment, or actual payroll. Assumptions might include the number of jobs expected next month, a possible price change, a planned hire, or the timing of a proposal. Do not present an assumption as historical performance. If the business has limited history, say so and use conservative ranges rather than giving a precise-looking number more confidence than it deserves.
The University of Wisconsin-Madison SBDC’s financial projections course emphasizes identifying the inputs needed to build projections and translating a business story into projection documents. That is a useful discipline for an owner: explain the operating story first, then make the numbers reflect it.
3. Forecast revenue from business drivers
Build revenue from the activities that create it. Depending on the business, the formula may be completed jobs multiplied by average job value, customers multiplied by average monthly revenue, billable hours multiplied by realization rate, or units sold multiplied by price. Choose the driver that the owner or team can observe and influence.
List each meaningful revenue stream separately when its volume, price, timing, or margin behaves differently. Separate contracted work from probable work and from opportunities that are still speculative. For a service company, also check delivery capacity. A projection that assumes more work than the team can complete is not an operating plan until staffing, scheduling, or subcontracting changes are included.
Do not make a target the same thing as a forecast. A target describes the result you want. A forecast describes the result the current evidence and assumptions suggest. Keep both if they are useful, but label them clearly.
4. Add direct costs and operating overhead
Once revenue is mapped, list the costs required to produce and deliver it. Direct costs usually move with a specific sale, such as materials, job labor, subcontractors, shipping, or transaction fees. Operating overhead supports the business more broadly, such as administrative payroll, rent, software, insurance, marketing, and professional services.
Use the historical relationship between revenue and direct costs as a starting point, but question whether the relationship will remain valid. A new supplier, service mix, wage rate, or pricing strategy can change margins. For overhead, identify fixed, variable, and step costs. A step cost stays stable until the business crosses a threshold, such as hiring a manager, adding a vehicle, or moving into a larger facility.
Show planned changes in the month they are expected to begin. If a hire is part of the revenue plan, include compensation, payroll taxes, benefits, recruiting costs, training time, and the ramp period. Otherwise, the projection may show the benefit of growth while leaving out the cost of producing it.
5. Model cash timing separately from profit
A profitable month and a cash-rich month are not always the same. A sale may be recorded before the customer pays, while payroll, rent, suppliers, taxes, and debt payments may leave the account on fixed dates. Add a cash timing view that starts with beginning cash, adds expected collections, subtracts expected payments, and ends with projected cash.
Use realistic collection assumptions by customer or revenue stream when payment timing varies. Include deposits, progress payments, accounts receivable, supplier terms, taxes, loan payments, equipment purchases, and owner distributions when they affect cash. You do not need to create false precision. The important point is to show when the cash pressure could occur and what decision would reduce it.
This is where a projection becomes a management tool. A strong sales month may increase future cash but still create a near-term funding need if delivery costs arrive before collections. A slower month may be manageable if the business has enough cash and flexible spending. Look at both the operating result and the cash position before committing to a major change.
6. Build an illustrative base, downside, and upside case
Start with a base case that reflects the most supportable assumptions. Then change a small number of connected inputs to create a downside case and an upside case. Avoid changing every line at once. If the scenario cannot be explained in plain language, it is probably too complicated to guide a decision.
Here is an illustrative example for a service business. The figures are example currency units only, not a forecast, price, or benchmark for any particular company.
| Monthly projection | Base case | Downside case | Upside case | What changes |
|---|---|---|---|---|
| Revenue | 50,000 | 42,000 | 56,000 | Completed work and timing |
| Direct costs | 17,500 | 15,500 | 19,600 | Delivery volume and mix |
| Operating overhead | 24,000 | 23,500 | 26,500 | Planned support and hiring |
| Operating result | 8,500 | 3,000 | 9,900 | Revenue less listed costs |
The downside case is not a prediction that the business will fail. It is a prompt for a decision. If 3,000 currency units of operating result does not cover an upcoming tax payment, equipment purchase, or debt obligation, the owner should address that risk before the downside arrives. The upside case also needs a capacity check. If the business cannot deliver 56,000 currency units of work without a hire, the hire belongs in the scenario instead of being treated as an afterthought.
Explore CCG’s CFO Services for budgeting, cash flow analysis, forecasting support, and financial reporting that connect projections to operating decisions.
7. Turn the spreadsheet into a monthly decision process
A projection is only useful when it is reviewed. At the end of each month, replace the projected period with actual results and compare the difference. Classify the largest variances: volume, price, timing, direct cost, overhead, capacity, collections, or an assumption that was never verified.
Keep a short variance log with three fields: what changed, why it changed, and what action follows. Assign an owner and a due date to each material action. Update the forward view using the new information. CCG’s rolling forecast model guide explains how a forward-looking view can stay current as actual results arrive. For this article’s purpose, the key lesson is simpler: do not let the original projection become a stale document.
What Is the Difference Between a Projection, Budget, Forecast, and Financial Model?
These terms are often used interchangeably, but the distinction can make your planning clearer:
- Budget: the approved plan for how the business intends to use resources during a defined period.
- Forecast: the current estimate of what is likely to happen based on the latest evidence.
- Projection: a forward-looking estimate built from stated assumptions, often used to test a plan, decision, or possible future.
- Financial model: the broader structure of formulas, schedules, and linked statements used to analyze relationships among business inputs and outcomes.
A business may use all four. The labels matter less than the discipline of stating the purpose, source, and confidence behind each number. If a lender requests projections, follow the requested format and make sure the assumptions are supportable. If the document is for internal use, prioritize the decisions the owner must make and the level of detail the team can maintain.
How Can You Use Financial Projections to Make Better Decisions?
Use the projection to ask decision questions before approving a change. For a planned hire, test the cost, ramp time, capacity gain, and cash effect. For a new service, model volume, pricing, delivery cost, marketing spend, and the time to reach dependable demand. For an expansion, include the added overhead, investment, working capital, and timing of expected revenue.
When the projection reveals a gap, choose a lever instead of simply changing the outcome. The lever may be price, volume, collection terms, staffing, supplier terms, discretionary spending, or timing. Document the decision and revisit the assumption when actual results arrive. This approach keeps the projection connected to the way the business is actually managed.
Outside support can be valuable when the owner cannot reconcile the numbers, when growth decisions depend on unreliable reports, or when maintaining the projection competes with daily operations. The right advisor should help clarify the business drivers, build an understandable process, and keep accountability with the owner and team.
What Mistakes Should You Avoid When Creating Projections?
- Starting with a desired revenue number: build from customers, jobs, units, capacity, price, and timing instead.
- Mixing facts and assumptions: label each input so a reviewer can see what is known and what must be tested.
- Forecasting profit without cash timing: show collections and payments separately when timing can create pressure.
- Leaving out growth costs: include the people, equipment, materials, marketing, and support required to deliver additional work.
- Using false precision: use ranges or scenarios when the evidence does not support one exact number.
- Building a file nobody reviews: assign an owner, set a cadence, compare actual results, and record the reason for each material variance.
- Repeating a generic template: customize the projection to the way the business earns revenue and spends cash.
CCG’s business planning services can help owners connect financial projections with market analysis, operating priorities, and an actionable plan. The useful outcome is not a polished spreadsheet by itself. It is a clearer basis for decisions and follow-through.
Contact The Chalifour Consulting Group to discuss a projection that fits your business and the decisions ahead.
Frequently Asked Questions
What is the easiest way to create financial projections?
Start with a monthly table for the next 12 months. Add revenue by business driver, direct costs, operating overhead, cash collections, and payments. Mark each input as a verified fact or assumption, then create base, downside, and upside cases that you can explain in plain language.
How far ahead should a small business project?
Use the horizon required by the decision. A 12-month monthly view is a practical starting point for many owner-led businesses. Extend it when seasonality, a major investment, a financing request, or a long sales cycle makes a shorter view misleading.
What is the difference between financial projections and a cash flow forecast?
Financial projections can include revenue, direct costs, overhead, operating results, and cash timing. A cash flow forecast focuses specifically on when money enters and leaves the business. Keep the cash view connected to the broader projection because profit and cash can move on different schedules.
Should financial projections use exact numbers or ranges?
Use exact numbers for verified commitments where appropriate, and use ranges or scenarios for uncertain assumptions. A range is more honest than false precision when demand, timing, pricing, capacity, or collections are still unclear.
When should a business owner get help with projections?
Consider outside help when you cannot explain major variances, when reports do not reconcile, or when an important growth decision depends on numbers nobody trusts. An experienced advisor can help clarify assumptions, connect the operating drivers, and establish a review process the team can maintain.
Request a conversation with The Chalifour Consulting Group to build a practical financial projection and turn the next decision into an executable plan.