Kona-Q
Appendix
Sales Forecast | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | |||||||||||||
Families | 0% | $0 | $3,445 | $3,665 | $3,701 | $3,898 | $3,998 | $4,141 | $4,202 | $4,336 | $4,454 | $4,545 | $4,641 |
Individuals | 0% | $0 | $2,722 | $2,895 | $2,924 | $3,079 | $3,158 | $3,271 | $3,320 | $3,425 | $3,519 | $3,591 | $3,666 |
Total Sales | $0 | $6,167 | $6,560 | $6,625 | $6,977 | $7,156 | $7,412 | $7,522 | $7,761 | $7,973 | $8,136 | $8,307 | |
Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Families | $0 | $1,034 | $1,100 | $1,110 | $1,169 | $1,199 | $1,242 | $1,261 | $1,301 | $1,336 | $1,364 | $1,392 | |
Individuals | $0 | $816 | $869 | $877 | $924 | $948 | $981 | $996 | $1,028 | $1,056 | $1,077 | $1,100 | |
Subtotal Direct Cost of Sales | $0 | $1,850 | $1,968 | $1,987 | $2,093 | $2,147 | $2,224 | $2,256 | $2,328 | $2,392 | $2,441 | $2,492 |
Personnel Plan | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Kevin | 0% | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Cook | 0% | $0 | $1,150 | $1,150 | $1,150 | $1,150 | $1,150 | $1,150 | $1,150 | $1,150 | $1,150 | $1,150 | $1,150 |
Manager | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Misc. | 0% | $0 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 |
Total People | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
Total Payroll | $2,000 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 |
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 | $0 | $6,167 | $6,560 | $6,625 | $6,977 | $7,156 | $7,412 | $7,522 | $7,761 | $7,973 | $8,136 | $8,307 | |
Direct Cost of Sales | $0 | $1,850 | $1,968 | $1,987 | $2,093 | $2,147 | $2,224 | $2,256 | $2,328 | $2,392 | $2,441 | $2,492 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $1,850 | $1,968 | $1,987 | $2,093 | $2,147 | $2,224 | $2,256 | $2,328 | $2,392 | $2,441 | $2,492 | |
Gross Margin | $0 | $4,317 | $4,592 | $4,637 | $4,884 | $5,009 | $5,189 | $5,265 | $5,433 | $5,581 | $5,695 | $5,815 | |
Gross Margin % | 0.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | |
Expenses | |||||||||||||
Payroll | $2,000 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | |
Sales and Marketing and Other Expenses | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Depreciation | $1,083 | $1,083 | $1,083 | $1,083 | $1,083 | $1,083 | $1,083 | $1,083 | $1,083 | $1,083 | $1,083 | $1,083 | |
Rent | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | |
Utilities | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Insurance | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Payroll Taxes | 15% | $300 | $608 | $608 | $608 | $608 | $608 | $608 | $608 | $608 | $608 | $608 | $608 |
Other | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | |
Total Operating Expenses | $4,908 | $7,266 | $7,266 | $7,266 | $7,266 | $7,266 | $7,266 | $7,266 | $7,266 | $7,266 | $7,266 | $7,266 | |
Profit Before Interest and Taxes | ($4,908) | ($2,949) | ($2,673) | ($2,628) | ($2,381) | ($2,256) | ($2,077) | ($2,000) | ($1,832) | ($1,685) | ($1,571) | ($1,450) | |
EBITDA | ($3,825) | ($1,866) | ($1,590) | ($1,545) | ($1,298) | ($1,173) | ($994) | ($917) | ($749) | ($602) | ($488) | ($367) | |
Interest Expense | $24 | $190 | $186 | $181 | $177 | $172 | $168 | $163 | $158 | $154 | $149 | $145 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($4,932) | ($3,139) | ($2,859) | ($2,809) | ($2,558) | ($2,428) | ($2,244) | ($2,163) | ($1,991) | ($1,838) | ($1,720) | ($1,595) | |
Net Profit/Sales | 0.00% | -50.91% | -43.58% | -42.41% | -36.66% | -33.93% | -30.28% | -28.76% | -25.65% | -23.06% | -21.14% | -19.20% |
Pro Forma Cash Flow | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $0 | $6,167 | $6,560 | $6,625 | $6,977 | $7,156 | $7,412 | $7,522 | $7,761 | $7,973 | $8,136 | $8,307 | |
Subtotal Cash from Operations | $0 | $6,167 | $6,560 | $6,625 | $6,977 | $7,156 | $7,412 | $7,522 | $7,761 | $7,973 | $8,136 | $8,307 | |
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 | $20,000 | $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 | $10,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $10,000 | $26,167 | $6,560 | $6,625 | $6,977 | $7,156 | $7,412 | $7,522 | $7,761 | $7,973 | $8,136 | $8,307 | |
Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Expenditures from Operations | |||||||||||||
Cash Spending | $2,000 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | $4,050 | |
Bill Payments | $4,304 | $1,926 | $4,177 | $4,287 | $4,305 | $4,404 | $4,454 | $4,525 | $4,554 | $4,621 | $4,680 | $4,724 | |
Subtotal Spent on Operations | $6,304 | $5,976 | $8,227 | $8,337 | $8,355 | $8,454 | $8,504 | $8,575 | $8,604 | $8,671 | $8,730 | $8,774 | |
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 | $550 | $550 | $550 | $550 | $550 | $550 | $550 | $550 | $550 | $550 | |
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 | $6,304 | $5,976 | $8,777 | $8,887 | $8,905 | $9,004 | $9,054 | $9,125 | $9,154 | $9,221 | $9,280 | $9,324 | |
Net Cash Flow | $3,696 | $20,190 | ($2,216) | ($2,262) | ($1,927) | ($1,848) | ($1,642) | ($1,603) | ($1,393) | ($1,249) | ($1,144) | ($1,017) | |
Cash Balance | $8,685 | $28,876 | $26,659 | $24,397 | $22,470 | $20,622 | $18,981 | $17,377 | $15,985 | $14,736 | $13,592 | $12,575 |
Pro Forma Balance Sheet | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $4,989 | $8,685 | $28,876 | $26,659 | $24,397 | $22,470 | $20,622 | $18,981 | $17,377 | $15,985 | $14,736 | $13,592 | $12,575 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $4,989 | $8,685 | $28,876 | $26,659 | $24,397 | $22,470 | $20,622 | $18,981 | $17,377 | $15,985 | $14,736 | $13,592 | $12,575 |
Long-term Assets | |||||||||||||
Long-term Assets | $22,141 | $22,141 | $22,141 | $22,141 | $22,141 | $22,141 | $22,141 | $22,141 | $22,141 | $22,141 | $22,141 | $22,141 | $22,141 |
Accumulated Depreciation | $8,989 | $10,072 | $11,155 | $12,238 | $13,321 | $14,404 | $15,487 | $16,570 | $17,653 | $18,736 | $19,819 | $20,902 | $21,985 |
Total Long-term Assets | $13,152 | $12,069 | $10,986 | $9,903 | $8,820 | $7,737 | $6,654 | $5,571 | $4,488 | $3,405 | $2,322 | $1,239 | $156 |
Total Assets | $18,141 | $20,754 | $39,862 | $36,562 | $33,217 | $30,207 | $27,276 | $24,552 | $21,865 | $19,390 | $17,058 | $14,831 | $12,731 |
Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Current Liabilities | |||||||||||||
Accounts Payable | $4,242 | $1,787 | $4,034 | $4,144 | $4,158 | $4,256 | $4,303 | $4,373 | $4,400 | $4,465 | $4,522 | $4,565 | $4,610 |
Current Borrowing | $0 | $0 | $20,000 | $19,450 | $18,900 | $18,350 | $17,800 | $17,250 | $16,700 | $16,150 | $15,600 | $15,050 | $14,500 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $4,242 | $1,787 | $24,034 | $23,594 | $23,058 | $22,606 | $22,103 | $21,623 | $21,100 | $20,615 | $20,122 | $19,615 | $19,110 |
Long-term Liabilities | $2,858 | $2,858 | $2,858 | $2,858 | $2,858 | $2,858 | $2,858 | $2,858 | $2,858 | $2,858 | $2,858 | $2,858 | $2,858 |
Total Liabilities | $7,100 | $4,645 | $26,892 | $26,452 | $25,916 | $25,464 | $24,961 | $24,481 | $23,958 | $23,473 | $22,980 | $22,473 | $21,968 |
Paid-in Capital | $0 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
Retained Earnings | $11,041 | $11,041 | $11,041 | $11,041 | $11,041 | $11,041 | $11,041 | $11,041 | $11,041 | $11,041 | $11,041 | $11,041 | $11,041 |
Earnings | $0 | ($4,932) | ($8,071) | ($10,930) | ($13,740) | ($16,298) | ($18,726) | ($20,970) | ($23,134) | ($25,125) | ($26,963) | ($28,683) | ($30,278) |
Total Capital | $11,041 | $16,109 | $12,970 | $10,111 | $7,301 | $4,743 | $2,315 | $71 | ($2,093) | ($4,084) | ($5,922) | ($7,642) | ($9,237) |
Total Liabilities and Capital | $18,141 | $20,754 | $39,862 | $36,562 | $33,217 | $30,207 | $27,276 | $24,552 | $21,865 | $19,390 | $17,058 | $14,831 | $12,731 |
Net Worth | $11,041 | $16,109 | $12,970 | $10,111 | $7,301 | $4,743 | $2,315 | $71 | ($2,093) | ($4,084) | ($5,922) | ($7,642) | ($9,237) |