GlobeSpan Meeting Planners, Inc.
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 | |||||||||||||
Meeting Planning | 0% | $3,000 | $7,000 | $8,000 | $7,000 | $7,000 | $11,888 | $11,888 | $12,888 | $11,888 | $11,888 | $11,888 | $11,888 |
Resource One Referrals | 0% | $0 | $0 | $0 | $0 | $0 | $600 | $600 | $600 | $600 | $600 | $600 | $600 |
Total Sales | $3,000 | $7,000 | $8,000 | $7,000 | $7,000 | $12,488 | $12,488 | $13,488 | $12,488 | $12,488 | $12,488 | $12,488 | |
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 | |
Meeting Planning | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Resource One Referrals | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
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 | ||
T. Latkovic | 0% | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 |
K. Feltenberg | 0% | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 |
Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Total Payroll | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,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 | 25.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 | $3,000 | $7,000 | $8,000 | $7,000 | $7,000 | $12,488 | $12,488 | $13,488 | $12,488 | $12,488 | $12,488 | $12,488 | |
Direct Cost of Sales | $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 Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Gross Margin | $3,000 | $7,000 | $8,000 | $7,000 | $7,000 | $12,488 | $12,488 | $13,488 | $12,488 | $12,488 | $12,488 | $12,488 | |
Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
Expenses | |||||||||||||
Payroll | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | |
Sales and Marketing and Other Expenses | $275 | $315 | $315 | $315 | $315 | $365 | $365 | $467 | $467 | $467 | $467 | $467 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales Telephone Cost | $484 | $484 | $484 | $484 | $484 | $484 | $484 | $484 | $484 | $484 | $484 | $484 | |
Service Telephone Cost | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Sales On-line Service | $22 | $22 | $22 | $22 | $22 | $22 | $22 | $22 | $22 | $22 | $22 | $22 | |
Service On-line Service | $22 | $22 | $22 | $22 | $22 | $22 | $22 | $22 | $22 | $22 | $22 | $22 | |
Payroll Taxes | 20% | $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 | $8,953 | $8,993 | $8,993 | $8,993 | $8,993 | $9,043 | $9,043 | $9,145 | $9,145 | $9,145 | $9,145 | $9,145 | |
Profit Before Interest and Taxes | ($5,953) | ($1,993) | ($993) | ($1,993) | ($1,993) | $3,445 | $3,445 | $4,343 | $3,343 | $3,343 | $3,343 | $3,343 | |
EBITDA | ($5,953) | ($1,993) | ($993) | ($1,993) | ($1,993) | $3,445 | $3,445 | $4,343 | $3,343 | $3,343 | $3,343 | $3,343 | |
Interest Expense | $408 | $399 | $390 | $381 | $372 | $363 | $354 | $345 | $337 | $328 | $319 | $310 | |
Taxes Incurred | ($1,590) | ($598) | ($346) | ($594) | ($591) | $770 | $773 | $999 | $752 | $754 | $756 | $758 | |
Net Profit | ($4,771) | ($1,794) | ($1,037) | ($1,781) | ($1,774) | $2,311 | $2,318 | $2,998 | $2,255 | $2,262 | $2,268 | $2,275 | |
Net Profit/Sales | -159.02% | -25.63% | -12.97% | -25.44% | -25.34% | 18.51% | 18.56% | 22.23% | 18.06% | 18.11% | 18.16% | 18.22% |
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 | $3,000 | $7,000 | $8,000 | $7,000 | $7,000 | $12,488 | $12,488 | $13,488 | $12,488 | $12,488 | $12,488 | $12,488 | |
Subtotal Cash from Operations | $3,000 | $7,000 | $8,000 | $7,000 | $7,000 | $12,488 | $12,488 | $13,488 | $12,488 | $12,488 | $12,488 | $12,488 | |
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 | $3,000 | $7,000 | $8,000 | $7,000 | $7,000 | $12,488 | $12,488 | $13,488 | $12,488 | $12,488 | $12,488 | $12,488 | |
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 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | |
Bill Payments | ($229) | ($195) | $802 | $1,029 | $780 | $821 | $2,176 | $2,181 | $2,481 | $2,233 | $2,226 | $2,220 | |
Subtotal Spent on Operations | $7,771 | $7,805 | $8,802 | $9,029 | $8,780 | $8,821 | $10,176 | $10,181 | $10,481 | $10,233 | $10,226 | $10,220 | |
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,069 | $1,069 | $1,069 | $1,069 | $1,069 | $1,069 | $1,069 | $1,069 | $1,069 | $1,069 | $1,069 | $1,069 | |
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 | $8,839 | $8,873 | $9,871 | $10,097 | $9,849 | $9,889 | $11,245 | $11,249 | $11,550 | $11,301 | $11,295 | $11,288 | |
Net Cash Flow | ($5,839) | ($1,873) | ($1,871) | ($3,097) | ($2,849) | $2,599 | $1,243 | $2,239 | $938 | $1,187 | $1,193 | $1,200 | |
Cash Balance | $44,161 | $42,288 | $40,417 | $37,320 | $34,471 | $37,070 | $38,313 | $40,552 | $41,490 | $42,677 | $43,870 | $45,070 |
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 | $50,000 | $44,161 | $42,288 | $40,417 | $37,320 | $34,471 | $37,070 | $38,313 | $40,552 | $41,490 | $42,677 | $43,870 | $45,070 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $50,000 | $44,161 | $42,288 | $40,417 | $37,320 | $34,471 | $37,070 | $38,313 | $40,552 | $41,490 | $42,677 | $43,870 | $45,070 |
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 | $50,000 | $44,161 | $42,288 | $40,417 | $37,320 | $34,471 | $37,070 | $38,313 | $40,552 | $41,490 | $42,677 | $43,870 | $45,070 |
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 | $989 | $1,224 | $976 | $970 | $2,326 | $2,319 | $2,629 | $2,380 | $2,374 | $2,368 | $2,361 |
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 | $0 | $989 | $1,224 | $976 | $970 | $2,326 | $2,319 | $2,629 | $2,380 | $2,374 | $2,368 | $2,361 |
Long-term Liabilities | $50,000 | $48,931 | $47,863 | $46,794 | $45,726 | $44,657 | $43,589 | $42,520 | $41,452 | $40,383 | $39,315 | $38,246 | $37,178 |
Total Liabilities | $50,000 | $48,931 | $48,852 | $48,019 | $46,702 | $45,627 | $45,915 | $44,840 | $44,081 | $42,764 | $41,689 | $40,614 | $39,539 |
Paid-in Capital | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 |
Retained Earnings | ($4,800) | ($4,800) | ($4,800) | ($4,800) | ($4,800) | ($4,800) | ($4,800) | ($4,800) | ($4,800) | ($4,800) | ($4,800) | ($4,800) | ($4,800) |
Earnings | $0 | ($4,771) | ($6,564) | ($7,602) | ($9,382) | ($11,156) | ($8,845) | ($6,527) | ($3,529) | ($1,274) | $988 | $3,256 | $5,531 |
Total Capital | $0 | ($4,771) | ($6,564) | ($7,602) | ($9,382) | ($11,156) | ($8,845) | ($6,527) | ($3,529) | ($1,274) | $988 | $3,256 | $5,531 |
Total Liabilities and Capital | $50,000 | $44,161 | $42,288 | $40,417 | $37,320 | $34,471 | $37,070 | $38,313 | $40,552 | $41,490 | $42,677 | $43,870 | $45,070 |
Net Worth | $0 | ($4,771) | ($6,564) | ($7,602) | ($9,382) | ($11,156) | ($8,845) | ($6,527) | ($3,529) | ($1,274) | $988 | $3,256 | $5,531 |