Grapevine Country Gifts

Start your own business plan »

Home, Garden Gifts Online Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Web Sales $990 $449 $1,782 $3,003 $3,340 $5,980 $7,300 $7,300 $7,300 $7,300 $7,300 $7,300
Road Shows $0 $1,375 $2,200 $3,300 $4,675 $4,675 $4,675 $4,675 $6,875 $8,250 $8,250 $8,250
Web Design $1,375 $1,375 $825 $825 $825 $825 $825 $825 $825 $825 $825 $825
Total Sales $2,365 $3,199 $4,807 $7,128 $8,840 $11,480 $12,800 $12,800 $15,000 $16,375 $16,375 $16,375
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Web Sales $445 $202 $800 $1,348 $1,499 $2,685 $3,278 $3,278 $3,278 $3,278 $3,278 $3,278
Road Shows $0 $825 $1,320 $1,980 $2,805 $2,805 $2,805 $2,805 $4,125 $4,950 $4,950 $4,950
Web Design $94 $94 $56 $56 $56 $56 $56 $56 $56 $56 $56 $56
Subtotal Direct Cost of Sales $538 $1,120 $2,176 $3,384 $4,361 $5,546 $6,139 $6,139 $7,459 $8,284 $8,284 $8,284
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Gwen Hultquist, Owner/Manager 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Tim Hultquist, Co-Owner 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
General Labor 0% $0 $0 $0 $0 $0 $0 $0 $0 $1,806 $1,806 $1,806 $1,806
Total People 2 2 2 2 2 2 2 2 4 4 4 4
Total Payroll $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $3,806 $3,806 $3,806 $3,806
Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $2,365 $3,199 $4,807 $7,128 $8,840 $11,480 $12,800 $12,800 $15,000 $16,375 $16,375 $16,375
Direct Cost of Sales $538 $1,120 $2,176 $3,384 $4,361 $5,546 $6,139 $6,139 $7,459 $8,284 $8,284 $8,284
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $538 $1,120 $2,176 $3,384 $4,361 $5,546 $6,139 $6,139 $7,459 $8,284 $8,284 $8,284
Gross Margin $1,827 $2,079 $2,631 $3,744 $4,479 $5,934 $6,661 $6,661 $7,541 $8,091 $8,091 $8,091
Gross Margin % 77.25% 64.99% 54.73% 52.52% 50.67% 51.69% 52.04% 52.04% 50.27% 49.41% 49.41% 49.41%
Expenses
Payroll $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $3,806 $3,806 $3,806 $3,806
Sales and Marketing and Other Expenses $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Depreciation $35 $35 $35 $35 $139 $139 $139 $139 $139 $139 $139 $139
Mortgage % for Business-only Areas $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350
Telephone & Utilities $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Insurance $71 $0 $0 $0 $0 $72 $72 $72 $72 $72 $72 $72
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Web Store & Internet $70 $70 $70 $70 $70 $70 $70 $70 $70 $70 $70 $70
Maintenance & Repair $63 $63 $63 $63 $63 $63 $63 $63 $63 $63 $63 $63
Business Supplies $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25
Professional Services 15% $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Expensed Barn Renovations 15% $0 $2,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Miscellaneous $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25
Total Operating Expenses $2,989 $5,418 $2,918 $2,918 $3,022 $3,094 $3,094 $3,094 $4,900 $4,900 $4,900 $4,900
Profit Before Interest and Taxes ($1,162) ($3,339) ($287) $826 $1,457 $2,840 $3,567 $3,567 $2,641 $3,191 $3,191 $3,191
EBITDA ($1,127) ($3,304) ($252) $861 $1,596 $2,979 $3,706 $3,706 $2,780 $3,330 $3,330 $3,330
Interest Expense $231 $228 $226 $224 $221 $219 $216 $214 $211 $209 $207 $204
Taxes Incurred ($418) ($1,070) ($154) $181 $371 $786 $1,005 $1,006 $729 $895 $895 $896
Net Profit ($975) ($2,497) ($359) $421 $865 $1,835 $2,345 $2,347 $1,701 $2,087 $2,089 $2,091
Net Profit/Sales -41.23% -78.07% -7.47% 5.91% 9.79% 15.98% 18.32% 18.34% 11.34% 12.75% 12.76% 12.77%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $2,365 $3,199 $4,807 $7,128 $8,840 $11,480 $12,800 $12,800 $15,000 $16,375 $16,375 $16,375
Subtotal Cash from Operations $2,365 $3,199 $4,807 $7,128 $8,840 $11,480 $12,800 $12,800 $15,000 $16,375 $16,375 $16,375
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 $40,000 $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 $42,365 $3,199 $4,807 $7,128 $8,840 $11,480 $12,800 $12,800 $15,000 $16,375 $16,375 $16,375
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $3,806 $3,806 $3,806 $3,806
Bill Payments $1,227 $826 $2,588 $3,966 $4,339 $5,949 $8,815 $8,945 $8,396 $10,821 $11,219 $10,340
Subtotal Spent on Operations $3,227 $2,826 $4,588 $5,966 $6,339 $7,949 $10,815 $10,945 $12,202 $14,627 $15,025 $14,146
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 $3,000 $0 $0 $0 $0 $0 $0 $0 $3,670
Long-term Liabilities Principal Repayment $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $1,500 $25,000 $11,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 $3,644 $4,743 $30,005 $20,383 $6,756 $8,366 $11,232 $11,362 $12,619 $15,044 $15,442 $18,233
Net Cash Flow $38,721 ($1,545) ($25,198) ($13,255) $2,083 $3,113 $1,568 $1,437 $2,380 $1,331 $932 ($1,859)
Cash Balance $52,374 $50,830 $25,632 $12,376 $14,460 $17,573 $19,140 $20,578 $22,958 $24,289 $25,221 $23,362
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $13,653 $52,374 $50,830 $25,632 $12,376 $14,460 $17,573 $19,140 $20,578 $22,958 $24,289 $25,221 $23,362
Inventory $6,000 $5,462 $4,342 $5,166 $4,781 $4,797 $6,101 $6,752 $6,752 $8,204 $9,112 $9,112 $9,112
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $19,653 $57,836 $55,172 $30,797 $17,158 $19,256 $23,673 $25,893 $27,330 $31,162 $33,401 $34,333 $32,474
Long-term Assets
Long-term Assets $12,555 $12,555 $14,055 $39,055 $50,055 $50,055 $50,055 $50,055 $50,055 $50,055 $50,055 $50,055 $50,055
Accumulated Depreciation $1,200 $1,235 $1,270 $1,305 $1,340 $1,479 $1,618 $1,757 $1,896 $2,035 $2,174 $2,313 $2,452
Total Long-term Assets $11,355 $11,320 $12,785 $37,750 $48,715 $48,576 $48,437 $48,298 $48,159 $48,020 $47,881 $47,742 $47,603
Total Assets $31,008 $69,157 $67,957 $68,548 $65,873 $67,833 $72,111 $74,191 $75,489 $79,182 $81,282 $82,075 $80,077
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $1,201 $742 $2,456 $3,823 $4,144 $5,656 $8,516 $8,668 $8,036 $10,446 $10,875 $9,996 $9,994
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $20,000 $20,000 $20,000 $20,000 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000 $13,330
Subtotal Current Liabilities $21,201 $20,742 $22,456 $23,823 $21,144 $22,656 $25,516 $25,668 $25,036 $27,446 $27,875 $26,996 $23,324
Long-term Liabilities $0 $39,583 $39,166 $38,749 $38,332 $37,915 $37,498 $37,081 $36,664 $36,247 $35,830 $35,413 $34,996
Total Liabilities $21,201 $60,325 $61,622 $62,572 $59,476 $60,571 $63,014 $62,749 $61,700 $63,693 $63,705 $62,409 $58,320
Paid-in Capital $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Retained Earnings ($19,350) $8,807 $8,807 $8,807 $8,807 $8,807 $8,807 $8,807 $8,807 $8,807 $8,807 $8,807 $8,807
Earnings $28,157 ($975) ($3,472) ($3,832) ($3,410) ($2,545) ($710) $1,635 $3,982 $5,683 $7,770 $9,859 $11,950
Total Capital $9,807 $8,832 $6,335 $5,975 $6,397 $7,262 $9,097 $11,442 $13,789 $15,490 $17,577 $19,666 $21,757
Total Liabilities and Capital $31,008 $69,157 $67,957 $68,548 $65,873 $67,833 $72,111 $74,191 $75,489 $79,182 $81,282 $82,075 $80,077
Net Worth $9,807 $8,832 $6,335 $5,975 $6,397 $7,262 $9,097 $11,442 $13,789 $15,490 $17,577 $19,666 $21,757