1. Compute return on investment (ROI). 2. Compute residual income. 日 તે FILE HOME INSERT * Calibri h Paste BIU Clipboard Б A1 × - Return on Investment (ROI) and Residual Income - Excel PAGE LAYOUT 11 Α' Α' FORMULAS DATA % REVIEW ? - VIEW A Alignment Number Conditional Format as Cell Cells - Font fx Б Formatting Table▾ Styles▾ Styles Editing X Sign In Adams Corporation evaluates divisional managers based on ROI. Operating A B с D E F 1 Adams Corporation evaluates divisional managers based on ROI. Operating results for the 2 company's Northern Division for last year are given below: 3 4 5 6 7 8 9 10 11 Sales Variable expenses Contribution margin Fixed expenses Net operating income Average divisional operating assets 9,500,000 12 The Northern Division has an opportunity to add a new product line at the beginning of the year as follows: $ 27,000,000 16,200,000 10,800,000 8,805,000 1,995,000 13 14 15 16 Average required investment Net operating income 17 Adams Corporation's minimum acceptable rate of return 18 $ 2,500,000 $ 400,000 15% G

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter12: Balanced Scorecard And Other Performance Measures
Section: Chapter Questions
Problem 9EA: Classify each of the following performance measures into the balanced scorecard perspective to which...
icon
Related questions
Question
1. Compute return on investment (ROI).
2. Compute residual income.
日
તે
FILE
HOME
INSERT
*
Calibri
h
Paste
BIU
Clipboard Б
A1
×
-
Return on Investment (ROI) and Residual Income - Excel
PAGE LAYOUT
11
Α' Α'
FORMULAS
DATA
%
REVIEW
?
-
VIEW
A Alignment Number Conditional Format as Cell Cells
-
Font
fx
Б
Formatting Table▾ Styles▾
Styles
Editing
X
Sign In
Adams Corporation evaluates divisional managers based on ROI. Operating
A
B
с
D
E
F
1 Adams Corporation evaluates divisional managers based on ROI. Operating results for the
2 company's Northern Division for last year are given below:
3
4
5
6
7
8
9
10
11
Sales
Variable expenses
Contribution margin
Fixed expenses
Net operating income
Average divisional operating assets
9,500,000
12 The Northern Division has an opportunity to add a new product line at the beginning of the year as follows:
$
27,000,000
16,200,000
10,800,000
8,805,000
1,995,000
13
14
15
16
Average required investment
Net operating income
17 Adams Corporation's minimum acceptable rate of return
18
10
$
2,500,000
$
400,000
15%
G
Transcribed Image Text:1. Compute return on investment (ROI). 2. Compute residual income. 日 તે FILE HOME INSERT * Calibri h Paste BIU Clipboard Б A1 × - Return on Investment (ROI) and Residual Income - Excel PAGE LAYOUT 11 Α' Α' FORMULAS DATA % REVIEW ? - VIEW A Alignment Number Conditional Format as Cell Cells - Font fx Б Formatting Table▾ Styles▾ Styles Editing X Sign In Adams Corporation evaluates divisional managers based on ROI. Operating A B с D E F 1 Adams Corporation evaluates divisional managers based on ROI. Operating results for the 2 company's Northern Division for last year are given below: 3 4 5 6 7 8 9 10 11 Sales Variable expenses Contribution margin Fixed expenses Net operating income Average divisional operating assets 9,500,000 12 The Northern Division has an opportunity to add a new product line at the beginning of the year as follows: $ 27,000,000 16,200,000 10,800,000 8,805,000 1,995,000 13 14 15 16 Average required investment Net operating income 17 Adams Corporation's minimum acceptable rate of return 18 10 $ 2,500,000 $ 400,000 15% G
19 Compute the following:
20
21 Northern Division ROI for last year
22
23 Northern Division ROI if new product line is added
24
25 Write an IF statement to determine whether the Northern Division
26 manager will ACCEPT or REJECT the new product line based on ROI.
27
28 Northern Division residual income for last year
29
30 Northern Division residual income if the new product line is added
31
32 Write an IF statement to determine whether the Northern Division manager
33 will ACCEPT or REJECT the new product line based on residual income
34
35
36
37
READY
Attempt(s)
Sheet1
-
H
+
10%
Hint
Show Me
Transcribed Image Text:19 Compute the following: 20 21 Northern Division ROI for last year 22 23 Northern Division ROI if new product line is added 24 25 Write an IF statement to determine whether the Northern Division 26 manager will ACCEPT or REJECT the new product line based on ROI. 27 28 Northern Division residual income for last year 29 30 Northern Division residual income if the new product line is added 31 32 Write an IF statement to determine whether the Northern Division manager 33 will ACCEPT or REJECT the new product line based on residual income 34 35 36 37 READY Attempt(s) Sheet1 - H + 10% Hint Show Me
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 8 steps

Blurred answer
Knowledge Booster
Divisional performance management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College