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 4.1GBP
To determine
Introduction:
Vertical analysis help to express each financial statement line item as a percentage of the base year.
To compute:
The missing values from “a” till “f” in the given table and rounding off the answer to near whole percentage.
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.
Perform a vertical analysis for the entry "Gross Sales" on the portion of an income statement shown below (as a %). (Round to nearest tenth.)
*Chart is attached with the information*
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…
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
- Requirements: 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_forwardPreparing Common-Size Income Statements by Using BasePeriod Horizontal AnalysisRefer to the information for Scherer Company on the previous page.Required:Prepare common-size income statements by using Year 1 as the base period. (Note: Roundanswers to the nearest whole percentage.)arrow_forward
- Refer to the information for Sundahl Company on the previous page.Required:1. Prepare a common-size income statement for Year 1 by expressing each line item as apercentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.)2. Prepare a common-size income statement for Year 2 by expressing each line item as apercentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.)arrow_forwardPerform a vertical analysis of the P&L (FS Company). "Formula: Vertical Analysis % Each income statement items / Revenues (or Net sales) Fill in each Blank. Round your answers to the nearest tenth percent, i.e. 4.5%. PLEASE SUBMIT YOUR ANSWERS IN % and include the % symbol. Do not leave any blank. If the answer is 0, be sure to put 0. Cost of goods sold Gross profit Net sales $858,000 Select] Other expenses Interest revenue Income from operations Interest expense 2018 Income before income taxes Income tax expense Net income 513,000 345,000 244,000 101,000 4,000 24,000 81,000 33,000 FS Company Comparative P&L statement Years Ended December 31, 2018 and 2017 48,000 % of sales Select J [Select] | Select | [Select] [Select] [Select] [ Select] Select] Select > >arrow_forwardIncome statements for Walton Company for Year 3 and Year 4 follow: WALTON COMPANY Income Statements. Sales Cost of goods sold. Selling expenses Administrative expenses Interest expense Total expenses Income before taxes Income taxes expense Net income Required A Required B Year 4 $200, 300 143,300 20,900 12,900 3,200 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. Sales Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses Income before taxes Income taxes expense Net income $180,300 $160,300 20,000 20,000 3,300 5,600 $ 14,400 $ 16,700 Complete this question by entering your answers in the tabs below. Year 3 $180,300 X Answer is complete but not entirely correct. Perform a vertical analysis, showing each income statement component as a percentage of…arrow_forward
- Comparative income statements for Pearle Company are provided: Required: Perform a horizontal analysis of Pearle Company's income statement by computing horizontal percentages for each item. Note: Round your answers to 1 decimal place. Sales Less cost of goods sold Gross margin Less operating expenses Income before taxes Income taxes Net income Pearle Company Comparitive Income Statement Years Ended December 31, Year 2 Year 1 $ 600,000 $ 539,700 388,700 361,650 $ 211,300 113,950 97,350 42,440 54,910 $ 178,050 103,770 74,280 33,412 40,868 Percentage Change 90.0 % % % % % % %arrow_forwardPlease Complete the Following: 1. Complete a vertical and horizontal analysis on the tabs labeled "Balance Sheet" and "Income Statement", use total assets on the balance sheet and net sales on the income statement for your vertical analysis. 2. Using the balance sheet and income statement, complete the ratios on the tab labeled "Ratios" 3. Answer the final OBSERVATION QUESTION (listed under Ratios calculations) Consolidated Balance Sheets (USD $) 12/31/2020 Vertical Analysis 12/31/2019 Vertical Analysis Horizontal Analysis In Millions, unless otherwise specified Current Assets: Cash and Cash Equivalents $1,723 $1,929 Receivables, net 1,484 1,398 Merchandise Inventories 11,079 11,057 Other Current Assets 1,016 895 Total Current Assets 15,302 15,279 Property and Equipment, at…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_forward
- 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_forwardPrepare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3. Complete this question by entering your answers in the tabs below. Analysis Analysis Bal Sheet Inc Stmt Prepare a vertical analysis of an income statements for Year 4 and Year 3. (Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .2345 should be entered as 23.45).) Revenues Sales (net) Other revenues Total revenues RUNDLE COMPANY Vertical Analysis of Income Statements Year 4 Expenses Cost of goods sold Selling, general, and administrative expense Net income Interest expense Income tax expense Total expenses Amount $ 230,300 8,900 239,200 Percentage of Total 119,400 54,300 6,700 22,100 202,500 $ 36,700 Show lessarrow_forwardGiven the profit loss (income statement) and balance sheet for Sam’sSandwich Delivery (Table 4–8), answer the following:a. Calculate the current and quick ratios.b. Using the inventory figure on the balance sheet as average inventory, calculatethe inventory turnover ratio.c. Calculate the debt-to-equity ratio, debt-to-total-asset ratio, and operatingprofit margin ratio.d. Perform a vertical analysis of the income statement.e. Perform a vertical analysis of the balance sheet.f. Based on your analysis, would you consider investing in Sam’s SandwichDelivery?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher: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