Our biggest savings of the year
Burly Skate Shop
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 | |||||||||||||
Apparel | 0% | $6,000 | $5,700 | $8,000 | $7,600 | $9,000 | $7,600 | $6,000 | $9,200 | $6,000 | $5,700 | $6,200 | $7,000 |
Shoes | 0% | $3,300 | $3,160 | $4,700 | $6,400 | $8,800 | $6,000 | $3,700 | $8,800 | $6,400 | $4,700 | $3,100 | $3,200 |
Boards/Hardware/Misc. | 0% | $2,400 | $2,300 | $2,680 | $3,360 | $2,450 | $2,200 | $2,100 | $4,400 | $5,000 | $4,700 | $2,200 | $2,400 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $11,700 | $11,160 | $15,380 | $17,360 | $20,250 | $15,800 | $11,800 | $22,400 | $17,400 | $15,100 | $11,500 | $12,600 | |
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 | |
Apparel/Shoes | $4,185 | $3,987 | $5,715 | $6,300 | $8,010 | $6,120 | $4,365 | $8,100 | $5,580 | $4,680 | $4,185 | $4,590 | |
Boards/Hardware/Misc. | $1,080 | $1,035 | $1,206 | $1,512 | $1,103 | $990 | $945 | $1,980 | $2,250 | $2,115 | $990 | $1,080 | |
Subtotal Direct Cost of Sales | $5,265 | $5,022 | $6,921 | $7,812 | $9,113 | $7,110 | $5,310 | $10,080 | $7,830 | $6,795 | $5,175 | $5,670 |
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 | ||
The Casperflips (Owners) | 0% | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 |
Full-Time | 0% | $1,730 | $1,730 | $1,730 | $1,730 | $1,730 | $1,730 | $1,730 | $1,730 | $1,730 | $1,730 | $1,730 | $1,730 |
Part-Time | 0% | $677 | $677 | $677 | $677 | $677 | $677 | $677 | $677 | $677 | $677 | $677 | $677 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Total Payroll | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 |
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 | $11,700 | $11,160 | $15,380 | $17,360 | $20,250 | $15,800 | $11,800 | $22,400 | $17,400 | $15,100 | $11,500 | $12,600 | |
Direct Cost of Sales | $5,265 | $5,022 | $6,921 | $7,812 | $9,113 | $7,110 | $5,310 | $10,080 | $7,830 | $6,795 | $5,175 | $5,670 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $5,265 | $5,022 | $6,921 | $7,812 | $9,113 | $7,110 | $5,310 | $10,080 | $7,830 | $6,795 | $5,175 | $5,670 | |
Gross Margin | $6,435 | $6,138 | $8,459 | $9,548 | $11,138 | $8,690 | $6,490 | $12,320 | $9,570 | $8,305 | $6,325 | $6,930 | |
Gross Margin % | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | 55.00% | |
Expenses | |||||||||||||
Payroll | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | |
Marketing/Promotion | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Rent | $1,875 | $1,875 | $1,875 | $1,875 | $1,875 | $1,875 | $1,875 | $1,875 | $1,875 | $1,875 | $1,875 | $1,875 | |
Utilities | $225 | $225 | $225 | $225 | $225 | $225 | $225 | $225 | $225 | $225 | $225 | $225 | |
Insurance | $48 | $48 | $48 | $48 | $48 | $48 | $48 | $48 | $48 | $48 | $48 | $48 | |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Telephone | $130 | $130 | $130 | $130 | $130 | $130 | $130 | $130 | $130 | $130 | $130 | $130 | |
Total Operating Expenses | $6,735 | $6,735 | $6,735 | $6,735 | $6,735 | $6,735 | $6,735 | $6,735 | $6,735 | $6,735 | $6,735 | $6,735 | |
Profit Before Interest and Taxes | ($300) | ($597) | $1,724 | $2,813 | $4,403 | $1,955 | ($245) | $5,585 | $2,835 | $1,570 | ($410) | $195 | |
EBITDA | ($300) | ($597) | $1,724 | $2,813 | $4,403 | $1,955 | ($245) | $5,585 | $2,835 | $1,570 | ($410) | $195 | |
Interest Expense | $405 | $394 | $382 | $370 | $359 | $347 | $336 | $324 | $313 | $301 | $289 | $278 | |
Taxes Incurred | ($212) | ($297) | $403 | $733 | $1,213 | $482 | ($174) | $1,578 | $757 | $381 | ($210) | ($25) | |
Net Profit | ($494) | ($693) | $939 | $1,710 | $2,831 | $1,125 | ($406) | $3,683 | $1,766 | $888 | ($490) | ($58) | |
Net Profit/Sales | -4.22% | -6.21% | 6.11% | 9.85% | 13.98% | 7.12% | -3.44% | 16.44% | 10.15% | 5.88% | -4.26% | -0.46% |
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 | $11,700 | $11,160 | $15,380 | $17,360 | $20,250 | $15,800 | $11,800 | $22,400 | $17,400 | $15,100 | $11,500 | $12,600 | |
Subtotal Cash from Operations | $11,700 | $11,160 | $15,380 | $17,360 | $20,250 | $15,800 | $11,800 | $22,400 | $17,400 | $15,100 | $11,500 | $12,600 | |
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 | $11,700 | $11,160 | $15,380 | $17,360 | $20,250 | $15,800 | $11,800 | $22,400 | $17,400 | $15,100 | $11,500 | $12,600 | |
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,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | $3,657 | |
Bill Payments | $109 | $3,268 | $3,197 | $3,873 | $4,335 | $8,806 | $8,740 | $7,027 | $19,947 | $9,499 | $9,321 | $6,650 | |
Subtotal Spent on Operations | $3,766 | $6,925 | $6,854 | $7,530 | $7,992 | $12,463 | $12,397 | $10,684 | $23,604 | $13,156 | $12,978 | $10,307 | |
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 | $1,388 | $1,388 | $1,388 | $1,388 | $1,388 | $1,388 | $1,388 | $1,388 | $1,388 | $1,388 | $1,388 | $1,388 | |
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 | $5,154 | $8,313 | $8,242 | $8,918 | $9,380 | $13,851 | $13,785 | $12,072 | $24,992 | $14,544 | $14,366 | $11,695 | |
Net Cash Flow | $6,546 | $2,847 | $7,138 | $8,442 | $10,870 | $1,949 | ($1,985) | $10,328 | ($7,592) | $556 | ($2,866) | $905 | |
Cash Balance | $8,109 | $10,956 | $18,093 | $26,535 | $37,405 | $39,353 | $37,368 | $47,696 | $40,104 | $40,659 | $37,794 | $38,698 |
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 | $1,563 | $8,109 | $10,956 | $18,093 | $26,535 | $37,405 | $39,353 | $37,368 | $47,696 | $40,104 | $40,659 | $37,794 | $38,698 |
Inventory | $40,000 | $34,735 | $29,713 | $22,792 | $14,980 | $10,024 | $7,821 | $5,841 | $11,088 | $8,613 | $7,475 | $5,693 | $6,237 |
Other Current Assets | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 |
Total Current Assets | $42,763 | $44,044 | $41,869 | $42,085 | $42,715 | $48,629 | $48,374 | $44,409 | $59,984 | $49,917 | $49,334 | $44,686 | $46,135 |
Long-term Assets | |||||||||||||
Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Assets | $42,763 | $44,044 | $41,869 | $42,085 | $42,715 | $48,629 | $48,374 | $44,409 | $59,984 | $49,917 | $49,334 | $44,686 | $46,135 |
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,163 | $3,069 | $3,734 | $4,042 | $8,513 | $8,521 | $6,351 | $19,630 | $9,186 | $9,102 | $6,332 | $9,227 |
Current Borrowing | $50,000 | $48,612 | $47,224 | $45,836 | $44,448 | $43,060 | $41,672 | $40,284 | $38,896 | $37,508 | $36,120 | $34,732 | $33,344 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $50,000 | $51,775 | $50,293 | $49,570 | $48,490 | $51,573 | $50,193 | $46,635 | $58,526 | $46,694 | $45,222 | $41,064 | $42,571 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $50,000 | $51,775 | $50,293 | $49,570 | $48,490 | $51,573 | $50,193 | $46,635 | $58,526 | $46,694 | $45,222 | $41,064 | $42,571 |
Paid-in Capital | $6,800 | $6,800 | $6,800 | $6,800 | $6,800 | $6,800 | $6,800 | $6,800 | $6,800 | $6,800 | $6,800 | $6,800 | $6,800 |
Retained Earnings | ($14,037) | ($14,037) | ($14,037) | ($14,037) | ($14,037) | ($14,037) | ($14,037) | ($14,037) | ($14,037) | ($14,037) | ($14,037) | ($14,037) | ($14,037) |
Earnings | $0 | ($494) | ($1,187) | ($248) | $1,462 | $4,293 | $5,418 | $5,012 | $8,694 | $10,460 | $11,348 | $10,859 | $10,801 |
Total Capital | ($7,237) | ($7,731) | ($8,424) | ($7,484) | ($5,775) | ($2,944) | ($1,819) | ($2,225) | $1,457 | $3,223 | $4,111 | $3,622 | $3,564 |
Total Liabilities and Capital | $42,763 | $44,044 | $41,869 | $42,085 | $42,715 | $48,629 | $48,374 | $44,409 | $59,984 | $49,917 | $49,334 | $44,686 | $46,135 |
Net Worth | ($7,237) | ($7,731) | ($8,424) | ($7,484) | ($5,775) | ($2,944) | ($1,819) | ($2,225) | $1,457 | $3,223 | $4,111 | $3,622 | $3,564 |