NEED EVERYTHING ANSWERED IN TELLOW ASAP

I NEED ALL BOXES ANSWERED IN THE GIVEN FORMAT

thank you!!!

Font Paste Format as Table Alignment Number Cells Editing Ideas Sensitivity Cell Styles Clipboard Styles Ideas Sensitivity 17 x & fr B DI E F G H N Class assignment: "Dupont" System of Return On Investment - Week 7 Student Enter name above in first column Graded points out of 55 Using the "Dupont system of return on investment, discussed Deduct 0.5 for wrong out of 100 in "Ver" below in class prepare the various versions (senarios) of this formula using TGIF GLOBAL DISTRIBUTORS Determine Changes original information from the two statement to the right and with the Balance Sheet for each version changes below, prepare the "Dupont" system of ROI for each version December 31, 2009 Show only changes: TGIF GLOBAL DISTRIBUTORS Determine Changes for each version Assets Ver 4 Ver 5 Income Statement Show revised statements below: Cash 65000 For the Year Ending Dec 31, 20 Ver 1 Ver 2 Ver 3 Ver 5 Accounts Receivable 165000 Sales 750000 Inventory 225000 Cost of Goods Sold 487500 Total 455000 Gross Profit 262500 Liabilities & Equity Operating Expenses 187500 Accounts Payable 123000 Operating Income 75000 Owner's equity 332000 interest expense 01 Total 455000 Net Income 75000 IF ITEM ISN'T CHANGED, USE THE ORIGINAL 2009 FIGURES FROM THE REVISED STATEMENTS (above) IN RATIOS BELOW Original Ratio Ratios and answers are automartically calculated after you enter numbers in the yellow boxes. sales/assets gross profit/sales oper.inc/gross profit net incloper.inc assets to equity as calculated Deduct. 5 for wrong figures in formula out of 100 below Problem 1 Original 2009 Deduct 1 for wrong ratio out of 100 Deduct 2 for wrong answer 75000 Original Rate ating Income Owner's equity 332000 rest expense Total 455000 Income 75000 ISN'T CHANGED, USE THE ORIGINAL 2009 FIGURES FROM THE REVISED STATEMENTS (above) IN RATIOS BELOW Ratios and answers are automatically calculated after you enter numbers in the yellow boxes sales/assets gross profit/sales operinc gross prolet net incloper inc assets to equity Deduct 5 for wrong figures in formula out of 100 as calculate below ginal 2009 Deduct 1 for wrong ratio out of 100 Deduct 2 for wrong answer Version #1 Deduct 5 for wrong figures in formula out of 100 Reduce Operating Expenses to $172,500 (1) Assume gross profit is $262,500 (2) Assume operating expenses (OH) foed at 172,500 Deduct 2 for wrong answ Deduct 1 for wrong ratio Version #2 Increase sales to $840,000 (1) Assume gross profit is still 35% of sales (2) Assume operating expenses foed at 187,500 Deduct 1 for wrong ratio Deduct 2 for wrong answer Version #3 Raise prices: Sales go up to 5862,000 for the same volume 0 Resulting in gross profit going up to 40% (2) Assume operating expenses foued at $187.500 Deduct 1 for wrong ratio Deduct 2 for wrong answer X Version 4 Lower assets and equity by $45.000 (1) Assume gross profit is 35% on original sales of $750 000 (2) Assume operating expenses fixed at $187.500 Deduct 1 for wrong ratio Deduct 2 for wrong answer Version #5 Increase prices 3% to 5772.500, lower oper. exp.to $165,000 and reduce assets & equity by $50,000, (1) Cost of goods sold remain at the $750,000 sales level (2) Operating expenses at $165,000 Deduct 1 for wrong ratio Deduct 2 for wrong answer Sheet1 11 AM