MANAGERIAL ACCOUNTING >C<
3rd Edition
ISBN: 9781259948503
Author: Whitecotton
Publisher: MCG CUSTOM
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 13, Problem 4ME
To determine
Introduction:
Vertical analysis help to express each financial statement line item as a percentage of the base year. It helps in making the comparison between two items of the statement for different years.
To state:
The ratios calculated in the vertical analysis and compare the results of these ratios from previous year to current year.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
If Year 1 sales equal $830, Year 2 sales equal $913, and Year 3 sales equal $1130, the percentage to be assigned for Year 2 in a trend analysis, assuming that Year 1 is the base year, is
110%.
136%.
91%.
124%.
eTextbook and Media
Required 1. Compute each year’s current ratio. Round ratios to one decimal. 2. Express the income statement data in common-size percents. Round percents to two decimals. 3. Express the balance sheet data in trend percents with 2017 as the base year. Round percents to two decimals. Analysis Component 4. Comment on any significant relations revealed by the ratios and percents computed.
A. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. Round percentages to one decimal place.
B. What conclusions can be drawn from the horizontal analysis? Round the answers to one decimal place.
Chapter 13 Solutions
MANAGERIAL ACCOUNTING >C<
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
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
- If Year 1 sales equal $750, Year 2 sales equal $1500, and Year 3 sales equal $930, the percentage to be assigned for Year 2 in a trend analysis, assuming that Year 1 is the base year, isarrow_forwardPrepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place. Yesarrow_forwardCompute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable. Sales $ 666,761 $ 432,962 $ 344,990 $ 249,090 $ 180,500 Cost of goods sold 329,263 213,901 172,445 124,054 88,445 Accounts receivable 32,138 25,242 23,632 14,547 12,328arrow_forward
- Conduct a vertical analysis (common-size financial statements). Comment on the components of the financial statements by year and its trend for the last three years. (Note: please see second picture as example for vertical analysis. The first picture is the given.)arrow_forwardCommon-size financial statements recast each statement item as: Multiple Choice a percentage using industry averages for the "base number." a percentage using a base year number for each line item. a percentage of some "base number" on the financial statement in question. a percentage of the "bottom line."arrow_forwardPlease select THREE of the ratios listed below and perform them for years 2012 and 2011. Please interpret the data by including the following: (1) Write out the formula for each ratio you selected and show your calculations. (2) Discuss whether each ratio you selected measures liquidity or profitability and what those terms mean. (3) What factor(s) contributed to the increase or decrease from last year? Discuss whether those changes were favorable or unfavorable to the company and why? (4) What does each of your calculated ratios potentially mean for the company’s overall financial condition? Please assume the market price of the common stock on 12/31/11 was $113.40. Also, if you need any numbers from 2010 for averages, please use the following: Cash 300,000 Marketable securities 1,000,000 A/R 345,000 Inventory 647,000 Prepaids 220,000…arrow_forward
- Addai Company has provided the following comparative information: You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years:2010-2014Rate earned on total assets ........28%Rate earned on stockholders' equity .....18%Number of times interest charges are earned. 2.7Ratio of liabilities to stockholders' equity... 0.4Instructions1. Prepare four line graphs with the ratio on the vertical axis and the years on the horizontal axis for the following four ratios (rounded to one decimal place):a. Rate earned on total assetsb. Rate earned on stockholders' equityc. Number of times interest charges are earnedd. Ratio of liabilities to stockholders' equityDisplay both the company ratio and the industry benchmark on each graph. That is, each graph should have two lines.2. Prepare an analysis of the graphs in(1).arrow_forwardVee-Jay Company (Pty) Ltd Extracted the following Ratios from its books for the year 2020 together with the relevant industry averages RATIOS 2020 Industry average 1. Current Ratio 1,9 2 2. Acid test ratio 0,8 1 3. Inventory Turnover 4 times 6 times 4. Debtors’ collection period (days) 51 days 40 days 5. Creditors payment period (days) 61 days 50 days Required:1. For each of the above five ratios , answer the following :a) what does the ratio measureb) state whether there is an improvement or decline in the ratio in comparison with the industry average 2. Comment on the company’s overall liquidity position in comparison with industry.arrow_forwardIdentify any favorable and unfavorable trends in the following income statements by preparing a vertical analysis. (Round percentages to two decimal places.) Year 2 Year 1 Revenues $394,000 $212,500 Operating expenses: Wages expense $ 79,000 $ 65,000 Rent expense 19,000 18,000 Utilities expense 21,000 14,200 Interest expense 7,500 7,800 Total operating expenses $126,500 $105,000 Net income $267,500 $107,500arrow_forward
- a) Compute Costco’s current ratio and quick ratio for 2006 and 2005. (Round answers two decimal places.) 2006 current ratio =?2005 current ratio =?2006 quick ratio =?2005 quick ratio =? (b) Compute Target's times interest earned and its liabilities-to-equity ratios for 2006 and 2005. (Round your answers to two decimal places.) 2006 times interest earned =?2005 times interest earned =?2006 liabilities-to-equity =?2005 liabilities-to-equity =?Comment on any observed trends. Which of the following statements best describes any trend in Target's liabilities-to-equity ratios? Choose the right Option from below a)The decrease in Target's liabilities-to-equity ratio remained constant. b)Target's liabilities-to-equity ratio decreased slightly in 2006, we have no concerns about Target's's ability to meet its debt obligations. c)Target's liabilities-to-equity ratio increased during the year primarily due to a decrease in its equity. d)Target's liabilities-to-equity ratio decreased due to a…arrow_forwardCompute increases (decreases) in percents for both Years 6 and 7 by entering all the missing data in the table below. Analyze and interpret any significant results revealed from this trend analysis.arrow_forwardFor the return on equity (ROE) and return on assets (ROA) ratios, perform a DuPont decomposition andanalyze the components of the ratios in both years. Comment on which components of the ROE and ROAratios are driving the changes in the ratios you observe. Here is my ROE for years 2021 (1728.1 / 11,951.5= 14.5%) and 2020 (1066.8 / 9759.1= 11.3%) Here is my ROA for 2021 (1728.1 / 13,555) * 100 = 12.7488% and 2020 (1066.8 / 11,168.9) * 100 = 9.5515%arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher: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
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
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
Accounts Receivable and Accounts Payable; Author: The Finance Storyteller;https://www.youtube.com/watch?v=x_aUWbQa878;License: Standard Youtube License