Cash Position
20XX Mo. Goal $300,000
Quick Ratio
20XX Goal > 2.5
500,000
4.0
450,000
3.5
400,000
3.0
350,000
300,000
2.5
250,000
2.0
200,000
1.5
150,000
1.0
100,000
0.5
50,000
0
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
0.0
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
Adjusted Gross Income
20XX Mo. Goal
Gross Income
20XX Mo. Goal $225,000
350,000
140,000
300,000
120,000
250,000
100,000
200,000
80,000
150,000
60,000
100,000
40,000
50,000
20,000
0
0
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
JAN
OCT
FEB
MAR
Operating Expenses
20XX Mo. Goal $37,000
APR
MAY
JUN
JUL
AUG
SEP
OCT
JUL
AUG
SEP
OCT
Net Profit (EBITDA)
20XX Mo. Goal $39,000
45,000
90,000
40,000
80,000
35,000
70,000
30,000
60,000
25,000
50,000
20,000
40,000
15,000
30,000
10,000
20,000
5,000
10,000
0
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
JAN
FEB
MAR
APR
MAY
JUN
KPI Report - OCT
20XX
JAN
20XX
FEB
20XX
MAR
20XX
APR
20XX
MAY
20XX
JUN
20XX
JUL
20XX
AUG
20XX
SEP
20XX
OCT
OCT
GOAL
OCT
Act v. G
2010
MO Avg
YTD
Actuals
20XX
Goals
20XX
Projected
% Difference Bet.
Projected & Goal
Summary
1. Cash Flow
1.1 Cash
1.2 Current assets (incl cash)
370,039
486,683
383,166
483,043
441,846
491,049
289,448
328,454
291,307
409,467
376,099
436,177
360,161
455,179
331,253
523,518
311,021
502,733
468,748
583,798
300,000
330,000
168,748
253,798
362,309
470,010
468,748
583,798
1.3 Collections
2. P&L
252,893
215,545
234,819
270,818
230,863
253,351
268,126
213,861
211,640
335,510
210,833
124,677
248,742
2,487,424
2,530,000
2,984,909
18%
2.1 Gross Income
2.1a Commission Income
2.1b Consulting Income
265,063
422
121,279
180,584
261
83,114
212,698
719
90,399
236,009
383
143,432
260,759
268
122,804
205,898
514
94,455
307,411
494
112,169
262,757
16,605
120,614
232,333
2,035
112,103
254,774
2,580
155,813
211,250
43,524
1,440,000
2,901,945
29,137
1,387,419
14%
37,813
2,418,287
24,281
1,156,182
2,535,000
118,000
241,829
2,428
115,618
2.1c Contract Income
2.1d Product Income
39,275
85,196
39,275
35,477
33,894
69,494
35,270
38,864
62,145
53,302
55,502
35,486
46,922
126,235
47,859
47,728
47,055
49,929
45,995
31,358
45,000
23,250
995
8,108
45,319
57,307
453,190
573,069
540,000
279,000
543,828
687,683
1%
146%
2.1e Hosting Income
18,265
22,352
18,154
18,001
22,240
19,841
21,592
29,952
21,286
19,028
18,000
1,028
21,071
210,711
216,000
252,853
17%
2.2a Consulting COGS
2.2b Contract COGS
60,200
19,756
57,744
22,068
58,613
21,453
69,752
56,284
64,385
35,062
63,643
21,304
58,681
25,492
67,674
20,797
66,572
18,558
71,231
18,439
63,850
25,921
638,496
259,212
2.2c Product COGS
2.2d Hosting COGS
73,023
13,488
32,185
13,626
62,143
13,826
37,655
13,596
50,661
13,913
33,320
13,595
105,162
13,509
44,172
14,826
43,709
17,340
30,468
15,962
51,250
14,368
512,497
143,681
2.3 Total COGS
166,466
125,622
156,035
177,287
164,021
131,862
202,844
147,469
146,179
136,099
135,520
579
155,389
1,553,886
1,626,245
1,864,663
15%
2.4 Adjusted Gross Income (accrual)
98,274
55,420
57,867
101,037
111,444
77,595
108,235
119,901
89,721
120,528
75,730
44,798
94,002
940,021
908,755
1,128,025
24%
2.5 Operating Expenses
2.6 Officer Distributions
39,669
0
40,430
0
40,144
5,000
35,223
5,000
35,287
5,000
34,663
5,000
37,176
5,000
35,835
5,000
39,459
5,000
32,795
5,000
36,721
-3,926
37,068
370,681
440,654
444,817
1%
2.7 Net Profit (EBITDA)
2.8 Net Profit % of Gross Income
58,605
22%
14,990
8%
12,723
6%
60,814
26%
71,157
27%
37,932
18%
66,059
21%
79,066
30%
45,261
19%
82,733
32%
39,008
18%
43,725
0
52,934
22%
529,340
22%
468,101
18%
635,208
22%
36%
19%
14,436
16,206
12%
4,812
19,248
2,848
19,054
-41%
-1%
3. Balance Sheet
3.1 AR >90 days
7,455
2,403
1,890
5,700
17,100
17,100
17,100
17,100
29,807
30,185
15,000
15,185
14,584
30,185
3.2 Total A/R (w/o prepayments)
3.3 Block Hour Prepayments
199,886
56,491
174,362
60,587
169,340
73,190
153,030
54,644
172,656
37,556
153,122
56,560
202,901
49,092
260,772
67,613
289,959
70,327
211,855
65,702
200,000
11,855
198,788
59,176
211,855
591,762
3.4 Contract Prepayments
3.5 Total Current Liabilities
35,851
195,867
26,056
171,592
53,452
220,920
54,980
199,838
28,740
184,634
50,583
245,861
38,770
184,881
19,625
178,108
39,995
174,989
33,756
169,156
108,900
60,256
38,181
192,585
381,808
169,156
1203
155
1,350
13,505
24
327
240
3,268
237
1,588
2,374
15,879
-4%
4. Sales & Billable Hours
4.1 New Bookings
4.2 # of Qualified Leads 90 days
4.3 # of Qualified Leads prop 60 days
4.4 # Forecasted 30 Days not invoiced
4.5 Total Billable Hours
1303
1093
1491
1412
1433
1406
1298
1449
1263
1358
4.5a Total No Charge Hours
4.5b Total Contract Hours
70
249
60
293
21
399
2
312
23
328
18
443
7
442
16
308
9
269
14
226
4.6 Total non-Billable Hours
4.7 Total Expected Hours
113
1,417
112
1,205
298
1,789
300
1,712
135
1,568
202
1,608
223
1,520
216
1,664
441
1,704
334
1,692
401
1604
5. Management Metrics
5.1 Consulting Gross Margin
50%
31%
35%
51%
48%
33%
48%
44%
41%
54%
55%
-1%
55%
5.2 Contract Gross Margin
5.3 Product Gross Margin
5.4 Hosting Gross Margin
50%
14%
26%
44%
9%
39%
37%
11%
24%
-60%
3%
24%
44%
5%
37%
62%
6%
31%
46%
17%
37%
57%
7%
51%
61%
12%
19%
60%
3%
16%
48%
18%
50%
12%
-15%
-34%
48%
18%
50%
92%
122.35
91%
113.93
83%
84.02
82%
126.79
91%
124.13
87%
102.18
85%
121.46
87%
119.63
74%
124.62
80%
146.23
75%
5%
85%
118.53
85%
75%
2.5
2.8
2.2
1.6
2.2
1.8
2.5
2.9
2.9
3.5
45%
2.4
3.5
5.5 Billable Efficiency
5.6 Average Hourly Income
5.7 Quick Ratio
6. Contract Metrics
6.1 Total No of TCP Contracts
6.2 Total No of Workstations
14
48
6.3 Total No of Servers
20
-67
88
85%
14%
Line items
1. Cash Flow
1.1 Cash
1.2 Cash - Curent assets
1.3 Collections
2. P&L
2.1 Income
2.2 COGS
2.3
2.5
2.6
2.7
Adjusted Gross Income (accrual)
Total Operating Expenses
Officer Distribution
Net Profit (EBIDTA)
3. Balance Sheet
3.1 90>
3.2 Total A/R
3.3 Block Hour Prepayments
3.4 Contract Prepayments
3.5 Total Current Liabilities
4. Key Data
4.1 Total Employees FTE's
4.2 Billable Employees FTE's
4.3 Total Billable Hours
4.4 Total non-Billable Hours
4.5 Total expected hours
5. Mgmt Metrics, Trend Indicators
5.1 Consulting Gross Margin
5.2 Contract Gross Margin
5.3 Product Gross Margin
5.4 Hosting Gross Margin
5.5 Billable Efficiency
5.6 Average Hourly Income
5.7 Quick Ratio
6. Key %
6.1 % business from 1 client 12 mo.
6.2 % Payroll & Benefits
6.6 % Facilities: Rent, Utilities
7. Forecasting
7.1 Jobs forcasted but not invoiced
7.4 Next month projected profit Margin
Rules
Balance sheet, Sum of banking account
Balance sheet, Total Current Assets
Cash collected
P&L accrual by month; Collapsed Income accounts (2.1a-2.1d)
P&L accrual by month; Total COGS for the month collapsed
Contract COGS = Total Contract COGS + Contract Salary + Contract Purchases
P&L accrual by month; Total Gross Profit
P&L accrual by month; Total expenses for the month
CJL Monthly Distribution; V. Lieu Gross Payroll
Formula (Adjusted Gross Income-Total Operating Expenses)
AR Aging Summary, by month, collapsed
AR Aging Summary, by month, collapsed, + Block Hr + Contract Prepayments
Block Hour Prepayment Spreadsheet
Contract Prepayment Spreadsheet
Balance sheet current liabilities + Block Hr Prepayment + Contract Prepayment
Refer to Empl count tab on this spreadsheet
Refer to Empl count tab on this spreadsheet
Total billed hours for month plus total hosting hours
Formula (Total Billable Hours - Total Expected Hours)
Total working hours for month minus PTO
Consulting Income - Consulting COGS / Consulting Income
Contract Income - Contract COGS / Contract Income
Product Income - Product COGS / Product Income
Hosting Income - Hosting COGS / Hosting Income
Total Billable Hours / Total Expected Hours
Sum of ((60% Contract Income)+(Consulting Income)+(80% Hosting Income))/Total Billable Hrs
Payroll & Benefits / Adjusted Gross Income
Fixed Costs / Adjusted Gross Income
3 months contracted Fee Revenue from DS Forecasting Report
