Kingfishers
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 |