Elsewares Promotional Products & Packaging
Appendix
Sales Forecast | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Unit Sales | |||||||||||||
Velour Drawstring Pouch | 0% | 7,000 | 7,000 | 15,000 | 25,000 | 25,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 75,000 | 75,000 |
Leather Drawstring Pouch | 0% | 1,500 | 1,500 | 3,000 | 5,000 | 5,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 75,000 | 75,000 |
Round Bottom Pouch | 0% | 2,250 | 2,250 | 3,000 | 3,750 | 3,750 | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 | 11,250 | 11,250 |
Pen/Mug & Eyeglass Bag | 0% | 1,800 | 1,800 | 2,400 | 3,000 | 3,000 | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 | 9,000 | 9,000 |
Metal Lip Eyeglass Bag | 0% | 750 | 750 | 1,000 | 1,250 | 1,250 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 3,750 | 3,750 |
Assorted Jewelry Rolls | 0% | 675 | 675 | 900 | 1,125 | 1,125 | 2,250 | 2,250 | 2,250 | 2,250 | 2,250 | 3,375 | 3,375 |
Satin Bags | 0% | 750 | 750 | 1,000 | 1,250 | 1,250 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 3,375 | 3,375 |
Message Imprinting | 0% | 14,725 | 14,725 | 25,300 | 40,375 | 40,375 | 80,750 | 80,750 | 80,750 | 80,750 | 80,750 | 180,750 | 180,750 |
Die Charges | 0% | 20 | 20 | 25 | 30 | 30 | 50 | 50 | 50 | 50 | 50 | 60 | 60 |
Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Total Unit Sales | 29,470 | 29,470 | 51,625 | 80,780 | 80,780 | 161,550 | 161,550 | 161,550 | 161,550 | 161,550 | 361,560 | 361,560 | |
Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Velour Drawstring Pouch | $0.22 | $0.22 | $0.22 | $0.22 | $0.22 | $0.22 | $0.22 | $0.22 | $0.22 | $0.22 | $0.22 | $0.22 | |
Leather Drawstring Pouch | $0.36 | $0.36 | $0.36 | $0.36 | $0.36 | $0.36 | $0.36 | $0.36 | $0.36 | $0.36 | $0.36 | $0.36 | |
Round Bottom Pouch | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 | $0.80 | |
Pen/Mug & Eyeglass Bag | $0.54 | $0.54 | $0.54 | $0.54 | $0.54 | $0.54 | $0.54 | $0.54 | $0.54 | $0.54 | $0.54 | $0.54 | |
Metal Lip Eyeglass Bag | $0.60 | $0.60 | $0.60 | $0.60 | $0.60 | $0.60 | $0.60 | $0.60 | $0.60 | $0.60 | $0.60 | $0.60 | |
Assorted Jewelry Rolls | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | |
Satin Bags | $0.44 | $0.44 | $0.44 | $0.44 | $0.44 | $0.44 | $0.44 | $0.44 | $0.44 | $0.44 | $0.44 | $0.44 | |
Message Imprinting | $0.10 | $0.10 | $0.10 | $0.10 | $0.10 | $0.10 | $0.10 | $0.10 | $0.10 | $0.10 | $0.10 | $0.10 | |
Die Charges | $37.50 | $37.50 | $37.50 | $37.50 | $37.50 | $37.50 | $37.50 | $37.50 | $37.50 | $37.50 | $37.50 | $37.50 | |
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 | |||||||||||||
Velour Drawstring Pouch | $1,540 | $1,540 | $3,300 | $5,500 | $5,500 | $11,000 | $11,000 | $11,000 | $11,000 | $11,000 | $16,500 | $16,500 | |
Leather Drawstring Pouch | $540 | $540 | $1,080 | $1,800 | $1,800 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $27,000 | $27,000 | |
Round Bottom Pouch | $1,800 | $1,800 | $2,400 | $3,000 | $3,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $9,000 | $9,000 | |
Pen/Mug & Eyeglass Bag | $972 | $972 | $1,296 | $1,620 | $1,620 | $3,240 | $3,240 | $3,240 | $3,240 | $3,240 | $4,860 | $4,860 | |
Metal Lip Eyeglass Bag | $450 | $450 | $600 | $750 | $750 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $2,250 | $2,250 | |
Assorted Jewelry Rolls | $3,375 | $3,375 | $4,500 | $5,625 | $5,625 | $11,250 | $11,250 | $11,250 | $11,250 | $11,250 | $16,875 | $16,875 | |
Satin Bags | $330 | $330 | $440 | $550 | $550 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,485 | $1,485 | |
Message Imprinting | $1,473 | $1,473 | $2,530 | $4,038 | $4,038 | $8,075 | $8,075 | $8,075 | $8,075 | $8,075 | $18,075 | $18,075 | |
Die Charges | $750 | $750 | $938 | $1,125 | $1,125 | $1,875 | $1,875 | $1,875 | $1,875 | $1,875 | $2,250 | $2,250 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Sales | $11,230 | $11,230 | $17,084 | $24,008 | $24,008 | $47,640 | $47,640 | $47,640 | $47,640 | $47,640 | $98,295 | $98,295 | |
Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Velour Drawstring Pouch | 0.00% | $0.11 | $0.11 | $0.11 | $0.11 | $0.11 | $0.11 | $0.11 | $0.11 | $0.11 | $0.11 | $0.11 | $0.11 |
Leather Drawstring Pouch | 0.00% | $0.18 | $0.18 | $0.18 | $0.18 | $0.18 | $0.18 | $0.18 | $0.18 | $0.18 | $0.18 | $0.18 | $0.18 |
Round Bottom Pouch | 0.00% | $0.40 | $0.40 | $0.40 | $0.40 | $0.40 | $0.40 | $0.40 | $0.40 | $0.40 | $0.40 | $0.40 | $0.40 |
Pen/Mug & Eyeglass Bag | 0.00% | $0.27 | $0.27 | $0.27 | $0.27 | $0.27 | $0.27 | $0.27 | $0.27 | $0.27 | $0.27 | $0.27 | $0.27 |
Metal Lip Eyeglass Bag | 0.00% | $0.30 | $0.30 | $0.30 | $0.30 | $0.30 | $0.30 | $0.30 | $0.30 | $0.30 | $0.30 | $0.30 | $0.30 |
Assorted Jewelry Rolls | 0.00% | $2.50 | $2.50 | $2.50 | $2.50 | $2.50 | $2.50 | $2.50 | $2.50 | $2.50 | $2.50 | $2.50 | $2.50 |
Satin Bags | 0.00% | $0.22 | $0.22 | $0.22 | $0.22 | $0.22 | $0.22 | $0.22 | $0.22 | $0.22 | $0.22 | $0.22 | $0.22 |
Message Imprinting | 0.00% | $0.07 | $0.07 | $0.07 | $0.07 | $0.07 | $0.07 | $0.07 | $0.07 | $0.07 | $0.07 | $0.07 | $0.07 |
Die Charges | 0.00% | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.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 | $0.00 |
Direct Cost of Sales | |||||||||||||
Velour Drawstring Pouch | $770 | $770 | $1,650 | $2,750 | $2,750 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $8,250 | $8,250 | |
Leather Drawstring Pouch | $270 | $270 | $540 | $900 | $900 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $13,500 | $13,500 | |
Round Bottom Pouch | $900 | $900 | $1,200 | $1,500 | $1,500 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $4,500 | $4,500 | |
Pen/Mug & Eyeglass Bag | $486 | $486 | $648 | $810 | $810 | $1,620 | $1,620 | $1,620 | $1,620 | $1,620 | $2,430 | $2,430 | |
Metal Lip Eyeglass Bag | $225 | $225 | $300 | $375 | $375 | $750 | $750 | $750 | $750 | $750 | $1,125 | $1,125 | |
Assorted Jewelry Rolls | $1,688 | $1,688 | $2,250 | $2,813 | $2,813 | $5,625 | $5,625 | $5,625 | $5,625 | $5,625 | $8,438 | $8,438 | |
Satin Bags | $165 | $165 | $220 | $275 | $275 | $550 | $550 | $550 | $550 | $550 | $743 | $743 | |
Message Imprinting | $1,031 | $1,031 | $1,771 | $2,826 | $2,826 | $5,653 | $5,653 | $5,653 | $5,653 | $5,653 | $12,653 | $12,653 | |
Die Charges | $500 | $500 | $625 | $750 | $750 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,500 | $1,500 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $6,034 | $6,034 | $9,204 | $12,999 | $12,999 | $25,748 | $25,748 | $25,748 | $25,748 | $25,748 | $53,138 | $53,138 |
Personnel Plan | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Production Personnel | |||||||||||||
Imprint | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $2,000 | $2,000 | |
Shipping | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $2,000 | $2,000 | |
Name or Title or Group | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $4,000 | $4,000 | |
Sales and Marketing Personnel | |||||||||||||
Marvin | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
Sales Reps | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Name or Title or Group | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | |
General and Administrative Personnel | |||||||||||||
Customer Service | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Name or Title or Group | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Name or Title or Group | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Other Personnel | |||||||||||||
Name or Title or Group | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Name or Title or Group | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Name or Title or Group | $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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Total Payroll | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $11,500 | $11,500 |
Pro Forma Profit and Loss | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Sales | $11,230 | $11,230 | $17,084 | $24,008 | $24,008 | $47,640 | $47,640 | $47,640 | $47,640 | $47,640 | $98,295 | $98,295 | |
Direct Cost of Sales | $6,034 | $6,034 | $9,204 | $12,999 | $12,999 | $25,748 | $25,748 | $25,748 | $25,748 | $25,748 | $53,138 | $53,138 | |
Production Payroll | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $4,000 | $4,000 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $8,034 | $8,034 | $11,204 | $14,999 | $14,999 | $27,748 | $27,748 | $27,748 | $27,748 | $27,748 | $57,138 | $57,138 | |
Gross Margin | $3,195 | $3,195 | $5,880 | $9,009 | $9,009 | $19,893 | $19,893 | $19,893 | $19,893 | $19,893 | $41,158 | $41,158 | |
Gross Margin % | 28.45% | 28.45% | 34.42% | 37.52% | 37.52% | 41.76% | 41.76% | 41.76% | 41.76% | 41.76% | 41.87% | 41.87% | |
Operating Expenses | |||||||||||||
Sales and Marketing Expenses | |||||||||||||
Sales and Marketing Payroll | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | |
Advertising/Promotion | $0 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
Travel | $300 | $300 | $2,000 | $500 | $4,000 | $5,000 | $500 | $300 | $500 | $4,000 | $500 | $1,000 | |
Miscellaneous | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Other Sales and Marketing Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Sales and Marketing Expenses | $5,300 | $9,300 | $11,000 | $9,500 | $13,000 | $14,000 | $9,500 | $9,300 | $9,500 | $13,000 | $9,500 | $10,000 | |
Sales and Marketing % | 47.20% | 82.82% | 64.39% | 39.57% | 54.15% | 29.39% | 19.94% | 19.52% | 19.94% | 27.29% | 9.66% | 10.17% | |
General and Administrative Expenses | |||||||||||||
General and Administrative Payroll | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Marketing/Promotion | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Rent | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Utilities | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | |
Insurance | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Payroll Taxes | 20% | $0 | $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 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | |
General and Administrative % | 87.27% | 87.27% | 57.37% | 40.82% | 40.82% | 20.57% | 20.57% | 20.57% | 20.57% | 20.57% | 9.97% | 9.97% | |
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 | |
Other Expenses | $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 | $15,100 | $19,100 | $20,800 | $19,300 | $22,800 | $23,800 | $19,300 | $19,100 | $19,300 | $22,800 | $19,300 | $19,800 | |
Profit Before Interest and Taxes | ($11,905) | ($15,905) | ($14,921) | ($10,291) | ($13,791) | ($3,908) | $593 | $793 | $593 | ($2,908) | $21,858 | $21,358 | |
EBITDA | ($11,905) | ($15,905) | ($14,921) | ($10,291) | ($13,791) | ($3,908) | $593 | $793 | $593 | ($2,908) | $21,858 | $21,358 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $417 | $625 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($11,905) | ($15,905) | ($14,921) | ($10,291) | ($13,791) | ($3,908) | $593 | $793 | $593 | ($2,908) | $21,441 | $20,733 | |
Net Profit/Sales | -106.01% | -141.63% | -87.34% | -42.87% | -57.45% | -8.20% | 1.24% | 1.66% | 1.24% | -6.10% | 21.81% | 21.09% |
Pro Forma Cash Flow | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Cash from Receivables | $0 | $374 | $11,230 | $11,425 | $17,314 | $24,008 | $24,795 | $47,640 | $47,640 | $47,640 | $47,640 | $49,329 | |
Subtotal Cash from Operations | $0 | $374 | $11,230 | $11,425 | $17,314 | $24,008 | $24,795 | $47,640 | $47,640 | $47,640 | $47,640 | $49,329 | |
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 | $50,000 | $25,000 | |
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 | $50,000 | $0 | $50,000 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $0 | $374 | $11,230 | $61,425 | $17,314 | $74,008 | $24,795 | $47,640 | $47,640 | $47,640 | $97,640 | $74,329 | |
Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Expenditures from Operations | |||||||||||||
Cash Spending | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $11,500 | $11,500 | |
Bill Payments | $253 | $7,733 | $11,657 | $13,536 | $20,634 | $29,224 | $55,454 | $37,541 | $37,354 | $37,664 | $42,862 | $94,502 | |
Subtotal Spent on Operations | $9,753 | $17,233 | $21,157 | $23,036 | $30,134 | $38,724 | $64,954 | $47,041 | $46,854 | $47,164 | $54,362 | $106,002 | |
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 | $9,753 | $17,233 | $21,157 | $23,036 | $30,134 | $38,724 | $64,954 | $47,041 | $46,854 | $47,164 | $54,362 | $106,002 | |
Net Cash Flow | ($9,753) | ($16,859) | ($9,927) | $38,389 | ($12,820) | $35,283 | ($40,158) | $599 | $786 | $476 | $43,278 | ($31,674) | |
Cash Balance | $107,647 | $90,788 | $80,860 | $119,249 | $106,430 | $141,713 | $101,554 | $102,153 | $102,939 | $103,415 | $146,693 | $115,019 |
Pro Forma Balance Sheet | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $117,400 | $107,647 | $90,788 | $80,860 | $119,249 | $106,430 | $141,713 | $101,554 | $102,153 | $102,939 | $103,415 | $146,693 | $115,019 |
Accounts Receivable | $0 | $11,230 | $22,085 | $27,939 | $40,522 | $47,215 | $70,847 | $93,692 | $93,692 | $93,692 | $93,692 | $144,347 | $193,314 |
Inventory | $40,000 | $33,966 | $27,932 | $18,728 | $14,299 | $14,299 | $28,322 | $28,322 | $28,322 | $28,322 | $28,322 | $58,451 | $58,451 |
Other Current Assets | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 |
Total Current Assets | $177,400 | $172,842 | $160,804 | $147,527 | $194,070 | $187,943 | $260,882 | $243,568 | $244,168 | $244,953 | $245,429 | $369,491 | $386,784 |
Long-term Assets | |||||||||||||
Long-term Assets | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
Total Assets | $182,400 | $177,842 | $165,804 | $152,527 | $199,070 | $192,943 | $265,882 | $248,568 | $249,168 | $249,953 | $250,429 | $374,491 | $391,784 |
Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Current Liabilities | |||||||||||||
Accounts Payable | $0 | $7,347 | $11,213 | $12,857 | $19,691 | $27,355 | $54,202 | $36,296 | $36,103 | $36,296 | $39,679 | $92,300 | $63,860 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $50,000 | $75,000 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $0 | $7,347 | $11,213 | $12,857 | $19,691 | $27,355 | $54,202 | $36,296 | $36,103 | $36,296 | $39,679 | $142,300 | $138,860 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $7,347 | $11,213 | $12,857 | $19,691 | $27,355 | $54,202 | $36,296 | $36,103 | $36,296 | $39,679 | $142,300 | $138,860 |
Paid-in Capital | $200,000 | $200,000 | $200,000 | $200,000 | $250,000 | $250,000 | $300,000 | $300,000 | $300,000 | $300,000 | $300,000 | $300,000 | $300,000 |
Retained Earnings | ($17,600) | ($17,600) | ($17,600) | ($17,600) | ($17,600) | ($17,600) | ($17,600) | ($17,600) | ($17,600) | ($17,600) | ($17,600) | ($17,600) | ($17,600) |
Earnings | $0 | ($11,905) | ($27,810) | ($42,730) | ($53,021) | ($66,813) | ($70,720) | ($70,128) | ($69,335) | ($68,743) | ($71,650) | ($50,209) | ($29,477) |
Total Capital | $182,400 | $170,495 | $154,591 | $139,670 | $179,379 | $165,588 | $211,680 | $212,273 | $213,065 | $213,658 | $210,750 | $232,191 | $252,923 |
Total Liabilities and Capital | $182,400 | $177,842 | $165,804 | $152,527 | $199,070 | $192,943 | $265,882 | $248,568 | $249,168 | $249,953 | $250,429 | $374,491 | $391,784 |
Net Worth | $182,400 | $170,495 | $154,590 | $139,670 | $179,379 | $165,587 | $211,680 | $212,272 | $213,065 | $213,657 | $210,750 | $232,191 | $252,923 |