AutoSave @ Off October 2021 Project Three Part Four (2) - Excel Search (Alt+Q) A Lewis, Josh G U X X File Insert Data Review View Help Comments Home Draw Page Layout Formulas Share ab General 10 ~ A" A" Conditional Formatting Insert Arial =1 AY O $ ~ % " Format as Table Delete Sort & Find & Analyze Sensitivity Paste B U Y $58 308 Cell Styles ~ Format Filter * Select v Dat Font Alignment Number Styles Cells Editing Analysis Sensitivity Undo Clipboard A1 vi X v fx Project 3 Part Four Problem (20 points) A B C D E F G H J K 44 45 Requirement Five: 46 Calculate ROI for each of the three again, but 47 assume fixed costs decrease by 10% for each one. 48 Assets and costs remain the same as presented. 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 X XXX Project Three Problem Four XX + + 120% Ready 9:06 AM Type here to search O W X ? 32"F 11/26/2021X AutoSave @ Off October 2021 Project Three Part Four (2) - Excel Search (Alt+Q) A Lewis, Josh G U X File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share Arial 10 ~ A" A" General Insert =1 ab Conditional Formatting AYO $ ~ % " Format as Table Delete Paste B U v Sort & Find & Analyze Sensitivity Cell Styles * Format Filter * Select ~ Dat Undo Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 vi X fx Project 3 Part Four Problem (20 points) A B C D E F G H J K 2 Dependable Networks is a data storage business operating in select cities in Texas. Select financial data is presented below to provide you with the necessary content for perfromance evaluation purposes. NOUAW Dallas Austin San Antonio Division Division Division Total Co Sales revenue 3,185,000 1,400,000 1,200,000 5,785,000 9 Variable costs 995,000 375,000 310,000 1,680,000 10 Contribution margin 2, 190,000 1,025,000 890,000 4, 105,000 11 Fixed costs 1,680,000 725,000 650,000 3,055,000 12 Operating income 510,000 300,000 240,000 1,050,000 13 Interest costs on long-term debt at 10% 450,000 14 Income before income taxes 600,000 15 Income taxes at 30% 180,000 16 Net income 420,000 17 Net book values at the end of 2020: 18 Current assets 850,000 700,000 300,000 1,850,000 19 Long-term assets 2,700,000 1,800,000 800,000 5,300,000 20 Total assets 3,550,000 2,500,000 1,100,000 7,150,000 21 Current liabilities 300,000 150,000 50,000 500,000 22 Long-term debt 4,500,000 23 Stockholders' equity 2,150,000 X XXX Project Three Problem Four XX + Ready + 120% O M X 9:05 AM Type here to search W ? 32.F 11/26/2021X AutoSave @ Off October 2021 Project Three Part Four (2) - Excel Search (Alt+Q) A Lewis, Josh G U X File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share General Arial 10 ~ A" A" =1 ab Conditional Formatting Insert AYO $ ~ % " Format as Table Delete Paste B Sort & Find & Analyze Sensitivity $58 308 Cell Styles * Format Filter * Select v Dat Undo Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 vi X fx Project 3 Part Four Problem (20 points) A B C D E F G H J K 24 Total liabilities and stockholders' equity 7,150,000 25 26 27 Requirement One: 28 Calculate ROI for each of the three 29 restaurants by using the condensed ROI formula 30 31 Requirement Two: 32 Calculate Profit Margin (Return on Sales) for each 33 Calculate Asset Turnover for each 34 35 Requirement Three: 36 Calculate ROI for each of the three again, but 37 assume assets increase by 400,000 for each one. 38 Sales and costs remain the same as presented. 39 40 Requirement Four: 41 Calculate ROI for each of the three again, but 42 assume sales increase by 5% for each one. 43 Assets and fixed costs remain the same as presented. 44 45 Requirement Five: X XXX Project Three Problem Four XX + Ready + 120% 9:06 AM Type here to search O W X ? 32"F 11/26/2021