### Sheet: Assumptions

| Item | Value | Unit | Status | Note |
|---|---|---|---|---|
| Repairs revenue, last year | 584,000 | $ / year | Given | Your figure |
| Installation revenue, last year | 400,000 | $ / year | Given | Your figure |
| Active maintenance agreements | 1,080 | count | Given | Your figure |
| Agreement price | 275 | $ / year | Given | Your figure |
| Revenue change vs last year | 0 | % | Assumption | Flat. Change this to test a better or worse year |
| Peak-month weight | 1.5 | × a normal month | Assumption (illustrative) | How much busier a peak month is than a normal one. Not measured — replace from your monthly sales if you have them |
| Normal-month weight | 1 | × a normal month | Assumption | Reference level |
| Slow-month weight | 0.6 | × a normal month | Assumption (illustrative) | Not measured — replace from your monthly sales if you have them |
| Field technicians | 3 | people | Given | Your figure |
| Technician pay rate | 35 | $ / hour | Assumption | Midpoint of your $32–38 range |
| Regular hours per technician | 173 | hours / month | Assumption | 40 h × 52 weeks ÷ 12, paid every month including slow ones |
| Overtime hours per technician, peak months | 20 | hours / month | Assumption (illustrative) | You said there is summer overtime; the amount was not given. Applied to every Peak month |
| Overtime pay multiplier | 1.5 | × pay rate | Assumption | Time-and-a-half; confirm |
| Office person hours | 87 | hours / month | Derived | Your 20 h/week × 52 ÷ 12 |
| Office person pay rate | 20 | $ / hour | Assumption (illustrative) | Not given — replace |
| Payroll taxes and benefits | 0.1 | % of wages | Assumption (illustrative) | Not given — confirm with your accountant |
| Installation equipment and materials | 0.45 | % of installation revenue | Assumption (illustrative) | Not given — replace from supplier invoices |
| Repair parts and refrigerant | 0.25 | % of repair revenue | Assumption (illustrative) | Not given — replace from supplier invoices |
| Agreement visit materials | 0.05 | % of agreement revenue | Assumption (illustrative) | Filters, cleaning supplies etc. Not given — replace |
| Shop and warehouse rent | 4,200 | $ / month | Given | Your figure |
| Trucks | 4 | count | Given | Your figure |
| Running cost per truck | 800 | $ / month | Assumption (illustrative) | Fuel, insurance, maintenance, any payments. Not given — replace |
| Other overhead | 3,000 | $ / month | Assumption (illustrative) | Business insurance, phones, software, marketing, accounting. Not given — replace |
| Opening cash balance, 1 Dec 2026 | 0 | $ | To confirm | Enter your bank balance. Left at 0, closing cash shows only the change over the year |
| Monthly pattern — season of each month and share of annual agreement money collected |  |  |  |  |
| Month | Season | Agreement cash collected (% of year) | Status |  |
| Dec 2026 | Peak | 0.08 | Season: given. Cash share: to confirm (check 3) |  |
| Jan 2027 | Peak | 0.08 | Season: given. Cash share: to confirm (check 3) |  |
| Feb 2027 | Normal | 0.08 | Season: assumption. Cash share: to confirm (check 3) |  |
| Mar 2027 | Slow | 0.08 | Season: given. Cash share: to confirm (check 3) |  |
| Apr 2027 | Slow | 0.08 | Season: given. Cash share: to confirm (check 3) |  |
| May 2027 | Normal | 0.08 | Season: assumption. Cash share: to confirm (check 3) |  |
| Jun 2027 | Peak | 0.08 | Season: given. Cash share: to confirm (check 3) |  |
| Jul 2027 | Peak | 0.08 | Season: given. Cash share: to confirm (check 3) |  |
| Aug 2027 | Peak | 0.08 | Season: given. Cash share: to confirm (check 3) |  |
| Sep 2027 | Normal | 0.08 | Season: assumption. Cash share: to confirm (check 3) |  |
| Oct 2027 | Slow | 0.08 | Season: given. Cash share: to confirm (check 3) |  |
| Nov 2027 | Normal | 0.08 | Season: assumption. Cash share: to confirm (check 3) |  |
| Total (must be 100%) |  | 1 |  |  |

### Sheet: Forecast

| 12-month forecast, Dec 2026 – Nov 2027 (USD) — draft for review; every figure is driven by the Assumptions sheet |  |  |  |  |  |  |  |  |  |  |  |  |  |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Line | Dec 2026 | Jan 2027 | Feb 2027 | Mar 2027 | Apr 2027 | May 2027 | Jun 2027 | Jul 2027 | Aug 2027 | Sep 2027 | Oct 2027 | Nov 2027 | Total |
| Season | Peak | Peak | Normal | Slow | Slow | Normal | Peak | Peak | Peak | Normal | Slow | Normal |  |
| Seasonal weight | 1.5 | 1.5 | 1 | 0.6 | 0.6 | 1 | 1.5 | 1.5 | 1.5 | 1 | 0.6 | 1 |  |
| Share of year's repair and installation work | 0.11 | 0.11 | 0.08 | 0.05 | 0.05 | 0.08 | 0.11 | 0.11 | 0.11 | 0.08 | 0.05 | 0.08 | 1 |
| PROFIT AND LOSS (accrual view) |  |  |  |  |  |  |  |  |  |  |  |  |  |
| Repairs revenue | 65,864.66 | 65,864.66 | 43,909.77 | 26,345.86 | 26,345.86 | 43,909.77 | 65,864.66 | 65,864.66 | 65,864.66 | 43,909.77 | 26,345.86 | 43,909.77 | 584,000 |
| Installation revenue | 45,112.78 | 45,112.78 | 30,075.19 | 18,045.11 | 18,045.11 | 30,075.19 | 45,112.78 | 45,112.78 | 45,112.78 | 30,075.19 | 18,045.11 | 30,075.19 | 400,000 |
| Agreement revenue (spread evenly) | 24,750 | 24,750 | 24,750 | 24,750 | 24,750 | 24,750 | 24,750 | 24,750 | 24,750 | 24,750 | 24,750 | 24,750 | 297,000 |
| Total revenue | 135,727.44 | 135,727.44 | 98,734.96 | 69,140.98 | 69,140.98 | 98,734.96 | 135,727.44 | 135,727.44 | 135,727.44 | 98,734.96 | 69,140.98 | 98,734.96 | 1,281,000 |
| Installation equipment and materials | 20,300.75 | 20,300.75 | 13,533.83 | 8,120.3 | 8,120.3 | 13,533.83 | 20,300.75 | 20,300.75 | 20,300.75 | 13,533.83 | 8,120.3 | 13,533.83 | 180,000 |
| Repair parts and refrigerant | 16,466.17 | 16,466.17 | 10,977.44 | 6,586.47 | 6,586.47 | 10,977.44 | 16,466.17 | 16,466.17 | 16,466.17 | 10,977.44 | 6,586.47 | 10,977.44 | 146,000 |
| Agreement visit materials | 1,237.5 | 1,237.5 | 1,237.5 | 1,237.5 | 1,237.5 | 1,237.5 | 1,237.5 | 1,237.5 | 1,237.5 | 1,237.5 | 1,237.5 | 1,237.5 | 14,850 |
| Technician wages, regular | 18,165 | 18,165 | 18,165 | 18,165 | 18,165 | 18,165 | 18,165 | 18,165 | 18,165 | 18,165 | 18,165 | 18,165 | 217,980 |
| Technician overtime (Peak months) | 3,150 | 3,150 | 0 | 0 | 0 | 0 | 3,150 | 3,150 | 3,150 | 0 | 0 | 0 | 15,750 |
| Office wages | 1,740 | 1,740 | 1,740 | 1,740 | 1,740 | 1,740 | 1,740 | 1,740 | 1,740 | 1,740 | 1,740 | 1,740 | 20,880 |
| Payroll taxes and benefits | 2,305.5 | 2,305.5 | 1,990.5 | 1,990.5 | 1,990.5 | 1,990.5 | 2,305.5 | 2,305.5 | 2,305.5 | 1,990.5 | 1,990.5 | 1,990.5 | 25,461 |
| Rent | 4,200 | 4,200 | 4,200 | 4,200 | 4,200 | 4,200 | 4,200 | 4,200 | 4,200 | 4,200 | 4,200 | 4,200 | 50,400 |
| Trucks | 3,200 | 3,200 | 3,200 | 3,200 | 3,200 | 3,200 | 3,200 | 3,200 | 3,200 | 3,200 | 3,200 | 3,200 | 38,400 |
| Other overhead | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 36,000 |
| Total costs | 73,764.92 | 73,764.92 | 58,044.28 | 48,239.77 | 48,239.77 | 58,044.28 | 73,764.92 | 73,764.92 | 73,764.92 | 58,044.28 | 48,239.77 | 58,044.28 | 745,721 |
| Operating profit before owner pay, loans and tax | 61,962.53 | 61,962.53 | 40,690.68 | 20,901.21 | 20,901.21 | 40,690.68 | 61,962.53 | 61,962.53 | 61,962.53 | 40,690.68 | 20,901.21 | 40,690.68 | 535,279 |
| CASH FLOW |  |  |  |  |  |  |  |  |  |  |  |  |  |
| Opening cash | 0 | 61,962.53 | 123,925.05 | 164,615.74 | 185,516.95 | 206,418.16 | 247,108.84 | 309,071.37 | 371,033.89 | 432,996.42 | 473,687.11 | 494,588.32 | 0 |
| Cash in: repairs and installations (paid in month of work) | 110,977.44 | 110,977.44 | 73,984.96 | 44,390.98 | 44,390.98 | 73,984.96 | 110,977.44 | 110,977.44 | 110,977.44 | 73,984.96 | 44,390.98 | 73,984.96 | 984,000 |
| Cash in: agreements (per monthly collection %) | 24,750 | 24,750 | 24,750 | 24,750 | 24,750 | 24,750 | 24,750 | 24,750 | 24,750 | 24,750 | 24,750 | 24,750 | 297,000 |
| Total cash in | 135,727.44 | 135,727.44 | 98,734.96 | 69,140.98 | 69,140.98 | 98,734.96 | 135,727.44 | 135,727.44 | 135,727.44 | 98,734.96 | 69,140.98 | 98,734.96 | 1,281,000 |
| Cash out: all costs (paid in month incurred) | 73,764.92 | 73,764.92 | 58,044.28 | 48,239.77 | 48,239.77 | 58,044.28 | 73,764.92 | 73,764.92 | 73,764.92 | 58,044.28 | 48,239.77 | 58,044.28 | 745,721 |
| Net cash flow | 61,962.53 | 61,962.53 | 40,690.68 | 20,901.21 | 20,901.21 | 40,690.68 | 61,962.53 | 61,962.53 | 61,962.53 | 40,690.68 | 20,901.21 | 40,690.68 | 535,279 |
| Closing cash | 61,962.53 | 123,925.05 | 164,615.74 | 185,516.95 | 206,418.16 | 247,108.84 | 309,071.37 | 371,033.89 | 432,996.42 | 473,687.11 | 494,588.32 | 535,279 | 535,279 |
| CHECKS (each should be 0) |  |  |  |  |  |  |  |  |  |  |  |  |  |
| Profit − cash flow − agreement timing difference | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total revenue vs your annual figures |  |  |  |  |  |  |  |  |  |  |  |  | 0 |
| Agreement cash collected vs annual agreement value |  |  |  |  |  |  |  |  |  |  |  |  | 0 |
| Closing cash = opening + net cash flow |  |  |  |  |  |  |  |  |  |  |  |  | 0 |
| Yellow cells on the Assumptions sheet drive everything. Most costs are illustrative — read the Notes sheet before relying on profit or cash. |  |  |  |  |  |  |  |  |  |  |  |  |  |

### Sheet: Notes

| Notes — draft for review with your accountant, as of 21 Nov 2026 |
|---|
| Read this first |
| With the illustrative cost assumptions, the forecast shows a large profit and no month with negative cash. That does not match your experience that cash is tight. So the missing or underestimated items below are probably large, and the profit line should not be relied on until the yellow cells are replaced with your own figures. |
| Scope and conventions |
| US dollars, rounded to whole dollars in display; sales tax ignored (assumed outside revenue). |
| Period: 12 months, December 2026 to November 2027. Starts from last year's revenue, flat unless you change 'Revenue change vs last year'. |
| Profit and loss: revenue counted in the month the work is done; agreement revenue spread evenly over 12 months. |
| Cash flow: repairs and installations assumed paid in the month of work; all costs assumed paid in the month incurred; agreement money collected per the monthly % on the Assumptions sheet (even 1/12 until check 3). |
| Repairs and installations follow the same seasonal pattern (Peak / Normal / Slow weights). Your seasons are given; the weights are illustrative. |
| Agreement revenue is 1,080 × $275 = $297,000, which is $1,000 above your rounded $296,000. |
| Not included (add if they apply) |
| Owner's own pay or draws |
| Loan or truck-finance principal and interest, if not in the truck cost |
| Income taxes |
| Equipment purchases (tools, a replacement truck) |
| Warranty and callback costs; bad debts; card or financing fees |
| Supplier payment terms or customer credit that would shift cash between months |
| Checks built in (Forecast sheet, rows 35–38) — all 0 at the time of building |
| Each month: profit − net cash flow equals the agreement timing difference (revenue spread vs cash collected). |
| Total revenue equals your annual figures (adjusted by the change %). |
| Agreement cash collected over the year equals the annual agreement value; Assumptions C41 must show 100%. |
| Closing cash equals opening cash plus the year's net cash flow. |
| Questions for your accountant |
| What does your bookkeeping show for parts and equipment costs as a share of repair and installation revenue? (replaces Assumptions B18–B19) |
| What is the full cost of payroll taxes, workers' compensation and benefits as a % of wages? (B17) |
| How should owner pay be shown — as a wage in costs, or as draws below profit? |
| Should agreement payments received in advance be recorded as deferred revenue? This model spreads them over 12 months. |
| Which months had the lowest bank balance in the last two years? (to test the cash pattern and set the opening balance, B25) |
| How to use |
| Change only the yellow cells on the Assumptions sheet. Everything on the Forecast sheet recalculates. To test a scenario, change one yellow cell at a time and watch Closing cash (row 32) and the slow months (Mar, Apr, Oct). |
