| 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 | |||||||||||||
| Walk-in customers | 40% | $0 | $8,765 | $10,987 | $12,554 | $16,776 | $18,443 | $20,001 | $21,332 | $22,343 | $25,311 | $26,544 | $26,544 |
| Mail order customers | 40% | $0 | $2,245 | $5,543 | $6,543 | $12,344 | $15,454 | $19,877 | $26,765 | $31,223 | $34,232 | $38,998 | $38,998 |
| Total Sales | $0 | $11,010 | $16,530 | $19,097 | $29,120 | $33,897 | $39,878 | $48,097 | $53,566 | $59,543 | $65,542 | $65,542 | |
| 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 | |
| Walk-in customers | $0 | $3,506 | $4,395 | $5,022 | $6,710 | $7,377 | $8,000 | $8,533 | $8,937 | $10,124 | $10,618 | $10,618 | |
| Mail order customers | $0 | $898 | $2,217 | $2,617 | $4,938 | $6,182 | $7,951 | $10,706 | $12,489 | $13,693 | $15,599 | $15,599 | |
| Subtotal Direct Cost of Sales | $0 | $4,404 | $6,612 | $7,639 | $11,648 | $13,559 | $15,951 | $19,239 | $21,426 | $23,817 | $26,217 | $26,217 | |
| 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 | ||
| CEO (John) | 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 |
| Pharmacist | 0% | $0 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
| Pharmacist technician | 0% | $0 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
| Pharmacist technician | 0% | $0 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
| Pharmacist technician | 0% | $0 | $0 | $0 | $0 | $0 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
| Sales agent | 0% | $0 | $0 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 |
| Sales agent | 0% | $0 | $0 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 |
| Sales agent | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 | $1,920 |
| Counter person/phone rep. | 0% | $0 | $0 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
| Counter person/phone rep. | 0% | $0 | $0 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
| Order fulfillment | 0% | $0 | $0 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
| Total People | 1 | 4 | 9 | 9 | 9 | 10 | 11 | 11 | 11 | 11 | 11 | 11 | |
| Total Payroll | $4,000 | $14,000 | $22,160 | $22,160 | $22,160 | $24,660 | $26,580 | $26,580 | $26,580 | $26,580 | $26,580 | $26,580 | |
| 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% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | $11,010 | $16,530 | $19,097 | $29,120 | $33,897 | $39,878 | $48,097 | $53,566 | $59,543 | $65,542 | $65,542 | |
| Direct Cost of Sales | $0 | $4,404 | $6,612 | $7,639 | $11,648 | $13,559 | $15,951 | $19,239 | $21,426 | $23,817 | $26,217 | $26,217 | |
| Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $0 | $4,404 | $6,612 | $7,639 | $11,648 | $13,559 | $15,951 | $19,239 | $21,426 | $23,817 | $26,217 | $26,217 | |
| Gross Margin | $0 | $6,606 | $9,918 | $11,458 | $17,472 | $20,338 | $23,927 | $28,858 | $32,140 | $35,726 | $39,325 | $39,325 | |
| Gross Margin % | 0.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | |
| Expenses | |||||||||||||
| Payroll | $4,000 | $14,000 | $22,160 | $22,160 | $22,160 | $24,660 | $26,580 | $26,580 | $26,580 | $26,580 | $26,580 | $26,580 | |
| Sales and Marketing and Other Expenses | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | |
| Depreciation | $142 | $142 | $142 | $142 | $142 | $142 | $142 | $142 | $142 | $142 | $142 | $142 | |
| Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Utilities | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
| Insurance | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
| Rent | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
| Payroll Taxes | 15% | $600 | $2,100 | $3,324 | $3,324 | $3,324 | $3,699 | $3,987 | $3,987 | $3,987 | $3,987 | $3,987 | $3,987 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $8,142 | $19,642 | $29,026 | $29,026 | $29,026 | $31,901 | $34,109 | $34,109 | $34,109 | $34,109 | $34,109 | $34,109 | |
| Profit Before Interest and Taxes | ($8,142) | ($13,036) | ($19,108) | ($17,568) | ($11,554) | ($11,563) | ($10,182) | ($5,251) | ($1,969) | $1,617 | $5,216 | $5,216 | |
| EBITDA | ($8,000) | ($12,894) | ($18,966) | ($17,426) | ($11,412) | ($11,421) | ($10,040) | ($5,109) | ($1,827) | $1,759 | $5,358 | $5,358 | |
| Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Net Profit | ($8,142) | ($13,036) | ($19,108) | ($17,568) | ($11,554) | ($11,563) | ($10,182) | ($5,251) | ($1,969) | $1,617 | $5,216 | $5,216 | |
| Net Profit/Sales | 0.00% | -118.40% | -115.60% | -91.99% | -39.68% | -34.11% | -25.53% | -10.92% | -3.68% | 2.72% | 7.96% | 7.96% | |
| 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 | $11,010 | $16,530 | $19,097 | $29,120 | $33,897 | $39,878 | $48,097 | $53,566 | $59,543 | $65,542 | $65,542 | |
| Subtotal Cash from Operations | $0 | $11,010 | $16,530 | $19,097 | $29,120 | $33,897 | $39,878 | $48,097 | $53,566 | $59,543 | $65,542 | $65,542 | |
| 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 | $11,010 | $16,530 | $19,097 | $29,120 | $33,897 | $39,878 | $48,097 | $53,566 | $59,543 | $65,542 | $65,542 | |
| 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 | $4,000 | $14,000 | $22,160 | $22,160 | $22,160 | $24,660 | $26,580 | $26,580 | $26,580 | $26,580 | $26,580 | $26,580 | |
| Bill Payments | $133 | $4,050 | $5,817 | $15,029 | $15,735 | $22,781 | $22,867 | $26,112 | $30,275 | $31,307 | $33,914 | $36,155 | |
| Subtotal Spent on Operations | $4,133 | $18,050 | $27,977 | $37,189 | $37,895 | $47,441 | $49,447 | $52,692 | $56,855 | $57,887 | $60,494 | $62,735 | |
| 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 | $4,133 | $18,050 | $27,977 | $37,189 | $37,895 | $47,441 | $49,447 | $52,692 | $56,855 | $57,887 | $60,494 | $62,735 | |
| Net Cash Flow | ($4,133) | ($7,040) | ($11,447) | ($18,092) | ($8,775) | ($13,544) | ($9,569) | ($4,595) | ($3,289) | $1,656 | $5,048 | $2,807 | |
| Cash Balance | $136,367 | $129,327 | $117,880 | $99,787 | $91,012 | $77,468 | $67,899 | $63,304 | $60,015 | $61,671 | $66,719 | $69,525 | |
| 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 | $140,500 | $136,367 | $129,327 | $117,880 | $99,787 | $91,012 | $77,468 | $67,899 | $63,304 | $60,015 | $61,671 | $66,719 | $69,525 |
| Inventory | $10,000 | $10,000 | $5,596 | $7,273 | $8,403 | $12,813 | $14,915 | $17,546 | $21,163 | $23,569 | $26,199 | $28,838 | $28,838 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $150,500 | $146,367 | $134,923 | $125,153 | $108,190 | $103,825 | $92,382 | $85,445 | $84,466 | $83,584 | $87,870 | $95,557 | $98,364 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 |
| Accumulated Depreciation | $0 | $142 | $284 | $426 | $568 | $710 | $852 | $994 | $1,136 | $1,278 | $1,420 | $1,562 | $1,704 |
| Total Long-term Assets | $8,500 | $8,358 | $8,216 | $8,074 | $7,932 | $7,790 | $7,648 | $7,506 | $7,364 | $7,222 | $7,080 | $6,938 | $6,796 |
| Total Assets | $159,000 | $154,725 | $143,139 | $133,227 | $116,122 | $111,615 | $100,030 | $92,951 | $91,830 | $90,806 | $94,950 | $102,495 | $105,160 |
| 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 | $3,867 | $5,317 | $14,513 | $14,976 | $22,023 | $22,001 | $25,104 | $29,234 | $30,179 | $32,706 | $35,035 | $32,484 |
| 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 | $3,867 | $5,317 | $14,513 | $14,976 | $22,023 | $22,001 | $25,104 | $29,234 | $30,179 | $32,706 | $35,035 | $32,484 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $0 | $3,867 | $5,317 | $14,513 | $14,976 | $22,023 | $22,001 | $25,104 | $29,234 | $30,179 | $32,706 | $35,035 | $32,484 |
| Paid-in Capital | $183,100 | $183,100 | $183,100 | $183,100 | $183,100 | $183,100 | $183,100 | $183,100 | $183,100 | $183,100 | $183,100 | $183,100 | $183,100 |
| Retained Earnings | ($24,100) | ($24,100) | ($24,100) | ($24,100) | ($24,100) | ($24,100) | ($24,100) | ($24,100) | ($24,100) | ($24,100) | ($24,100) | ($24,100) | ($24,100) |
| Earnings | $0 | ($8,142) | ($21,178) | ($40,286) | ($57,854) | ($69,408) | ($80,971) | ($91,153) | ($96,404) | ($98,373) | ($96,756) | ($91,540) | ($86,324) |
| Total Capital | $159,000 | $150,858 | $137,822 | $118,714 | $101,146 | $89,592 | $78,029 | $67,847 | $62,596 | $60,627 | $62,244 | $67,460 | $72,676 |
| Total Liabilities and Capital | $159,000 | $154,725 | $143,139 | $133,227 | $116,122 | $111,615 | $100,030 | $92,951 | $91,830 | $90,806 | $94,950 | $102,495 | $105,160 |
| Net Worth | $159,000 | $150,858 | $137,822 | $118,714 | $101,146 | $89,592 | $78,029 | $67,847 | $62,596 | $60,627 | $62,244 | $67,460 | $72,676 |