Godsend Concierge Service
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 | |||||||||||||
Corporations | 0% | $0 | $2,577 | $3,216 | $3,677 | $4,032 | $4,706 | $5,700 | $7,847 | $7,984 | $7,998 | $8,001 | $8,978 |
Individuals | 0% | $0 | $180 | $246 | $295 | $341 | $393 | $482 | $534 | $543 | $549 | $671 | $1,100 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $0 | $2,757 | $3,462 | $3,972 | $4,373 | $5,099 | $6,182 | $8,381 | $8,527 | $8,547 | $8,672 | $10,078 | |
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 | |
Corporations | $0 | $0 | $0 | $0 | $0 | $0 | $1,325 | $1,325 | $1,490 | $1,656 | $1,822 | $1,987 | |
Individuals | $0 | $0 | $0 | $0 | $0 | $0 | $147 | $147 | $165 | $184 | $202 | $221 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $1,472 | $1,472 | $1,655 | $1,840 | $2,024 | $2,208 |
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 | ||
Payroll | 0% | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $3,298 | $3,298 | $4,689 | $4,848 | $4,912 | $6,416 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
Total Payroll | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $3,298 | $3,298 | $4,689 | $4,848 | $4,912 | $6,416 |
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% | 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 | $0 | $2,757 | $3,462 | $3,972 | $4,373 | $5,099 | $6,182 | $8,381 | $8,527 | $8,547 | $8,672 | $10,078 | |
Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $1,472 | $1,472 | $1,655 | $1,840 | $2,024 | $2,208 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $1,472 | $1,472 | $1,655 | $1,840 | $2,024 | $2,208 | |
Gross Margin | $0 | $2,757 | $3,462 | $3,972 | $4,373 | $5,099 | $4,710 | $6,909 | $6,872 | $6,707 | $6,648 | $7,870 | |
Gross Margin % | 0.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 76.19% | 82.44% | 80.59% | 78.47% | 76.66% | 78.09% | |
Expenses | |||||||||||||
Payroll | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $3,298 | $3,298 | $4,689 | $4,848 | $4,912 | $6,416 | |
Sales and Marketing and Other Expenses | $0 | $150 | $150 | $150 | $125 | $375 | $150 | $150 | $150 | $200 | $200 | $200 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $41 | $41 | $41 | $41 | $41 | $41 | $41 | $41 | $41 | $41 | $41 | $41 | |
Additional payroll burdens- 7.5% | $0 | $0 | $0 | $0 | $110 | $110 | $110 | $371 | $371 | $371 | $371 | $481 | |
Comunication Equipment | $150 | $175 | $200 | $200 | $200 | $220 | $220 | $220 | $220 | $220 | $220 | $220 | |
Utilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Insurance | $0 | $0 | $0 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Payroll Taxes | 15% | $300 | $300 | $300 | $300 | $300 | $300 | $495 | $495 | $703 | $727 | $737 | $962 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $2,491 | $2,666 | $2,691 | $2,791 | $2,876 | $3,146 | $4,414 | $4,675 | $6,274 | $6,507 | $6,581 | $8,420 | |
Profit Before Interest and Taxes | ($2,491) | $91 | $771 | $1,181 | $1,497 | $1,953 | $296 | $2,234 | $598 | $200 | $67 | ($550) | |
EBITDA | ($2,491) | $91 | $771 | $1,181 | $1,497 | $1,953 | $296 | $2,234 | $598 | $200 | $67 | ($550) | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | ($747) | $23 | $193 | $295 | $374 | $488 | $74 | $559 | $149 | $50 | $17 | ($138) | |
Net Profit | ($1,744) | $68 | $578 | $886 | $1,123 | $1,465 | $222 | $1,676 | $448 | $150 | $50 | ($413) | |
Net Profit/Sales | 0.00% | 2.48% | 16.70% | 22.30% | 25.67% | 28.73% | 3.59% | 19.99% | 5.26% | 1.75% | 0.58% | -4.10% |
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 | $1,654 | $2,077 | $2,383 | $2,624 | $3,059 | $3,709 | $5,029 | $5,116 | $5,128 | $5,203 | $6,047 | |
Cash from Receivables | $0 | $0 | $37 | $1,112 | $1,392 | $1,594 | $1,759 | $2,054 | $2,502 | $3,354 | $3,411 | $3,420 | |
Subtotal Cash from Operations | $0 | $1,654 | $2,114 | $3,495 | $4,015 | $4,654 | $5,468 | $7,083 | $7,618 | $8,483 | $8,614 | $9,467 | |
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 | $2,000 | $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 | $1,255 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $1,255 | $1,654 | $2,114 | $3,495 | $6,015 | $4,654 | $5,468 | $7,083 | $7,618 | $8,483 | $8,614 | $9,467 | |
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 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $3,298 | $3,298 | $4,689 | $4,848 | $4,912 | $6,416 | |
Bill Payments | ($256) | ($225) | $695 | $891 | $1,092 | $1,263 | $1,669 | $2,687 | $3,407 | $3,395 | $3,554 | $3,722 | |
Subtotal Spent on Operations | $1,744 | $1,775 | $2,695 | $2,891 | $3,092 | $3,263 | $4,967 | $5,985 | $8,096 | $8,243 | $8,466 | $10,138 | |
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 | $1,744 | $1,775 | $2,695 | $2,891 | $3,092 | $3,263 | $4,967 | $5,985 | $8,096 | $8,243 | $8,466 | $10,138 | |
Net Cash Flow | ($489) | ($121) | ($581) | $605 | $2,924 | $1,390 | $502 | $1,098 | ($477) | $239 | $148 | ($671) | |
Cash Balance | $766 | $645 | $64 | $669 | $3,593 | $4,983 | $5,485 | $6,583 | $6,105 | $6,345 | $6,493 | $5,822 |
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 | $1,255 | $766 | $645 | $64 | $669 | $3,593 | $4,983 | $5,485 | $6,583 | $6,105 | $6,345 | $6,493 | $5,822 |
Accounts Receivable | $0 | $0 | $1,103 | $2,451 | $2,927 | $3,285 | $3,730 | $4,444 | $5,743 | $6,651 | $6,716 | $6,774 | $7,384 |
Other Current Assets | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Total Current Assets | $3,755 | $3,266 | $4,248 | $5,015 | $6,096 | $9,378 | $11,214 | $12,429 | $14,825 | $15,257 | $15,561 | $15,766 | $15,706 |
Long-term Assets | |||||||||||||
Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Assets | $3,755 | $3,266 | $4,248 | $5,015 | $6,096 | $9,378 | $11,214 | $12,429 | $14,825 | $15,257 | $15,561 | $15,766 | $15,706 |
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 | $0 | $914 | $1,102 | $1,298 | $1,456 | $1,828 | $2,821 | $3,541 | $3,525 | $3,679 | $3,834 | $4,187 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Subtotal Current Liabilities | $0 | $0 | $914 | $1,102 | $1,298 | $3,456 | $3,828 | $4,821 | $5,541 | $5,525 | $5,679 | $5,834 | $6,187 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $0 | $914 | $1,102 | $1,298 | $3,456 | $3,828 | $4,821 | $5,541 | $5,525 | $5,679 | $5,834 | $6,187 |
Paid-in Capital | $7,500 | $8,755 | $8,755 | $8,755 | $8,755 | $8,755 | $8,755 | $8,755 | $8,755 | $8,755 | $8,755 | $8,755 | $8,755 |
Retained Earnings | ($3,745) | ($3,745) | ($3,745) | ($3,745) | ($3,745) | ($3,745) | ($3,745) | ($3,745) | ($3,745) | ($3,745) | ($3,745) | ($3,745) | ($3,745) |
Earnings | $0 | ($1,744) | ($1,675) | ($1,097) | ($211) | $911 | $2,376 | $2,598 | $4,274 | $4,722 | $4,872 | $4,922 | $4,510 |
Total Capital | $3,755 | $3,266 | $3,335 | $3,913 | $4,799 | $5,921 | $7,386 | $7,608 | $9,284 | $9,732 | $9,882 | $9,932 | $9,520 |
Total Liabilities and Capital | $3,755 | $3,266 | $4,248 | $5,015 | $6,096 | $9,378 | $11,214 | $12,429 | $14,825 | $15,257 | $15,561 | $15,766 | $15,706 |
Net Worth | $3,755 | $3,266 | $3,335 | $3,913 | $4,799 | $5,921 | $7,386 | $7,608 | $9,284 | $9,732 | $9,882 | $9,932 | $9,520 |