People's News

Start your own business plan »

Newsagent - Newsstand 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
Unit Sales
Monthly magazines 600 636 674 715 757 803 851 902 956 1,014 1,075 1,139
Weekly magazines and newspapers 1,200 1,272 1,348 1,429 1,515 1,606 1,702 1,804 1,913 2,027 2,149 2,278
Daily newspapers 2,000 2,120 2,247 2,382 2,525 2,676 2,837 3,007 3,188 3,379 3,582 3,797
Beverages 1,200 1,272 1,348 1,429 1,515 1,606 1,702 1,804 1,913 2,027 2,149 2,278
Snacks 950 1,007 1,067 1,131 1,199 1,271 1,348 1,428 1,514 1,605 1,701 1,803
Candy 1,400 1,484 1,573 1,667 1,767 1,874 1,986 2,105 2,231 2,365 2,507 2,658
Total Unit Sales 7,350 7,791 8,258 8,754 9,279 9,836 10,426 11,052 11,715 12,418 13,163 13,952
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Monthly magazines $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00
Weekly magazines and newspapers $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00
Daily newspapers $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00
Beverages $1.25 $1.25 $1.25 $1.25 $1.25 $1.25 $1.25 $1.25 $1.25 $1.25 $1.25 $1.25
Snacks $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00
Candy $0.75 $0.75 $0.75 $0.75 $0.75 $0.75 $0.75 $0.75 $0.75 $0.75 $0.75 $0.75
Sales
Monthly magazines $1,800 $1,908 $2,022 $2,144 $2,272 $2,409 $2,553 $2,707 $2,869 $3,041 $3,224 $3,417
Weekly magazines and newspapers $2,400 $2,544 $2,697 $2,858 $3,030 $3,212 $3,404 $3,609 $3,825 $4,055 $4,298 $4,556
Daily newspapers $2,000 $2,120 $2,247 $2,382 $2,525 $2,676 $2,837 $3,007 $3,188 $3,379 $3,582 $3,797
Beverages $1,500 $1,590 $1,685 $1,787 $1,894 $2,007 $2,128 $2,255 $2,391 $2,534 $2,686 $2,847
Snacks $950 $1,007 $1,067 $1,131 $1,199 $1,271 $1,348 $1,428 $1,514 $1,605 $1,701 $1,803
Candy $1,050 $1,113 $1,180 $1,251 $1,326 $1,405 $1,489 $1,579 $1,674 $1,774 $1,880 $1,993
Total Sales $9,700 $10,282 $10,899 $11,553 $12,246 $12,981 $13,760 $14,585 $15,460 $16,388 $17,371 $18,413
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Monthly magazines 70.00% $2.10 $2.10 $2.10 $2.10 $2.10 $2.10 $2.10 $2.10 $2.10 $2.10 $2.10 $2.10
Weekly magazines and newspapers 75.00% $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50
Daily newspapers 80.00% $0.80 $0.80 $0.80 $0.80 $0.80 $0.80 $0.80 $0.80 $0.80 $0.80 $0.80 $0.80
Beverages 60.00% $0.75 $0.75 $0.75 $0.75 $0.75 $0.75 $0.75 $0.75 $0.75 $0.75 $0.75 $0.75
Snacks 60.00% $0.60 $0.60 $0.60 $0.60 $0.60 $0.60 $0.60 $0.60 $0.60 $0.60 $0.60 $0.60
Candy 60.00% $0.45 $0.45 $0.45 $0.45 $0.45 $0.45 $0.45 $0.45 $0.45 $0.45 $0.45 $0.45
Direct Cost of Sales
Monthly magazines $1,260 $1,336 $1,416 $1,501 $1,591 $1,686 $1,787 $1,895 $2,008 $2,129 $2,256 $2,392
Weekly magazines and newspapers $1,800 $1,908 $2,022 $2,144 $2,272 $2,409 $2,553 $2,707 $2,869 $3,041 $3,224 $3,417
Daily newspapers $1,600 $1,696 $1,798 $1,906 $2,020 $2,141 $2,270 $2,406 $2,550 $2,703 $2,865 $3,037
Beverages $900 $954 $1,011 $1,072 $1,136 $1,204 $1,277 $1,353 $1,434 $1,521 $1,612 $1,708
Snacks $570 $604 $640 $679 $720 $763 $809 $857 $908 $963 $1,021 $1,082
Candy $630 $668 $708 $750 $795 $843 $894 $947 $1,004 $1,064 $1,128 $1,196
Subtotal Direct Cost of Sales $6,760 $7,166 $7,596 $8,051 $8,534 $9,046 $9,589 $10,165 $10,774 $11,421 $12,106 $12,832
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
Store 1 Employees $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Store 2 Employees $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Store 3 Employees $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Administrative Manager $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 1 1 1 1 1 1 1 1 1 1 1 1
Total Payroll $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
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 $9,700 $10,282 $10,899 $11,553 $12,246 $12,981 $13,760 $14,585 $15,460 $16,388 $17,371 $18,413
Direct Cost of Sales $6,760 $7,166 $7,596 $8,051 $8,534 $9,046 $9,589 $10,165 $10,774 $11,421 $12,106 $12,832
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $6,760 $7,166 $7,596 $8,051 $8,534 $9,046 $9,589 $10,165 $10,774 $11,421 $12,106 $12,832
Gross Margin $2,940 $3,116 $3,303 $3,502 $3,712 $3,934 $4,170 $4,421 $4,686 $4,967 $5,265 $5,581
Gross Margin % 30.31% 30.31% 30.31% 30.31% 30.31% 30.31% 30.31% 30.31% 30.31% 30.31% 30.31% 30.31%
Expenses
Payroll $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Marketing/Promotion $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $23 $23 $23 $23 $23 $23 $23 $23 $23 $23 $23 $23
Rent $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Utilities $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Renewal Permits and Licenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Payroll Taxes 15% $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450
New Store Startup Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $4,273 $4,273 $4,273 $4,273 $4,273 $4,273 $4,273 $4,273 $4,273 $4,273 $4,273 $4,273
Profit Before Interest and Taxes ($1,333) ($1,157) ($970) ($772) ($562) ($339) ($103) $147 $413 $694 $992 $1,308
EBITDA ($1,310) ($1,134) ($947) ($748) ($538) ($316) ($80) $171 $436 $717 $1,015 $1,331
Interest Expense $50 $50 $50 $50 $50 $50 $50 $50 $50 $44 $38 $31
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($1,383) ($1,207) ($1,020) ($822) ($612) ($389) ($153) $97 $363 $650 $954 $1,276
Net Profit/Sales -14.26% -11.74% -9.36% -7.11% -4.99% -3.00% -1.11% 0.67% 2.35% 3.97% 5.49% 6.93%
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 $9,700 $10,282 $10,899 $11,553 $12,246 $12,981 $13,760 $14,585 $15,460 $16,388 $17,371 $18,413
Subtotal Cash from Operations $9,700 $10,282 $10,899 $11,553 $12,246 $12,981 $13,760 $14,585 $15,460 $16,388 $17,371 $18,413
Additional Cash Received
Sales Tax, VAT, HST/GST Received 8.88% $861 $913 $967 $1,025 $1,087 $1,152 $1,221 $1,294 $1,372 $1,454 $1,542 $1,634
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 $10,561 $11,195 $11,866 $12,578 $13,333 $14,133 $14,981 $15,880 $16,832 $17,842 $18,913 $20,048
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 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Bill Payments $6,568 $9,495 $8,904 $9,360 $9,844 $10,357 $10,900 $11,476 $12,087 $12,731 $13,410 $14,131
Subtotal Spent on Operations $9,568 $12,495 $11,904 $12,360 $12,844 $13,357 $13,900 $14,476 $15,087 $15,731 $16,410 $17,131
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $861 $913 $967 $1,025 $1,087 $1,152 $1,221 $1,294 $1,372 $1,454 $1,542 $1,634
Principal Repayment of Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $500 $500 $500
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $500 $500 $1,000
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 $10,429 $13,408 $12,871 $13,386 $13,931 $14,509 $15,121 $15,771 $16,459 $18,185 $18,952 $20,265
Net Cash Flow $132 ($2,213) ($1,005) ($808) ($598) ($376) ($140) $109 $374 ($343) ($39) ($218)
Cash Balance $10,132 $7,919 $6,914 $6,106 $5,508 $5,132 $4,992 $5,101 $5,474 $5,132 $5,093 $4,875
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 $10,000 $10,132 $7,919 $6,914 $6,106 $5,508 $5,132 $4,992 $5,101 $5,474 $5,132 $5,093 $4,875
Inventory $1,000 $3,380 $3,583 $3,798 $4,026 $4,267 $4,523 $4,795 $5,082 $5,387 $5,710 $6,053 $6,416
Other Current Assets $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Total Current Assets $11,500 $14,012 $12,002 $11,211 $10,632 $10,275 $10,155 $10,286 $10,683 $11,361 $11,342 $11,646 $11,791
Long-term Assets
Long-term Assets $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400
Accumulated Depreciation $0 $23 $47 $70 $93 $117 $140 $163 $187 $210 $233 $257 $280
Total Long-term Assets $1,400 $1,377 $1,353 $1,330 $1,307 $1,283 $1,260 $1,237 $1,213 $1,190 $1,167 $1,143 $1,120
Total Assets $12,900 $15,389 $13,355 $12,541 $11,938 $11,558 $11,415 $11,523 $11,896 $12,552 $12,509 $12,789 $12,911
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 $1,000 $4,872 $4,045 $4,252 $4,470 $4,702 $4,948 $5,208 $5,484 $5,777 $6,084 $6,410 $6,756
Current Borrowing $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $3,500 $3,000 $2,500
Other Current Liabilities $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $4,500 $4,000 $3,000
Subtotal Current Liabilities $10,000 $13,872 $13,045 $13,252 $13,470 $13,702 $13,948 $14,208 $14,484 $14,777 $14,084 $13,410 $12,256
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $10,000 $13,872 $13,045 $13,252 $13,470 $13,702 $13,948 $14,208 $14,484 $14,777 $14,084 $13,410 $12,256
Paid-in Capital $6,600 $6,600 $6,600 $6,600 $6,600 $6,600 $6,600 $6,600 $6,600 $6,600 $6,600 $6,600 $6,600
Retained Earnings ($3,700) ($3,700) ($3,700) ($3,700) ($3,700) ($3,700) ($3,700) ($3,700) ($3,700) ($3,700) ($3,700) ($3,700) ($3,700)
Earnings $0 ($1,383) ($2,590) ($3,610) ($4,432) ($5,044) ($5,433) ($5,585) ($5,488) ($5,126) ($4,476) ($3,521) ($2,245)
Total Capital $2,900 $1,517 $310 ($710) ($1,532) ($2,144) ($2,533) ($2,685) ($2,588) ($2,226) ($1,576) ($621) $655
Total Liabilities and Capital $12,900 $15,389 $13,355 $12,541 $11,938 $11,558 $11,415 $11,523 $11,896 $12,552 $12,509 $12,789 $12,911
Net Worth $2,900 $1,517 $310 ($710) ($1,532) ($2,144) ($2,533) ($2,685) ($2,588) ($2,226) ($1,576) ($621) $655