Yeti Cards & Gifts
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 |