Kingfishers

Start your own business plan »

Fishing Supplies and Fly Shop 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
Sales
Fishing Equipment 0% $1,730 $1,730 $2,730 $4,000 $2,730 $7,166 $16,000 $16,000 $16,000 $8,000 $2,730 $4,000
Guide Services 0% $0 $0 $1,000 $4,500 $0 $3,740 $7,480 $8,460 $7,480 $4,740 $0 $0
Drift Boat Rentals 0% $0 $0 $0 $1,440 $0 $2,000 $4,320 $4,320 $4,320 $2,440 $0 $0
Licenses 0% $0 $0 $0 $5,400 $0 $200 $5,400 $5,400 $5,400 $5,000 $0 $0
Lodging 0% $0 $0 $0 $0 $0 $4,500 $13,500 $13,500 $13,500 $9,000 $9,000 $0
Hunting Equipment 0% $0 $0 $0 $0 $0 $0 $0 $0 $250 $500 $600 $0
Hunting Apparel 0% $0 $0 $0 $0 $0 $0 $0 $0 $250 $500 $600 $0
Flies 0% $0 $0 $635 $2,000 $500 $1,567 $15,000 $12,000 $8,000 $1,567 $0 $0
Misc. 0% $0 $0 $0 $0 $0 $400 $600 $600 $600 $300 $200 $0
Total Sales $1,730 $1,730 $4,365 $17,340 $3,230 $19,573 $62,300 $60,280 $55,800 $32,047 $13,130 $4,000
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
Fishing Equipment $952 $952 $1,501 $2,200 $1,501 $3,941 $8,800 $8,800 $8,800 $4,400 $1,501 $2,200
Lodging 1% $0 $0 $0 $0 $0 $23 $68 $68 $68 $45 $45 $0
Hunting Equipment $0 $0 $0 $0 $0 $0 $0 $0 $138 $275 $330 $0
Hunting Apparel $0 $0 $0 $0 $0 $0 $0 $0 $138 $275 $330 $0
Flies $0 $0 $273 $860 $215 $673 $6,450 $5,160 $3,440 $672 $0 $0
Misc $0 $0 $0 $0 $0 $160 $240 $240 $240 $120 $80 $0
Subtotal Direct Cost of Sales $952 $952 $1,774 $3,060 $1,716 $4,797 $15,558 $14,268 $12,824 $5,787 $2,286 $2,200
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
Owner Operator 0% $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300
Cabin Manager (Brassie) 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Part Time Employee 0% $0 $0 $0 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $0 $0
Name or Title or Group 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 2 2 2 3 3 3 3 3 3 3 2 3
Total Payroll $1,300 $1,300 $1,300 $3,100 $3,100 $3,100 $3,100 $3,100 $3,100 $3,100 $1,300 $1,300
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 $1,730 $1,730 $4,365 $17,340 $3,230 $19,573 $62,300 $60,280 $55,800 $32,047 $13,130 $4,000
Direct Cost of Sales $952 $952 $1,774 $3,060 $1,716 $4,797 $15,558 $14,268 $12,824 $5,787 $2,286 $2,200
Independant Guide Cost 60% $0 $0 $0 $2,700 $0 $2,244 $4,488 $5,076 $4,488 $2,844 $0 $0
License Funds going back to state $0 $0 $0 $5,400 $0 $0 $5,400 $5,400 $5,400 $5,000 $0 $0
Credit Card Fees 1% $9 $9 $23 $92 $17 $104 $330 $319 $296 $170 $70 $21
Lodging - cleaning and maintenance 32% $0 $0 $0 $0 $0 $1,440 $4,320 $4,320 $4,320 $2,880 $2,880 $0
Total Cost of Sales $961 $961 $1,797 $11,252 $1,733 $8,584 $30,096 $29,383 $27,327 $16,681 $5,236 $2,221
Gross Margin $769 $769 $2,568 $6,088 $1,497 $10,989 $32,204 $30,897 $28,473 $15,366 $7,894 $1,779
Gross Margin % 44.47% 44.44% 58.83% 35.11% 46.34% 56.14% 51.69% 51.26% 51.03% 47.95% 60.12% 44.47%
Expenses
Payroll $1,300 $1,300 $1,300 $3,100 $3,100 $3,100 $3,100 $3,100 $3,100 $3,100 $1,300 $1,300
Marketing/Promotion $1,500 $1,500 $1,000 $700 $700 $700 $700 $700 $700 $700 $700 $1,000
Depreciation $1,255 $1,255 $1,255 $1,255 $1,255 $1,255 $1,255 $1,255 $1,255 $1,255 $1,255 $1,255
Utilities $300 $300 $300 $300 $275 $275 $200 $200 $200 $250 $300 $300
Insurance $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75
Total Operating Expenses $4,630 $4,630 $4,130 $5,630 $5,605 $5,605 $5,530 $5,530 $5,530 $5,580 $3,830 $4,130
Profit Before Interest and Taxes ($3,861) ($3,861) ($1,562) $458 ($4,108) $5,384 $26,674 $25,367 $22,943 $9,786 $4,064 ($2,351)
EBITDA ($2,606) ($2,606) ($307) $1,713 ($2,853) $6,639 $27,929 $26,622 $24,198 $11,041 $5,319 ($1,096)
Interest Expense $3,420 $3,420 $3,420 $3,392 $3,363 $3,335 $3,306 $3,278 $3,249 $3,221 $3,192 $3,164
Taxes Incurred ($2,184) ($2,184) ($1,495) ($880) ($2,241) $615 $7,010 $6,627 $5,908 $1,970 $262 ($1,654)
Net Profit ($5,096) ($5,097) ($3,487) ($2,053) ($5,230) $1,434 $16,358 $15,463 $13,786 $4,596 $611 ($3,860)
Net Profit/Sales -294.59% -294.61% -79.90% -11.84% -161.91% 7.33% 26.26% 25.65% 24.71% 14.34% 4.65% -96.51%
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 $1,730 $1,730 $4,365 $17,340 $3,230 $19,573 $62,300 $60,280 $55,800 $32,047 $13,130 $4,000
Subtotal Cash from Operations $1,730 $1,730 $4,365 $17,340 $3,230 $19,573 $62,300 $60,280 $55,800 $32,047 $13,130 $4,000
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 $1,730 $1,730 $4,365 $17,340 $3,230 $19,573 $62,300 $60,280 $55,800 $32,047 $13,130 $4,000
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 $1,300 $1,300 $1,300 $3,100 $3,100 $3,100 $3,100 $3,100 $3,100 $3,100 $1,300 $1,300
Bill Payments $111 $3,320 $3,327 $3,805 $11,659 $2,609 $9,555 $26,035 $26,150 $24,585 $19,321 $75,193
Subtotal Spent on Operations $1,411 $4,620 $4,627 $6,905 $14,759 $5,709 $12,655 $29,135 $29,250 $27,685 $20,621 $76,493
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 $4,275 $4,275 $4,275 $4,275 $4,275 $4,275 $4,275 $4,275 $4,275
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 $1,411 $4,620 $4,627 $11,180 $19,034 $9,984 $16,930 $33,410 $33,525 $31,960 $24,896 $80,768
Net Cash Flow $319 ($2,890) ($262) $6,160 ($15,804) $9,589 $45,370 $26,870 $22,275 $87 ($11,766) ($76,768)
Cash Balance $15,319 $12,429 $12,168 $18,327 $2,524 $12,113 $57,483 $84,353 $106,628 $106,715 $94,949 $18,181
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 $15,000 $15,319 $12,429 $12,168 $18,327 $2,524 $12,113 $57,483 $84,353 $106,628 $106,715 $94,949 $18,181
Inventory $98,000 $97,049 $96,097 $94,323 $91,263 $89,547 $84,750 $69,193 $54,925 $42,102 $36,315 $104,029 $101,829
Other Current Assets $6,400 $6,400 $6,400 $6,400 $6,400 $6,400 $6,400 $6,400 $6,400 $6,400 $6,400 $6,400 $6,400
Total Current Assets $119,400 $118,768 $114,926 $112,890 $115,990 $98,470 $103,263 $133,075 $145,678 $155,130 $149,430 $205,377 $126,410
Long-term Assets
Long-term Assets $452,400 $452,400 $452,400 $452,400 $452,400 $452,400 $452,400 $452,400 $452,400 $452,400 $452,400 $452,400 $452,400
Accumulated Depreciation $0 $1,255 $2,510 $3,765 $5,020 $6,275 $7,530 $8,785 $10,040 $11,295 $12,550 $13,805 $15,060
Total Long-term Assets $452,400 $451,145 $449,890 $448,635 $447,380 $446,125 $444,870 $443,615 $442,360 $441,105 $439,850 $438,595 $437,340
Total Assets $571,800 $569,913 $564,816 $561,525 $563,370 $544,595 $548,133 $576,690 $588,038 $596,235 $589,280 $643,972 $563,750
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,209 $3,209 $3,406 $11,579 $2,309 $8,687 $25,162 $25,322 $24,008 $16,732 $75,089 $3,002
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 $0 $3,209 $3,209 $3,406 $11,579 $2,309 $8,687 $25,162 $25,322 $24,008 $16,732 $75,089 $3,002
Long-term Liabilities $513,000 $513,000 $513,000 $513,000 $508,725 $504,450 $500,175 $495,900 $491,625 $487,350 $483,075 $478,800 $474,525
Total Liabilities $513,000 $516,209 $516,209 $516,406 $520,304 $506,759 $508,862 $521,062 $516,947 $511,358 $499,807 $553,889 $477,527
Paid-in Capital $64,000 $64,000 $64,000 $64,000 $64,000 $64,000 $64,000 $64,000 $64,000 $64,000 $64,000 $64,000 $64,000
Retained Earnings ($5,200) ($5,200) ($5,200) ($5,200) ($5,200) ($5,200) ($5,200) ($5,200) ($5,200) ($5,200) ($5,200) ($5,200) ($5,200)
Earnings $0 ($5,096) ($10,193) ($13,681) ($15,734) ($20,964) ($19,529) ($3,172) $12,291 $26,077 $30,673 $31,283 $27,423
Total Capital $58,800 $53,704 $48,607 $45,119 $43,066 $37,836 $39,271 $55,628 $71,091 $84,877 $89,473 $90,083 $86,223
Total Liabilities and Capital $571,800 $569,913 $564,816 $561,525 $563,370 $544,595 $548,133 $576,690 $588,038 $596,235 $589,280 $643,972 $563,750
Net Worth $58,800 $53,704 $48,607 $45,119 $43,066 $37,836 $39,271 $55,628 $71,091 $84,877 $89,473 $90,083 $86,223