| 01 | Cover Page | 01 |
| 02 | Contents | 02 |
| 03 | Executive Summary | 03 |
| 04 | Income Statement (P&L) | 04 |
| 05 | Revenue by Service Line | 05 |
| 06 | Technician Productivity & Utilization | 06 |
| 07 | Cash Flow & Working Capital | 07 |
| 08 | Balance Sheet Snapshot | 08 |
| 09 | Fleet & Equipment Tracker | 09 |
| 10 | Seasonal Demand Forecast | 10 |
| 11 | 🔒 Accounts Receivable Aging | 11 |
| 12 | 🔒 CTA | 12 |
| Jan Actual | Jan Budget | Var $ | Var % | YTD Actual | |
|---|---|---|---|---|---|
| Revenue | |||||
| Service & Repair | $196,842 | $185,000 | $11,842 | 6.4% | $196,842 |
| Installation / New Systems | $112,200 | $115,000 | ($2,800) | (2.4%) | $112,200 |
| Maintenance Agreements (SMA) | $94,138 | $90,000 | $4,138 | 4.6% | $94,138 |
| Duct Cleaning & IAQ | $18,200 | $14,000 | $4,200 | 30.0% | $18,200 |
| Total Revenue | $421,380 | $404,000 | $17,380 | 4.3% | $421,380 |
| Cost of Revenue | |||||
| Parts & Materials | $108,372 | $112,000 | $3,628 | 3.2% | $108,372 |
| Technician Labor (Direct) | $84,502 | $86,000 | $1,498 | 1.7% | $84,502 |
| Subcontractors | $15,000 | $12,000 | ($3,000) | (25.0%) | $15,000 |
| Vehicle / Fleet Costs | $10,000 | $9,500 | ($500) | (5.3%) | $10,000 |
| Total Cost of Revenue | $217,874 | $219,500 | $1,626 | 0.7% | $217,874 |
| GROSS PROFIT | $203,506 | $184,500 | $19,006 | 10.3% | $203,506 |
| Operating Expenses | |||||
| Salaries & Admin Staff | $28,400 | $28,000 | ($400) | (1.4%) | $28,400 |
| Marketing & Advertising | $12,800 | $14,000 | $1,200 | 8.6% | $12,800 |
| Insurance (GL, WC, Vehicle) | $8,200 | $8,200 | $0 | 0.0% | $8,200 |
| Rent & Facilities | $4,800 | $4,800 | $0 | 0.0% | $4,800 |
| Software & Technology | $1,823 | $2,000 | $177 | 8.9% | $1,823 |
| Total OpEx | $56,023 | $57,000 | $977 | 1.7% | $56,023 |
| EBITDA | $147,483 | $127,500 | $19,983 | 15.7% | $147,483 |
| Depreciation | $6,800 | $7,000 | $200 | 2.9% | $6,800 |
| Interest Expense | $2,800 | $3,000 | $200 | 6.7% | $2,800 |
| Estimated Tax Provision | $8,536 | $7,300 | ($1,236) | (16.9%) | $8,536 |
| NET INCOME | $129,347 | $110,200 | $19,147 | 17.4% | $129,347 |
| Service Line | Revenue | % Mix | Margin | Jobs | Avg Ticket |
|---|---|---|---|---|---|
| 🔧 Service & Repair | $196,842 | 46.7% | 52.4% | 404 | $487 |
| ❄️ Installation / New Systems | $112,200 | 26.6% | 38.2% | 14 | $8,014 |
| 📋 Maintenance Agreements | $94,138 | 22.3% | 61.8% | 446 | $211 |
| 💨 Duct Cleaning & IAQ | $18,200 | 4.3% | 58.3% | 38 | $479 |
| TOTAL | $421,380 | 100% | 48.3% | 902 | $467 |
| Technician | Revenue | Jobs | Avg Ticket | Utilization | Callbacks | Rating |
|---|---|---|---|---|---|---|
| Miguel Rodriguez | $47,820 | 86 | $556 | 92% | 1 | ⭐ 4.9 |
| Jake Thompson | $42,350 | 79 | $536 | 88% | 2 | ⭐ 4.8 |
| Carlos Mendez | $39,100 | 82 | $477 | 85% | 1 | ⭐ 4.7 |
| Dave Mitchell | $38,200 | 78 | $490 | 83% | 2 | ⭐ 4.7 |
| Tyler Banks | $37,650 | 74 | $509 | 79% | 3 | ⭐ 4.6 |
| Maria Santos | $36,400 | 71 | $513 | 78% | 1 | ⭐ 4.8 |
| Chris Wilson | $34,800 | 69 | $504 | 76% | 2 | ⭐ 4.5 |
| James Patterson | $33,100 | 72 | $460 | 74% | 4 | ⭐ 4.3 |
| Anthony Davis | $31,900 | 67 | $476 | 71% | 3 | ⭐ 4.4 |
| Robert Nguyen | $30,200 | 64 | $472 | 69% | 2 | ⭐ 4.5 |
| Brandon Lee | $27,360 | 58 | $472 | 65% | 3 | ⭐ 4.2 |
| Kevin Price | $22,500 | 52 | $433 | 58% | 5 | ⭐ 3.9 |
| AVERAGE / TOTAL | $35,115 | 73 | $492 | 77% | 2.4 | 4.5 |
| Working Capital Metrics | Current | Prior Month | Target |
|---|---|---|---|
| Days Sales Outstanding (DSO) | 24 days | 27 days | < 30 days |
| Days Inventory Outstanding | 36 days | 31 days | < 30 days |
| Days Payable Outstanding | 22 days | 21 days | 25-30 days |
| Cash Conversion Cycle | 38 days | 37 days | < 35 days |
| Current Ratio | 2.8x | 2.6x | > 2.0x |
| Quick Ratio | 2.1x | 2.0x | > 1.5x |
| ASSETS | |
|---|---|
| Current Assets | |
| Cash & Equivalents | $352,530 |
| Accounts Receivable | $89,400 |
| Parts Inventory | $127,200 |
| Prepaid Insurance | $12,600 |
| Total Current Assets | $581,730 |
| Fixed Assets | |
| Service Vehicles (12) | $384,000 |
| Tools & Equipment | $68,500 |
| Less: Accum. Depreciation | ($148,200) |
| Total Fixed Assets (Net) | $304,300 |
| Goodwill | $45,000 |
| TOTAL ASSETS | $931,030 |
| LIABILITIES & EQUITY | |
|---|---|
| Current Liabilities | |
| Accounts Payable | $72,400 |
| Accrued Wages | $34,200 |
| Deferred Revenue (Prepaid SMAs) | $48,600 |
| Sales Tax Payable | $18,300 |
| Current Portion of LTD | $24,000 |
| Total Current Liabilities | $197,500 |
| Long-Term Liabilities | |
| Vehicle Loans | $142,000 |
| Equipment Financing | $28,000 |
| Total Long-Term Liabilities | $170,000 |
| Equity | |
| Owner’s Equity | $200,000 |
| Retained Earnings | $234,183 |
| Current Period Net Income | $129,347 |
| TOTAL LIABILITIES & EQUITY | $931,030 |
| Vehicle / Unit | Year | Mileage | Book Value | MTD Fuel | MTD Maint. | Status |
|---|---|---|---|---|---|---|
| 🚚 Unit 01 — Ford E-350 (M. Rodriguez) | 2023 | 42,100 | $34,200 | $680 | $120 | 🟢 |
| 🚚 Unit 02 — Ford E-350 (J. Thompson) | 2023 | 38,700 | $35,800 | $640 | $85 | 🟢 |
| 🚚 Unit 03 — Chevy Express (C. Mendez) | 2022 | 61,300 | $26,400 | $720 | $340 | 🟡 |
| 🚚 Unit 04 — Ford E-350 (D. Mitchell) | 2022 | 58,200 | $27,100 | $690 | $210 | 🟢 |
| 🚚 Unit 05 — Chevy Express (T. Banks) | 2021 | 74,800 | $22,000 | $750 | $480 | 🟡 |
| 🚚 Unit 06 — Ford Transit (M. Santos) | 2023 | 31,400 | $37,200 | $580 | $65 | 🟢 |
| 🚚 Unit 07 — Ford E-350 (C. Wilson) | 2021 | 82,100 | $18,600 | $810 | $650 | 🔴 |
| 🚚 Unit 08 — Chevy Express (J. Patterson) | 2022 | 55,600 | $28,800 | $670 | $190 | 🟢 |
| 🚚 Unit 09 — Ford Transit (A. Davis) | 2023 | 28,900 | $38,400 | $560 | $45 | 🟢 |
| 🚚 Unit 10 — Ford E-350 (R. Nguyen) | 2021 | 79,400 | $19,800 | $780 | $520 | 🟡 |
| 🚚 Unit 11 — Chevy Express (B. Lee) | 2022 | 52,300 | $29,500 | $650 | $175 | 🟢 |
| 🚚 Unit 12 — Ford Transit (K. Price) | 2022 | 49,100 | $30,200 | $630 | $145 | 🟢 |
| FLEET TOTAL (12 Vehicles) | 654K | $348,000 | $8,160 | $3,025 |
| Month | Revenue Forecast | Heating Mix | Cooling Mix | Install Mix | SMA Mix | Demand |
|---|---|---|---|---|---|---|
| Jan (Actual) | $421,380 | 38% | 5% | 27% | 22% | 🔥🔥🔥 |
| Feb | $385,000 | 32% | 8% | 28% | 24% | 🔥🔥 |
| Mar | $368,000 | 18% | 22% | 32% | 22% | 🔥 |
| Apr | $410,000 | 5% | 35% | 35% | 20% | 🔥🔥 |
| May | $520,000 | 2% | 48% | 30% | 16% | 🔥🔥🔥🔥 |
| Jun | $610,000 | 0% | 55% | 28% | 14% | 🔥🔥🔥🔥🔥 |
| Jul | $680,000 | 0% | 58% | 26% | 12% | 🔥🔥🔥🔥🔥 |
| Aug | $650,000 | 0% | 56% | 27% | 13% | 🔥🔥🔥🔥🔥 |
| Sep | $490,000 | 2% | 42% | 32% | 18% | 🔥🔥🔥 |
| Oct | $410,000 | 10% | 28% | 35% | 22% | 🔥🔥 |
| Nov | $380,000 | 28% | 10% | 30% | 24% | 🔥🔥 |
| Dec | $395,000 | 35% | 5% | 28% | 24% | 🔥🔥🔥 |
| ANNUAL FORECAST | $5,719,380 | Peak: Jun-Aug (40% of annual revenue) | ||||
| Customer | Current | 1-30 | 31-60 | 61-90 | 90+ | Total |
|---|---|---|---|---|---|---|
| Westfield Plaza Management | $0 | $0 | $8,400 | $12,600 | $0 | $21,000 |
| Metro Industrial Park | $4,200 | $3,800 | $5,200 | $0 | $0 | $13,200 |
| Residential (Various) | $38,400 | $12,600 | $2,800 | $0 | $0 | $53,800 |
| Greenway Office Complex | $1,400 | $0 | $0 | $0 | $0 | $1,400 |
| TOTAL | $44,000 | $16,400 | $16,400 | $12,600 | $0 | $89,400 |
PDF available with your subscription
Clients receive polished PDFs automatically by the 5th of every month.