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 |
By 
