The 12-Month Operating Forecast

1Operating plans and financial estimates

A managed services provider (MSP) earns money from technology services and products. An operating forecast estimates future earned revenue, delivery costs and operating overhead. The forecast helps the CEO compare the expected work with the resources required to perform it. The forecast is updated when information or decisions change.

A forecast assumption is an input about a future quantity, price, timing or cost. An assumption should have a source, an owner and a date. A driver is an activity or condition that changes a financial amount. The number of managed users can drive service revenue and license costs. The number and start dates of employees can drive payroll expense.

The admin manager prepares reliable actual records and maintains the agreed inputs. The CEO owns the growth plan and approves business assumptions and decisions. QuickBooks Online supplies historical accounting results. Syncro supplies contract, billing and service information. Excel can calculate the financial effects of those inputs. Keep the company's confidential records in the approved finance workspace.

A twelve-month horizon lets the business see an annual service cycle, renewal timing and the effect of costs that start partway through the year. Twelve months is a planning structure, rather than a guarantee of certainty. The early months may have signed contracts and known payroll. Later months may rely more heavily on estimates. Label that difference instead of presenting every column as equally certain.

2Actual results and the starting point

A baseline is the starting set of amounts and assumptions for a comparison. Start the operating forecast with reviewed actual records and a current contract and cost schedule. A historical average can help identify a pattern, but it does not establish future commitments. A client that left during the year should not remain in future recurring revenue merely because the historical average includes that client's invoices.

The supplied January through September 2026 accrual revenue totals $1,109,891.18. Dividing by nine gives approximately $123,321.24 per calendar month. This is a historical monthly average of reported total revenue. It includes recurring and nonrecurring categories, and it is not committed monthly recurring revenue. Close approval remains unconfirmed for the supplied months.

The recurring-revenue account totals $888,896.41 for the same period. Its monthly average is approximately $98,766.27. That account average still does not establish signed future contract revenue. September's recurring-revenue account is $106,456.25. Use the current contract schedule to explain what will continue, change or end after September.

Build a separate starting schedule for payroll, benefits, licenses, rent, debt interest and other recurring commitments. The supplied payroll account combines amounts without identifying employee roles or confirming the employer and employee tax split. The accountant and payroll records are needed before using those totals as a delivery labor cost driver. Preserve the actual accounting classification when reconciling the historical record, and document any different management-model classification.

The company financial reference records the supplied aggregate figures, reporting periods and missing supporting records. Use that reference when checking this lesson's company calculations.

3Revenue quantities prices and timing

Separate recurring service, projects and product sales when they behave differently. Contract-based recurring revenue uses signed quantities, prices and effective dates under a stated definition. Project revenue uses the planned work and the applicable revenue recognition policy. Product revenue uses expected deliveries and the company's approved gross or net treatment.

Practice example: a hypothetical service contract has 100 users at $150 per user per month. The monthly service amount is $15,000. Another approved contract begins in month four with 20 users at the same price, adding $3,000 monthly from that point. Assume the service is earned evenly during each active month, with no discounts, cancellations or changes. The first contract contributes $180,000 over twelve months. The second contributes $27,000 across nine active months.

A sales opportunity is potential work that has not yet become an accepted commitment. Keep signed work separate from estimated new sales. If the CEO includes expected opportunities in the forecast, record the expected start date, revenue, delivery cost and basis for including the opportunity. A probability estimate can help produce an expected value, but it does not create a signed contract or collection date.

A price increase affects only the contracts and dates where the change can actually occur. Check renewal and notice terms. A planned increase beginning in month seven affects six months of that twelve-month forecast. A full-year percentage applied to every client would overstate the effect if some clients cannot change during the year. Keep explicit month-by-month rows so the CEO can see the timing.

4Delivery costs and operating overhead

Direct delivery and product costs are the costs included in the company's gross-profit classification. Operating overhead supports the business beyond those direct costs. Gross profit is revenue minus direct delivery and product costs. Operating profit is gross profit minus operating overhead. Preserve that sequence in the forecast so another reader can explain the result.

Practice example: tools cost $30 per active user per month. The first 100 users therefore require $3,000 of monthly tools. The additional 20 users require another $600 per month from month four. Tool cost is linked to the same active-user row used for revenue. This link prevents revenue from growing while related licenses remain unchanged by mistake.

Payroll does not always increase at the same rate as revenue. Existing employees may have some capacity available for new work. When additional work requires another employee or subcontractor, the cost can increase in a larger step. Include the employee's expected start date, pay, employer taxes, benefits and other approved costs. Explain the period before the employee can deliver at the assumed level.

Separate operating expenses from cash payments that have different accounting effects. Loan principal reduces debt and cash, while interest is an expense. Equipment purchases may create an asset with depreciation expense over time under the applicable book policy. Depreciation is the allocation of an asset's depreciable cost over its expected useful life. The accountant determines the actual treatment. The operating forecast should agree with those policies, and the cash forecast should contain the actual payment timing.

5An Excel forecast structure

Use a small workbook with understandable inputs and formulas. A formula calculates an amount from other cells. An input is a value entered from an approved assumption or record. Distinguish input cells visibly using the company's workbook convention. Label every row with its units, such as users, dollars per user, employees or dollars per month.

Use formulas for quantities multiplied by prices, active months and subtotals. Avoid typing the same assumed revenue into multiple sheets. Repeated manual totals can disagree after a change. A formula should make its purpose visible without requiring the reader to reverse engineer several unnamed cells.

Include checks for missing quantities, inactive contracts earning revenue, costs beginning before or after their intended dates, and monthly totals that do not equal the annual total. A zero can be an actual assumption. A blank can mean an input is missing. The workbook should preserve that difference. Document any manual override so the CEO knows why the formula's normal result was replaced.

6Forecast changes and cash implications

Before comparing a proposed change, save the current baseline. A scenario is a coherent set of changed assumptions used to explore a possible outcome. Changing a hire date, a client start date or a supplier price creates a new result. Compare the change with the baseline and explain the assumptions that caused the difference.

Practice example: a proposed employee costs $6,000 per month under the exercise's loaded-cost definition and begins in month seven. The twelve-month forecast adds $36,000 of payroll cost across six months. A $2,000 recruitment cost in month six is an additional expense in this exercise. The CEO needs to see both the recurring cost and the initial cost. The example assumes the costs are expenses under the applicable policy.

A profitable operating forecast can still require financing. Client payment terms, supplier purchases, tax commitments, debt principal and equipment payments affect cash. Link approved operating assumptions to a dated cash forecast. Do not use operating profit as the amount available to spend. The operating forecast estimates earned results; the cash forecast estimates receipts, payments and balances.

Update the forecast after each agreed review with new actuals and changed assumptions. Keep the original approved plan available for variance reporting. A forecast version should identify what changed, who approved the assumption and when the change took effect. The admin manager maintains the record. The CEO accepts the business plan and decides which commitments can proceed.

7Operating forecast practice

Practice example: a service business starts with 100 users at $150 per month and $30 of tools per user per month. Twenty additional users begin in month four. Delivery payroll is $8,000 per month. Operating overhead is $3,000 per month. A proposed employee adds $6,000 monthly from month seven and a $2,000 recruitment expense in month six. Assume no other revenue, costs, cancellations or changes.

1. Calculate annual revenue and annual tools cost.
2. Calculate annual operating profit before the proposed employee.
3. Add the proposed employee and recruitment expense. Calculate the revised operating profit.
4. Explain which rows need to change if the additional users begin in month seven instead of month four.
5. List the information still needed to forecast cash rather than operating profit.

8Your company operating forecast

The admin manager prepares an actuals worksheet using the reviewed accounting basis and a current cost schedule. Obtain the signed contract quantities and dates rather than treating reported recurring-revenue averages as commitments. Identify the missing employee-role, payroll-tax and vendor details needed for the forecast.

The CEO supplies approved growth assumptions: expected client starts, renewal changes, project plans, hiring proposals and supplier commitments. Record whether each item is signed, approved for planning or still an opportunity. The admin manager checks the formulas and reconciles the starting figures. The CEO reviews the financial consequences and the required cash.

The deliverable is a twelve-month operating forecast with an assumption register and a short explanation of the largest decision effects. Include a missing-input list and a comparison with the approved baseline. A reader should be able to trace a changed profit figure to quantities, prices and dates, then identify the separate cash information required before committing funds.

9Going deeper

10The completed work

A twelve-month operating forecast with sourced assumptions, checks and a baseline comparison.

Keep approved company work in your finance workspace. The course records study progress in this browser; it does not store your reports or forecast files.

11Quiz

1. A new contract adds $3,000 monthly beginning in month four of a twelve-month forecast. What revenue does it add under the stated assumptions?

   A.$36,000 for a full twelve monthsB.$12,000 using the start month as the multiplierC.$27,000D.$9,000 based only on the first quarter
   Answer

   Include the revenue only in the months when the service is active and earned under the exercise's assumptions.

   Check answer
2. The historical recurring-revenue account averages $98,766.27 per month. What is needed before using that amount as committed future service revenue?

   A.A current signed-contract reconciliationB.The same average rounded to the nearest thousandC.The number of invoices issued in the busiest monthD.A higher growth percentage applied to the average
   Answer

   Historical account revenue is a starting record, rather than a signed future contract schedule.

   Check answer
3. A forecast adds 20 users with $30 monthly tools cost per user. What should happen to tools cost when those users begin?

   A.It stays unchanged because tools are already in overheadB.It increases by the entire contract selling priceC.It decreases as the user count growsD.It increases by $600 per active month
   Answer

   Link related revenue and cost drivers to the same effective user quantities and dates.

   Check answer
4. A proposed employee costs $6,000 monthly and starts in month seven. What recurring expense belongs in the twelve-month forecast?

   A.$72,000 as if employed throughout the yearB.$36,000C.$42,000 by multiplying by the start-month numberD.$6,000 with remaining cost included only after hiring
   Answer

   Use the employee's active months and include initial costs separately.

   Check answer
5. An operating forecast shows positive profit. Which additional record supports approval of a cash commitment?

   A.The forecast title and annual revenue totalB.A larger projected margin with the same cash assumptionsC.A dated cash forecast with commitments and collection timingD.The prior year's bank balance as the spending limit
   Answer

   Profit and cash require separate calculations. Include taxes, debt principal and asset purchases in the cash planning as applicable.

   Check answer
6. The CEO changes the planned hire date. What should the model retain?

   A.The new payroll total typed into every monthly columnB.The old total without noting the changed assumptionC.Only the new result with all earlier versions removedD.The changed assumption and baseline comparison
   Answer

   Keep the assumption source, approval and timing visible, then compare the new result with the saved baseline.

   Check answer

12Glossary

Operating forecast

An estimate of future earned revenue, delivery costs and operating overhead.

Forecast assumption

An input about a future quantity, price, timing or cost, with a stated source and owner.

Driver

An activity or condition that changes a financial amount.

Baseline

The starting set of amounts and assumptions used for a comparison.

Sales opportunity

Potential work that has not become an accepted commitment.

Input

A value entered into a model from an assumption or record.

Formula

A calculation that derives an amount from other values.

Operating profit

Gross profit minus operating overhead under the stated classification.

Depreciation

The allocation of an asset's depreciable cost over its expected useful life.

Scenario

A coherent set of changed assumptions used to explore a possible outcome.

Assumption register

A list of model inputs with their sources, owners, dates and approval status.

13Sources

Company examples use the accrual reports supplied on October 6, 2026. Report periods, selected totals and limits are recorded in the company reference. Examples labeled practice use hypothetical inputs.

• OpenStax: Contribution margin: Revenue, cost and contribution relationships supporting forecast calculations.