File Home Insert Page Layout Formulas Data Review View Help O Tell me what you want to do X Cut E AutoSum - Calibri - 11 A A * Wrap Text General e Copy O Fill- $ - % Insert Delete Format Paste Conditional Format as Cell Sort & Find & BIU A Merge & Center - * Format Painter Formatting - Table- Styles • Clear Filter - Select Clipboard Font Alignment Number Styles Cells Editing 07 AB D E FG H LM N P R V X Instructional Instructional Accounting 500,000 $ 1,000,000 250,000 $ 550,000 Business 1 Revenues Operating Expenses Income before Service Charges 2 3 FORMULA 1 FORMULA 2 5 Investment $ 300,000$ 500,000 7 ROI before service charges FORMULA 3 FORMULA 4 8 Number of professors 10 Number of studenta in program 200 500 Payroll (Driver is # of (Driver is # of professora) 100,000 $ Advising 4 Service department expenses students) 200,000 7. Service department charge rate FORMULA 5 FORMULA 6 Instructional Instructional Accounting 24 500,000 $ 1,000,000 250,000 $ 550,000 Business Revenues Operating expenses Income before service charges 250,000 $ 450,000 3 Service charges: FORMULA 8 Рayroll Advising Income from operations FORMULA 7 FORMULA 9 FORMULA 10 FORMULA 11 FORMULA 12 ROI after service charges FORMULA 13 FORMULA 14 9 Sheet1

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

Accounting Excel Practice Problem - I attached a picture of the instructions and I attached a picture of the excel spreadsheet. Anywhere it says "formula" on the excel spreadsheet, needs the formula figured out.

20211_ACG2071_Module 6 Decentralized NEW - Excel
alexandra
A
困
File
Home
Insert
Page Layout
Formulas
Data
Review
View
Help
Tell me what you want to do
& Share
X Cut
E AutoSum
A A
22 Wrap Text
会了
Calibri
11
General
e Copy
V Fill
Paste
В I
$ • %
Conditional Format as
Cell
Insert Delete Format
Sort & Find &
.00
2 Merge & Center -
00
V Format Painter
Formatting
Table
Styles
O Clear
Filter - Select
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
07
fx
AB
D
F G
H
K
N
Q
R
V
W
Y
Instructional
Instructional
Accounting
$
500,000
10
Business
$ 1,000,000
$
11
Revenues
Operating Expenses
Income before Service Charges
12
250,000
550,000
13
FORMULA 1
FORMULA 2
14
15
Investment
$
300,000
$
500,000
16
17
ROI before service charges
FORMULA 3
FORMULA 4
18
Number of professors
Number of students in program
19
10
20
200
500
21
22
Рayroll
(Driver is # of
professors)
100,000
Advising
(Driver is # of
students)
200,000
23
24
25
Service department expenses
26
27
Service department charge rate
FORMULA 5
FORMULA 6
28
Instructional
Instructional
29
Accounting
Business
$
$ 1,000,000
2$
30
Revenues
500,000
31
Operating expenses
$
250,000
550,000
$
Income before service charges
Service charges:
32
$
250,000
450,000
33
Рayroll
Advising
Income from operations
34
FORMULA 7
FORMULA 8
35
FORMULA 9
FORMULA 10
36
FORMULA 11
FORMULA 12
37
38
ROI after service charges
FORMULA 13
FORMULA 14
39
Sheet1
+
曲
86%
8:21 PM
O Type here to search
日
99+
5/25/2021
(Q E
Transcribed Image Text:20211_ACG2071_Module 6 Decentralized NEW - Excel alexandra A 困 File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Share X Cut E AutoSum A A 22 Wrap Text 会了 Calibri 11 General e Copy V Fill Paste В I $ • % Conditional Format as Cell Insert Delete Format Sort & Find & .00 2 Merge & Center - 00 V Format Painter Formatting Table Styles O Clear Filter - Select Clipboard Font Alignment Number Styles Cells Editing 07 fx AB D F G H K N Q R V W Y Instructional Instructional Accounting $ 500,000 10 Business $ 1,000,000 $ 11 Revenues Operating Expenses Income before Service Charges 12 250,000 550,000 13 FORMULA 1 FORMULA 2 14 15 Investment $ 300,000 $ 500,000 16 17 ROI before service charges FORMULA 3 FORMULA 4 18 Number of professors Number of students in program 19 10 20 200 500 21 22 Рayroll (Driver is # of professors) 100,000 Advising (Driver is # of students) 200,000 23 24 25 Service department expenses 26 27 Service department charge rate FORMULA 5 FORMULA 6 28 Instructional Instructional 29 Accounting Business $ $ 1,000,000 2$ 30 Revenues 500,000 31 Operating expenses $ 250,000 550,000 $ Income before service charges Service charges: 32 $ 250,000 450,000 33 Рayroll Advising Income from operations 34 FORMULA 7 FORMULA 8 35 FORMULA 9 FORMULA 10 36 FORMULA 11 FORMULA 12 37 38 ROI after service charges FORMULA 13 FORMULA 14 39 Sheet1 + 曲 86% 8:21 PM O Type here to search 日 99+ 5/25/2021 (Q E
20211 ACG2071_Module 6 Excel Spreadsheet Instructions - Word
alexandra
困
A
File
Home
Insert
Design
Layout
References
Mailings
Review
View
Help
Tell me what you want to do
유 Share
% Cut
Arial
A A
:E - E -
处
O Find -
14
Aa v
AaBbCcDd AaBbCcDd AaBbC AABBCCC AaB AaBbCcD AaBbCcDd AaBbCcDd AaBbCcDd
E Copy
dac Replace
Paste
BI U v abe X, x
aby v
I Normal
1 No Spac. Heading 1
Heading 2
Title
Subtitle
Subtle Em.. Emphasis
Intense E.
V Format Painter
A Select -
Clipboard
Font
Paragraph
Styles
Editing
1... |...
1...1... · . 2... ..·3. ..1...4: . 5. .:|· . · 6.. 7...
Data set #2
Data set #3
Below you will see three sets of inputs. After inputting all of your formulas,
you should be able to use any of these sets of data and have the answers
automatically update.
Inputs:
Inputs:
Instructional Instructional
Business
Instructional Instructional
Accounting
600,000
$ 250,000$
FORMULA 1
Accounting
Business
Please choose one of the data sets above and input all of the necessary
formulas to find the answers. Once you are done, choose a different data
set, enter it into your spreadsheet, and check the updated answers to
$ 1,200,000
800,000
FORMULA 2
Revenues
Revenues
%24
600,000
$ 1,000,000
Operating Expenses
Income before Service Charges
250,000 $ 600,000
Operating Expenses
Income before Service Charges
FORMULA 1
FORMULA 2
ensure that everything is flowing through the formulas appropriately. A
check answer for each one has been provided.
Investment
750,000 $ 1,000,000
Investment
750,000 $
900,000
ROI before service charges
FORMULA 3
FORMULA 4
ROI before service charges
FORMULA 3
FORMULA 4
Number
professors
students in program
Data set #1
20
20
Number
Number
professors
students
20
Number
700
300
program
700
500
Inputs
Instructional Instructional
Accounting
500,000 $ 1,000,000
Advising
(Driver is # of (Driver is # of
students)
400,000
Рayroll
Advising
Рayroll
Business
(Driver is # of (Driver is # of
professors)
$ 100,000 $ 200,000
professors)
$ 100,000 $
Revenues
$
$ 250,000 $ 550,000
students)
Service department expenses
Operating Expenses
Income before Service Charges
Service department expenses
FORMULA 1
FORMULA 2
Check figure (ROI after service charges – Instructional
Accounting):
Check figure (ROI after service charges – Instructional
Accounting):
Investment
300,000
500,000
ROI before service charges
FORMULA 3
FORMULA 4
20%
Number of professors
Number of students in program
10
200
500
Рayroll
Advising
(Driver is # of (Driver is # of
professors)
$ 100,000 $
students)
200.000
Service department expenses
Check figure (ROI after service charges – Instructional Accounting):
53%
Page 1 of 3
125 words
50%
5:55 PM
O Type here to search
日
(99+
5/27/2021
Transcribed Image Text:20211 ACG2071_Module 6 Excel Spreadsheet Instructions - Word alexandra 困 A File Home Insert Design Layout References Mailings Review View Help Tell me what you want to do 유 Share % Cut Arial A A :E - E - 处 O Find - 14 Aa v AaBbCcDd AaBbCcDd AaBbC AABBCCC AaB AaBbCcD AaBbCcDd AaBbCcDd AaBbCcDd E Copy dac Replace Paste BI U v abe X, x aby v I Normal 1 No Spac. Heading 1 Heading 2 Title Subtitle Subtle Em.. Emphasis Intense E. V Format Painter A Select - Clipboard Font Paragraph Styles Editing 1... |... 1...1... · . 2... ..·3. ..1...4: . 5. .:|· . · 6.. 7... Data set #2 Data set #3 Below you will see three sets of inputs. After inputting all of your formulas, you should be able to use any of these sets of data and have the answers automatically update. Inputs: Inputs: Instructional Instructional Business Instructional Instructional Accounting 600,000 $ 250,000$ FORMULA 1 Accounting Business Please choose one of the data sets above and input all of the necessary formulas to find the answers. Once you are done, choose a different data set, enter it into your spreadsheet, and check the updated answers to $ 1,200,000 800,000 FORMULA 2 Revenues Revenues %24 600,000 $ 1,000,000 Operating Expenses Income before Service Charges 250,000 $ 600,000 Operating Expenses Income before Service Charges FORMULA 1 FORMULA 2 ensure that everything is flowing through the formulas appropriately. A check answer for each one has been provided. Investment 750,000 $ 1,000,000 Investment 750,000 $ 900,000 ROI before service charges FORMULA 3 FORMULA 4 ROI before service charges FORMULA 3 FORMULA 4 Number professors students in program Data set #1 20 20 Number Number professors students 20 Number 700 300 program 700 500 Inputs Instructional Instructional Accounting 500,000 $ 1,000,000 Advising (Driver is # of (Driver is # of students) 400,000 Рayroll Advising Рayroll Business (Driver is # of (Driver is # of professors) $ 100,000 $ 200,000 professors) $ 100,000 $ Revenues $ $ 250,000 $ 550,000 students) Service department expenses Operating Expenses Income before Service Charges Service department expenses FORMULA 1 FORMULA 2 Check figure (ROI after service charges – Instructional Accounting): Check figure (ROI after service charges – Instructional Accounting): Investment 300,000 500,000 ROI before service charges FORMULA 3 FORMULA 4 20% Number of professors Number of students in program 10 200 500 Рayroll Advising (Driver is # of (Driver is # of professors) $ 100,000 $ students) 200.000 Service department expenses Check figure (ROI after service charges – Instructional Accounting): 53% Page 1 of 3 125 words 50% 5:55 PM O Type here to search 日 (99+ 5/27/2021
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 7 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education