Home | Koko FitClub Website | In The News | Financials | Executive Summary | Investment | Business Plan

Financials

Koko FitClub Parmer Lane
       
Membership Rates and Assumptions
Yearly membership $ 79.00
Month-to-month membership $ 119.00
One time Koko Key fee $ -
One time Koko Access card fee $ -
Membership Joining fee $ 199.00
Membership Variables
percent of members on Annual membership 95%
percent of members on Monthly membership 5%
% of new members choosing key access 0%
Attrition % 2.5% (no attrition for first 100 members) Ending Members
30% Total Year End Mon 12 End Mon 24 End Mon 36
330 390 366
Sensitivity 105%
# of Members 20 35 45 35 35 40 20 15 20 30 35 25 20 10 20 12 12 5 15 10 20 15 5 12 5 5 10 5 8 5 5 12 5 5 5 10
Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Months Months Months
Membership Aug-11 Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 1 - 12 13 - 24 25 - 36
Starting members - 21 58 105 140 174 212 228 238 254 280 311 330 343 345 358 363 366 363 369 371 383 390 386 390 386 382 384 380 379 375 372 375 372 368 364 - 330 390
New members joined for month 21 37 47 37 37 42 21 16 21 32 37 26 21 11 21 13 13 5 16 11 21 16 5 13 5 5 11 5 8 5 5 13 5 5 5 11 373 164 84
members lost for month - - - 2 3 4 5 5 5 6 6 7 8 8 8 8 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 43 104 108
total ending members for month 21 58 105 140 174 212 228 238 254 280 311 330 343 345 358 363 366 363 369 371 383 390 386 390 386 382 384 380 379 375 372 375 372 368 364 366 330 390 366
Monthly Revenues from Membership Dues and Fees
New member joining fees $ 3,970 $ 6,948 $ 8,933 $ 6,948 $ 6,948 $ 7,940 $ 3,970 $ 2,978 $ 3,970 $ 5,955 $ 6,948 $ 4,963 $ 3,970 $ 1,985 $ 3,970 $ 2,382 $ 2,382 $ 993 $ 2,978 $ 1,985 $ 3,970 $ 2,978 $ 993 $ 2,382 $ 993 $ 993 $ 1,985 $ 993 $ 1,588 $ 993 $ 993 $ 2,382 $ 993 $ 993 $ 993 $ 1,985 $ 70,468 $ 30,966 $ 15,880
Month-to-month Membership fees 125 344 625 832 1,032 1,258 1,354 1,418 1,513 1,665 1,847 1,962 2,039 2,054 2,132 2,159 2,180 2,158 2,198 2,207 2,279 2,319 2,296 2,318 2,296 2,273 2,282 2,260 2,256 2,234 2,212 2,233 2,211 2,188 2,166 2,175 13,974 26,339 26,786
Yearly Contract Membership fees 1,576 4,334 7,880 10,488 13,021 15,873 17,074 17,881 19,081 20,995 23,303 24,748 25,723 25,911 26,887 27,232 27,502 27,221 27,727 27,840 28,740 29,247 28,966 29,236 28,954 28,673 28,785 28,504 28,459 28,178 27,896 28,166 27,885 27,603 27,322 27,435 176,255 332,231 337,860
New member Koko Key fees - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
New Member Koko Access fees - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Total Monthly revenues $ 5,671 $ 11,625 $ 17,438 $ 18,267 $ 21,001 $ 25,072 $ 22,398 $ 22,276 $ 24,564 $ 28,615 $ 32,098 $ 31,672 $ 31,733 $ 29,950 $ 32,988 $ 31,773 $ 32,064 $ 30,371 $ 32,903 $ 32,032 $ 34,989 $ 34,543 $ 32,254 $ 33,936 $ 32,242 $ 31,939 $ 33,053 $ 31,756 $ 32,303 $ 31,404 $ 31,100 $ 32,781 $ 31,088 $ 30,784 $ 30,481 $ 31,595 $ 260,697 $ 389,537 $ 380,526
Operating Expenses
Rent and CAM $ - $ - $ 2,500 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 4,696 $ 44,763 $ 56,350 $ 56,350
Equipment Financing - - 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 483 4,833 5,800 5,800
Royalties 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 395 4,740 4,740 4,740
Utilities 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 6,000 6,000 6,000
Insurance 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 3,000 3,000 3,000
Access devices 105 184 236 184 184 210 105 79 105 158 184 131 105 53 105 63 63 26 79 53 105 79 26 63 26 26 53 26 42 26 26 63 26 26 26 53 1,864 819 420
Koko Keys 419 586 943 733 733 838 419 314 419 628 733 524 419 209 419 251 251 105 314 209 419 314 105 251 105 105 209 105 168 105 105 251 105 105 105 209 7,289 3,268 1,676
Advertising Fund (3%) 170 349 523 548 630 752 672 668 737 858 963 950 952 899 990 953 962 911 987 961 1,050 1,036 968 1,018 967 958 992 953 969 942 933 983 933 924 914 948 7,821 11,686 11,416
Local Advertising (minimum $10k for Grand Opening) 5,000 5,000 5,000 500 500 5,000 1,000 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 24,500 6,000 6,000
System Fees 105 289 525 699 868 1,058 1,138 1,191 1,271 1,399 1,553 1,649 1,714 1,726 1,791 1,814 1,832 1,814 1,847 1,855 1,915 1,949 1,930 1,948 1,929 1,910 1,918 1,899 1,896 1,877 1,859 1,877 1,858 1,839 1,820 1,828 11,743 22,134 22,509
Credit Card fees 170 349 523 548 630 752 672 668 737 858 963 950 952 899 990 953 962 911 987 961 1,050 1,036 968 1,018 967 958 992 953 969 942 933 983 933 924 914 948 7,821 11,686 11,416
Printing/office supplies 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 500 500 500
Other 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 600 600 600
Payroll (Hrs/Wk * Hourly Rate * wks in mon=4) 1,600 1,600 1,600 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 26,400 28,800 28,800
Total Operating Expenses $ 8,806 $ 9,593 $ 13,570 $ 12,028 $ 12,360 $ 17,426 $ 12,821 $ 12,237 $ 12,585 $ 13,217 $ 13,711 $ 13,520 $ 13,457 $ 13,101 $ 13,610 $ 13,351 $ 13,386 $ 13,083 $ 13,530 $ 13,354 $ 13,854 $ 13,730 $ 13,312 $ 13,614 $ 13,310 $ 13,273 $ 13,479 $ 13,251 $ 13,360 $ 13,208 $ 13,171 $ 13,474 $ 13,170 $ 13,133 $ 13,096 $ 13,301 $ 151,873 $ 161,383 $ 159,226
Income before MGR/OWNER Salaries, Depreciation, Interest and Taxes $ (3,135) $ 2,032 $ 3,867 $ 6,240 $ 8,641 $ 7,646 $ 9,576 $ 10,039 $ 11,979 $ 15,397 $ 18,387 $ 18,152 $ 18,275 $ 16,849 $ 19,378 $ 18,422 $ 18,678 $ 17,289 $ 19,373 $ 18,678 $ 21,135 $ 20,813 $ 18,943 $ 20,322 $ 18,932 $ 18,665 $ 19,574 $ 18,505 $ 18,944 $ 18,196 $ 17,929 $ 19,308 $ 17,918 $ 17,651 $ 17,385 $ 18,293 $ 108,824 $ 228,154 $ 221,300
Year 1 $ 74.30 Ad spend per member
Year 2 $ 15.40 Ad spend per member
$ 44.85 Avg between Yr 1 and 2
Year One Total $ 108,824 196 avg members  
Year Two Total $ 228,154 369 avg members  
Year Three Total $ 221,300 375 avg members
Total Staffed Hours per week 40 40 40 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60
Hourly Rate $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00
# of Hourly Staff 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3