Could you get the formula also? thanks used in the testcondition, value_i_true, or value_f false arguments then the text itself should be entered in quotations sothat Excel will recognize the text as a "string of text" instesd of another function. From the Excel Simulation below, if in a blarcell =F(G10>20, Total cost is High","Total cost is low") was entered, the formula would output the result of the value_if_truesince the test_condition would be result es true, or in this case the text "Total cost is high". Excel processes the IF function bseparating it out into separste parts. First the test_condition- Excel thinks, find cell G10 and detemine if the value is greatethan 20. Once Excel determines if the result of that test_condition is TRUE or FALSE, it will return the value_if_true orvalue_if_folse.Return on Investment (ROI) and Residual Income - ExcelFILEHOMEINSERTPAGE LAYOUTFORMULASDATAREVIEWVIEWSign InCalibri11%Alignment Number Conditional Format asFormatting- Table Styles-PasteBIU-CellCelsClipboardFontStylesA1Adams Corporation evaluates divisional managers based on ROI. OperatingDE1112 The Northern Division has an opportunity to add a new product line at the beginning of the year as follows:13Average required investmentNet operating income142,500,00015400,0001617 Adams Corporation's minimum acceptable rate of return15%1819 compute the following:2021 Northern Division ROI for last year2223 Northern Division ROI if new product line is added2425 Write an IF statement to determine whether the Northern Division26 manager willl ACCEPT or REJECT the new product line based on ROI.2728 Northern Division residual income for last year2930 Northern Division residual income if the new product line is added3132 write an IF statement to determine whether the Northern Division manager33 will ACCEPT or REJECT the new product line based on residual income34SheetiREADY100%Attempt(s)Hint Adams Corporation evalustes divisional managers based on Retum on Investment (ROI) and has provided the opersting results of theNorthern Division from last year. The Controller has esked you to compute the ROI and Residual Income besed on data from last yearand if the division adds a new product line. Use the information included in the Excel Simulation and the Excel functions describedbelow to complete the task.Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blankcell, "=G5" was entered, the formulo would output the result from cell G5, or 4.00 in this example.Basic Math functions: Allows you to use the basic math symbols to perform mathemotical functions. You can use the followingkeys: + (plus sign to add). - (minus sign to subtract). * (asterisk sign to multiply), and / (forwerd slash to divide). From the ExcelSimulstion below, if in a blank cell =G5-G6" wos entered, the formula would add the values from those cells and output theresult, or 10.00 in this example. If using the other math symbols the result would output an appropriste answer for its function.SUM function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges toutilize this function. From the Excel Simulation below, if in a blonk cell "=SUM(G5,66,G7)" wes entered, the formula wouldoutput the result of adding those three separate cells, or 12.00 in this example. Similarly, if in a blank cell =SUM(G5:G7)" wasentered, the formula would output the same result of adding those cells, except they are expressed es a range in the formuls,and the result would be 12.00 in this example.IF function: Allows you to test a condition and return a specific value is the result is true and different value if the result isfalse. The syntax of the IF function is "=IF(test_condition,value_if_true,value_if_false)" and specific considerstions need to bemade when using this function. The test_condition argument is an evaluation of the status of a cell, such es if the value of a cellis greater than, less than, or equal to another number or cell. The value_it_true and value_it_false arguments will return anyspecific result for each option, such as another cell reference, a value, or text. Throughout the entire equation, if text is beingused in the test_condition, value_iLtrue, or value_ffalse orguments then the text itself should be entered in quotations sothat Excel will recognize the text as a "string of text" instesd of another function. From the Excel Simulation below, if in a blankcell "=F(G10-20,"Total cost is High","Total cost is lovw") was entered, the formula would output the result of the value_if_truesince the test_condition would be result es true, or in this case the text "Total cost is high". Excel processes the IF function byseparsting it out into separste parts. First the test_condition- Excel thinks, find cell G10 and detemine if the value is greaterthan 20. Once Excel determines if the result of that test condition is TRUE or FALSE, it will return the value_it_true orvalue_it_folse.Return on Investment (ROI) and Residual Income - ExcelFILEHOMEINSERTPAGE LAYOUTFORMULASDATAREVIEWVIEWSign inCalibri11A AAlignment Number Conditional Format asCellPasteBIU-CellsFormatting - Table Styles-ClipboardFontStylesA1Adams Corporation evaluates divisional managers based on ROI. OperatingBDEpams corporatiorevaiuates aiviSionai managers Daseo on KUI. Uperanng resuits Tor tneɔmpany's Northern Division for last year are given below:24Sales27,000,000Variable expenses16,200,0006Contribution margin10,800,000Fixed expenses8,805,0001.995.000Net operating income10Average divisional operating assets9.500.00011

Solution: Return on investment = Net operating income / Average operating assets Residual income =…

that Excel will recognize the text as a "string of text" instead of another function. From the Excel Simulation below, if in a cell =F(G10>20,"Total cost is High"."Total cost is low") was entered, the formula would output the result of the value_if_tr since the test_condition would be result as true, or in this case the text "Total cost is high". Excel processes the IF functio separating it out into separate parts. First the test_condition - Excel thinks, find cell GI0 and determine if the value is gre than 20. Once Excel determines if the result of that test condition is TRUE or FALSE, it will return the value_it_true or value_Lfalse. Return on Investment (RO) and Residual Income - Excel REVIEW Sign in FILE HOME INSERT PAGE LAYOUT FORMULAS DATA VIEW Calibri 11 A A Paste Alignment Number Conditional Format as Cell Formatting- Table- Styles- BIU- Cels Clipboard Font Styles Adams Corporation evaluates divisional managers based on ROI. Operating A1 11 12 The Northern Division has an opportunity to add a new product line at the beginning of the year as follows: 4 Average required investment Net operating income 2,500,000 400,000 L6 17 Adams Corporation's minimum acceptable rate of return 15% 9 Compute the following: 1 Northern Division ROI for last year 22 3 Northem Division ROI if new product line is added 24 s write an IF statement to determine whether the Northern Division 6 manager will ACCEPT or REJECT the new product line based on ROI. 27 8 Northerm Division residual income for last year 19 10 Northern Division residual income if the new product line is added 12 Write an IF statement to determine whether the Northern Division manager 13 will ACCEPT or REJECT the new product line based on residual income 14 Sheeti

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q