Our biggest savings of the year
Cutting Edge Drapery
Appendix
Sales Forecast | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Unit Sales | |||||||||||||
Draperies | 0% | 15 | 15 | 15 | 15 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 |
Curtains | 0% | 20 | 20 | 20 | 20 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 |
Swags | 0% | 11 | 11 | 11 | 11 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 |
Jabots | 0% | 10 | 10 | 10 | 10 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 |
Slip covers | 0% | 20 | 20 | 20 | 20 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 |
Roman shades | 0% | 8 | 8 | 8 | 8 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |
Balloon shades | 0% | 11 | 11 | 11 | 11 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 |
Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Total Unit Sales | 95 | 95 | 95 | 95 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | 111 | |
Unit Prices | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Draperies | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | |
Curtains | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | |
Swags | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | $150.00 | |
Jabots | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | |
Slip covers | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | |
Roman shades | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | |
Balloon shades | $285.00 | $285.00 | $285.00 | $285.00 | $285.00 | $285.00 | $285.00 | $285.00 | $285.00 | $285.00 | $285.00 | $285.00 | |
Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
Sales | |||||||||||||
Draperies | $3,750 | $3,750 | $3,750 | $3,750 | $4,250 | $4,250 | $4,250 | $4,250 | $4,250 | $4,250 | $4,250 | $4,250 | |
Curtains | $3,000 | $3,000 | $3,000 | $3,000 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | |
Swags | $1,650 | $1,650 | $1,650 | $1,650 | $1,950 | $1,950 | $1,950 | $1,950 | $1,950 | $1,950 | $1,950 | $1,950 | |
Jabots | $2,000 | $2,000 | $2,000 | $2,000 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | |
Slip covers | $7,000 | $7,000 | $7,000 | $7,000 | $7,700 | $7,700 | $7,700 | $7,700 | $7,700 | $7,700 | $7,700 | $7,700 | |
Roman shades | $1,600 | $1,600 | $1,600 | $1,600 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Balloon shades | $3,135 | $3,135 | $3,135 | $3,135 | $3,705 | $3,705 | $3,705 | $3,705 | $3,705 | $3,705 | $3,705 | $3,705 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Sales | $22,135 | $22,135 | $22,135 | $22,135 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | |
Direct Unit Costs | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Draperies | 0.00% | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 |
Curtains | 0.00% | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 |
Swags | 0.00% | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 |
Jabots | 0.00% | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 |
Slip covers | 0.00% | $42.00 | $42.00 | $42.00 | $42.00 | $42.00 | $42.00 | $42.00 | $42.00 | $42.00 | $42.00 | $42.00 | $42.00 |
Roman shades | 0.00% | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 |
Balloon shades | 0.00% | $34.20 | $34.20 | $34.20 | $34.20 | $34.20 | $34.20 | $34.20 | $34.20 | $34.20 | $34.20 | $34.20 | $34.20 |
Other | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Direct Cost of Sales | |||||||||||||
Draperies | $450 | $450 | $450 | $450 | $510 | $510 | $510 | $510 | $510 | $510 | $510 | $510 | |
Curtains | $360 | $360 | $360 | $360 | $432 | $432 | $432 | $432 | $432 | $432 | $432 | $432 | |
Swags | $198 | $198 | $198 | $198 | $234 | $234 | $234 | $234 | $234 | $234 | $234 | $234 | |
Jabots | $240 | $240 | $240 | $240 | $288 | $288 | $288 | $288 | $288 | $288 | $288 | $288 | |
Slip covers | $840 | $840 | $840 | $840 | $924 | $924 | $924 | $924 | $924 | $924 | $924 | $924 | |
Roman shades | $192 | $192 | $192 | $192 | $240 | $240 | $240 | $240 | $240 | $240 | $240 | $240 | |
Balloon shades | $376 | $376 | $376 | $376 | $445 | $445 | $445 | $445 | $445 | $445 | $445 | $445 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $2,656 | $2,656 | $2,656 | $2,656 | $3,073 | $3,073 | $3,073 | $3,073 | $3,073 | $3,073 | $3,073 | $3,073 |
Personnel Plan | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Production Personnel | |||||||||||||
Stitcher 1 | $1,284 | $1,284 | $1,284 | $1,712 | $1,712 | $1,712 | $1,712 | $1,712 | $1,712 | $1,712 | $1,712 | $1,712 | |
Stitcher 2 | $1,150 | $1,150 | $1,150 | $1,533 | $1,533 | $1,533 | $1,533 | $1,533 | $1,533 | $1,533 | $1,533 | $1,533 | |
Stitcher 3 | $1,442 | $1,442 | $1,442 | $1,442 | $1,442 | $1,442 | $1,442 | $1,442 | $1,442 | $1,442 | $1,442 | $1,442 | |
Stitcher 4 | $1,363 | $1,363 | $1,363 | $1,363 | $1,363 | $1,363 | $1,363 | $1,363 | $1,363 | $1,363 | $1,363 | $1,363 | |
Supervisor | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
New stitcher | $0 | $0 | $0 | $0 | $0 | $0 | $1,022 | $1,022 | $1,022 | $1,022 | $1,022 | $1,022 | |
Subtotal | $7,238 | $7,238 | $7,238 | $8,050 | $8,050 | $8,050 | $9,072 | $9,072 | $9,072 | $9,072 | $9,072 | $9,072 | |
Sales and Marketing Personnel | |||||||||||||
Owner | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
General and Administrative Personnel | |||||||||||||
Administrative assistant | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | |
Other Personnel | |||||||||||||
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 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
Total Payroll | $13,198 | $13,198 | $13,198 | $14,010 | $14,010 | $14,010 | $15,032 | $15,032 | $15,032 | $15,032 | $15,032 | $15,032 |
Pro Forma Profit and Loss | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | $22,135 | $22,135 | $22,135 | $22,135 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | |
Direct Cost of Sales | $2,656 | $2,656 | $2,656 | $2,656 | $3,073 | $3,073 | $3,073 | $3,073 | $3,073 | $3,073 | $3,073 | $3,073 | |
Production Payroll | $7,238 | $7,238 | $7,238 | $8,050 | $8,050 | $8,050 | $9,072 | $9,072 | $9,072 | $9,072 | $9,072 | $9,072 | |
Misc operating expenses | $316 | $316 | $316 | $316 | $316 | $316 | $316 | $316 | $316 | $316 | $316 | $316 | |
Total Cost of Sales | $10,211 | $10,211 | $10,211 | $11,022 | $11,438 | $11,438 | $12,461 | $12,461 | $12,461 | $12,461 | $12,461 | $12,461 | |
Gross Margin | $11,924 | $11,924 | $11,924 | $11,113 | $14,167 | $14,167 | $13,144 | $13,144 | $13,144 | $13,144 | $13,144 | $13,144 | |
Gross Margin % | 53.87% | 53.87% | 53.87% | 50.21% | 55.33% | 55.33% | 51.34% | 51.34% | 51.34% | 51.34% | 51.34% | 51.34% | |
Operating Expenses | |||||||||||||
Sales and Marketing Expenses | |||||||||||||
Sales and Marketing Payroll | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
Advertising/Promotion | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Car insurance/depreciation/maint./fuel | $560 | $560 | $560 | $560 | $560 | $560 | $560 | $560 | $560 | $560 | $560 | $560 | |
Miscellaneous | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Sales and Marketing Expenses | $6,560 | $6,560 | $6,560 | $6,560 | $6,560 | $6,560 | $6,560 | $6,560 | $6,560 | $6,560 | $6,560 | $6,560 | |
Sales and Marketing % | 29.64% | 29.64% | 29.64% | 29.64% | 25.62% | 25.62% | 25.62% | 25.62% | 25.62% | 25.62% | 25.62% | 25.62% | |
General and Administrative Expenses | |||||||||||||
General and Administrative Payroll | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | |
Sales and Marketing and Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $166 | $166 | $167 | $166 | $166 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | |
Accounting/consultants | $3,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Electricity | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Heat | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Postage | $42 | $42 | $42 | $42 | $42 | $42 | $42 | $42 | $42 | $42 | $40 | $40 | |
Telephone | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Dues and Subscriptions | $90 | $90 | $90 | $90 | $90 | $90 | $90 | $90 | $90 | $90 | $90 | $90 | |
Bank Charges | $17 | $17 | $17 | $17 | $17 | $17 | $17 | $17 | $17 | $17 | $17 | $17 | |
Supplies/misc office expense | $84 | $84 | $84 | $84 | $84 | $84 | $84 | $84 | $84 | $84 | $80 | $80 | |
Rent | $897 | $897 | $897 | $897 | $897 | $897 | $897 | $897 | $897 | $897 | $897 | $897 | |
Payroll Taxes | 13% | $1,037 | $1,037 | $1,037 | $1,140 | $1,140 | $1,140 | $1,269 | $1,269 | $1,269 | $1,269 | $1,269 | $1,269 |
Other General and Administrative Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total General and Administrative Expenses | $6,743 | $3,743 | $3,744 | $3,846 | $3,846 | $3,847 | $3,976 | $3,976 | $3,976 | $3,976 | $3,970 | $3,970 | |
General and Administrative % | 30.46% | 16.91% | 16.91% | 17.37% | 15.02% | 15.02% | 15.53% | 15.53% | 15.53% | 15.53% | 15.50% | 15.50% | |
Other Expenses: | |||||||||||||
Other Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Consultants | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Contract/Consultants | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
Total Operating Expenses | $13,303 | $10,303 | $10,304 | $10,406 | $10,406 | $10,407 | $10,536 | $10,536 | $10,536 | $10,536 | $10,530 | $10,530 | |
Profit Before Interest and Taxes | ($1,379) | $1,621 | $1,620 | $707 | $3,761 | $3,760 | $2,608 | $2,608 | $2,608 | $2,608 | $2,614 | $2,614 | |
EBITDA | ($1,213) | $1,787 | $1,787 | $873 | $3,927 | $3,927 | $2,775 | $2,775 | $2,775 | $2,775 | $2,781 | $2,781 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | ($414) | $567 | $567 | $248 | $1,316 | $1,316 | $913 | $913 | $913 | $913 | $915 | $915 | |
Net Profit | ($965) | $1,054 | $1,053 | $460 | $2,445 | $2,444 | $1,695 | $1,695 | $1,695 | $1,695 | $1,699 | $1,699 | |
Net Profit/Sales | -4.36% | 4.76% | 4.76% | 2.08% | 9.55% | 9.55% | 6.62% | 6.62% | 6.62% | 6.62% | 6.64% | 6.64% |
Pro Forma Cash Flow | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $22,135 | $22,135 | $22,135 | $22,135 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | |
Subtotal Cash from Operations | $22,135 | $22,135 | $22,135 | $22,135 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | |
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 | $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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $22,135 | $22,135 | $22,135 | $22,135 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | $25,605 | |
Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Expenditures from Operations | |||||||||||||
Cash Spending | $13,198 | $13,198 | $13,198 | $14,010 | $14,010 | $14,010 | $15,032 | $15,032 | $15,032 | $15,032 | $15,032 | $15,032 | |
Bill Payments | $389 | $11,526 | $7,717 | $7,709 | $7,564 | $9,427 | $8,975 | $8,711 | $8,711 | $8,711 | $8,710 | $8,707 | |
Subtotal Spent on Operations | $13,587 | $24,725 | $20,915 | $21,719 | $21,574 | $23,437 | $24,007 | $23,743 | $23,743 | $23,743 | $23,742 | $23,739 | |
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 | $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 | $13,587 | $24,725 | $20,915 | $21,719 | $21,574 | $23,437 | $24,007 | $23,743 | $23,743 | $23,743 | $23,742 | $23,739 | |
Net Cash Flow | $8,548 | ($2,590) | $1,220 | $416 | $4,031 | $2,168 | $1,598 | $1,862 | $1,862 | $1,862 | $1,863 | $1,866 | |
Cash Balance | $10,548 | $7,958 | $9,178 | $9,595 | $13,626 | $15,794 | $17,391 | $19,254 | $21,116 | $22,979 | $24,841 | $26,708 |