Income-Expense Planner
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRST
1
*To edit this spreadsheet you will need to save it as an Excel file on your computer. To do this, click File --> Email as attachment --> enter your email address --> Send.
2
3
Targeted Number Of Closings
4
Transactionsyear 1year 2year 3year 4year 5
5
Jan00000
6
Feb00000
7
Mar11222
8
Apr11333
9
May3244
10
Jun12345
11
Jul11334
12
Aug21212
13
Sep1222
14
Oct11111
15
Nov1111
16
Dec00000
17
Total712192124
18
19
Avg Listing$200,000$210,000$220,000$230,000$240,000
20
21
Commission %3%3%3%3%3%
22
Commission SplitAgent:50%Company:50%
23
Company Monthly Fee$0$0$0$0$0
24
25
26
Commissionyear 1year 2year 3year 4year 5
27
Jan - - - - -
28
Feb - - - - -
29
Mar$3,000$3,150$6,600$6,900$7,200
30
Apr$3,000$3,150$9,900$10,350$10,800
31
May - $9,450$6,600$13,800$14,400
32
Jun$3,000$6,300$9,900$13,800$18,000
33
Jul$3,000$3,150$9,900$10,350$14,400
34
Aug$6,000$3,150$6,600$3,450$7,200
35
Sep - $3,150$6,600$6,900$7,200
36
Oct$3,000$3,150$3,300$3,450$3,600
37
Nov - $3,150$3,300$3,450$3,600
38
Dec - - - - -
39
Total$21,000$37,800$62,700$72,450$86,400
40
41
Annual % Expense Increase2%
42
43
Expensesyear 1year 2year 3year 4year 5
44
Company Fee - - - - -
45
Desk Fee - - - - -
46
Internet Charges - - - -
47
E&O Insurance - - - - -
48
Business Insurance - - - - -
49
Medical Insurance - - - - -
50
Advertising - - - -
51
Personal Marketing$1,200$1,224$1,248$1,273$1,298
52
Signs - - - -
53
Office Supplies$200$204$208$212$216
54
Postage / Copies$200$204$208$212$216
55
Office Expense$500$510$520$530$541
56
Telephone$600$612$624$636$649
57
Dues - - - -
58
Subscriptions$500$510$520$530$541
59
Professional Development$500$510$520$530$541
60
Legal - - - - -
61
Accounting$500$510$520$530$541
62
Franchise fees - - - - -
63
Broker Listing Expenses$500$510$520$530$541
64
Auto - Fuel$1,200$1,224$1,248$1,273$1,298
65
Auto - Insurance$400$408$416$424$432
66
Auto - Maintenance$300$306$312$318$324
67
Travel - - - - -
68
Meals & Entertainment$200$204$208$212$216
69
Miscellaneous$500$510$520$530$541
70
Total$7,300$7,446$7,592$7,740$7,895
71
72
Net Income$13,700$30,354$55,108$64,710$78,505
73
74
Self Employment Tax1699376468338024973512.4%
75
Medicare3978801598187722772.9%
76
State Income Tax - - - - - 0%
77
Federal Income Tax - - - - - 0%
78
Total Business Taxes$2,096$4,644$8,431$9,901$12,012
79
80
Net Cash Flow**$11,604$25,710$46,677$54,809$66,493
Loading...
Main menu