ABCDEFGHIJKLMNPQRSTUVWXYZAA
1
Business Summary
2
Becker-Hill IncJan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Total
3
QTYQTY
4
Income
5
Coaching 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 120,000
6
Book sales 0
7
Training 0
8
Fall 2018 Empowerment School Launch 0
9
Full package with office hours access 10 79,980 79,990
10
Scholarship Package 5 29,990 29,995
11
Individual Course 1 10 3,000 3,010
12
Individual Course 2 10 3,000 3,010
13
Individual Course 3 10 3,000 3,010
14
Individual Course 4 10 3,000 3,010
15
Individual Course 5 10 3,000 3,010
16
Individual Course 6 10 3,000 3,010
17
Individual Course 7 10 3,000 3,010
18
Individual Course 8 10 3,000 3,010
19
Individual Course 9 10 3,000 3,010
20
Individual Course 10 10 3,000 3,010
21
Interest Received 0 0
22
Tax Refund 0 0
23
Other Refunds 10,000 0 10,000
24
Total Income 10,000 10,000 10,000 10,000 10,000 20,000 10,000 10,000 10,000 149,970 10,000 10,000 270,085
25
26
Profit
27
Transfer to Sylvia Becker-Hill 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 10,000 10,000 10,000 75,000
28
29
Cashflow available for Expenses 5,000 5,000 5,000 5,000 5,000 15,000 5,000 5,000 5,000 139,970 0 0 195,085
30
 0
31
Cash Expenses 0
32
Ad & Promo(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(1,200)
33
Airfare and Accomodations(1,000)(1,000)(1,000)(1,000)(4,000)
34
Automobile Expense(500)(500)
35
Bank Charges(25)(25)(25)(25)(25)(25)(25)(25)(25)(25)(25)(25)(300)
36
Books and Magazines(50)(50)(50)(50)(50)(50)(50)(50)(50)(50)(50)(50)(600)75000
37
Continuing Education(250)(250)(250)(250)(250)(250)(250)(250)(250)(250)(250)(250)(3,000)6250
38
Dues and Subscriptions(50)(50)(50)(50)(50)(50)(50)(50)(50)(50)(50)(50)(600)
39
Interest Expense(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(1,200)
40
Finance Charges 0
41
Foreign Taxes 0
42
Food - 100%(200)(200)(200)(200)(800)
43
Insurance(40)(40)(40)(40)(40)(40)(40)(40)(40)(40)(40)(40)(480)
44
Meals & Ent 50%(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(1,200)
45
Office Supplies(200)(200)(200)(600)
46
Postage and Delivery(100)(100)(100)(300)
47
Professional / Subcontractors(1,000)(1,000)(1,000)(2,000)(2,000)(2,000)(2,000)(2,000)(2,000)(5,000)(5,000)(5,000)(30,000)
48
Training Supplies(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(1,200)
49
Referral Fees 0
50
Refunds 0
51
Online Marketing(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(1,200)
52
Taxes(844)(844)
53
Telephone(60)(60)(60)(60)(60)(60)(60)(60)(60)(60)(60)(60)(720)
54
Travel(150)(150)(150)(150)(150)(150)(150)(150)(150)(150)(150)(150)(1,800)
55
Website(50)(50)(50)(50)(50)(50)(50)(50)(50)(50)(50)(50)(600)
56
Working Lunches for Training 0
57
Unknown 0
58
Total Cash Expenses(3,275)(2,275)(3,519)(4,275)(3,075)(3,275)(3,175)(4,275)(3,075)(6,775)(6,175)(7,275)(50,444)
59
Income vs Expense ratio33%23%35%43%31%16%32%43%31%5%62%73%19%
60
Cashflow
61
Monthly Cashflow 1,725 2,725 1,481 725 1,925 11,725 1,825 725 1,925 133,195 (6,175)(7,275) 144,641
62
Accumulated Cashflow 1,725 4,450 5,931 6,656 8,581 20,306 22,131 22,856 24,781 157,976 151,801 144,526 137,366
63
64
Non cash Expenses
65
Business Use of the home(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(100)(1,200)
66
Mileage Deduction (500)(500)(500)(500)(500)(500)(500)(500)(500)(500)(500)(500)(6,000)
67
Total Non-cash expenses(600)(600)(600)(600)(600)(600)(600)(600)(600)(600)(600)(600)(7,200)
68
69
Taxable Income 6,125 7,125 5,881 5,125 6,325 16,125 6,225 5,125 6,325 142,595 3,225 2,125 212,441
70
Estimated Tax on income 1,531 1,781 1,470 1,281 1,581 4,031 1,556 1,281 1,581 35,649 806 531 53,110
71
less estimated taxes paid(5,000)(5,000)(5,000)(5,000)(20,000)
72
Tax to pay 1,531 3,313 (217) 1,064 2,645 1,677 3,233 4,514 4,514 1,095 36,744 37,550 33,082 66,192
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100