EBK MANAGERIAL ACCOUNTING
3rd Edition
ISBN: 9781259738586
Author: Whitecotton
Publisher: MCGRAW HILL BOOK COMPANY
expand_more
expand_more
format_list_bulleted
Question
Chapter 13, Problem 4.3GBP
To determine
Introduction:
Vertical analysis help to express each financial statement line item as a percentage of the base year.
To state:
Whether there is an increase or decrease in the net profit margin of the company.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Which of the following is a technique for reviewing relationships on an income statement by assigning net sales as 100%? A. Ratio analysis. B. Current ratio. C. Horizontal analysis. D. Vertical analysis.
Case 1: Vertical Analysis of Profit and LossPrepare a vertical analysis of the income statements of GMA from 2007 to 2010 by usingRevenues as the base.1. Describe the trend of revenues from 2007 to 2010. What observations can be drawn?2. Describe the trend of direct costs from 2007 to 2010. What observations can be drawn?3. Describe the trend of operating expenses from 2007 to 2010. What observations can be drawn?4. Describe the trend of operating income from 2007 to 2010. What observations can be drawn?5. Describe the trend of net income from 2007 to 2010. What observations can be drawn?
Question 1
Mabel is a potter and sells her pottery at stalls that she rents in four tourist information centres
across the south of England.
Extracts from her financial statements for the years ended 31 December 2021 and 2020 are
shown below.
Statement of profit or loss for the year ended 31 December:
2021
28,900
|(16,500)
12,400
(3,800)
8,600
|(4,000)
4,600
2020
Revenue
27,200
(14,000)
13,200
(3,600)
9,600
Cost of sales
Gross profit
Operating expenses
Operating profit
Non-operating expenses
Net profit
9,600
Statement of financial position as at 31 December:
2021
Non-current assets
Current assets
Total assets
22,660
4,360
27,020
2020
20,920
3,750
24,670
Equity
Non-current liabilities
Current liabilities
Equity and liabilities
20,940
3,000
3,080
27,020
16,340
3,500
4,830
24,670
The following information is also relevant:
In July 2021 the rent on one of Mabel's stalls was increased significantly for the third time in
three years so she decided not to renew the annual contract. She sold…
Chapter 13 Solutions
EBK 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
- Using the information from 27A prepare the following ratios: gross profit margin profit margin return on assets earnings per share current ratio acid test ratio debt ratio Indicate what each is used for (ie: measuring efficiency, solvency etc)arrow_forwardRequirements: a. Prepare horizontal analysis based on the above statements presented (for percent: round of your answers to 2 decimal places) Music Lover, Inc.xlsx b. Evaluate the company's financial position and results of operation using the comparative statement analysis i. Short-term solvency analysis ii. Long-term financial position analysis iii. Operating efficiency and profitability analysisarrow_forwardComparative Income Statement Use the following comparative income statement form to enter amounts you identify from the computations on the Liquidity and Solvency Measures part and on the Profitability Measures part. Compute any missing amounts and complete the horizontal analysis columns. Enter percentages as decimal amounts, rounded to one decimal place. When rounding, look only at the figure to the right of one decimal place. If 5, round up. For example, for 32.048% enter 32.0%. For 32.058% enter 32.1%. Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total operating expenses Operating income Other expense (interest) Income before income tax expense Income tax expense Net income Comparative Income Statement For the Years Ended December 31, 20Y6 and 20Y5 $ 20Y6 8,250,000 X (1,242,000) 20Y5 $7,287,000 (3,444,000) $3,843,000 $(1,457,600) (1,106,000) $(2,563,600) $1,279,400 (120,600) $1,158,800 (181,980) $976,820 $ $ $ Increase/(Decrease) Amount 823,000 X…arrow_forward
- - Please refer to the following Income Statement and Balance Sheet (see attached picture): Prepare a vertical analysis for both the income statement and balance sheet. Write a paragraph comparing the company’s performance with the industry average. Compute the following ratios and comment on what the results mean when evaluating the company: Current ratio Gross profit percentage ratio Debt ratio Profit margin ratioarrow_forwardRequired: Compute the following: (For Requirements 1 to 4, enter your percentage answers rounded to 2 decimal places (i.e., 0.1234 should be entered as 12.34).) 1. Gross margin percentage. 2. Net profit margin percentage. 3. Return on total assets. 4. Return on equity. 5. Was financial leverage positive or negative for the year? 1. Gross margin percentage % 2. Net profit margin percentage % 3. Return on total assets % 4. Return on equity % 5. Financial Leveragearrow_forwardQuestion 51: In the vertical analysis of an income statement, what is the base (100%) figure? Answer: A. Total expenses B. Total revenues C. Total assets D. Net incomearrow_forward
- Required: (a) You are required to calculate the following ratios:(i) Gross profit margin(ii) Operating profit margin(iii) Expenses to sales(iv) Return on Capital Employed(v) Asset turnover(vi) Non-current asset turnover(vii) Current Ratio(viii) Quick Ratio(ix) Inventory days(x) Receivables days(xi) Payable days(xii) Interest cover (b) In light of your calculations comment on the performance of the company over thelast two years.arrow_forwardVanishing Games Corporation (VGC) operates a massively multiplayer online game, charging players a monthly subscription of $15. At the start of January 2021, VGC's income statement accounts had zero balances and its balance sheet account balances were as follows: Cash Accounts Receivable Supplies Equipment Buildings Land Accounts Payable Deferred Revenue Notes Payable (due 2025) Common Stock Retained Earnings $ 1,500,000 150,000 14,700 874,500 422,000 1,200,000 108,000 73,500 60,000 2,500,000 1,419,700 In addition to the above accounts, VGC's chart of accounts includes the following: Service Revenue, Salaries and Wages Expense, Advertising Expense, and Utilities Expense. The January transactions are shown below: a. Received $50,000 cash from customers on 1/1 for subscriptions that had already been earned and charged on account in 2020. b. Purchased 10 new computer servers for $33,500 on 1/2; paid $10,000 cash and signed a three-year note for the remainder owed. c. Paid $10,000 for an…arrow_forwardANALY SIS OF PROFITABILITY Based on the financial statement data in Exercise 24-1A, compute the following profitability measures for 20-2 (round all calculations to two decimal places): (a) Profit margin ratio (b) Return on assets (c) Return on common stockholders equity (d) Earnings per share of common stockarrow_forward
- Income statements for Campbell Company for Year 3 and Year 4 follow: CAMPBELL COMPANY Income Statements Year 4 Year 3 $180,800 120,400 19,900 14,500 Sales $200,800 Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses 142,400 21,900 12,500 3,900 $180,700 5,900 $160,700 20,100 3,700 Income before taxes 20,100 Income taxes expense 6,500 Net income $ 13,600 $ 16,400 Required a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year. Complete this question by entering your answers in the tabs below. Required A Required B Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. (Negative answers should be indicated by a minus sign. Round your percentage answers to 1 decimal place. (i.e., 0.234 should be entered…arrow_forward5. Profitability ratios Profitability ratios help in the analysis of the combined impact of liquidity ratios, asset management ratios, and debt management ratios on the operating performance of a firm. Your boss has asked you to calculate the profitability ratios of Diusitech Inc. and make comments on its second-year performance as compared with its first-year performance. The following shows Diusitech Inc.'s income statement for the last two years. The company had assets of $4,700 million in the first year and $7,518 million in the second year. Common equity was equal to $2,500 million in the first year, and the company distributed 100% of its earnings out as dividends during the first and the second years. In addition, the firm did not issue new stock during either year. Diusitech Inc. Income Statement For the Year Ending on December 31 (Millions of dollars) Year 2 Year 1 2,540 2,000 1,610 1,495 127 80 1,737 803 80 723 181 542 Net Sales Operating costs except depreciation and…arrow_forwarda) Based on the information provided, calculate the following ratios for the years ended 31December 2021 and 2020.You should give the formula for each ratio, in addition to your calculation.I. Gross profit marginII. Operating profit marginIII. Return on equityIV. Current ratioV. Gearing b) By comparing the financial information for years ended 31 December 2021 and 2020, andreviewing your ratio calculations, comment on the profitability, liquidity, and long-termsolvency of Mabel’s business over the past year. You should use the other information givento suggest reasons for any changes identified. c)If an investor was interested in buying Mabel’s business and was presented with theseresults, what further advice would you give them?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning