PrintingSolutions.com
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 | |||||||||||||
Internet Printing Products | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $41,667 | $43,667 | $42,667 | $41,667 | $40,667 | $39,667 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $0 | $0 | $0 | $0 | $0 | $0 | $41,667 | $43,667 | $42,667 | $41,667 | $40,667 | $39,667 | |
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 | |
Internet Printing Products | $0 | $0 | $0 | $0 | $0 | $0 | $13,333 | $13,333 | $13,333 | $13,333 | $13,333 | $13,333 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $13,333 | $13,333 | $13,333 | $13,333 | $13,333 | $13,333 |
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 | ||
Dalton Grant | 0% | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 |
Webmaster | 0% | $4,348 | $4,348 | $4,348 | $4,348 | $4,348 | $4,348 | $4,348 | $4,348 | $4,348 | $4,348 | $4,348 | $4,348 |
Website developers | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Marketing Coordinator | 0% | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 |
Outsourcing Coordinator | 0% | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 |
Office Assistant | 0% | $1,449 | $1,449 | $1,449 | $1,449 | $1,449 | $1,449 | $1,449 | $1,449 | $1,449 | $1,449 | $1,449 | $1,449 |
Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
Total Payroll | $14,494 | $14,494 | $14,494 | $14,494 | $14,494 | $14,494 | $14,493 | $14,493 | $14,493 | $14,493 | $14,493 | $14,493 |
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 | $0 | $0 | $0 | $41,667 | $43,667 | $42,667 | $41,667 | $40,667 | $39,667 | |
Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $13,333 | $13,333 | $13,333 | $13,333 | $13,333 | $13,333 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | |
Total Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | |
Gross Margin | $0 | $0 | $0 | $0 | $0 | $0 | $26,667 | $28,667 | $27,667 | $26,667 | $25,667 | $24,667 | |
Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 64.00% | 65.65% | 64.84% | 64.00% | 63.11% | 62.18% | |
Expenses | |||||||||||||
Payroll | $14,494 | $14,494 | $14,494 | $14,494 | $14,494 | $14,494 | $14,493 | $14,493 | $14,493 | $14,493 | $14,493 | $14,493 | |
Marketing/Promotion | $35,833 | $35,833 | $35,833 | $35,833 | $35,833 | $35,833 | $35,833 | $35,833 | $35,833 | $35,833 | $35,833 | $35,833 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Software/IS expense | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | |
Contract Labor | $0 | $0 | $0 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | $2,899 | |
Legal and Professiona expense | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | |
Bank charges | $50 | $50 | $50 | $50 | $50 | $50 | $333 | $333 | $333 | $333 | $333 | $333 | |
Rent | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
Payroll Taxes | 15% | $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 | $62,044 | $62,044 | $62,044 | $64,943 | $64,943 | $64,943 | $65,225 | $65,225 | $65,225 | $65,225 | $65,225 | $65,225 | |
Profit Before Interest and Taxes | ($62,044) | ($62,044) | ($62,044) | ($64,943) | ($64,943) | ($64,943) | ($38,558) | ($36,558) | ($37,558) | ($38,558) | ($39,558) | ($40,558) | |
EBITDA | ($62,044) | ($62,044) | ($62,044) | ($64,943) | ($64,943) | ($64,943) | ($38,558) | ($36,558) | ($37,558) | ($38,558) | ($39,558) | ($40,558) | |
Interest Expense | $7,770 | $7,623 | $7,476 | $7,329 | $7,182 | $7,035 | $6,888 | $6,741 | $6,594 | $6,447 | $6,300 | $6,153 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($69,814) | ($69,667) | ($69,520) | ($72,272) | ($72,125) | ($71,978) | ($45,446) | ($43,299) | ($44,152) | ($45,005) | ($45,858) | ($46,711) | |
Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | -109.07% | -99.16% | -103.48% | -108.01% | -112.77% | -117.76% |
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 | $0 | $0 | $0 | $10,417 | $10,917 | $10,667 | $10,417 | $10,167 | $9,917 | |
Cash from Receivables | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,042 | $31,300 | $32,725 | $31,975 | $31,225 | |
Subtotal Cash from Operations | $0 | $0 | $0 | $0 | $0 | $0 | $10,417 | $11,958 | $41,967 | $43,142 | $42,142 | $41,142 | |
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 | $0 | $0 | $0 | $10,417 | $11,958 | $41,967 | $43,142 | $42,142 | $41,142 | |
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 | $14,494 | $14,494 | $14,494 | $14,494 | $14,494 | $14,494 | $14,493 | $14,493 | $14,493 | $14,493 | $14,493 | $14,493 | |
Bill Payments | $1,844 | $55,315 | $55,168 | $55,117 | $57,773 | $57,626 | $58,477 | $86,793 | $72,468 | $72,321 | $72,174 | $72,027 | |
Subtotal Spent on Operations | $16,338 | $69,809 | $69,662 | $69,611 | $72,267 | $72,120 | $72,970 | $101,286 | $86,961 | $86,814 | $86,667 | $86,520 | |
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 | $13,888 | $13,888 | $13,888 | $13,888 | $13,888 | $13,888 | $13,888 | $13,888 | $13,888 | $13,888 | $13,888 | $13,888 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | |
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 | $33,976 | $87,447 | $87,300 | $87,249 | $89,905 | $89,758 | $90,608 | $118,924 | $104,599 | $104,452 | $104,305 | $104,158 | |
Net Cash Flow | ($33,976) | ($87,447) | ($87,300) | ($87,249) | ($89,905) | ($89,758) | ($80,191) | ($106,965) | ($62,632) | ($61,310) | ($62,163) | ($63,016) | |
Cash Balance | $916,024 | $828,577 | $741,277 | $654,028 | $564,123 | $474,365 | $394,174 | $287,209 | $224,576 | $163,266 | $101,103 | $38,086 |
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 | $950,000 | $916,024 | $828,577 | $741,277 | $654,028 | $564,123 | $474,365 | $394,174 | $287,209 | $224,576 | $163,266 | $101,103 | $38,086 |
Accounts Receivable | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $31,250 | $62,958 | $63,658 | $62,183 | $60,708 | $59,233 |
Inventory | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $14,667 | $14,667 | $14,667 | $14,667 | $14,667 | $14,667 |
Other Current Assets | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 |
Total Current Assets | $1,150,000 | $1,116,024 | $1,028,577 | $941,277 | $854,028 | $764,123 | $674,365 | $640,091 | $564,834 | $502,901 | $440,116 | $376,478 | $311,986 |
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 | $1,150,000 | $1,116,024 | $1,028,577 | $941,277 | $854,028 | $764,123 | $674,365 | $640,091 | $564,834 | $502,901 | $440,116 | $376,478 | $311,986 |
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 | $53,476 | $53,334 | $53,192 | $55,852 | $55,710 | $55,568 | $84,377 | $70,057 | $69,915 | $69,773 | $69,631 | $69,489 |
Current Borrowing | $500,000 | $486,112 | $472,224 | $458,336 | $444,448 | $430,560 | $416,672 | $402,784 | $388,896 | $375,008 | $361,120 | $347,232 | $333,344 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $500,000 | $539,588 | $525,558 | $511,528 | $500,300 | $486,270 | $472,240 | $487,161 | $458,953 | $444,923 | $430,893 | $416,863 | $402,833 |
Long-term Liabilities | $450,000 | $446,250 | $442,500 | $438,750 | $435,000 | $431,250 | $427,500 | $423,750 | $420,000 | $416,250 | $412,500 | $408,750 | $405,000 |
Total Liabilities | $950,000 | $985,838 | $968,058 | $950,278 | $935,300 | $917,520 | $899,740 | $910,911 | $878,953 | $861,173 | $843,393 | $825,613 | $807,833 |
Paid-in Capital | $1,080,000 | $1,080,000 | $1,080,000 | $1,080,000 | $1,080,000 | $1,080,000 | $1,080,000 | $1,080,000 | $1,080,000 | $1,080,000 | $1,080,000 | $1,080,000 | $1,080,000 |
Retained Earnings | ($880,000) | ($880,000) | ($880,000) | ($880,000) | ($880,000) | ($880,000) | ($880,000) | ($880,000) | ($880,000) | ($880,000) | ($880,000) | ($880,000) | ($880,000) |
Earnings | $0 | ($69,814) | ($139,480) | ($209,000) | ($281,272) | ($353,397) | ($425,374) | ($470,821) | ($514,120) | ($558,272) | ($603,277) | ($649,136) | ($695,847) |
Total Capital | $200,000 | $130,186 | $60,520 | ($9,000) | ($81,272) | ($153,397) | ($225,374) | ($270,821) | ($314,120) | ($358,272) | ($403,277) | ($449,136) | ($495,847) |
Total Liabilities and Capital | $1,150,000 | $1,116,024 | $1,028,577 | $941,277 | $854,028 | $764,123 | $674,365 | $640,091 | $564,834 | $502,901 | $440,116 | $376,478 | $311,986 |
Net Worth | $200,000 | $130,186 | $60,520 | ($9,000) | ($81,272) | ($153,397) | ($225,374) | ($270,821) | ($314,120) | ($358,272) | ($403,277) | ($449,136) | ($495,847) |