Business Plan - financial statement
S.SHARON
financial_planning.xlsxIncome Statement
| Particulars | Year 1 | |
| Sales | 1000 | |
| Less: Cost of Goods Sold | 107 | |
| Gross Margin | 893 | |
| Less: Operating Expenses | ERROR:#REF! | |
| Profit Before Interest and Taxes | ERROR:#REF! | |
| Less: Interest Expense | 5 | |
| Income Before Interest | ERROR:#REF! | |
| Less: Taxes Incurred @35% | ERROR:#REF! | |
| Net Profit After Interest and Taxes | ERROR:#REF! |
COGS
| Schedule of Cost of Goods Sold | |||||||||
| Jan 1 to Dec 31, 2014 | |||||||||
| Year 1 | Year 2 | Year 3 | |||||||
| Beginning Inventory | 100 | 100 | 100 | ||||||
| Add: Purchases | 25 | 25 | 25 | ||||||
| Freight-in | 50 | 50 | 50 | ||||||
| Cost of Purchases | 75 | 75 | 75 | ||||||
| Less: Purchase Discounts | 5 | 5 | 5 | ||||||
| Purchase returns and allowances | 3 | 3 | 3 | ||||||
| Net Purchases | 67 | 67 | 67 | ||||||
| Cost of Goods Available for sale | 167 | 167 | 167 | ||||||
| Less: Ending Inventory | 60 | 60 | 60 | ||||||
| Cost of Goods Sold | 107 | 107 | 107 |
Operating Expenses
| Operating Expenses | ||||||||||||||
| Details | Jan | Feb | March | April | May | June | July | August | September | October | November | December | Total | |
| Wages and Salaries | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 144 | |
| Marketing Expenses | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Fringe Benefits | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 24 | |
| Supplies | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 36 | |
| Repair, and Maintenance | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | |
| Utilities | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 36 | |
| Travel Expense | 1 | 2 | 1 | 3 | 5 | 1 | 2 | 3 | 2 | 1 | 4 | 1 | 26 | |
| Rent | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 120 | |
| Insurance | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | |
| Legal Fees and Charges | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | |
| Property Taxes | 0 | |||||||||||||
| Recruiting and training expenses | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | |
| Bank Charges | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | |
| Telephone Charges | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 24 | |
| Other Miscellaneous expenses | 1 | 2 | 3 | 2 | 3 | 4 | 2 | 2 | 2 | 3 | 2 | 2 | 28 | |
| Total | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
Salaries
| Salaries | Year 1 (First month) | Year 2 | Year 3 | |||
| President | 10000 | 120000 | 120000 | |||
| Chief Marketing Officer | 7500 | 90000 | 90000 | 744.602 | ||
| Chief Financial Officer | 7500 | 90000 | 90000 | |||
| Chief Human Resource Officer | 7500 | 90000 | 90000 | |||
| Truck Drivers(2) | 8666 | 104000 | 104000 | |||
| Warehouse Loader(4) | 10332 | 124000 | 124000 | |||
| Receptionist | 3000 | 36000 | 36000 | |||
| Facility Supervisor | 6667 | 80000 | 80000 | |||
| Maintenace Technician | 3583 | 43000 | 43000 | |||
| 744.602 |
Insurance
| Insurance Fees | Year 1 (Month) | Year 2 | Year 3 | |
| Property Insurance | 81.57 | 978.88 | 978.88 | |
| Employees Insurance | 744.602 | 8935.224 | 8935.224 |
Equipments
| Equipments | Year 1 (Month) | Year 2 | Year 3 | ||
| Trucks | 55000 | 0 | 0 | ||
| Furnitures, Equipments | 7000 | 300 | 300 |
Rent
| Rent | Year 1 (Month) | Year 2 | Year 3 | ||
| 2750 | 33000 | 33000 |
Utilities
| Utilities | Year 1 (Month ) | Year 2 | Year 3 | ||
| Electricity, Water, Gas | 1000 | 12000 | 12000 |
Marketing
| 2018 (first month) | 2019 (year) | 2020 (year) | ||
| Online Marketing | ||||
| Email Marketing (mail chimp) | $10 | $120 | $120 | |
| CRM Sales force | $75 | $900 | $1,800 | |
| Klipfolio (dashboard) | $49 | $588 | $1,188 | |
| Local Marketing | ||||
| Newspaper | $198 | $2,376 | $3,708 | |
| Radio | $1,116 | $13,392 | $26,784 | |
| Train Station | $675 | $8,100 | $16,200 | |
| Mall | $1,625 | $19,500 | $19,500 | |
| Total price | $3,748 | $44,976 | $69,300 |
