[HAWRAF] 2018 Critical Metrics (clean)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ALMNOP
1
2018
2
Q1Q2Q3Q4T
3
Sales (Cash) $ 38,720.00 $ 157,100.00 $ 149,836.00 $ 120,370.00 $ 466,026.00
4
Uncategorized Income $ 2,500.00 $ 411.36 $ 815.14 $ 163.66 $ 3,890.16
5
Total Income (Cash) $ 41,220.00 $ 157,511.36 $ 150,651.14 $ 120,533.66 $ 469,916.16
6
GROSS PROFIT $ 41,220.00 $ 157,511.36 $ 150,651.14 $ 120,533.66 $ 469,916.16
7
Advertising & Marketing $ (115.50) $ (224.85) $ (633.62) $ (166.59) $ (1,140.56)
8
Bank Charges & Fees $ (43.60) $ (23.84) $ - $ (20.00) $ (87.44)
9
Catering $ - $ - $ - $ - $ -
10
Charity $ - $ (361.36) $ (315.14) $ (163.66) $ (840.16)
11
Coffee $ (258.41) $ (347.81) $ (266.65) $ (208.94) $ (1,081.81)
12
Continuing Education $ (80.00) $ (124.30) $ (113.72) $ (127.65) $ (445.67)
13
Cost of Labor $ - $ - $ - $ (9,000.00) $ (9,000.00)
14
Gift $ (104.00) $ - $ - $ - $ (104.00)
15
Insurance $ (5,906.55) $ (5,906.55) $ (5,906.55) $ (3,937.70) $ (21,657.35)
16
Job Supplies $ - $ - $ - $ - $ -
17
Legal & Professional Services $ (750.00) $ (2,950.00) $ (750.00) $ (750.00) $ (5,200.00)
18
Meals & Entertainment $ (1,246.22) $ (1,128.99) $ (1,013.77) $ (371.12) $ (3,760.10)
19
Office Supplies & Software $ (693.61) $ (1,674.04) $ (2,076.82) $ (2,071.24) $ (6,515.71)
20
Other Business Expenses $ (273.77) $ (215.70) $ - $ - $ (489.47)
21
Purchases $ 2,535.16 $ 150.00 $ - $ - $ 2,685.16
22
QuickBooks Payments Fees $ - $ (587.93) $ - $ - $ (587.93)
23
Reimbursable Expenses $ (160.01) $ - $ - $ (589.15) $ (749.16)
24
Rent & Lease $ (3,450.00) $ (3,600.00) $ (4,425.00) $ (1,700.00) $ (13,175.00)
25
Repairs & Maintenance $ - $ - $ (123.91) $ - $ (123.91)
26
Research $ (19.41) $ (19.99) $ - $ - $ (39.40)
27
Taxes & Licenses $ (25.00) $ - $ - $ - $ (25.00)
28
Travel $ (1,708.26) $ (3,339.67) $ (1,884.52) $ (326.98) $ (7,259.43)
29
Uncategorized Expense $ (81.58) $ - $ - $ - $ (81.58)
30
Utilities $ (494.94) $ (494.94) $ (514.94) $ (184.98) $ (1,689.80)
31
Total Expenses $ (12,875.70) $ (20,849.97) $ (18,024.64) $ (19,618.01) $ (71,368.32)
32
Budgeted Expenses $ (15,000.00) $ (15,000.00) $ (15,000.00) $ (15,000.00) $ (60,000.00)
33
% Expense Budget 86%139%120%131%119%
34
NET OPERATING INCOME $ 28,344.30 $ 136,661.39 $ 132,626.50 $ 100,915.65 $ 398,547.84
35
NET INCOME $ 28,344.30 $ 136,661.39 $ 132,626.50 $ 100,915.65 $ 398,547.84
36
Owner's Pay $ (66,000.00) $ (132,991.00) $ (105,715.75) $ (65,000.00) $ (369,706.75)
37
Net-Owner's $ $ (37,655.70) $ 3,670.39 $ 26,910.75 $ 35,915.65 $ 28,841.09
38
Target Revenue$150,000$150,000$150,000$150,000$600,000
39
Cash % Target Revenue 27%105%100%80%78%
40
Retained Earnings $ (37,655.70) $ 3,670.39 $ 26,910.75 $ 35,915.65 $ 305,768.36
44
Bank Balance $ 26,334.01 $ 23,823.06 $ 44,946.80 $ 106,944.57
45
Burn Rate $ 4,291.90 $ 6,949.99 $ 6,008.21 $ 2,120.87
46
Runway (months) 6.143.437.4850.42First Day of Current Q:
47
+ Owner's (months) 1.000.461.094.50
48
% Ideal Runway34%28%54%150%10/1/2018
49
Months into Q9.256/17/2019
Loading...