RELIABLE PAPERS ONLY PLEASE
letdue
ass._3_spreedsheet_applications.xlsSheet1
| Med Supply Online Warehouse | ||||||
| Six-Year Financial Projection | ||||||
| Year 1 | ||||||
| Sales | ||||||
| Cost of Goods | ||||||
| Gross Margin | ||||||
| Expenses | ||||||
| Advertising | ||||||
| Maintenance | 1605000 | 4378000 | 5920000 | 5050000 | 3200000 | 4250000 |
| Rent | 2700000 | |||||
| Salaries | ||||||
| Shipping | ||||||
| Supplies | ||||||
| Web Services | 250000 | |||||
| Total Expenses | ||||||
| Operating Income | ||||||
| Income Tax | ||||||
| Net Income | ||||||
| Assumptions | ||||||
| Units Sold in Prior Year | 1589712 | |||||
| Unit Cost | 59.5 | |||||
| Annual Sales Growth | 0.045 | |||||
| Annual Price Decrease | 0.038 | |||||
| Margin | 0.388 |
