BUSN 278 Week 7 Assignment | Devry University
- Devry University / BUSN 278
- 10 Nov 2021
- Price: $5
- Accounting & Economics Assignment Help / Finance
BUSN 278 Week 7 Assignment | Devry University
Week 7: Lab
Assignment
Requirements:
Using Microsoft Excel to create a 12 month pro-forma income statement based on
the following assumptions
Sales for first month: $60000 |
Cost of sales = 42% of sales, all variable |
Operating expenses = $10,000 fixed plus 5% of sales |
Tax rate 30% |
Sales increased by 5% each month |