EXCEL SKILLS
fkirazli
e-book_2011_project.xlsxSheet1
| E-Book.com | |||||
| Five-Year Projected Financial Statement | |||||
| 2011 | 2012 | 2013 | 2014 | 2015 | |
| Revenue | 131201647 | 133366474 | 135567021 | 137803877 | 140077641 |
| Cost of Goods Sold | |||||
| Gross Margin | |||||
| Expenses | |||||
| Advertising | |||||
| Rent | |||||
| Salaries | |||||
| Supplies | |||||
| Maintenance | 2100000 | 5450000 | 3900000 | 5350000 | 2750000 |
| Total Expenses | |||||
| Income Before Taxes | |||||
| Income Taxes | |||||
| Net Income | |||||
| Assumptions | |||||
| Units Sold in Year 2010 | 8,492,016 | ||||
| Unit Cost | 9.27% | ||||
| Annual Sales Growth | 7.00% | ||||
| Annual Price Decrease | 5.00% | ||||
| Margin | 40.00% |
