|
|
| Sales Forecast |
| 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
| 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 |
| 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% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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/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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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) |
|