A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||||||||||||||||||
2 | ProForma | Month over Month Change in Dues Collected | 3% | ||||||||||||||||||||||||
3 | Anytime Fitness, Sample Town | Month over Month Change in Training Collected | $1,000 | ||||||||||||||||||||||||
4 | |||||||||||||||||||||||||||
5 | Operational | ||||||||||||||||||||||||||
6 | Revenue | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Year 1 Totals | |||||||||||||
7 | Membership Dues | $33,446.00 | $34,449.38 | $35,482.86 | $36,547.35 | $37,643.77 | $38,773.08 | $39,936.27 | $41,134.36 | $42,368.39 | $43,639.44 | $44,948.63 | $46,297.09 | $474,666.62 | |||||||||||||
8 | Enhancement Fees | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $20,227.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $20,227.00 | $40,454.00 | |||||||||||||
9 | Upfront Membership Fees | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $24,000.00 | |||||||||||||
10 | Late Fee | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||
11 | Training | $3,122.00 | $4,122.00 | $5,122.00 | $6,122.00 | $7,122.00 | $8,122.00 | $9,122.00 | $10,122.00 | $11,122.00 | $12,122.00 | $13,122.00 | $14,122.00 | $103,464.00 | |||||||||||||
12 | Vending | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||
13 | Visitor Passes | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||
14 | Total Revenue | $38,568.00 | $40,571.38 | $42,604.86 | $44,669.35 | $46,765.77 | $69,122.08 | $51,058.27 | $53,256.36 | $55,490.39 | $57,761.44 | $60,070.63 | $82,646.09 | $642,584.62 | |||||||||||||
15 | |||||||||||||||||||||||||||
16 | Less Cost of Sales | ||||||||||||||||||||||||||
17 | All Access Key Cards | $0.00 | $0.00 | $0.00 | $0.00 | $500.00 | $0.00 | $0.00 | $0.00 | $500.00 | $0.00 | $0.00 | $0.00 | $1,000.00 | |||||||||||||
18 | Franchise Fee | $699.00 | $699.00 | $699.00 | $699.00 | $699.00 | $699.00 | $699.00 | $699.00 | $699.00 | $699.00 | $699.00 | $699.00 | $8,388.00 | |||||||||||||
19 | General Ad Fund Fee | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $7,200.00 | |||||||||||||
20 | Software Fees | $710.00 | $710.00 | $710.00 | $710.00 | $710.00 | $710.00 | $710.00 | $710.00 | $710.00 | $710.00 | $710.00 | $710.00 | $8,520.00 | |||||||||||||
21 | Administrative Fees | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $10.00 | $120.00 | |||||||||||||
22 | Contract Storage Fee | $13.00 | $13.00 | $13.00 | $13.00 | $13.00 | $13.00 | $13.00 | $13.00 | $13.00 | $13.00 | $13.00 | $13.00 | $156.00 | |||||||||||||
23 | Credit Card Pass Through Fee | $721.14 | $721.14 | $721.14 | $721.14 | $721.14 | $721.14 | $721.14 | $721.14 | $721.14 | $721.14 | $721.14 | $721.14 | $8,653.68 | |||||||||||||
24 | Merchant Service Fees | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||
25 | Processing Fees | $1,254.00 | $1,254.00 | $1,254.00 | $1,254.00 | $1,254.00 | $1,254.00 | $1,254.00 | $1,254.00 | $1,254.00 | $1,254.00 | $1,254.00 | $1,254.00 | $15,048.00 | |||||||||||||
26 | Forward to Collections Fee | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||
27 | Supplements Expense | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||
28 | Total Cost of Sales | $4,007.14 | $4,007.14 | $4,007.14 | $4,007.14 | $4,507.14 | $4,007.14 | $4,007.14 | $4,007.14 | $4,507.14 | $4,007.14 | $4,007.14 | $4,007.14 | $49,085.68 | |||||||||||||
29 | |||||||||||||||||||||||||||
30 | Gross Profit | $34,560.86 | $36,564.24 | $38,597.72 | $40,662.21 | $42,258.63 | $65,114.94 | $47,051.13 | $49,249.22 | $50,983.25 | $53,754.30 | $56,063.49 | $78,638.95 | $593,498.94 | |||||||||||||
31 | |||||||||||||||||||||||||||
32 | Operating Expenses | ||||||||||||||||||||||||||
33 | Accounting Fees | $329.00 | $355.00 | $355.00 | $355.00 | $355.00 | $355.00 | $355.00 | $355.00 | $355.00 | $355.00 | $355.00 | $355.00 | $4,234.00 | |||||||||||||
34 | Advertising and Promotion | $500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $17,000.00 | |||||||||||||
35 | Cable/Phone/Internet Service | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $3,600.00 | |||||||||||||
36 | Cleaning Supplies | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $3,600.00 | |||||||||||||
37 | Cleaning/Janitorial Service | $800.00 | $800.00 | $800.00 | $800.00 | $800.00 | $800.00 | $800.00 | $800.00 | $800.00 | $800.00 | $800.00 | $800.00 | $9,600.00 | |||||||||||||
38 | Electric//Water/Sewer | $2,300.00 | $2,300.00 | $2,300.00 | $2,300.00 | $2,300.00 | $2,300.00 | $2,300.00 | $2,300.00 | $2,300.00 | $2,300.00 | $2,300.00 | $2,300.00 | $27,600.00 | |||||||||||||
39 | Gas | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $420.00 | |||||||||||||
40 | General Liability Insurance | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $3,000.00 | |||||||||||||
41 | Bond | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||
42 | Workers Compensation Insurance | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $60.00 | $720.00 | |||||||||||||
43 | Gym Equipment Expense | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $5,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $5,000.00 | $10,000.00 | |||||||||||||
44 | Office Supplies | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $1,800.00 | |||||||||||||
45 | Payroll Processing Fees | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $540.00 | |||||||||||||
46 | Repairs and Maintenance | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $75.00 | $900.00 | |||||||||||||
47 | Rent | $8,595.00 | $8,595.00 | $8,595.00 | $8,595.00 | $8,595.00 | $8,595.00 | $8,595.00 | $8,595.00 | $8,595.00 | $8,595.00 | $8,595.00 | $8,595.00 | $103,140.00 | |||||||||||||
48 | Salaries/Wages | $3,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $9,000.00 | $102,000.00 | |||||||||||||
49 | Commissions | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $4,800.00 | |||||||||||||
50 | Payroll Taxes | $300.00 | $650.00 | $650.00 | $650.00 | $650.00 | $650.00 | $650.00 | $650.00 | $650.00 | $650.00 | $650.00 | $650.00 | $7,450.00 | |||||||||||||
51 | Sales Taxes | $2,350.07 | $2,416.59 | $2,485.11 | $2,555.69 | $2,628.38 | $4,044.31 | $2,780.37 | $2,859.81 | $2,941.62 | $3,025.90 | $3,112.69 | $4,543.15 | $35,743.70 | |||||||||||||
52 | Total Operating Expenses | $19,789.07 | $27,231.59 | $27,300.11 | $27,370.69 | $27,443.38 | $33,859.31 | $27,595.37 | $27,674.81 | $27,756.62 | $27,840.90 | $27,927.69 | $34,358.15 | $336,147.70 | |||||||||||||
53 | |||||||||||||||||||||||||||
54 | Net Operating Income / (Loss) | $14,771.79 | $9,332.65 | $11,297.61 | $13,291.52 | $14,815.25 | $31,255.64 | $19,455.76 | $21,574.41 | $23,226.63 | $25,913.41 | $28,135.79 | $44,280.80 | $257,351.24 | |||||||||||||
55 | |||||||||||||||||||||||||||
56 | |||||||||||||||||||||||||||
57 | |||||||||||||||||||||||||||
58 | |||||||||||||||||||||||||||
59 | |||||||||||||||||||||||||||
60 | |||||||||||||||||||||||||||
61 | |||||||||||||||||||||||||||
62 | |||||||||||||||||||||||||||
63 | |||||||||||||||||||||||||||
64 | |||||||||||||||||||||||||||
65 | |||||||||||||||||||||||||||
66 | |||||||||||||||||||||||||||
67 | |||||||||||||||||||||||||||
68 | |||||||||||||||||||||||||||
69 | |||||||||||||||||||||||||||
70 | |||||||||||||||||||||||||||
71 | |||||||||||||||||||||||||||
72 | |||||||||||||||||||||||||||
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 |