Question: Please make this chart and fill it out with formula's! thank you so much! HOMEWORK PROBLEM Sales $500,343 Total Overhead Expenses-$106, 510 (40% Variable, 60%

 Please make this chart and fill it out with formula's! thank

you so much! HOMEWORK PROBLEM Sales $500,343 Total Overhead Expenses-$106, 510 (40%

Please make this chart and fill it out with formula's! thank you so much!

HOMEWORK PROBLEM Sales $500,343 Total Overhead Expenses-$106, 510 (40% Variable, 60% Fixed) Cost of Goods Sold $373,396 Inventory on Hand $43,783 Net Accounts Receivable $5,614 Cash-on-Hand $6,756 Fixed Assets $144,858 Prepaid Expenses $3,511 Note: All dollar figures are in millions. Create spreadsheet to calculate EBIT $, EBIT Margin %, Asset Turnover %, and Return on Assets 96. 1. If there is a 5% increase in sales, recalculate metrics. (remember, COGS and variable overhead expense increase correspondingly, and assume that Inventory and Net A/R increase correspondingly as we 2. If there is 5% decrease in cost (COGS + variable OH), recalculate metrics. Assume that COGS and Inventory decrease proportionally. 3

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 Finance Questions!