Grutzen Watches
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 | |||||||||||||
Sales | 0% | $81,000 | $81,000 | $81,000 | $175,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $81,000 | $81,000 | $81,000 | $175,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | |
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 | |
Sales | $32,000 | $32,000 | $32,000 | $58,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $32,000 | $32,000 | $32,000 | $58,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 |
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 | ||
President | 0% | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 |
Head of American Division | 0% | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 |
Vice President American Division | 0% | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 |
Other | 0% | $8,700 | $8,700 | $8,700 | $8,700 | $8,700 | $8,700 | $8,700 | $8,700 | $8,700 | $8,700 | $8,700 | $8,700 |
Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
Total Payroll | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 |
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 | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | |
Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | $81,000 | $81,000 | $81,000 | $175,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | |
Direct Cost of Sales | $32,000 | $32,000 | $32,000 | $58,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | |
Other | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | |
Total Cost of Sales | $34,750 | $34,750 | $34,750 | $60,750 | $34,750 | $34,750 | $34,750 | $34,750 | $34,750 | $34,750 | $34,750 | $34,750 | |
Gross Margin | $46,250 | $46,250 | $46,250 | $114,250 | $46,250 | $46,250 | $46,250 | $46,250 | $46,250 | $46,250 | $46,250 | $46,250 | |
Gross Margin % | 57.10% | 57.10% | 57.10% | 65.29% | 57.10% | 57.10% | 57.10% | 57.10% | 57.10% | 57.10% | 57.10% | 57.10% | |
Expenses | |||||||||||||
Payroll | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | |
Sales and Marketing and Other Expenses | $8,350 | $8,350 | $8,350 | $8,900 | $8,275 | $8,350 | $8,350 | $8,350 | $8,350 | $8,350 | $8,350 | $8,350 | |
Depreciation | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | |
Leased Equipment | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | |
Utilities | $500 | $500 | $550 | $600 | $575 | $550 | $500 | $500 | $500 | $500 | $550 | $500 | |
Insurance | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Rent | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
Other | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Payroll Taxes | 12% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $45,842 | $45,842 | $45,892 | $46,492 | $45,842 | $45,892 | $45,842 | $45,842 | $45,842 | $45,842 | $45,892 | $45,842 | |
Profit Before Interest and Taxes | $408 | $408 | $358 | $67,758 | $408 | $358 | $408 | $408 | $408 | $408 | $358 | $408 | |
EBITDA | $700 | $700 | $650 | $68,050 | $700 | $650 | $700 | $700 | $700 | $700 | $650 | $700 | |
Interest Expense | $397 | $395 | $392 | $732 | $729 | $727 | $557 | $555 | $552 | $383 | $381 | $378 | |
Taxes Incurred | $3 | $3 | ($9) | $16,757 | ($80) | ($92) | ($37) | ($37) | ($36) | $6 | ($6) | $7 | |
Net Profit | $7 | $10 | ($26) | $50,270 | ($241) | ($276) | ($112) | ($110) | ($108) | $19 | ($17) | $22 | |
Net Profit/Sales | 0.01% | 0.01% | -0.03% | 28.73% | -0.30% | -0.34% | -0.14% | -0.14% | -0.13% | 0.02% | -0.02% | 0.03% |
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 | $40,500 | $40,500 | $40,500 | $87,500 | $40,500 | $40,500 | $40,500 | $40,500 | $40,500 | $40,500 | $40,500 | $40,500 | |
Cash from Receivables | $0 | $1,350 | $40,500 | $40,500 | $42,067 | $85,933 | $40,500 | $40,500 | $40,500 | $40,500 | $40,500 | $40,500 | |
Subtotal Cash from Operations | $40,500 | $41,850 | $81,000 | $128,000 | $82,567 | $126,433 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | |
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 | $41,000 | $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 | $40,500 | $41,850 | $81,000 | $169,000 | $82,567 | $126,433 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | $81,000 | |
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 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | $24,700 | |
Bill Payments | $7,207 | $65,861 | $55,999 | $58,444 | $124,982 | $28,603 | $56,279 | $56,120 | $56,118 | $56,112 | $55,991 | $56,024 | |
Subtotal Spent on Operations | $31,907 | $90,561 | $80,699 | $83,144 | $149,682 | $53,303 | $80,979 | $80,820 | $80,818 | $80,812 | $80,691 | $80,724 | |
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 | $20,000 | $0 | $0 | $20,000 | $0 | $0 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $334 | $334 | $334 | $334 | $333 | $333 | $333 | $333 | $333 | $333 | $333 | $333 | |
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 | $32,241 | $90,895 | $81,033 | $83,478 | $150,015 | $53,636 | $101,312 | $81,153 | $81,151 | $101,145 | $81,024 | $81,057 | |
Net Cash Flow | $8,259 | ($49,045) | ($33) | $85,522 | ($67,448) | $72,797 | ($20,312) | ($153) | ($151) | ($20,145) | ($24) | ($57) | |
Cash Balance | $78,259 | $29,215 | $29,181 | $114,703 | $47,255 | $120,052 | $99,740 | $99,587 | $99,436 | $79,291 | $79,267 | $79,210 |
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 | $70,000 | $78,259 | $29,215 | $29,181 | $114,703 | $47,255 | $120,052 | $99,740 | $99,587 | $99,436 | $79,291 | $79,267 | $79,210 |
Accounts Receivable | $0 | $40,500 | $79,650 | $79,650 | $126,650 | $125,083 | $79,650 | $79,650 | $79,650 | $79,650 | $79,650 | $79,650 | $79,650 |
Inventory | $25,000 | $35,200 | $35,200 | $35,200 | $63,800 | $35,200 | $35,200 | $35,200 | $35,200 | $35,200 | $35,200 | $35,200 | $35,200 |
Other Current Assets | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
Total Current Assets | $100,000 | $158,959 | $149,065 | $149,031 | $310,153 | $212,538 | $239,902 | $219,590 | $219,437 | $219,286 | $199,141 | $199,117 | $199,060 |
Long-term Assets | |||||||||||||
Long-term Assets | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 |
Accumulated Depreciation | $0 | $292 | $584 | $876 | $1,168 | $1,460 | $1,752 | $2,044 | $2,336 | $2,628 | $2,920 | $3,212 | $3,504 |
Total Long-term Assets | $35,000 | $34,708 | $34,416 | $34,124 | $33,832 | $33,540 | $33,248 | $32,956 | $32,664 | $32,372 | $32,080 | $31,788 | $31,496 |
Total Assets | $135,000 | $193,667 | $183,481 | $183,155 | $343,985 | $246,078 | $273,150 | $252,546 | $252,101 | $251,658 | $231,221 | $230,905 | $230,556 |
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 | $5,000 | $63,994 | $54,132 | $54,166 | $124,060 | $26,727 | $54,408 | $54,249 | $54,248 | $54,246 | $54,123 | $54,158 | $54,120 |
Current Borrowing | $30,000 | $30,000 | $30,000 | $30,000 | $71,000 | $71,000 | $71,000 | $51,000 | $51,000 | $51,000 | $31,000 | $31,000 | $31,000 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $35,000 | $93,994 | $84,132 | $84,166 | $195,060 | $97,727 | $125,408 | $105,249 | $105,248 | $105,246 | $85,123 | $85,158 | $85,120 |
Long-term Liabilities | $20,000 | $19,666 | $19,332 | $18,998 | $18,664 | $18,331 | $17,998 | $17,665 | $17,332 | $16,999 | $16,666 | $16,333 | $16,000 |
Total Liabilities | $55,000 | $113,660 | $103,464 | $103,164 | $213,724 | $116,058 | $143,406 | $122,914 | $122,580 | $122,245 | $101,789 | $101,491 | $101,120 |
Paid-in Capital | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 | $171,000 |
Retained Earnings | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) | ($91,000) |
Earnings | $0 | $7 | $17 | ($9) | $50,261 | $50,020 | $49,744 | $49,632 | $49,521 | $49,413 | $49,431 | $49,414 | $49,437 |
Total Capital | $80,000 | $80,007 | $80,017 | $79,991 | $130,261 | $130,020 | $129,744 | $129,632 | $129,521 | $129,413 | $129,431 | $129,414 | $129,437 |
Total Liabilities and Capital | $135,000 | $193,667 | $183,481 | $183,155 | $343,985 | $246,078 | $273,150 | $252,546 | $252,101 | $251,658 | $231,221 | $230,905 | $230,556 |
Net Worth | $80,000 | $80,007 | $80,017 | $79,991 | $130,261 | $130,020 | $129,744 | $129,632 | $129,521 | $129,413 | $129,431 | $129,414 | $129,437 |