Grapevine Country Gifts home, garden gifts online business plan appendix. Grapevine Country Gifts offers home and garden accessories online and at local craft shows. The owner is seeking funding to renovate her storage space for inventory management.

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
Grapevine Country Gifts home, garden gifts online business plan appendix. Grapevine Country Gifts offers home and garden accessories online and at local craft shows. The owner is seeking funding to renovate her storage space for inventory management.