Cyclist Repair Center
Appendix
Sales Forecast | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Sales | |||||||||||||
Sports massage | 0% | $0 | $0 | $0 | $804 | $1,474 | $2,446 | $2,613 | $3,015 | $3,618 | $3,953 | $4,288 | $4,559 |
Personal trainer | 0% | $0 | $0 | $0 | $768 | $1,408 | $2,336 | $2,496 | $2,880 | $3,456 | $3,776 | $4,096 | $4,355 |
Fitness assessment | 0% | $0 | $0 | $0 | $648 | $1,188 | $1,971 | $2,106 | $2,430 | $2,916 | $3,186 | $3,456 | $3,675 |
Bike fit | 0% | $0 | $0 | $0 | $684 | $1,254 | $2,081 | $2,223 | $2,565 | $3,078 | $3,363 | $3,648 | $3,879 |
Cycling related injuries | 0% | $0 | $0 | $0 | $1,200 | $2,200 | $3,650 | $3,900 | $4,500 | $5,400 | $5,900 | $6,400 | $6,805 |
Total Sales | $0 | $0 | $0 | $4,104 | $7,524 | $12,483 | $13,338 | $15,390 | $18,468 | $20,178 | $21,888 | $23,273 | |
Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Sports massage | $0 | $0 | $0 | $40 | $74 | $122 | $131 | $151 | $181 | $198 | $214 | $228 | |
Personal trainer | $0 | $0 | $0 | $38 | $70 | $117 | $125 | $144 | $173 | $189 | $205 | $218 | |
Fitness assessment | $0 | $0 | $0 | $32 | $59 | $99 | $105 | $122 | $146 | $159 | $173 | $184 | |
Bike fit | $0 | $0 | $0 | $34 | $63 | $104 | $111 | $128 | $154 | $168 | $182 | $194 | |
Cycling related injuries | $0 | $0 | $0 | $60 | $110 | $183 | $195 | $225 | $270 | $295 | $320 | $340 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $205 | $376 | $624 | $667 | $770 | $923 | $1,009 | $1,094 | $1,164 |
Personnel Plan | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Arthur | 0% | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Physician | 0% | $0 | $0 | $0 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Massage therapist | 0% | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Massage therapist | 0% | $0 | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Physical therapist | 0% | $0 | $0 | $0 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 |
Physical therapist | 0% | $0 | $0 | $0 | $0 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 |
Coach/trainer | 0% | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Receptionist | 0% | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Accounting clerk/receptionist | 0% | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Total People | 0 | 0 | 0 | 7 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | |
Total Payroll | $0 | $0 | $2,000 | $16,000 | $21,500 | $21,500 | $21,500 | $21,500 | $21,500 | $21,500 | $21,500 | $21,500 |
General Assumptions | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
Current Interest 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% | |
Long-term Interest 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% | |
Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Pro Forma Profit and Loss | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Sales | $0 | $0 | $0 | $4,104 | $7,524 | $12,483 | $13,338 | $15,390 | $18,468 | $20,178 | $21,888 | $23,273 | |
Direct Cost of Sales | $0 | $0 | $0 | $205 | $376 | $624 | $667 | $770 | $923 | $1,009 | $1,094 | $1,164 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $0 | $205 | $376 | $624 | $667 | $770 | $923 | $1,009 | $1,094 | $1,164 | |
Gross Margin | $0 | $0 | $0 | $3,899 | $7,148 | $11,859 | $12,671 | $14,621 | $17,545 | $19,169 | $20,794 | $22,109 | |
Gross Margin % | 0.00% | 0.00% | 0.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | |
Expenses | |||||||||||||
Payroll | $0 | $0 | $2,000 | $16,000 | $21,500 | $21,500 | $21,500 | $21,500 | $21,500 | $21,500 | $21,500 | $21,500 | |
Sales and Marketing and Other Expenses | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Depreciation | $367 | $367 | $367 | $367 | $367 | $367 | $367 | $367 | $367 | $367 | $367 | $367 | |
Rent | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Utilities | $140 | $140 | $140 | $140 | $140 | $140 | $140 | $140 | $140 | $140 | $140 | $140 | |
Insurance | 15% | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 |
Payroll Taxes | 15% | $0 | $0 | $300 | $2,400 | $3,225 | $3,225 | $3,225 | $3,225 | $3,225 | $3,225 | $3,225 | $3,225 |
Total Operating Expenses | $2,457 | $2,457 | $4,757 | $20,857 | $27,182 | $27,182 | $27,182 | $27,182 | $27,182 | $27,182 | $27,182 | $27,182 | |
Profit Before Interest and Taxes | ($2,457) | ($2,457) | ($4,757) | ($16,958) | ($20,034) | ($15,323) | ($14,511) | ($12,562) | ($9,637) | ($8,013) | ($6,388) | ($5,073) | |
EBITDA | ($2,090) | ($2,090) | ($4,390) | ($16,591) | ($19,667) | ($14,956) | ($14,144) | ($12,195) | ($9,270) | ($7,646) | ($6,021) | ($4,706) | |
Interest Expense | $247 | $244 | $240 | $237 | $234 | $230 | $227 | $223 | $220 | $216 | $213 | $209 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($2,704) | ($2,701) | ($4,997) | ($17,195) | ($20,268) | ($15,553) | ($14,738) | ($12,785) | ($9,857) | ($8,229) | ($6,601) | ($5,282) | |
Net Profit/Sales | 0.00% | 0.00% | 0.00% | -418.98% | -269.38% | -124.60% | -110.49% | -83.07% | -53.38% | -40.78% | -30.16% | -22.70% |
Pro Forma Cash Flow | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $0 | $0 | $0 | $4,104 | $7,524 | $12,483 | $13,338 | $15,390 | $18,468 | $20,178 | $21,888 | $23,273 | |
Subtotal Cash from Operations | $0 | $0 | $0 | $4,104 | $7,524 | $12,483 | $13,338 | $15,390 | $18,468 | $20,178 | $21,888 | $23,273 | |
Additional Cash Received | |||||||||||||
Sales Tax, VAT, HST/GST Received | 0.00% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
New Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Other Liabilities (interest-free) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales of Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales of Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Investment Received | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $0 | $0 | $0 | $4,104 | $7,524 | $12,483 | $13,338 | $15,390 | $18,468 | $20,178 | $21,888 | $23,273 | |
Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Expenditures from Operations | |||||||||||||
Cash Spending | $0 | $0 | $2,000 | $16,000 | $21,500 | $21,500 | $21,500 | $21,500 | $21,500 | $21,500 | $21,500 | $21,500 | |
Bill Payments | $78 | $2,337 | $2,343 | $2,707 | $4,965 | $5,933 | $6,171 | $6,212 | $6,313 | $6,461 | $6,543 | $6,625 | |
Subtotal Spent on Operations | $78 | $2,337 | $4,343 | $18,707 | $26,465 | $27,433 | $27,671 | $27,712 | $27,813 | $27,961 | $28,043 | $28,125 | |
Additional Cash Spent | |||||||||||||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Principal Repayment of Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $387 | $391 | $394 | $397 | $400 | $404 | $407 | $411 | $414 | $417 | $421 | $424 | |
Purchase Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Purchase Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Spent | $465 | $2,727 | $4,737 | $19,104 | $26,866 | $27,837 | $28,078 | $28,123 | $28,227 | $28,379 | $28,464 | $28,549 | |
Net Cash Flow | ($465) | ($2,727) | ($4,737) | ($15,000) | ($19,342) | ($15,354) | ($14,740) | ($12,733) | ($9,759) | ($8,201) | ($6,576) | ($5,276) | |
Cash Balance | $121,035 | $118,307 | $113,570 | $98,570 | $79,228 | $63,874 | $49,135 | $36,402 | $26,643 | $18,443 | $11,866 | $6,591 |
Pro Forma Balance Sheet | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $121,500 | $121,035 | $118,307 | $113,570 | $98,570 | $79,228 | $63,874 | $49,135 | $36,402 | $26,643 | $18,443 | $11,866 | $6,591 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $121,500 | $121,035 | $118,307 | $113,570 | $98,570 | $79,228 | $63,874 | $49,135 | $36,402 | $26,643 | $18,443 | $11,866 | $6,591 |
Long-term Assets | |||||||||||||
Long-term Assets | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 |
Accumulated Depreciation | $0 | $367 | $734 | $1,101 | $1,468 | $1,835 | $2,202 | $2,569 | $2,936 | $3,303 | $3,670 | $4,037 | $4,404 |
Total Long-term Assets | $22,000 | $21,633 | $21,266 | $20,899 | $20,532 | $20,165 | $19,798 | $19,431 | $19,064 | $18,697 | $18,330 | $17,963 | $17,596 |
Total Assets | $143,500 | $142,668 | $139,573 | $134,469 | $119,102 | $99,393 | $83,672 | $68,566 | $55,466 | $45,340 | $36,773 | $29,829 | $24,187 |
Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Current Liabilities | |||||||||||||
Accounts Payable | $0 | $2,259 | $2,256 | $2,543 | $4,768 | $5,727 | $5,964 | $6,002 | $6,098 | $6,243 | $6,322 | $6,402 | $6,465 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $0 | $2,259 | $2,256 | $2,543 | $4,768 | $5,727 | $5,964 | $6,002 | $6,098 | $6,243 | $6,322 | $6,402 | $6,465 |
Long-term Liabilities | $30,000 | $29,613 | $29,222 | $28,828 | $28,431 | $28,030 | $27,627 | $27,219 | $26,809 | $26,395 | $25,977 | $25,556 | $25,132 |
Total Liabilities | $30,000 | $31,871 | $31,478 | $31,371 | $33,199 | $33,758 | $33,590 | $33,221 | $32,906 | $32,638 | $32,300 | $31,958 | $31,597 |
Paid-in Capital | $122,000 | $122,000 | $122,000 | $122,000 | $122,000 | $122,000 | $122,000 | $122,000 | $122,000 | $122,000 | $122,000 | $122,000 | $122,000 |
Retained Earnings | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) |
Earnings | $0 | ($2,704) | ($5,404) | ($10,402) | ($27,597) | ($47,864) | ($63,418) | ($78,156) | ($90,940) | ($100,798) | ($109,027) | ($115,629) | ($120,911) |
Total Capital | $113,500 | $110,796 | $108,096 | $103,098 | $85,903 | $65,636 | $50,082 | $35,344 | $22,560 | $12,702 | $4,473 | ($2,129) | ($7,411) |
Total Liabilities and Capital | $143,500 | $142,668 | $139,573 | $134,469 | $119,102 | $99,393 | $83,672 | $68,566 | $55,466 | $45,340 | $36,773 | $29,829 | $24,187 |
Net Worth | $113,500 | $110,796 | $108,096 | $103,098 | $85,903 | $65,636 | $50,082 | $35,344 | $22,560 | $12,702 | $4,473 | ($2,129) | ($7,411) |