Circuit Fitness Importing
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 | |||||||||||||
Distributors | 0% | $0 | $0 | $0 | $0 | $9,500 | $14,500 | $18,500 | $21,000 | $23,500 | $28,000 | $30,050 | $31,050 |
Health Clubs | 0% | $0 | $0 | $0 | $0 | $7,030 | $10,730 | $13,690 | $15,540 | $17,390 | $20,720 | $22,237 | $22,977 |
Vertical Markets | 0% | $0 | $0 | $0 | $0 | $6,840 | $10,440 | $13,320 | $15,120 | $16,920 | $20,160 | $21,636 | $22,356 |
Total Sales | $0 | $0 | $0 | $0 | $23,370 | $35,670 | $45,510 | $51,660 | $57,810 | $68,880 | $73,923 | $76,383 | |
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 | |
Distributors | $0 | $0 | $0 | $0 | $6,080 | $9,280 | $11,840 | $13,440 | $15,040 | $17,920 | $19,232 | $19,872 | |
Health Clubs | $0 | $0 | $0 | $0 | $4,780 | $7,296 | $9,309 | $10,567 | $11,825 | $14,090 | $15,121 | $15,624 | |
Vertical Markets | $0 | $0 | $0 | $0 | $4,651 | $7,099 | $9,058 | $10,282 | $11,506 | $13,709 | $14,712 | $15,202 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $15,512 | $23,676 | $30,207 | $34,289 | $38,371 | $45,718 | $49,066 | $50,698 |
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 | ||
Max | 0% | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Support | 0% | $0 | $0 | $0 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 |
Support | 0% | $0 | $0 | $0 | $0 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 |
Repair | 0% | $0 | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Sales | 0% | $0 | $0 | $0 | $0 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Sales | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Total People | 0 | 0 | 1 | 2 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | |
Total Payroll | $0 | $0 | $2,000 | $3,800 | $10,100 | $10,100 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 |
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 | $0 | $23,370 | $35,670 | $45,510 | $51,660 | $57,810 | $68,880 | $73,923 | $76,383 | |
Direct Cost of Sales | $0 | $0 | $0 | $0 | $15,512 | $23,676 | $30,207 | $34,289 | $38,371 | $45,718 | $49,066 | $50,698 | |
Other Costs of Goods | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $0 | $0 | $15,512 | $23,676 | $30,207 | $34,289 | $38,371 | $45,718 | $49,066 | $50,698 | |
Gross Margin | $0 | $0 | $0 | $0 | $7,858 | $11,994 | $15,303 | $17,371 | $19,439 | $23,162 | $24,857 | $25,685 | |
Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 33.63% | 33.63% | 33.63% | 33.63% | 33.63% | 33.63% | 33.63% | 33.63% | |
Expenses | |||||||||||||
Payroll | $0 | $0 | $2,000 | $3,800 | $10,100 | $10,100 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | |
Sales and Marketing and Other Expenses | $0 | $0 | $0 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | |
Depreciation | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Rent | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Utilities | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Insurance | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Payroll Taxes | 15% | $0 | $0 | $300 | $570 | $1,515 | $1,515 | $1,890 | $1,890 | $1,890 | $1,890 | $1,890 | $1,890 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $1,650 | $1,650 | $3,950 | $9,520 | $16,765 | $16,765 | $19,640 | $19,640 | $19,640 | $19,640 | $19,640 | $19,640 | |
Profit Before Interest and Taxes | ($1,650) | ($1,650) | ($3,950) | ($9,520) | ($8,907) | ($4,771) | ($4,337) | ($2,269) | ($201) | $3,522 | $5,217 | $6,045 | |
EBITDA | ($1,400) | ($1,400) | ($3,700) | ($9,270) | ($8,657) | ($4,521) | ($4,087) | ($2,019) | $49 | $3,772 | $5,467 | $6,295 | |
Interest Expense | $699 | $690 | $681 | $671 | $662 | $652 | $643 | $633 | $623 | $613 | $603 | $593 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($2,349) | ($2,340) | ($4,631) | ($10,191) | ($9,568) | ($5,423) | ($4,979) | ($2,902) | ($824) | $2,908 | $4,614 | $5,451 | |
Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | -40.94% | -15.20% | -10.94% | -5.62% | -1.43% | 4.22% | 6.24% | 7.14% |
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 | $0 | $11,685 | $17,835 | $22,755 | $25,830 | $28,905 | $34,440 | $36,962 | $38,192 | |
Cash from Receivables | $0 | $0 | $0 | $0 | $0 | $390 | $11,890 | $17,999 | $22,858 | $25,933 | $29,090 | $34,524 | |
Subtotal Cash from Operations | $0 | $0 | $0 | $0 | $11,685 | $18,225 | $34,645 | $43,829 | $51,763 | $60,373 | $66,051 | $72,716 | |
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 | $0 | $11,685 | $18,225 | $34,645 | $43,829 | $51,763 | $60,373 | $66,051 | $72,716 | |
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 | $3,800 | $10,100 | $10,100 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | |
Bill Payments | $70 | $2,099 | $2,100 | $2,506 | $6,948 | $30,494 | $35,028 | $41,000 | $43,889 | $48,124 | $56,840 | $58,158 | |
Subtotal Spent on Operations | $70 | $2,099 | $4,100 | $6,306 | $17,048 | $40,594 | $47,628 | $53,600 | $56,489 | $60,724 | $69,440 | $70,758 | |
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 | $1,098 | $1,107 | $1,116 | $1,125 | $1,135 | $1,144 | $1,154 | $1,163 | $1,173 | $1,183 | $1,193 | $1,203 | |
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 | $1,168 | $3,206 | $5,216 | $7,431 | $18,183 | $41,738 | $48,781 | $54,763 | $57,662 | $61,907 | $70,633 | $71,961 | |
Net Cash Flow | ($1,168) | ($3,206) | ($5,216) | ($7,431) | ($6,498) | ($23,513) | ($14,136) | ($10,934) | ($5,899) | ($1,534) | ($4,582) | $755 | |
Cash Balance | $165,932 | $162,727 | $157,511 | $150,080 | $143,582 | $120,069 | $105,932 | $94,998 | $89,099 | $87,565 | $82,983 | $83,738 |
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 | $167,100 | $165,932 | $162,727 | $157,511 | $150,080 | $143,582 | $120,069 | $105,932 | $94,998 | $89,099 | $87,565 | $82,983 | $83,738 |
Accounts Receivable | $0 | $0 | $0 | $0 | $0 | $11,685 | $29,131 | $39,996 | $47,827 | $53,874 | $62,382 | $70,254 | $73,921 |
Inventory | $0 | $0 | $0 | $0 | $0 | $7,756 | $11,838 | $15,103 | $17,144 | $19,185 | $22,859 | $24,533 | $25,349 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $167,100 | $165,932 | $162,727 | $157,511 | $150,080 | $163,023 | $161,037 | $161,031 | $159,969 | $162,158 | $172,805 | $177,769 | $183,008 |
Long-term Assets | |||||||||||||
Long-term Assets | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 |
Accumulated Depreciation | $0 | $250 | $500 | $750 | $1,000 | $1,250 | $1,500 | $1,750 | $2,000 | $2,250 | $2,500 | $2,750 | $3,000 |
Total Long-term Assets | $15,000 | $14,750 | $14,500 | $14,250 | $14,000 | $13,750 | $13,500 | $13,250 | $13,000 | $12,750 | $12,500 | $12,250 | $12,000 |
Total Assets | $182,100 | $180,682 | $177,227 | $171,761 | $164,080 | $176,773 | $174,537 | $174,281 | $172,969 | $174,908 | $185,305 | $190,019 | $195,008 |
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,029 | $2,020 | $2,301 | $5,937 | $29,333 | $33,664 | $39,542 | $42,294 | $46,231 | $54,902 | $56,195 | $56,935 |
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,029 | $2,020 | $2,301 | $5,937 | $29,333 | $33,664 | $39,542 | $42,294 | $46,231 | $54,902 | $56,195 | $56,935 |
Long-term Liabilities | $85,000 | $83,902 | $82,796 | $81,679 | $80,554 | $79,419 | $78,275 | $77,122 | $75,958 | $74,785 | $73,602 | $72,410 | $71,207 |
Total Liabilities | $85,000 | $85,932 | $84,816 | $83,981 | $86,491 | $108,752 | $111,939 | $116,663 | $118,253 | $121,016 | $128,505 | $128,605 | $128,142 |
Paid-in Capital | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 |
Retained Earnings | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) |
Earnings | $0 | ($2,349) | ($4,689) | ($9,320) | ($19,511) | ($29,080) | ($34,502) | ($39,482) | ($42,384) | ($43,208) | ($40,299) | ($35,686) | ($30,234) |
Total Capital | $97,100 | $94,751 | $92,411 | $87,780 | $77,589 | $68,020 | $62,598 | $57,618 | $54,716 | $53,892 | $56,801 | $61,414 | $66,866 |
Total Liabilities and Capital | $182,100 | $180,682 | $177,227 | $171,761 | $164,080 | $176,773 | $174,537 | $174,281 | $172,969 | $174,908 | $185,305 | $190,019 | $195,008 |
Net Worth | $97,100 | $94,751 | $92,411 | $87,780 | $77,589 | $68,020 | $62,598 | $57,618 | $54,716 | $53,892 | $56,801 | $61,414 | $66,866 |