Question: Using Microsoft Excel to create a pro-forma income statement based on the following assumptions: Sales for first month: $60000 Cost of sales = 42% of
Using Microsoft Excel to create a 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 moth |
Back Week 7: Lab Assignment Submission Types File Upload Submission & Rubric Description Requirements: Using Microsoft Excel to create a 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 moth Submit Assignment
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
