Assignment
Sam1409
lab5template.xlsxYour Name Goes Here
| Put some company name here. | |||||
| Income | FY2015 | FY2016 | FY2017 | FY2018 | FY2019 |
| Gross Sales | |||||
| Business Expenses | |||||
| Salaries | |||||
| Building | |||||
| Insurance | |||||
| Supplies | |||||
| Other | |||||
| Total | |||||
| Gross Income | |||||
| Taxes | |||||
| Post Tax Income | |||||
| Profit Sharing | |||||
| Net Profit | |||||
| Sum of total profit for next 4 years: | |||||
| Assumptions | |||||
| Sales increase per year | 5.00% | ||||
| Salaries increase | 5.50% | ||||
| Building Costs | 2.00% | ||||
| Insurance Costs | 3.00% | ||||
| Supply Costs | 11.00% | ||||
| Other Costs | 3.50% |
