NEED ANSWERED ASAP!

EVERY TH ING IN YELLOW AND IN THE SAME CHART FORMAT

Thank You!

last picture is simply a zoomed out ceiw of the whole problem

thank you again!

THESE ARE CLEARER PICTURES

USE THESE

NEED ALL INFORMATION IN YELLOW ANSWERED IN THAT FORMAT ASAP

THIS IS ALL THAT I WAS GIVEN FOR THE PROBLEM

ALL INFORMATION IS LISTED IN THE PICTURE

ANSWER NOW

X fx B D E F G H J K LM N Class assignment: "Dupont" System of Return On Investment - Week 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, 200 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 0 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 3 Ratios and answers are automartically calculated after you enter numbers in the yellow boxes. 9 sales/assets gross profit/sales oper.inc/gross profit net ing/oper.inc assets to equity as calculated 0 Deduct 5 for wrong figures in formula out of 100 below 1 Problem 2 1 Original 2009 23 24 Deduct 1 for wrong ratio out of 100 Deduct 2 for wrong answer 25 X 26 Deduct 5 for wrong figures in formula out of 100 272 Version #1 Reduce Operating Expenses to $172,500 28 (1) Assume gross profit is $262.500 (2) Assume operating expenses (O.H.) fixed at 172,500 29 30 31 Deduct 1 for wrang ratio Deduct 2 for wrong answer 0 Cost of Goods Sold 487500 Total 455000 Gross Pro 262500 Liabilities & Equity Operating Expenses 187500 Accounts Payable 123000 Operating Income 750001 Owner's equity 332000 interest expense Total 455000 Net Income 75000 IF ITEM 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 oper.inc gross profit net inbper inc assets to equity Deduct 5 for wrong figures in formula out of 100 Problem 1 Original 2009 Original Ratio as calculated below Deduct 1 for wrong ratio out of 100 Deduct 2 for wrong answer x 2 Version #1 Deduct 5 for wrong figures in formula out of 100 Reduce Operating Expenses to $172,500 (O) Assume gross profit is $262.500 (2) Assume operating expenses (OH) fixed at 172,500 Deduct 1 for wrong ratio Deduct 2 for wrong answer X Version 2 Increase Sales to 5840.000 Assume gross profit is still 35% of sales (2) Assume operating expenses fixed at 187 500 Deduct 1 for wrong ratio Deduct2 for wrong answer 1 2 3 53 5 6 7 8 9 0 14 2 3 4 45 16 17 18 5 Version 3 Raise prices: Sales go up to $862,000 for the same volume ( Resulting in gross profe going up to 40% 2 Assume operating expenses fixed at $187.500 Deduct 1 for wrong to Deduct 2 for wrong answer Version 4 Lower assets and equity by 545,000 (0) Assume gross profit is 35% on original sales of $750,000 (2) Assume operating expenses fixed at $187.500 50 51 52 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 550,000 Cost of goods sold man at the $750,000 sales level 2) Operating expenses at $165,000 55 6 56 67 58 59 60 61 62 Deduct 1 for wrong at Deduct 2 for wrong arawer 64 66 67 68 69 TO Do you want to switch to tablet mo This makes Windows more touch-frie when using your device as a tablet 72 73 G H K M N Class assignment: "Dupont System of Return On Investment - Week Student Enter name above in first column Graded points out of 56 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 200 Ver 1 Ver 2 Ver 3 Ver 5 Accounts Receivable 165000 Sales 750000 Inventory 225000 Cost of Goods Sold 487500 Total 455000 Gross Pront 262500 Liabilities & Equity Operating Expenses 187500 Accounts Payable 123000 Operating Income 75000 Owner's equity 302000 Interest expense ol Total 455000 Net Income 75000 IF ITEM ISNT CHANGED, USE THE ORIGINAL 2009 FIGURES FROM THE REVISED STATEMENTS (above) IN RATIOS BELOW Original Ratio Ratios and answers are automatically calculated after you enter numbers in the yellow boxes sales assets gross profiles oper.inc gross profit neticbper.inc assets to quity as calculated Deduct 5 for wrong figures in formula out of 100 below 1 Problem 2 1 Original 2009 Deduct 1 for wrong ratio out of 100 Deduct 2 for wrong answer Version 1 34 25 26 27 2 28 29 30 31 32 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) fred at 172.500 Deduct 1 for wrong ratio Deduct 2 for wrong answer X 34 3 Version 2 Increase Sales to $340,000 Assume gross profit is still 35% of sales Assume operating expenses fixed 187.500 36 37 Deduct 1 for wrong Deduct 2 for wrong answer 39 40 Version 3 Raise prices: Sales go up to $862,000 for the same volume 0 Resulting in gross profit going up to 40% Assume operating expenses fixed $187.500 44 45 45 Deduct 1 for wrong Decurt? for wrong 4B 5 Version 4 Lower assets and equity by $45,000 (0) Assume gross profit is 35% on original sales of $750.000 (2) Assume operating expenses fixed at $167 500 50 51 52 Deduct for wrong Version 5 Increase prices $2.500, lawer operexpo $165.000 and reduce an equity by 150,000 (1) Cost of goods soldreman the 5750.000 sales level Operating expenses at 5165 000 Deduct Font Paste Alignment Number Cells Format as Table Cell Styles Editing Ideas Sensitivity Clipboard Styles Ideas Sensitivity 17 fi B c D E F G H K 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 profil net inc/oper.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 ating income 75000 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 operincgross prolet net incloper inc assets to equity Deduct 5 for wrong figures in formula out of 100 Orginal Rat 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 1 for wrong ratio Deduct 2 for wrong answer 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 $862,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 X fx B D E F G H J K LM N Class assignment: "Dupont" System of Return On Investment - Week 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, 200 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 0 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 3 Ratios and answers are automartically calculated after you enter numbers in the yellow boxes. 9 sales/assets gross profit/sales oper.inc/gross profit net ing/oper.inc assets to equity as calculated 0 Deduct 5 for wrong figures in formula out of 100 below 1 Problem 2 1 Original 2009 23 24 Deduct 1 for wrong ratio out of 100 Deduct 2 for wrong answer 25 X 26 Deduct 5 for wrong figures in formula out of 100 272 Version #1 Reduce Operating Expenses to $172,500 28 (1) Assume gross profit is $262.500 (2) Assume operating expenses (O.H.) fixed at 172,500 29 30 31 Deduct 1 for wrang ratio Deduct 2 for wrong answer 0 Cost of Goods Sold 487500 Total 455000 Gross Pro 262500 Liabilities & Equity Operating Expenses 187500 Accounts Payable 123000 Operating Income 750001 Owner's equity 332000 interest expense Total 455000 Net Income 75000 IF ITEM 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 oper.inc gross profit net inbper inc assets to equity Deduct 5 for wrong figures in formula out of 100 Problem 1 Original 2009 Original Ratio as calculated below Deduct 1 for wrong ratio out of 100 Deduct 2 for wrong answer x 2 Version #1 Deduct 5 for wrong figures in formula out of 100 Reduce Operating Expenses to $172,500 (O) Assume gross profit is $262.500 (2) Assume operating expenses (OH) fixed at 172,500 Deduct 1 for wrong ratio Deduct 2 for wrong answer X Version 2 Increase Sales to 5840.000 Assume gross profit is still 35% of sales (2) Assume operating expenses fixed at 187 500 Deduct 1 for wrong ratio Deduct2 for wrong answer 1 2 3 53 5 6 7 8 9 0 14 2 3 4 45 16 17 18 5 Version 3 Raise prices: Sales go up to $862,000 for the same volume ( Resulting in gross profe going up to 40% 2 Assume operating expenses fixed at $187.500 Deduct 1 for wrong to Deduct 2 for wrong answer Version 4 Lower assets and equity by 545,000 (0) Assume gross profit is 35% on original sales of $750,000 (2) Assume operating expenses fixed at $187.500 50 51 52 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 550,000 Cost of goods sold man at the $750,000 sales level 2) Operating expenses at $165,000 55 6 56 67 58 59 60 61 62 Deduct 1 for wrong at Deduct 2 for wrong arawer 64 66 67 68 69 TO Do you want to switch to tablet mo This makes Windows more touch-frie when using your device as a tablet 72 73 G H K M N Class assignment: "Dupont System of Return On Investment - Week Student Enter name above in first column Graded points out of 56 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 200 Ver 1 Ver 2 Ver 3 Ver 5 Accounts Receivable 165000 Sales 750000 Inventory 225000 Cost of Goods Sold 487500 Total 455000 Gross Pront 262500 Liabilities & Equity Operating Expenses 187500 Accounts Payable 123000 Operating Income 75000 Owner's equity 302000 Interest expense ol Total 455000 Net Income 75000 IF ITEM ISNT CHANGED, USE THE ORIGINAL 2009 FIGURES FROM THE REVISED STATEMENTS (above) IN RATIOS BELOW Original Ratio Ratios and answers are automatically calculated after you enter numbers in the yellow boxes sales assets gross profiles oper.inc gross profit neticbper.inc assets to quity as calculated Deduct 5 for wrong figures in formula out of 100 below 1 Problem 2 1 Original 2009 Deduct 1 for wrong ratio out of 100 Deduct 2 for wrong answer Version 1 34 25 26 27 2 28 29 30 31 32 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) fred at 172.500 Deduct 1 for wrong ratio Deduct 2 for wrong answer X 34 3 Version 2 Increase Sales to $340,000 Assume gross profit is still 35% of sales Assume operating expenses fixed 187.500 36 37 Deduct 1 for wrong Deduct 2 for wrong answer 39 40 Version 3 Raise prices: Sales go up to $862,000 for the same volume 0 Resulting in gross profit going up to 40% Assume operating expenses fixed $187.500 44 45 45 Deduct 1 for wrong Decurt? for wrong 4B 5 Version 4 Lower assets and equity by $45,000 (0) Assume gross profit is 35% on original sales of $750.000 (2) Assume operating expenses fixed at $167 500 50 51 52 Deduct for wrong Version 5 Increase prices $2.500, lawer operexpo $165.000 and reduce an equity by 150,000 (1) Cost of goods soldreman the 5750.000 sales level Operating expenses at 5165 000 Deduct Font Paste Alignment Number Cells Format as Table Cell Styles Editing Ideas Sensitivity Clipboard Styles Ideas Sensitivity 17 fi B c D E F G H K 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 profil net inc/oper.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 ating income 75000 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 operincgross prolet net incloper inc assets to equity Deduct 5 for wrong figures in formula out of 100 Orginal Rat 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 1 for wrong ratio Deduct 2 for wrong answer 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 $862,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