Interior Views LLC

Start your own business plan »

Home Decoration Fabrics Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Direct Retail Sales 0% $36,400 $25,000 $28,000 $30,000 $34,000 $29,200 $22,000 $23,000 $24,000 $32,000 $28,000 $24,000
Consignment Sales 0% $1,000 $800 $1,000 $1,200 $1,200 $1,000 $900 $900 $1,000 $1,200 $1,300 $1,000
Sub-lease Revenue 0% $405 $405 $525 $405 $405 $525 $405 $405 $525 $405 $405 $525
eBay Sales-Fabric 0% $3,900 $4,875 $5,525 $5,850 $7,150 $8,125 $9,425 $10,725 $11,050 $11,375 $11,700 $12,025
eBay Sales-Products 0% $250 $375 $500 $700 $875 $1,000 $1,075 $1,125 $1,200 $1,250 $1,325 $1,375
eBay Shipping and Handling 0% $700 $900 $1,050 $1,180 $1,450 $1,650 $1,880 $2,100 $2,180 $2,250 $2,330 $2,400
Other 0% $240 $260 $280 $300 $320 $340 $360 $380 $400 $420 $440 $400
Total Sales $42,895 $32,615 $36,880 $39,635 $45,400 $41,840 $36,045 $38,635 $40,355 $48,900 $45,500 $41,725
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Direct Retail Sales $16,380 $11,250 $12,600 $13,500 $15,300 $13,140 $9,900 $10,350 $10,800 $14,400 $12,600 $10,800
Consignment Sales $30 $24 $30 $36 $36 $30 $27 $27 $30 $36 $39 $30
Sub-lease Revenue $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
eBay Sales-Fabric $1,950 $2,438 $2,763 $2,925 $3,575 $4,063 $4,713 $5,363 $5,525 $5,688 $5,850 $6,013
eBay Sales-Products $125 $188 $250 $350 $438 $500 $538 $563 $600 $625 $683 $688
Shipping and Handling $525 $675 $788 $885 $1,088 $1,238 $1,410 $1,575 $1,635 $1,688 $1,748 $1,800
Other $120 $130 $140 $150 $160 $170 $180 $190 $200 $210 $220 $200
Subtotal Direct Cost of Sales $19,130 $14,705 $16,571 $17,846 $20,597 $19,141 $16,768 $18,068 $18,790 $22,647 $21,140 $19,531
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 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50%
Long-term Interest Rate 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50%
Tax Rate 30.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.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 $42,895 $32,615 $36,880 $39,635 $45,400 $41,840 $36,045 $38,635 $40,355 $48,900 $45,500 $41,725
Direct Cost of Sales $19,130 $14,705 $16,571 $17,846 $20,597 $19,141 $16,768 $18,068 $18,790 $22,647 $21,140 $19,531
Production Payroll $260 $260 $760 $1,060 $1,100 $1,142 $1,226 $1,272 $1,321 $1,372 $1,426 $1,482
Final Value Fees 8.00% $388 $492 $566 $618 $758 $862 $990 $1,116 $1,154 $1,190 $1,228 $1,264
Item Fees $0.04 $194 $246 $283 $309 $379 $431 $495 $558 $577 $595 $614 $632
PayPal Fees 2.90% $141 $178 $205 $224 $275 $312 $359 $405 $418 $431 $445 $458
Other $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Total Cost of Sales $20,613 $16,381 $18,885 $20,557 $23,609 $22,388 $20,338 $21,919 $22,760 $26,735 $25,353 $23,867
Gross Margin $22,282 $16,234 $17,995 $19,078 $21,791 $19,452 $15,707 $16,716 $17,595 $22,165 $20,147 $17,858
Gross Margin % 51.95% 49.77% 48.79% 48.13% 48.00% 46.49% 43.58% 43.27% 43.60% 45.33% 44.28% 42.80%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $1,690 $1,690 $1,790 $1,840 $1,690 $1,690 $1,690 $1,690 $1,690 $1,690 $1,690 $1,690
Advertising/Promotion $250 $2,150 $750 $750 $1,950 $750 $750 $750 $1,950 $750 $750 $750
Travel $0 $0 $1,250 $0 $0 $0 $0 $0 $0 $900 $800 $100
Online Ramp-up Marketing $1,000 $1,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
eBay Promotion $100 $100 $150 $200 $100 $100 $100 $150 $150 $200 $200 $150
Miscellaneous $340 $220 $220 $340 $220 $220 $340 $220 $220 $340 $220 $220
Total Sales and Marketing Expenses $3,380 $5,160 $4,160 $3,130 $3,960 $2,760 $2,880 $2,810 $4,010 $3,880 $3,660 $2,910
Sales and Marketing % 7.88% 15.82% 11.28% 7.90% 8.72% 6.60% 7.99% 7.27% 9.94% 7.93% 8.04% 6.97%
General and Administrative Expenses
General and Administrative Payroll $2,960 $2,920 $2,980 $2,980 $2,980 $3,020 $3,020 $3,020 $3,000 $3,000 $3,000 $2,960
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $195 $195 $195 $195 $195 $195 $195 $195 $195 $195 $195 $5
eBay Store Fees $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Internet Access/Wesite Hosting $65 $65 $65 $65 $65 $65 $65 $65 $65 $65 $65 $65
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $240 $235 $230 $225 $220 $215 $215 $215 $220 $225 $230 $235
Insurance $212 $212 $212 $212 $212 $212 $212 $212 $212 $212 $212 $212
Rent $2,848 $2,848 $2,848 $2,848 $2,848 $2,848 $2,848 $2,848 $2,848 $2,848 $2,848 $2,848
Payroll Taxes 15% $668 $662 $671 $671 $671 $677 $677 $677 $674 $674 $674 $668
Legal Fees for eBay Store Start-up $1,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other General and Administrative Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $8,738 $7,187 $7,251 $7,246 $7,241 $7,282 $7,282 $7,282 $7,264 $7,269 $7,274 $7,043
General and Administrative % 20.37% 22.03% 19.66% 18.28% 15.95% 17.40% 20.20% 18.85% 18.00% 14.86% 15.99% 16.88%
Other Expenses:
Other Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Consultants - Website Design $1,000 $1,000 $500 $0 $0 $1,000 $0 $0 $1,000 $0 $0 $500
Contract/Consultants $36 $36 $36 $816 $36 $36 $36 $36 $36 $36 $36 $36
Total Other Expenses $1,036 $1,036 $536 $816 $36 $1,036 $36 $36 $1,036 $36 $36 $536
Other % 2.42% 3.18% 1.45% 2.06% 0.08% 2.48% 0.10% 0.09% 2.57% 0.07% 0.08% 1.28%
Total Operating Expenses $13,154 $13,383 $11,947 $11,192 $11,237 $11,078 $10,198 $10,128 $12,310 $11,185 $10,970 $10,489
Profit Before Interest and Taxes $9,129 $2,852 $6,049 $7,887 $10,555 $8,375 $5,510 $6,589 $5,286 $10,981 $9,178 $7,370
EBITDA $9,324 $3,047 $6,244 $8,082 $10,750 $8,570 $5,705 $6,784 $5,481 $11,176 $9,373 $7,375
Interest Expense $178 $182 $186 $190 $195 $199 $203 $207 $211 $215 $219 $223
Taxes Incurred $2,685 $747 $1,641 $2,155 $2,901 $2,289 $1,486 $1,787 $1,421 $3,014 $2,508 $2,001
Net Profit $6,265 $1,922 $4,221 $5,541 $7,459 $5,887 $3,821 $4,595 $3,654 $7,751 $6,450 $5,145
Net Profit/Sales 14.61% 5.89% 11.44% 13.98% 16.43% 14.07% 10.60% 11.89% 9.05% 15.85% 14.18% 12.33%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $42,895 $32,615 $36,880 $39,635 $45,400 $41,840 $36,045 $38,635 $40,355 $48,900 $45,500 $41,725
Subtotal Cash from Operations $42,895 $32,615 $36,880 $39,635 $45,400 $41,840 $36,045 $38,635 $40,355 $48,900 $45,500 $41,725
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 $1,214 $1,214 $1,214 $1,214 $1,214 $1,214 $1,214 $1,214 $1,214 $1,214 $1,214 $1,214
New Other Liabilities (interest-free) $102 $102 $102 $102 $102 $102 $102 $102 $102 $102 $102 $102
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 $59,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $103,211 $33,931 $38,196 $40,951 $46,716 $43,156 $37,361 $39,951 $41,671 $50,216 $46,816 $43,041
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $4,910 $4,870 $5,530 $5,880 $5,770 $5,852 $5,936 $5,982 $6,011 $6,062 $6,116 $6,132
Bill Payments $8,530 $15,729 $10,905 $10,357 $10,213 $11,358 $10,717 $9,587 $17,657 $31,468 $38,498 $31,152
Subtotal Spent on Operations $13,440 $20,599 $16,435 $16,237 $15,983 $17,210 $16,653 $15,569 $23,668 $37,530 $44,614 $37,284
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 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700
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 $7,500 $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 $21,640 $21,299 $17,135 $16,937 $16,683 $17,910 $17,353 $16,269 $24,368 $38,230 $45,314 $37,984
Net Cash Flow $81,571 $12,632 $21,061 $24,014 $30,033 $25,246 $20,008 $23,682 $17,303 $11,986 $1,502 $5,057
Cash Balance $82,771 $95,403 $116,465 $140,479 $170,512 $195,757 $215,765 $239,447 $256,750 $268,736 $270,238 $275,295
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $1,200 $82,771 $95,403 $116,465 $140,479 $170,512 $195,757 $215,765 $239,447 $256,750 $268,736 $270,238 $275,295
Inventory $150,000 $134,370 $119,665 $103,094 $85,248 $64,651 $45,510 $28,742 $18,068 $18,790 $22,647 $21,140 $19,531
Other Current Assets $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300
Total Current Assets $153,500 $219,441 $217,368 $221,859 $228,027 $237,463 $243,567 $246,807 $259,815 $277,840 $293,683 $293,678 $297,126
Long-term Assets
Long-term Assets $4,200 $11,700 $11,700 $11,700 $11,700 $11,700 $11,700 $11,700 $11,700 $11,700 $11,700 $11,700 $11,700
Accumulated Depreciation $2,050 $2,245 $2,440 $2,635 $2,830 $3,025 $3,220 $3,415 $3,610 $3,805 $4,000 $4,195 $4,200
Total Long-term Assets $2,150 $9,455 $9,260 $9,065 $8,870 $8,675 $8,480 $8,285 $8,090 $7,895 $7,700 $7,505 $7,500
Total Assets $155,650 $228,896 $226,628 $230,924 $236,897 $246,138 $252,047 $255,092 $267,905 $285,735 $301,383 $301,183 $304,626
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $8,000 $15,365 $10,559 $10,018 $9,834 $11,000 $10,406 $9,014 $16,616 $30,177 $37,457 $30,191 $27,872
Current Borrowing $22,000 $22,514 $23,028 $23,542 $24,056 $24,570 $25,084 $25,598 $26,112 $26,626 $27,140 $27,654 $28,168
Other Current Liabilities $1,150 $1,252 $1,354 $1,456 $1,558 $1,660 $1,762 $1,864 $1,966 $2,068 $2,170 $2,272 $2,374
Subtotal Current Liabilities $31,150 $39,131 $34,941 $35,016 $35,448 $37,230 $37,252 $36,476 $44,694 $58,871 $66,767 $60,117 $58,414
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $31,150 $39,131 $34,941 $35,016 $35,448 $37,230 $37,252 $36,476 $44,694 $58,871 $66,767 $60,117 $58,414
Paid-in Capital $0 $59,000 $59,000 $59,000 $59,000 $59,000 $59,000 $59,000 $59,000 $59,000 $59,000 $59,000 $59,000
Retained Earnings $112,500 $124,500 $124,500 $124,500 $124,500 $124,500 $124,500 $124,500 $124,500 $124,500 $124,500 $124,500 $124,500
Earnings $12,000 $6,265 $8,187 $12,408 $17,949 $25,408 $31,295 $35,116 $39,711 $43,364 $51,116 $57,566 $62,711
Total Capital $124,500 $189,765 $191,687 $195,908 $201,449 $208,908 $214,795 $218,616 $223,211 $226,864 $234,616 $241,066 $246,211
Total Liabilities and Capital $155,650 $228,896 $226,628 $230,924 $236,897 $246,138 $252,047 $255,092 $267,905 $285,735 $301,383 $301,183 $304,626
Net Worth $124,500 $189,765 $191,687 $195,908 $201,449 $208,908 $214,795 $218,616 $223,211 $226,864 $234,616 $241,066 $246,211
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Production Personnel
Pharis - Sales Fulfillment $260 $260 $260 $260 $260 $260 $300 $300 $300 $300 $300 $300
eBay Shipper - Sales Fulfillment $0 $0 $500 $800 $840 $882 $926 $972 $1,021 $1,072 $1,126 $1,182
Name or Title $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $260 $260 $760 $1,060 $1,100 $1,142 $1,226 $1,272 $1,321 $1,372 $1,426 $1,482
Sales and Marketing Personnel
Kandi - Design Consultant $630 $630 $630 $630 $630 $630 $630 $630 $630 $630 $630 $630
Cheryl - Design Consultant $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Pharis - Design Consultant $260 $260 $260 $260 $260 $260 $260 $260 $260 $260 $260 $260
Doug - Online Marketing Implementation $200 $200 $300 $350 $200 $200 $200 $200 $200 $200 $200 $200
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $1,690 $1,690 $1,790 $1,840 $1,690 $1,690 $1,690 $1,690 $1,690 $1,690 $1,690 $1,690
General and Administrative Personnel
Judy - Owner (Draw against LLC) $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Julie - Manager $840 $800 $860 $860 $860 $900 $900 $900 $880 $880 $880 $840
Robin - Bookkeeper $120 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $2,960 $2,920 $2,980 $2,980 $2,980 $3,020 $3,020 $3,020 $3,000 $3,000 $3,000 $2,960
Other Personnel
Name or title $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or title $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or title $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 7 7 8 8 8 8 8 8 8 8 8 8
Total Payroll $4,910 $4,870 $5,530 $5,880 $5,770 $5,852 $5,936 $5,982 $6,011 $6,062 $6,116 $6,132