The Discount Pharmacy

Start your own business plan »

Pharmacy Business Plan

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