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

That is a good question. This is all of the information that I was given.
 Using Microsoft Excel to create a pro-forma income statement based on

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!