Yeti Cards & Gifts

Start your own business plan »

Gift Novelty Souvenir Shop Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Cards 0% $1,654 $1,715 $1,878 $1,854 $1,901 $2,154 $2,745 $2,898 $3,112 $3,225 $3,389 $3,656
Health & Beauty 0% $1,472 $1,526 $1,671 $1,650 $1,692 $1,917 $2,443 $2,579 $2,770 $2,870 $3,016 $3,254
Novelty 0% $1,290 $1,338 $1,465 $1,446 $1,483 $1,680 $2,141 $2,260 $2,427 $2,516 $2,643 $2,852
Candy & Beverages 0% $1,389 $1,441 $1,578 $1,557 $1,597 $1,809 $2,306 $2,434 $2,614 $2,709 $2,847 $3,071
Japanese 0% $1,224 $1,269 $1,390 $1,372 $1,407 $1,594 $2,031 $2,145 $2,303 $2,387 $2,508 $2,705
Total Sales $7,030 $7,289 $7,982 $7,880 $8,079 $9,155 $11,666 $12,317 $13,226 $13,706 $14,403 $15,538
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cards $579 $600 $657 $649 $665 $754 $961 $1,014 $1,089 $1,129 $1,186 $1,280
Health & Beauty $515 $534 $585 $578 $592 $671 $855 $903 $969 $1,005 $1,056 $1,139
Novelty $452 $468 $513 $506 $519 $588 $749 $791 $850 $880 $925 $998
Candy & Beverages $486 $504 $552 $545 $559 $633 $807 $852 $915 $948 $996 $1,075
Japanese $428 $444 $486 $480 $492 $558 $711 $751 $806 $835 $878 $947
Subtotal Direct Cost of Sales $2,460 $2,551 $2,794 $2,758 $2,828 $3,204 $4,083 $4,311 $4,629 $4,797 $5,041 $5,438
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Dan 0% $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Ishada 0% $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Part-time employee 0% $0 $0 $0 $0 $0 $552 $552 $552 $552 $552 $552 $552
Part-time employee 0% $0 $0 $0 $0 $0 $552 $552 $552 $552 $552 $552 $552
Part-time employee 0% $0 $0 $0 $0 $0 $552 $552 $552 $552 $552 $552 $552
Total People 2 2 2 2 2 5 5 5 5 5 5 5
Total Payroll $2,400 $2,400 $2,400 $2,400 $2,400 $4,056 $4,056 $4,056 $4,056 $4,056 $4,056 $4,056
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 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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $7,030 $7,289 $7,982 $7,880 $8,079 $9,155 $11,666 $12,317 $13,226 $13,706 $14,403 $15,538
Direct Cost of Sales $2,460 $2,551 $2,794 $2,758 $2,828 $3,204 $4,083 $4,311 $4,629 $4,797 $5,041 $5,438
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $2,460 $2,551 $2,794 $2,758 $2,828 $3,204 $4,083 $4,311 $4,629 $4,797 $5,041 $5,438
Gross Margin $4,569 $4,738 $5,188 $5,122 $5,252 $5,950 $7,583 $8,006 $8,597 $8,909 $9,362 $10,100
Gross Margin % 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00%
Expenses
Payroll $2,400 $2,400 $2,400 $2,400 $2,400 $4,056 $4,056 $4,056 $4,056 $4,056 $4,056 $4,056
Sales and Marketing and Other Expenses $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Depreciation $167 $167 $167 $250 $250 $250 $250 $250 $250 $250 $250 $250
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $200 $200 $200 $200 $200 $200 $350 $350 $350 $350 $350 $350
Insurance $250 $250 $250 $250 $250 $250 $450 $450 $450 $450 $450 $450
Rent $600 $600 $600 $600 $600 $600 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100
Payroll Taxes 15% $360 $360 $360 $360 $360 $608 $608 $608 $608 $608 $608 $608
Other $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Total Operating Expenses $4,577 $4,577 $4,577 $4,660 $4,660 $6,564 $7,414 $7,414 $7,414 $7,414 $7,414 $7,414
Profit Before Interest and Taxes ($8) $161 $611 $462 $592 ($614) $169 $591 $1,183 $1,495 $1,948 $2,685
EBITDA $159 $328 $778 $712 $842 ($364) $419 $841 $1,433 $1,745 $2,198 $2,935
Interest Expense $125 $125 $125 $289 $287 $285 $283 $280 $278 $276 $273 $271
Taxes Incurred ($40) $11 $146 $52 $91 ($270) ($34) $93 $271 $366 $502 $724
Net Profit ($93) $25 $340 $121 $213 ($629) ($80) $218 $633 $853 $1,172 $1,690
Net Profit/Sales -1.32% 0.35% 4.26% 1.53% 2.64% -6.87% -0.68% 1.77% 4.79% 6.22% 8.14% 10.88%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $7,030 $7,289 $7,982 $7,880 $8,079 $9,155 $11,666 $12,317 $13,226 $13,706 $14,403 $15,538
Subtotal Cash from Operations $7,030 $7,289 $7,982 $7,880 $8,079 $9,155 $11,666 $12,317 $13,226 $13,706 $14,403 $15,538
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 $20,000 $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 $7,030 $7,289 $7,982 $27,880 $8,079 $9,155 $11,666 $12,317 $13,226 $13,706 $14,403 $15,538
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $2,400 $2,400 $2,400 $2,400 $2,400 $4,056 $4,056 $4,056 $4,056 $4,056 $4,056 $4,056
Bill Payments $4,071 $2,097 $2,150 $2,321 $3,552 $5,313 $5,976 $8,395 $8,063 $8,640 $8,747 $9,220
Subtotal Spent on Operations $6,471 $4,497 $4,550 $4,721 $5,952 $9,369 $10,032 $12,451 $12,119 $12,696 $12,803 $13,276
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 $265 $267 $269 $271 $274 $276 $278 $281 $283
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $10,000 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $16,471 $4,497 $4,550 $9,986 $6,219 $9,638 $10,303 $12,725 $12,395 $12,975 $13,084 $13,559
Net Cash Flow ($9,441) $2,792 $3,431 $17,894 $1,860 ($484) $1,363 ($408) $831 $732 $1,319 $1,979
Cash Balance $2,922 $5,714 $9,145 $27,038 $28,898 $28,414 $29,777 $29,369 $30,200 $30,932 $32,251 $34,230
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $12,363 $2,922 $5,714 $9,145 $27,038 $28,898 $28,414 $29,777 $29,369 $30,200 $30,932 $32,251 $34,230
Inventory $12,455 $9,995 $7,444 $4,650 $3,034 $3,111 $3,524 $4,492 $4,742 $5,092 $5,277 $5,545 $5,982
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $24,818 $12,916 $13,157 $13,795 $30,072 $32,009 $31,939 $34,269 $34,111 $35,292 $36,209 $37,796 $40,212
Long-term Assets
Long-term Assets $5,000 $15,000 $15,000 $15,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Accumulated Depreciation $2,751 $2,918 $3,085 $3,252 $3,502 $3,752 $4,002 $4,252 $4,502 $4,752 $5,002 $5,252 $5,502
Total Long-term Assets $2,249 $12,082 $11,915 $11,748 $16,498 $16,248 $15,998 $15,748 $15,498 $15,248 $14,998 $14,748 $14,498
Total Assets $27,067 $24,998 $25,073 $25,543 $46,570 $48,257 $47,937 $50,017 $49,609 $50,541 $51,207 $52,545 $54,711
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $4,001 $2,025 $2,074 $2,205 $3,376 $5,117 $5,695 $8,127 $7,775 $8,349 $8,441 $8,887 $9,646
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 $4,001 $2,025 $2,074 $2,205 $3,376 $5,117 $5,695 $8,127 $7,775 $8,349 $8,441 $8,887 $9,646
Long-term Liabilities $15,000 $15,000 $15,000 $15,000 $34,735 $34,468 $34,199 $33,928 $33,654 $33,378 $33,100 $32,819 $32,536
Total Liabilities $19,001 $17,025 $17,074 $17,205 $38,111 $39,585 $39,894 $42,054 $41,429 $41,727 $41,540 $41,706 $42,182
Paid-in Capital $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Retained Earnings $2,612 $8,066 $8,066 $8,066 $8,066 $8,066 $8,066 $8,066 $8,066 $8,066 $8,066 $8,066 $8,066
Earnings $5,454 ($93) ($68) $272 $393 $606 ($23) ($103) $114 $747 $1,601 $2,773 $4,463
Total Capital $8,066 $7,973 $7,998 $8,338 $8,459 $8,672 $8,043 $7,963 $8,180 $8,813 $9,667 $10,839 $12,529
Total Liabilities and Capital $27,067 $24,998 $25,073 $25,543 $46,570 $48,257 $47,937 $50,017 $49,609 $50,541 $51,207 $52,545 $54,711
Net Worth $8,066 $7,973 $7,998 $8,338 $8,459 $8,672 $8,043 $7,963 $8,180 $8,813 $9,667 $10,839 $12,529