Managerial Accounting
3rd Edition
ISBN: 9780077826482
Author: Stacey M Whitecotton Associate Professor, Robert Libby, Fred Phillips Associate Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Chapter 13, Problem 3E
To determine
(a)
Introduction:
Horizontal analysis is an analysis used to compare the historical data. It shows the changes in the amount of financial statements over the period of time.
To prepare:
The horizontal analyses with rounding the answer up to one decimal place. Also, compare the change in price of computers to the company’s change in sales revenue.
To determine
(b)
Introduction:
Vertical analysis help to express each financial statement line item as a percentage of the base year.
To prepare:
Vertical analyses with rounding the answer up to one decimal place.To compare if the company earned more gross profit per sales dollar during 2013 compare to 2012.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment
fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of
Gonzalez Industries for the year ended December 31, 2018.
Sales Revenue
Cost of Goods Sold
Gross Profit
Selling, General, and Administrative Expenses
Interest Expense
Income before Income Tax Expense
Income Tax Expense
Net Income
Required 1 Required 2
2018
$ 117,000
68,500
48,500
37,700
Year
670
10, 130
2,500
$ 7,630
2017
2018
2017
$ 145,500
Required:
1. Compute the times interest earned ratios for 2018 and 2017.
2. Does Gonzalez generate sufficient net income in both years (before taxes and interest) to cover the cost of debt financing?
78,300
67,200
40,400
Complete this question by entering your answers in the tabs below.
560
26,240
6,700
$ 19,540
Compute the times interest earned ratios for 2018 and 2017. (Round your answers to 1…
According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment
fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of
Gonzalez Industries for the year ended December 31, 2018.
Sales Revenue
Cost of Goods Sold
Gross Profit
Selling, General, and Administrative Expenses
Interest Expense
Income before Income Tax Expense
Income Tax Expense
Net Income
Required 1
Required 2 Required 3
2018
$ 105,000
62,500
Required:
1. Compute the gross profit percentage for each year. Assuming the change from 2017 to 2018 is the beginning of a sustained trend,
is Gonzalez likely to earn more or less gross profit from each dollar of sales in 2019?
2. Compute the net profit margin for each year. Did Gonzalez do a better or worse job of controlling operating expenses in 2018
relative to 2017?
3. Gonzalez reported average net fixed assets of $54,700 in 2018 and $45,600 in…
According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment
fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of
Gonzalez Industries for the year ended December 31, 2018.
Sales Revenue
Cost of Goods Sold
Gross Profit
Selling, General, and Administrative Expenses
Interest Expense
Income before Income Tax Expense
Income Tax Expense
Net Income
Required 1 Required 2
Required 3
2018
$ 105,000
62,500
42,500
36,500
Required:
1. Compute the gross profit percentage for each year. Assuming the change from 2017 to 2018 is the beginning of a sustained trend, is
Gonzalez likely to earn more or less gross profit from each dollar of sales in 2019?
2. Compute the net profit margin for each year. Did Gonzalez do a better or worse job of controlling operating expenses in 2018
relative to 2017?
550
5,450
1,500
$ 3,950
3. Gonzalez reported average net fixed assets…
Chapter 13 Solutions
Managerial Accounting
Ch. 13 - Prob. 1QCh. 13 - Prob. 2QCh. 13 - What is ratio analysis? Why is it useful?
Ch. 13 - What benchmarks are commonly used for interpreting...Ch. 13 - Prob. 5QCh. 13 - Why are some analyses called horizontal and others...Ch. 13 - Slow Cellar’s current ratio increased from 1.2 to...Ch. 13 - From last year to this year. Colossal Company’s...Ch. 13 - From last year to this year, Berry Barn reported...Ch. 13 - Prob. 10Q
Ch. 13 - Prob. 1MCCh. 13 - Prob. 2MCCh. 13 - Prob. 3MCCh. 13 - Prob. 4MCCh. 13 - Prob. 5MCCh. 13 - Prob. 6MCCh. 13 - Prob. 7MCCh. 13 - Prob. 8MCCh. 13 - Prob. 9MCCh. 13 - Prob. 1MECh. 13 - Prob. 2MECh. 13 - Prob. 3MECh. 13 - Prob. 4MECh. 13 - Prob. 5MECh. 13 - Prob. 6MECh. 13 - Prob. 7MECh. 13 - Prob. 8MECh. 13 - Prob. 9MECh. 13 - Prob. 10MECh. 13 - Prob. 11MECh. 13 - Prob. 12MECh. 13 - Prob. 13MECh. 13 - Prob. 14MECh. 13 - Prob. 1ECh. 13 - Prob. 2ECh. 13 - Prob. 3ECh. 13 - Prob. 4ECh. 13 - Prob. 5ECh. 13 - Prob. 6ECh. 13 - Prob. 7ECh. 13 - Computing and Interpreting Liquidity Ratios...Ch. 13 - Prob. 9ECh. 13 - Prob. 10ECh. 13 - Prob. 11ECh. 13 - Prob. 12ECh. 13 - Prob. 13ECh. 13 - Analyzing the Impact of Selected Transactions on...Ch. 13 - Prob. 15ECh. 13 - Prob. 1.1GAPCh. 13 - Prob. 1.2GAPCh. 13 - Prob. 2.1GAPCh. 13 - Prob. 2.2GAPCh. 13 - Prob. 2.3GAPCh. 13 - Prob. 2.4GAPCh. 13 - Prob. 2.5GAPCh. 13 - Prob. 2.6GAPCh. 13 - Prob. 2.7GAPCh. 13 - Prob. 2.8GAPCh. 13 - Prob. 3.1GAPCh. 13 - Prob. 3.2GAPCh. 13 - Prob. 3.3GAPCh. 13 - Prob. 4.1GAPCh. 13 - Prob. 4.2GAPCh. 13 - Prob. 4.3GAPCh. 13 - Prob. 5.1GAPCh. 13 - Prob. 5.2GAPCh. 13 - Prob. 5.3GAPCh. 13 - Prob. 5.4GAPCh. 13 - Prob. 6.1GAPCh. 13 - Prob. 6.2GAPCh. 13 - Prob. 7GAPCh. 13 - Prob. 1.1GBPCh. 13 - Prob. 1.2GBPCh. 13 - Prob. 2.1GBPCh. 13 - Prob. 2.2GBPCh. 13 - Prob. 2.3GBPCh. 13 - Prob. 2.4GBPCh. 13 - Prob. 2.5GBPCh. 13 - Prob. 2.6GBPCh. 13 - Prob. 2.7GBPCh. 13 - Prob. 2.8GBPCh. 13 - Prob. 3.1GBPCh. 13 - Prob. 3.2GBPCh. 13 - Prob. 3.3GBPCh. 13 - Prob. 4.1GBPCh. 13 - Prob. 4.2GBPCh. 13 - Prob. 4.3GBPCh. 13 - Prob. 5.1GBPCh. 13 - Prob. 5.2GBPCh. 13 - Prob. 5.3GBPCh. 13 - Prob. 5.4GBPCh. 13 - Prob. 6.1GBPCh. 13 - Prob. 6.2GBPCh. 13 - Prob. 7GBP
Knowledge Booster
Similar questions
- According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2016. Let’s see whether these changes are reflected in the income statement of Computer Tycoon Inc. for the year ended December 31, 2016. 2016 2015 Sales Revenue $ 120,000 $ 150,000 Cost of Goods Sold 70,000 79,500 Gross Profit 50,000 70,500 Selling, General, and Administrative Expenses 38,000 41,000 Interest Expense 700 575 Income before Income Tax Expense 11,300 28,925 Income Tax Expense 2,500 7,000 Net Income $ 8,800 $ 21,925 Required: Compute the gross profit percentage for each year. Assuming that the change from 2015 to 2016 is the beginning of a sustained trend, is Computer Tycoon likely to earn more or less gross profit from each dollar of sales in 2017? Compute the net profit margin…arrow_forwardAccording to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of Wizard Computers for the year ended December 31, 2018. 2018 2017 Sales Revenue $ 118,000 $ 147,000 Cost of Goods Sold 69,000 78,700 Gross Profit 49,000 68,300 Selling, General, and Administrative Expenses 37,800 40,600 Interest Expense 680 565 Income before Income Tax Expense 10,520 27,135 Income Tax Expense 2,500 6,800 Net Income $ 8,020 $ 20,335 Required: Compute the times interest earned ratios for 2018 and 2017. Does Wizard generate sufficient net income in both years (before taxes and interest) to cover the cost of debt financing? yes or noarrow_forwardA condensed income statement for Weber Associates and a partially completed vertical analysis follow. Required: 1. Complete the vertical analysis by computing each missing line item as a percentage of net revenues. TIP: In the prior year, Cost of Goods Sold was 31 percent of Net Revenues, computed as ($1,397 ÷ $4,571). 2. Does Cost of Goods Sold, as a percentage of Net Revenues, represent better or worse performance in 2019 as compared to 2018? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Complete the vertical analysis by computing each missing line item as a percentage of net revenues. TIP: In the prior year, Cost of Goods Sold was 31 percent of Net Revenues, computed as ($1,397 ÷ $4,571). (Decreases should be indicated by a minus sign. Round your answers to the nearest whole percent.) Net Revenues Cost of Goods Sold Research and Development Expense Sales and Marketing Expense General and Administrative Expense Income from Operations Other…arrow_forward
- Calculate gross profit, cost of goods sold, and selling price MBI, Inc., had sales of $600 million for fiscal 2016. The company’s gross profit ratio for that year was 31.2%.Required:a. Calculate the gross profit and cost of goods sold for MBI, Inc., for fiscal 2016.b. Assume that a new product is developed and that it will cost $1,634 to manufacture. Calculate the selling price that must be set for this new product if its gross profit ratio is to be the same as the average achieved for all products for fiscal 2016.c. From a management viewpoint, what would you do with this information?arrow_forwardThe problem is stated in the picture. Here is the question: 1. Assume instead, the Company uses the Moving Average method in the measurement of its inventories, how much would be the weighted average cost per unit of the sales made at May 20? (Round off the final answers to two decimal places)arrow_forward7 According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2016. Let's see whether these changes are reflected in the income statement of Computer Tycoon Inc. for the year ended December 31, 2016. 2016 2015 Sales Revenue $113,000 66,500 46,500 $139,500 76,700 62,800 Cost of Goods Sold Gross Profit Вook Selling, General, and Administrative Expenses Interest Expense Income before Income Tax Expense Income Tax Expense 37,300 39,600 630 540 Hint 8,570 2,000 $ 6,570 22,660 6,300 $ 16,360 Print Net Income erences Required: 1. Compute the gross profit percentage for each year. Assuming that the change from 2015 to 2016 is the beginning of a sustained trend, is Computer Tycoon likely to earn more or less gross profit from each dollar of sales in 2017? 2. Compute the net profit margin for each year. Given your calculations here and in requirement 1, explain whether Computer…arrow_forward
- Time series analysis involves comparing a company’s income statement and balance sheet forthe current year to its previous years’ income statements and balance sheets.Required:Explain whether it is always bad if a company’s cost of goods sold is increasing from year to year.arrow_forwardAccording to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of Gonzalez Industries for the year ended December 31, 2018. Sales Revenue Cost of Goods Sold Gross Profit Selling, General, and Administrative Expenses Interest Expense Income before Income Tax Expense Income Tax Expense Net Income Required 1 Required: 1. Compute the gross profit percentage for each year. Assuming the change from 2017 to 2018 is the beginning of a sustained trend, is Gonzalez likely to earn more or less gross profit from each dollar of sales in 2019? 2. Compute the net profit margin for each year. Did Gonzalez do a better or worse job of controlling operating expenses in 2018 relative to 2017? Required 2 2018 $ 105,000 62,500 42,500 36,500 3. Gonzalez reported average net fixed assets of $54,700 in 2018 and $45,600 in…arrow_forwardDuring the current year, Sokowski Manufacturing earned income of $350,000 from total sales of $5,500,000 and average capital assets of $12,000,000. A. Based on this information, calculate asset turnover. B. Using the sales margin from the previous exercise, what is the total ROI for the company during the current year?arrow_forward
- The following revenue data were taken from the December 31, 2017, General Electric annual report (10-K): For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales. Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data. How might a division sales manager use this data?arrow_forwardUsing the information in the previous exercises about Marleys Manufacturing, determine the operating income for department B, assuming department A sold department B 1,000 units during the month and department A reduces the selling price to the market price.arrow_forwardThe financial analysis of a manufacturing company for the previous year yielded the following details: Component Net revenue Cost of goods sold Value on hand Raw material Work in process Finished goods Amount (in €). 30,000 18,000 900 1,000 1,500 The inventory turnover of the company is turns. (Enter your response rounded to two decimal places.)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning