Our biggest savings of the year
ToyLearn
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 | |||||||||||||
Individuals | 0% | $0 | $0 | $0 | $3,432 | $4,454 | $5,645 | $6,754 | $7,656 | $8,776 | $9,987 | $10,887 | $8,989 |
Businesses | 0% | $0 | $0 | $0 | $2,986 | $3,875 | $4,911 | $5,876 | $6,661 | $7,635 | $8,689 | $9,472 | $7,820 |
Total Sales | $0 | $0 | $0 | $6,418 | $8,329 | $10,556 | $12,630 | $14,317 | $16,411 | $18,676 | $20,359 | $16,809 | |
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 | |
Individuals | $0 | $0 | $0 | $1,373 | $1,782 | $2,258 | $2,702 | $3,062 | $3,510 | $3,995 | $4,355 | $3,596 | |
Businesses | $0 | $0 | $0 | $1,194 | $1,550 | $1,964 | $2,350 | $2,664 | $3,054 | $3,475 | $3,789 | $3,128 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $2,567 | $3,332 | $4,222 | $5,052 | $5,727 | $6,564 | $7,470 | $8,143 | $6,724 |
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 | ||
Jen | 0% | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
David | 0% | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Sales | 0% | $0 | $0 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Customer Service | 0% | $0 | $0 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Total People | 2 | 2 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
Total Payroll | $4,000 | $4,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 |
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 | $6,418 | $8,329 | $10,556 | $12,630 | $14,317 | $16,411 | $18,676 | $20,359 | $16,809 | |
Direct Cost of Sales | $0 | $0 | $0 | $2,567 | $3,332 | $4,222 | $5,052 | $5,727 | $6,564 | $7,470 | $8,143 | $6,724 | |
Other Costs of Goods | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $0 | $2,567 | $3,332 | $4,222 | $5,052 | $5,727 | $6,564 | $7,470 | $8,143 | $6,724 | |
Gross Margin | $0 | $0 | $0 | $3,851 | $4,997 | $6,334 | $7,578 | $8,590 | $9,847 | $11,205 | $12,215 | $10,086 | |
Gross Margin % | 0.00% | 0.00% | 0.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | |
Expenses | |||||||||||||
Payroll | $4,000 | $4,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | |
Sales and Marketing and Other Expenses | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
Depreciation | $166 | $166 | $166 | $166 | $166 | $166 | $166 | $166 | $166 | $166 | $166 | $166 | |
Rent | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | |
Utilities | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Insurance | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Payroll Taxes | 15% | $600 | $600 | $1,350 | $1,350 | $1,350 | $1,350 | $1,350 | $1,350 | $1,350 | $1,350 | $1,350 | $1,350 |
Other | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Total Operating Expenses | $6,366 | $6,366 | $12,116 | $12,116 | $12,116 | $12,116 | $12,116 | $12,116 | $12,116 | $12,116 | $12,116 | $12,116 | |
Profit Before Interest and Taxes | ($6,366) | ($6,366) | ($12,116) | ($8,265) | ($7,119) | ($5,782) | ($4,538) | ($3,526) | ($2,269) | ($911) | $99 | ($2,030) | |
EBITDA | ($6,200) | ($6,200) | ($11,950) | ($8,099) | ($6,953) | ($5,616) | ($4,372) | ($3,360) | ($2,103) | ($745) | $265 | ($1,864) | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($6,366) | ($6,366) | ($12,116) | ($8,265) | ($7,119) | ($5,782) | ($4,538) | ($3,526) | ($2,269) | ($911) | $99 | ($2,030) | |
Net Profit/Sales | 0.00% | 0.00% | 0.00% | -128.79% | -85.47% | -54.78% | -35.93% | -24.63% | -13.83% | -4.88% | 0.49% | -12.08% |
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 | $1,604 | $2,082 | $2,639 | $3,157 | $3,579 | $4,103 | $4,669 | $5,090 | $4,202 | |
Cash from Receivables | $0 | $0 | $0 | $0 | $160 | $4,861 | $6,302 | $7,969 | $9,515 | $10,790 | $12,365 | $14,049 | |
Subtotal Cash from Operations | $0 | $0 | $0 | $1,604 | $2,243 | $7,500 | $9,460 | $11,548 | $13,617 | $15,459 | $17,455 | $18,251 | |
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 | $1,604 | $2,243 | $7,500 | $9,460 | $11,548 | $13,617 | $15,459 | $17,455 | $18,251 | |
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 | $4,000 | $4,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | |
Bill Payments | $73 | $2,200 | $2,225 | $3,036 | $5,543 | $6,311 | $7,200 | $8,024 | $8,705 | $9,545 | $10,443 | $11,046 | |
Subtotal Spent on Operations | $4,073 | $6,200 | $11,225 | $12,036 | $14,543 | $15,311 | $16,200 | $17,024 | $17,705 | $18,545 | $19,443 | $20,046 | |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
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 | $4,073 | $6,200 | $11,225 | $12,036 | $14,543 | $15,311 | $16,200 | $17,024 | $17,705 | $18,545 | $19,443 | $20,046 | |
Net Cash Flow | ($4,073) | ($6,200) | ($11,225) | ($10,431) | ($12,300) | ($7,811) | ($6,740) | ($5,476) | ($4,087) | ($3,086) | ($1,988) | ($1,795) | |
Cash Balance | $112,527 | $106,327 | $95,102 | $84,671 | $72,371 | $64,560 | $57,819 | $52,343 | $48,256 | $45,170 | $43,182 | $41,387 |
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 | $116,600 | $112,527 | $106,327 | $95,102 | $84,671 | $72,371 | $64,560 | $57,819 | $52,343 | $48,256 | $45,170 | $43,182 | $41,387 |
Accounts Receivable | $0 | $0 | $0 | $0 | $4,813 | $10,900 | $13,956 | $17,126 | $19,894 | $22,688 | $25,905 | $28,809 | $27,367 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $116,600 | $112,527 | $106,327 | $95,102 | $89,484 | $83,270 | $78,515 | $74,945 | $72,237 | $70,944 | $71,075 | $71,991 | $68,754 |
Long-term Assets | |||||||||||||
Long-term Assets | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
Accumulated Depreciation | $0 | $166 | $332 | $498 | $664 | $830 | $996 | $1,162 | $1,328 | $1,494 | $1,660 | $1,826 | $1,992 |
Total Long-term Assets | $10,000 | $9,834 | $9,668 | $9,502 | $9,336 | $9,170 | $9,004 | $8,838 | $8,672 | $8,506 | $8,340 | $8,174 | $8,008 |
Total Assets | $126,600 | $122,361 | $115,995 | $104,604 | $98,820 | $92,440 | $87,519 | $83,783 | $80,909 | $79,450 | $79,415 | $80,165 | $76,762 |
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,127 | $2,127 | $2,852 | $5,333 | $6,072 | $6,933 | $7,735 | $8,387 | $9,197 | $10,073 | $10,724 | $9,351 |
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,127 | $2,127 | $2,852 | $5,333 | $6,072 | $6,933 | $7,735 | $8,387 | $9,197 | $10,073 | $10,724 | $9,351 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $2,127 | $2,127 | $2,852 | $5,333 | $6,072 | $6,933 | $7,735 | $8,387 | $9,197 | $10,073 | $10,724 | $9,351 |
Paid-in Capital | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 |
Retained Earnings | ($13,400) | ($13,400) | ($13,400) | ($13,400) | ($13,400) | ($13,400) | ($13,400) | ($13,400) | ($13,400) | ($13,400) | ($13,400) | ($13,400) | ($13,400) |
Earnings | $0 | ($6,366) | ($12,732) | ($24,848) | ($33,113) | ($40,232) | ($46,014) | ($50,552) | ($54,078) | ($56,348) | ($57,258) | ($57,159) | ($59,189) |
Total Capital | $126,600 | $120,234 | $113,868 | $101,752 | $93,487 | $86,368 | $80,586 | $76,048 | $72,522 | $70,252 | $69,342 | $69,441 | $67,411 |
Total Liabilities and Capital | $126,600 | $122,361 | $115,995 | $104,604 | $98,820 | $92,440 | $87,519 | $83,783 | $80,909 | $79,450 | $79,415 | $80,165 | $76,762 |
Net Worth | $126,600 | $120,234 | $113,868 | $101,752 | $93,487 | $86,368 | $80,586 | $76,048 | $72,522 | $70,252 | $69,342 | $69,441 | $67,411 |