Gymnastics Jump-Start
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 | |||||||||||||
Parent and Tot | 0% | $450 | $464 | $477 | $492 | $506 | $522 | $537 | $553 | $570 | $587 | $605 | $623 |
Preschool | 0% | $4,568 | $4,705 | $4,846 | $4,992 | $5,141 | $5,296 | $5,454 | $5,618 | $5,787 | $5,960 | $6,139 | $6,323 |
Girls | 0% | $4,096 | $4,219 | $4,345 | $4,476 | $4,610 | $4,748 | $4,891 | $5,038 | $5,189 | $5,344 | $5,505 | $5,670 |
Boys | 0% | $820 | $845 | $870 | $896 | $923 | $951 | $979 | $1,008 | $1,039 | $1,070 | $1,102 | $1,135 |
Tumbling and Adult Gymnastics | 0% | $1,840 | $1,895 | $1,952 | $2,011 | $2,071 | $2,133 | $2,197 | $2,263 | $2,331 | $2,401 | $2,473 | $2,547 |
Birthday Parties and Field Trips | 0% | $550 | $567 | $583 | $601 | $619 | $638 | $657 | $676 | $697 | $718 | $739 | $761 |
Cheerleading | 0% | $1,000 | $1,030 | $1,061 | $1,093 | $1,126 | $1,159 | $1,194 | $1,230 | $1,267 | $1,305 | $1,344 | $1,384 |
Advanced Girls | 0% | $1,586 | $1,634 | $1,683 | $1,733 | $1,785 | $1,839 | $1,894 | $1,951 | $2,009 | $2,069 | $2,131 | $2,195 |
Total Sales | $14,910 | $15,357 | $15,818 | $16,293 | $16,781 | $17,285 | $17,803 | $18,337 | $18,888 | $19,454 | $20,038 | $20,639 | |
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 | |
Preschool gymnastics teachers | 30% | $1,505 | $1,551 | $1,597 | $1,645 | $1,694 | $1,745 | $1,798 | $1,851 | $1,907 | $1,964 | $2,023 | $2,084 |
Beginner girls, boy, and tumbling teachers | 30% | $2,027 | $2,088 | $2,150 | $2,215 | $2,281 | $2,350 | $2,420 | $2,493 | $2,567 | $2,645 | $2,724 | $2,806 |
Advanced girls teachers | 40% | $1,034 | $1,065 | $1,097 | $1,130 | $1,164 | $1,199 | $1,235 | $1,272 | $1,310 | $1,350 | $1,390 | $1,432 |
Subtotal Direct Cost of Sales | $4,567 | $4,704 | $4,845 | $4,990 | $5,140 | $5,294 | $5,453 | $5,616 | $5,785 | $5,958 | $6,137 | $6,321 |
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 | ||
Receptionist | 0% | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
Wanda Bounce | 0% | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
Bea Flip | 0% | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
Total People | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
Total Payroll | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 |
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 | $14,910 | $15,357 | $15,818 | $16,293 | $16,781 | $17,285 | $17,803 | $18,337 | $18,888 | $19,454 | $20,038 | $20,639 | |
Direct Cost of Sales | $4,567 | $4,704 | $4,845 | $4,990 | $5,140 | $5,294 | $5,453 | $5,616 | $5,785 | $5,958 | $6,137 | $6,321 | |
Other Costs of Sales | $280 | $280 | $280 | $280 | $280 | $280 | $280 | $280 | $280 | $280 | $280 | $280 | |
Total Cost of Sales | $4,847 | $4,984 | $5,125 | $5,270 | $5,420 | $5,574 | $5,733 | $5,896 | $6,065 | $6,238 | $6,417 | $6,601 | |
Gross Margin | $10,063 | $10,374 | $10,693 | $11,023 | $11,362 | $11,711 | $12,071 | $12,441 | $12,823 | $13,216 | $13,621 | $14,038 | |
Gross Margin % | 67.49% | 67.55% | 67.60% | 67.65% | 67.70% | 67.75% | 67.80% | 67.85% | 67.89% | 67.93% | 67.97% | 68.02% | |
Expenses | |||||||||||||
Payroll | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | |
Marketing/Promotion | $2,000 | $200 | $200 | $200 | $700 | $200 | $200 | $200 | $200 | $500 | $200 | $200 | |
Depreciation | $333 | $333 | $333 | $333 | $333 | $333 | $333 | $333 | $333 | $333 | $333 | $337 | |
Rent | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Utilities | $250 | $250 | $250 | $250 | $250 | $250 | $400 | $400 | $400 | $400 | $250 | $250 | |
Insurance | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Total Operating Expenses | $9,839 | $8,039 | $8,039 | $8,039 | $8,539 | $8,039 | $8,189 | $8,189 | $8,189 | $8,489 | $8,039 | $8,043 | |
Profit Before Interest and Taxes | $224 | $2,335 | $2,654 | $2,984 | $2,823 | $3,672 | $3,882 | $4,252 | $4,634 | $4,727 | $5,582 | $5,995 | |
EBITDA | $557 | $2,668 | $2,987 | $3,317 | $3,156 | $4,005 | $4,215 | $4,585 | $4,967 | $5,060 | $5,915 | $6,332 | |
Interest Expense | $301 | $298 | $294 | $290 | $287 | $283 | $280 | $276 | $272 | $269 | $265 | $261 | |
Taxes Incurred | ($23) | $611 | $708 | $808 | $761 | $1,017 | $1,081 | $1,193 | $1,308 | $1,337 | $1,595 | $1,720 | |
Net Profit | ($54) | $1,426 | $1,652 | $1,885 | $1,775 | $2,372 | $2,521 | $2,783 | $3,053 | $3,121 | $3,722 | $4,013 | |
Net Profit/Sales | -0.36% | 9.28% | 10.44% | 11.57% | 10.58% | 13.72% | 14.16% | 15.18% | 16.16% | 16.04% | 18.57% | 19.45% |
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 | $11,183 | $11,518 | $11,864 | $12,219 | $12,586 | $12,964 | $13,352 | $13,753 | $14,166 | $14,591 | $15,028 | $15,479 | |
Cash from Receivables | $0 | $124 | $3,731 | $3,843 | $3,958 | $4,077 | $4,200 | $4,326 | $4,455 | $4,589 | $4,727 | $4,868 | |
Subtotal Cash from Operations | $11,183 | $11,642 | $15,595 | $16,063 | $16,544 | $17,041 | $17,552 | $18,079 | $18,621 | $19,180 | $19,755 | $20,348 | |
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 | $11,183 | $11,642 | $15,595 | $16,063 | $16,544 | $17,041 | $17,552 | $18,079 | $18,621 | $19,180 | $19,755 | $20,348 | |
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 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | $3,440 | |
Bill Payments | $373 | $11,156 | $10,166 | $10,401 | $10,654 | $11,230 | $11,152 | $11,518 | $11,790 | $12,078 | $12,560 | $12,553 | |
Subtotal Spent on Operations | $3,813 | $14,596 | $13,606 | $13,841 | $14,094 | $14,670 | $14,592 | $14,958 | $15,230 | $15,518 | $16,000 | $15,993 | |
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 | $436 | $436 | $436 | $436 | $436 | $436 | $436 | $436 | $436 | $436 | $436 | $437 | |
Purchase Other Current Assets | $0 | $0 | $2,000 | $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 | $4,249 | $15,032 | $16,042 | $14,277 | $14,530 | $15,106 | $15,028 | $15,394 | $15,666 | $15,954 | $16,436 | $16,430 | |
Net Cash Flow | $6,934 | ($3,390) | ($447) | $1,786 | $2,014 | $1,935 | $2,524 | $2,685 | $2,955 | $3,226 | $3,319 | $3,917 | |
Cash Balance | $16,934 | $13,544 | $13,097 | $14,883 | $16,897 | $18,832 | $21,356 | $24,041 | $26,996 | $30,221 | $33,541 | $37,458 |
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 | $10,000 | $16,934 | $13,544 | $13,097 | $14,883 | $16,897 | $18,832 | $21,356 | $24,041 | $26,996 | $30,221 | $33,541 | $37,458 |
Accounts Receivable | $0 | $3,728 | $7,443 | $7,666 | $7,896 | $8,133 | $8,377 | $8,628 | $8,887 | $9,153 | $9,428 | $9,711 | $10,002 |
Other Current Assets | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Total Current Assets | $10,000 | $20,661 | $20,986 | $22,762 | $24,778 | $27,030 | $29,208 | $31,984 | $34,928 | $38,149 | $41,649 | $45,252 | $49,460 |
Long-term Assets | |||||||||||||
Long-term Assets | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 |
Accumulated Depreciation | $0 | $333 | $666 | $999 | $1,332 | $1,665 | $1,998 | $2,331 | $2,664 | $2,997 | $3,330 | $3,663 | $4,000 |
Total Long-term Assets | $40,000 | $39,667 | $39,334 | $39,001 | $38,668 | $38,335 | $38,002 | $37,669 | $37,336 | $37,003 | $36,670 | $36,337 | $36,000 |
Total Assets | $50,000 | $60,328 | $60,320 | $61,763 | $63,446 | $65,365 | $67,210 | $69,653 | $72,264 | $75,152 | $78,319 | $81,589 | $85,460 |
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 | $10,818 | $9,820 | $10,046 | $10,280 | $10,859 | $10,768 | $11,125 | $11,388 | $11,660 | $12,142 | $12,125 | $12,420 |
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 | $10,818 | $9,820 | $10,046 | $10,280 | $10,859 | $10,768 | $11,125 | $11,388 | $11,660 | $12,142 | $12,125 | $12,420 |
Long-term Liabilities | $36,600 | $36,164 | $35,729 | $35,293 | $34,857 | $34,421 | $33,986 | $33,550 | $33,114 | $32,679 | $32,243 | $31,807 | $31,370 |
Total Liabilities | $36,600 | $46,982 | $45,548 | $45,339 | $45,137 | $45,280 | $44,754 | $44,675 | $44,503 | $44,338 | $44,385 | $43,932 | $43,791 |
Paid-in Capital | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 |
Retained Earnings | ($36,600) | ($36,600) | ($36,600) | ($36,600) | ($36,600) | ($36,600) | ($36,600) | ($36,600) | ($36,600) | ($36,600) | ($36,600) | ($36,600) | ($36,600) |
Earnings | $0 | ($54) | $1,372 | $3,024 | $4,909 | $6,684 | $9,056 | $11,578 | $14,361 | $17,414 | $20,535 | $24,256 | $28,270 |
Total Capital | $13,400 | $13,346 | $14,772 | $16,424 | $18,309 | $20,084 | $22,456 | $24,978 | $27,761 | $30,814 | $33,935 | $37,656 | $41,670 |
Total Liabilities and Capital | $50,000 | $60,328 | $60,320 | $61,763 | $63,446 | $65,365 | $67,210 | $69,653 | $72,264 | $75,152 | $78,319 | $81,589 | $85,460 |
Net Worth | $13,400 | $13,346 | $14,772 | $16,424 | $18,309 | $20,084 | $22,456 | $24,978 | $27,761 | $30,814 | $33,935 | $37,656 | $41,670 |