Bizcomm, Inc

Start your own business plan »

Online Print Shop Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Unit Sales
Slida-Cards® units of 1,000 cards 0% 135 135 135 135 180 185 185 185 190 190 190 190
Large Discounters 0% 0 0 0 90 90 90 90 90 90 90 90 90
Commercial Printing 0% 1 1 1 1 1 1 1 1 1 1 1 1
Other 0% 0 0 0 0 0 0 0 0 0 0 0 0
Total Unit Sales 136 136 136 226 271 276 276 276 281 281 281 281
Unit Prices Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Slida-Cards® units of 1,000 cards $199.00 $199.00 $199.00 $199.00 $199.00 $199.00 $199.00 $199.00 $199.00 $199.00 $199.00 $199.00
Large Discounters $0.00 $0.00 $0.00 $82.50 $82.50 $82.50 $82.50 $82.50 $82.50 $82.50 $82.50 $82.50
Commercial Printing $27,000.00 $27,000.00 $27,000.00 $27,000.00 $27,000.00 $27,000.00 $27,000.00 $27,000.00 $27,000.00 $27,000.00 $27,000.00 $27,000.00
Other $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Sales
Slida-Cards® units of 1,000 cards $26,865 $26,865 $26,865 $26,865 $35,820 $36,815 $36,815 $36,815 $37,810 $37,810 $37,810 $37,810
Large Discounters $0 $0 $0 $7,425 $7,425 $7,425 $7,425 $7,425 $7,425 $7,425 $7,425 $7,425
Commercial Printing $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $53,865 $53,865 $53,865 $61,290 $70,245 $71,240 $71,240 $71,240 $72,235 $72,235 $72,235 $72,235
Direct Unit Costs Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Slida-Cards® units of 1,000 cards 0.00% $19.50 $19.50 $19.50 $19.50 $19.50 $19.50 $19.50 $19.50 $19.50 $19.50 $19.50 $19.50
Large Discounters 0.00% $0.00 $0.00 $0.00 $21.00 $21.00 $21.00 $21.00 $21.00 $21.00 $21.00 $21.00 $21.00
Commercial Printing 0.00% $12,825.00 $12,825.00 $12,825.00 $12,825.00 $12,825.00 $12,825.00 $12,825.00 $12,825.00 $12,825.00 $12,825.00 $12,825.00 $12,825.00
Other 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Direct Cost of Sales
Slida-Cards® units of 1,000 cards $2,633 $2,633 $2,633 $2,633 $3,510 $3,608 $3,608 $3,608 $3,705 $3,705 $3,705 $3,705
Large Discounters $0 $0 $0 $1,890 $1,890 $1,890 $1,890 $1,890 $1,890 $1,890 $1,890 $1,890
Commercial Printing $12,825 $12,825 $12,825 $12,825 $12,825 $12,825 $12,825 $12,825 $12,825 $12,825 $12,825 $12,825
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $15,458 $15,458 $15,458 $17,348 $18,225 $18,323 $18,323 $18,323 $18,420 $18,420 $18,420 $18,420
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Production Personnel
Production Manager -Frank $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160
Assistant $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
Subtotal $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160
Sales and Marketing Personnel
Telemarketer - Sadie $569 $569 $569 $569 $569 $569 $569 $569 $569 $569 $569 $569
Telemarketer- Jennie $693 $693 $693 $693 $693 $693 $693 $693 $693 $693 $693 $693
Telemarketer- Jack $1,365 $1,365 $1,365 $1,365 $1,365 $1,365 $1,365 $1,365 $1,365 $1,365 $1,365 $1,365
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $2,627 $2,627 $2,627 $2,627 $2,627 $2,627 $2,627 $2,627 $2,627 $2,627 $2,627 $2,627
General and Administrative Personnel
General Manager - Francis Pullman $5,416 $5,416 $5,416 $5,416 $5,416 $5,416 $5,416 $5,416 $5,416 $5,416 $5,416 $5,416
Art Designer - Vie $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Secretary - Jonathon $2,253 $2,253 $2,253 $2,253 $2,253 $2,253 $2,253 $2,253 $2,253 $2,253 $2,253 $2,253
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $10,169 $10,169 $10,169 $10,169 $10,169 $10,169 $10,169 $10,169 $10,169 $10,169 $10,169 $10,169
Other Personnel
Name or title $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
Subtotal $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 7 7 7 7 7 7 7 7 7 7 7 7
Total Payroll $16,956 $16,956 $16,956 $16,956 $16,956 $16,956 $16,956 $16,956 $16,956 $16,956 $16,956 $16,956
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 45.00% 45.00% 45.00% 45.00% 45.00% 45.00% 45.00% 45.00% 45.00% 45.00% 45.00% 45.00%
Long-term Interest Rate 9.30% 9.30% 9.30% 9.30% 9.30% 9.30% 9.30% 9.30% 9.30% 9.30% 9.30% 9.30%
Tax Rate 30.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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $53,865 $53,865 $53,865 $61,290 $70,245 $71,240 $71,240 $71,240 $72,235 $72,235 $72,235 $72,235
Direct Cost of Sales $15,458 $15,458 $15,458 $17,348 $18,225 $18,323 $18,323 $18,323 $18,420 $18,420 $18,420 $18,420
Production Payroll $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160 $4,160
Industrial rags $22 $22 $22 $22 $22 $22 $22 $22 $22 $22 $22 $22
Total Cost of Sales $19,640 $19,640 $19,640 $21,530 $22,407 $22,505 $22,505 $22,505 $22,602 $22,602 $22,602 $22,602
Gross Margin $34,226 $34,226 $34,226 $39,761 $47,838 $48,736 $48,736 $48,736 $49,633 $49,633 $49,633 $49,633
Gross Margin % 63.54% 63.54% 63.54% 64.87% 68.10% 68.41% 68.41% 68.41% 68.71% 68.71% 68.71% 68.71%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $2,627 $2,627 $2,627 $2,627 $2,627 $2,627 $2,627 $2,627 $2,627 $2,627 $2,627 $2,627
Travel $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Miscellaneous $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Advertising/Promotion $0 $5,000 $5,000 $0 $0 $0 $5,000 $5,000 $5,000 $0 $0 $0
Telemarketing commissions $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Internet Services: $198 $198 $198 $198 $198 $198 $198 $198 $198 $198 $198 $198
Total Sales and Marketing Expenses $3,825 $8,825 $8,825 $3,825 $3,825 $3,825 $8,825 $8,825 $8,825 $3,825 $3,825 $3,825
Sales and Marketing % 7.10% 16.38% 16.38% 6.24% 5.44% 5.37% 12.39% 12.39% 12.22% 5.29% 5.29% 5.29%
General and Administrative Expenses
General and Administrative Payroll $10,169 $10,169 $10,169 $10,169 $10,169 $10,169 $10,169 $10,169 $10,169 $10,169 $10,169 $10,169
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $3,466 $3,466 $3,466 $3,466 $3,466 $3,466 $3,466 $3,466 $3,466 $3,466 $3,466 $3,466
Leased Vehicles: $985 $985 $985 $985 $985 $985 $985 $985 $985 $985 $985 $985
Utilities $411 $411 $411 $411 $411 $411 $411 $411 $411 $411 $411 $411
Insurance $497 $497 $497 $497 $497 $497 $497 $497 $497 $497 $497 $497
Medical and Dental: $2,154 $2,154 $2,154 $2,154 $2,154 $2,154 $2,154 $2,154 $2,154 $2,154 $2,154 $2,154
Telephone $970 $970 $970 $970 $970 $970 $970 $970 $970 $970 $970 $970
Retirement Acct (P. Vitale): $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Payroll Services: $168 $168 $168 $168 $168 $168 $168 $168 $168 $168 $168 $168
Postage $950 $950 $950 $950 $950 $950 $950 $950 $950 $950 $950 $950
Rent $3,943 $3,943 $3,943 $3,943 $3,943 $3,943 $3,943 $3,943 $2,500 $2,500 $2,500 $2,500
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other General and Administrative Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $24,013 $24,013 $24,013 $24,013 $24,013 $24,013 $24,013 $24,013 $22,570 $22,570 $22,570 $22,570
General and Administrative % 44.58% 44.58% 44.58% 39.18% 34.18% 33.71% 33.71% 33.71% 31.25% 31.25% 31.25% 31.25%
Other Expenses:
Other Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Contract/Consultants $5,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Other Expenses $5,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other % 9.28% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Total Operating Expenses $32,838 $32,838 $32,838 $27,838 $27,838 $27,838 $32,838 $32,838 $31,395 $26,395 $26,395 $26,395
Profit Before Interest and Taxes $1,388 $1,388 $1,388 $11,923 $20,001 $20,898 $15,898 $15,898 $18,239 $23,239 $23,239 $23,239
EBITDA $4,854 $4,854 $4,854 $15,389 $23,467 $24,364 $19,364 $19,364 $21,705 $26,705 $26,705 $26,705
Interest Expense $2,075 $3,796 $3,763 $3,731 $3,699 $3,666 $3,259 $3,226 $2,818 $2,786 $2,134 $1,736
Taxes Incurred ($206) ($602) ($594) $2,048 $4,075 $4,308 $3,160 $3,168 $3,855 $5,113 $5,276 $5,376
Net Profit ($481) ($1,806) ($1,782) $6,144 $12,226 $12,924 $9,480 $9,504 $11,565 $15,340 $15,828 $16,127
Net Profit/Sales -0.89% -3.35% -3.31% 10.02% 17.41% 18.14% 13.31% 13.34% 16.01% 21.24% 21.91% 22.33%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cash from Receivables $29,361 $31,156 $53,865 $53,865 $54,113 $61,589 $70,278 $71,240 $71,240 $71,273 $72,235 $72,235
Subtotal Cash from Operations $29,361 $31,156 $53,865 $53,865 $54,113 $61,589 $70,278 $71,240 $71,240 $71,273 $72,235 $72,235
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 $46,752 $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 $76,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $105,361 $77,908 $53,865 $53,865 $54,113 $61,589 $70,278 $71,240 $71,240 $71,273 $72,235 $72,235
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $16,956 $16,956 $16,956 $16,956 $16,956 $16,956 $16,956 $16,956 $16,956 $16,956 $16,956 $16,956
Bill Payments $92,571 $18,510 $19,790 $19,687 $17,528 $22,470 $38,113 $41,338 $41,282 $40,226 $36,457 $35,975
Subtotal Spent on Operations $109,527 $35,466 $36,746 $36,643 $34,484 $39,426 $55,069 $58,294 $58,238 $57,182 $53,413 $52,931
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 $10,000 $0 $10,000 $0 $16,752 $10,000
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $4,158 $4,165 $4,172 $4,179 $4,186 $4,193 $4,200 $4,207 $4,214 $4,221 $2,978 $2,985
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 $113,685 $39,631 $40,918 $40,822 $38,670 $43,619 $69,269 $62,501 $72,452 $61,403 $73,143 $65,916
Net Cash Flow ($8,324) $38,277 $12,947 $13,043 $15,442 $17,970 $1,010 $8,739 ($1,212) $9,870 ($908) $6,319
Cash Balance $7,863 $46,140 $59,086 $72,129 $87,571 $105,541 $106,550 $115,290 $114,078 $123,948 $123,040 $129,359
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $16,187 $7,863 $46,140 $59,086 $72,129 $87,571 $105,541 $106,550 $115,290 $114,078 $123,948 $123,040 $129,359
Accounts Receivable $58,721 $83,226 $105,935 $105,935 $113,360 $129,492 $139,144 $140,105 $140,105 $141,100 $142,062 $142,062 $142,062
Inventory $99,430 $83,973 $68,515 $53,058 $35,710 $20,048 $20,155 $20,155 $20,155 $20,262 $20,262 $20,262 $20,262
Other Current Assets $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Total Current Assets $176,338 $177,061 $222,589 $220,078 $223,198 $239,110 $266,839 $268,810 $277,550 $277,440 $288,272 $287,364 $293,684
Long-term Assets
Long-term Assets $226,967 $226,967 $226,967 $226,967 $226,967 $226,967 $226,967 $226,967 $226,967 $226,967 $226,967 $226,967 $226,967
Accumulated Depreciation $43,015 $46,481 $49,947 $53,413 $56,879 $60,345 $63,811 $67,277 $70,743 $74,209 $77,675 $81,141 $84,607
Total Long-term Assets $183,952 $180,486 $177,020 $173,554 $170,088 $166,622 $163,156 $159,690 $156,224 $152,758 $149,292 $145,826 $142,360
Total Assets $360,290 $357,547 $399,609 $393,632 $393,286 $405,732 $429,995 $428,500 $433,774 $430,198 $437,564 $433,190 $436,044
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $91,955 $17,851 $19,132 $19,108 $16,797 $21,203 $36,735 $39,960 $39,937 $39,010 $35,258 $34,785 $34,497
Current Borrowing $0 $0 $46,752 $46,752 $46,752 $46,752 $46,752 $36,752 $36,752 $26,752 $26,752 $10,000 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $91,955 $17,851 $65,884 $65,860 $63,549 $67,955 $83,487 $76,712 $76,689 $65,762 $62,010 $44,785 $34,497
Long-term Liabilities $271,874 $267,716 $263,551 $259,379 $255,200 $251,014 $246,821 $242,621 $238,414 $234,200 $229,979 $227,001 $224,016
Total Liabilities $363,829 $285,567 $329,435 $325,239 $318,749 $318,969 $330,308 $319,333 $315,103 $299,962 $291,989 $271,786 $258,513
Paid-in Capital $46,912 $122,912 $122,912 $122,912 $122,912 $122,912 $122,912 $122,912 $122,912 $122,912 $122,912 $122,912 $122,912
Retained Earnings $20,631 ($50,451) ($50,451) ($50,451) ($50,451) ($50,451) ($50,451) ($50,451) ($50,451) ($50,451) ($50,451) ($50,451) ($50,451)
Earnings ($71,082) ($481) ($2,287) ($4,068) $2,076 $14,302 $27,226 $36,706 $46,210 $57,775 $73,115 $88,943 $105,070
Total Capital ($3,539) $71,980 $70,174 $68,393 $74,537 $86,763 $99,687 $109,167 $118,671 $130,236 $145,576 $161,404 $177,531
Total Liabilities and Capital $360,290 $357,547 $399,609 $393,632 $393,286 $405,732 $429,995 $428,500 $433,774 $430,198 $437,564 $433,190 $436,044
Net Worth ($3,539) $71,980 $70,174 $68,393 $74,537 $86,763 $99,687 $109,167 $118,671 $130,236 $145,576 $161,404 $177,531