Applying Integrated Excel: Horizontal and Vertical Analysis using ROUND Net sales Cost of goods sold Gross margin Operating expenses Net income Cash Accounts receivable, net Merchandise inventory Plant assets, net Total assets Current liabilities Long-term liabilities Common stock Retained earnings Total liabilities and equity Goliath Company Comparative Income Statements For Years Ended December 31 Current Year One Year Ago $ 271,000 $ 243,000 135,000 136,000 54,000 186,000 57,000 23,000 $ 82,000 $ 34,000 $ 355,000 $ 41,000 100,000 30,000 184,000 $ 355,000 Two Years Ago $ 211,000 131,000 Goliath Company Comparative Balance Sheets For Years Ended December 31 Current Year One Year Ago $ 95,000 $ 35,000 76,000 68,000 34,000 65,000 150,000 130,000 $ 298,000 $ 56,000 110,000 30,000 102,000 $ 298,000 Required: Using the above information, compute the following: 80,000 32,000 $ 48,000 Three Years Ago $ 150,000 117,000 33,000 13,000 $ 20,000 Two Years Ago Three Years Ago $ 32,000 42,000 $ 45,000 59,000 33,000 100,000 $ 237,000 $ 39,000 100,000 30,000 68,000 $ 237,000 41,000 90,000 $ 205,000 $ 35,000 120,000 30,000 20,000 $ 205,000 1) Calculate trend percents for all components of the income statements using three years ago as the base year, rounding all percents to 2 decimal places. 2) Express the balance sheets in common-size percents, rounding all percents to 2 decimals.
Applying Integrated Excel: Horizontal and Vertical Analysis using ROUND Net sales Cost of goods sold Gross margin Operating expenses Net income Cash Accounts receivable, net Merchandise inventory Plant assets, net Total assets Current liabilities Long-term liabilities Common stock Retained earnings Total liabilities and equity Goliath Company Comparative Income Statements For Years Ended December 31 Current Year One Year Ago $ 271,000 $ 243,000 135,000 136,000 54,000 186,000 57,000 23,000 $ 82,000 $ 34,000 $ 355,000 $ 41,000 100,000 30,000 184,000 $ 355,000 Two Years Ago $ 211,000 131,000 Goliath Company Comparative Balance Sheets For Years Ended December 31 Current Year One Year Ago $ 95,000 $ 35,000 76,000 68,000 34,000 65,000 150,000 130,000 $ 298,000 $ 56,000 110,000 30,000 102,000 $ 298,000 Required: Using the above information, compute the following: 80,000 32,000 $ 48,000 Three Years Ago $ 150,000 117,000 33,000 13,000 $ 20,000 Two Years Ago Three Years Ago $ 32,000 42,000 $ 45,000 59,000 33,000 100,000 $ 237,000 $ 39,000 100,000 30,000 68,000 $ 237,000 41,000 90,000 $ 205,000 $ 35,000 120,000 30,000 20,000 $ 205,000 1) Calculate trend percents for all components of the income statements using three years ago as the base year, rounding all percents to 2 decimal places. 2) Express the balance sheets in common-size percents, rounding all percents to 2 decimals.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
answer in text form with all workings
Transcribed Image Text:Applying Integrated Excel: Horizontal and Vertical Analysis using ROUND
Net sales
Cost of goods sold
Gross margin
Operating expenses
Net income
Cash
Accounts receivable, net
Merchandise inventory
Plant assets, net
Total assets
Current liabilities
Long-term liabilities
Common stock
Retained earnings
Total liabilities and equity
Goliath Company
Comparative Income Statements
For Years Ended December 31
One Year Ago
Current Year
$ 271,000
135,000
$ 243,000
186,000
136,000
54,000
$ 82,000
57,000
23,000
$ 34,000
Required:
Using the above information, compute the following:
Two Years Ago
$ 211,000
131,000
80,000
32,000
$ 48,000
Goliath Company
Comparative Balance Sheets.
For Years Ended December 31
Current Year One Year Ago
$ 95,000
76,000
$ 35,000
68,000
65,000
130,000
34,000
150,000
$ 355,000
$ 41,000
100,000
30,000
184,000
$ 355,000
$ 298,000
$ 56,000
110,000
30,000
102,000
$ 298,000
Three Years Ago
$ 150,000
117,000
33,000
13,000
$ 20,000
Two Years Ago Three Years Ago
$ 32,000
42,000
$ 45,000
59,000
33,000
100,000
$ 237,000
$ 39,000
100,000
30,000
68,000
$ 237,000
41,000
90,000
$ 205,000
$ 35,000
120,000
30,000
20,000
$ 205,000
1) Calculate trend percents for all components of the income statements using three years ago as the base year, rounding all percents
to 2 decimal places.
2) Express the balance sheets in common-size percents, rounding all percents to 2 decimals.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 3 images
Knowledge Booster
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.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education