Interior Views LLC home decoration fabrics business plan appendix. Interior Views LLC is a retailer/e-tailer of home decorator fabrics and accessories.

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

Get the Bplans newsletter:

Expert business tips and advice delivered weekly.

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
Interior Views LLC home decoration fabrics business plan appendix. Interior Views LLC is a retailer/e-tailer of home decorator fabrics and accessories.
\n