Horngren's Financial & Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780133866292
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 15, Problem 15.17E
To determine
Vertical Analysis: Vertical analysis is prepared to analyze the relationship among various financial statements with a particular base amount. Use the following formula to calculate vertical analysis percentage:
This analysis is otherwise called as common-size statement.
To perform: Vertical analysis for T company’s
Given info: Balance sheet of Company T for 2016 and 2015
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
What is the base vertical analysis on the balance sheet?
The first year presented
Total liabilities and equity
Sales revenue
Total equity
Total current assets
Required:
(a) You are required to calculate the following ratios:(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.
=
The current year financial statements for Blue Water Company and Prime Fish Company are presented below.
Prime Fish
Balance sheet
Cash
Accounts receivable (net)
Inventory
Property & equipment (net)
Other assets
Total assets
Current liabilities
Long-term debt (interest rate: 15%)
Capital stock ($10 par value)
Additional paid-in capital
Retained earnings
Total liabilities and stockholders' equity
Income statement
Sales revenue (1/2 on credit)
Cost of goods sold
Operating expenses
Net income
Other data
Per share stock price at end of current year
Blue Water
$ 42,300
44,500
92,500
159,500
85,300
$ 424,100
$ 92,500
74,100
157,100
30,300
70,100
$ 424,100
$ 427,500
(234,500)
(163,600)
$ 29,400
$ 23.3
45%
$ 19,700
34,900
47,800
416,600
318,000
$ 34,300
$ 837,000
$ 68,500
62,600
525,000
107,300
73,600
$ 837,000
$ 789,000
(401,300)
(312,300)
$ 75,400
$28
45%
Average income tax rate
Dividends declared and paid in current year
Both companies are in the fish catching and manufacturing business.…
Chapter 15 Solutions
Horngren's Financial & Managerial Accounting (5th Edition)
Ch. 15 - What part of the Libertys annual report is written...Ch. 15 - Horizontal analysis of Liberty's balance sheet for...Ch. 15 - Vertical analysis of Liberty's balance sheet for...Ch. 15 - Which statement best describes Liberty's acid-test...Ch. 15 - Liberty's inventory turnover during 2017 was...Ch. 15 - Prob. 6QCCh. 15 - Prob. 7QCCh. 15 - Liberty's rate of return on common stockholders'...Ch. 15 - The company has 2,500 shares of common stock...Ch. 15 - Prob. 10AQC
Ch. 15 - What ate the three main ways to analyze financial...Ch. 15 - What is an annual report? Briefly describe the key...Ch. 15 - Prob. 3RQCh. 15 - What is trend analysis, and how does it differ...Ch. 15 - Prob. 5RQCh. 15 - Prob. 6RQCh. 15 - Prob. 7RQCh. 15 - Briefly describe the ratios that can be used to...Ch. 15 - Prob. 9RQCh. 15 - Briefly describe the ratios that can be used to...Ch. 15 - Briefly describe the ratios that can be used to...Ch. 15 - Prob. 12RQCh. 15 - Prob. 13RQCh. 15 - Prob. 14RQCh. 15 - Prob. 15RQCh. 15 - Prob. 15.1SECh. 15 - Performing horizontal analysis McDonald Corp....Ch. 15 - Calculating trend analysis Variline Corp. reported...Ch. 15 - Performing vertical analysis Hoosier Optical...Ch. 15 - Preparing common-size income statement Data for...Ch. 15 - Shine's Companies, a home improvement store chain,...Ch. 15 - Shine's Companies, a home improvement store chain,...Ch. 15 - Shine's Companies, a home improvement store chain,...Ch. 15 - Prob. 15.9SECh. 15 - Prob. 15.10SECh. 15 - Prob. 15.11SECh. 15 - Using ratios to reconstruct a balance sheet...Ch. 15 - Prob. 15.13SECh. 15 - Prob. 15.14SECh. 15 - Prob. 15.15ECh. 15 - Computing trend analysis Grand Oaks Realty's net...Ch. 15 - Prob. 15.17ECh. 15 - Prob. 15.18ECh. 15 - Prob. 15.19ECh. 15 - Prob. 15.20ECh. 15 - Analyzing the ability to pay liabilities Big Bend...Ch. 15 - Analyzing profitability Varsity, Inc.s comparative...Ch. 15 - Prob. 15.23ECh. 15 - Using ratios to reconstruct a balance sheet The...Ch. 15 - Prob. 15.25ECh. 15 - Computing earnings per share Falconi Academy...Ch. 15 - Prob. 15.27APCh. 15 - Prob. 15.28APCh. 15 - Prob. 15.29APCh. 15 - Prob. 15.30APCh. 15 - Using ratios to evaluate a stock investment...Ch. 15 - Prob. 15.32APCh. 15 - Preparing an income statement The following...Ch. 15 - Computing trend analysis and return on common...Ch. 15 - Prob. 15.35BPCh. 15 - Prob. 15.36BPCh. 15 - Determining the effects of business transactions...Ch. 15 - Prob. 15.38BPCh. 15 - Prob. 15.39BPCh. 15 - Prob. 15.40BPCh. 15 - Prob. 15.41CPCh. 15 - Lance Berkman is the controller of Saturn, a dance...Ch. 15 - Prob. 15.1CTEI
Knowledge Booster
Similar questions
- Using the following Balance Sheet summary information, for the two years presented calculate: A. working capital B. current ratioarrow_forwardUsing the following Balance Sheet summary information, calculate for the two years presented: A. working capital B. current ratioarrow_forwardWhich of the following is used to determine how the sales revenue of a company has changed from one year to the next? A horizontal analysis of the income statement B vertical analysis of the income statement C vertical analysis of the balance sheet D horizontal analysis of the balance sheetarrow_forward
- Please Helparrow_forward.arrow_forwardThe following data (in millions) were taken from the financial statements of Costco Wholesale Corporation: a. For Costco, determine the amount of change in millions and the percent of change (round to one decimal place) from the prior year to the recent year for: 1. Revenue 2. Operating expenses 3. Operating income b. Comment on the results of your horizontal analysis in part (a). c. Based upon Exercise 2-23, compare and comment on the operating results of Target and Costco for the recent year.arrow_forward
- The following items are reported on a companys balance sheet: Determine (a) the current ratio and (b) the quick ratio. Round to one decimal place.arrow_forwardThe following historical information is from Assisi Community Markets. Calculate the working capital and current ratio for each year. What observations do you make, and what actions might the owner consider taking?arrow_forwardCuneo Companys income statements for the last 3 years are as follows: Refer to the information for Cuneo Company above. Required: 1. Prepare a common-size income statement for Year 2 by expressing each line item for Year 2 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 3 by expressing each line item for Year 3 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.)arrow_forward
- Grammatico Company has just completed its third year of operations. The income statement is as follows: Selected information from the balance sheet is as follows: Required: Note: Round answers to two decimal places. 1. Compute the times-interest-earned ratio. 2. Compute the debt ratio. 3. CONCEPTUAL CONNECTION Assume that the lower quartile, median, and upper quartile values for debt and times-interest-earned ratios in Grammaticos industry are as follows: How does Grammatico compare with the industrial norms? Does it have too much debt?arrow_forwardlonic Exploration Company reported these figures for 2018 and 2017: E (Click the icon to view the figures.) Compute the rate of return on total assets for 2018. (Round to two decimals.) Select the formula, then enter the amounts to compute the rate of return on total assets for 2018. (Enter the rate of return as a percent rounded to two decimal places, X.XX%.) Rate of return on total assets %3D Data Table S: Income Statement-partial: 2018 2017 Interest Expense $ 17,800,000 $ 14,500,000 Net Income 18,400,000 14,600,000 Balance Sheet-partial: Dec. 31, 2018 Dec. 31, 2017 Total Assets $ 322,000,000 $ 320,000,000 Print Donearrow_forwardeBook Print References INCOME STATEMENT (Figures in 5 millions) Net sales Cost of goods sold Other expenses Depreciation Earnings before interest and taxes (EBIT) Interest expense Income before tax Taxes (at 21%) Net income Dividends Assets Cash and marketable securities Receivables Inventories Other current assets Total current assets. BALANCE SHEET (Figures in $ millions) Net property, plant, and equipment Other long-term assets $ 12,600 3,760 4,127 2,338 $ 2,375 655 Total assets Liabilities and shareholders' equity Payables Short-term debt $1,720 361 $ 1,359 $816 Other current liabilities Total current liabilities Long-term debt and leases Other long-term liabilities Shareholders' equity Total liabilities and shareholders' equity End of Year Start of Year $ 152 2,370 208 902 $ 3,632 19,855 3,710 $ 27,197 $83 2,082 157 837 $ 3,159 19,913 4,156 $ 27,228 $ 2,504 1,389 781 $ 4,674 8,512 6,118 7,924 $ 27,228 $ 2,980 1,543 757 $5,280 7,907 6,089 7,921 $ 27,197 Calculate the following…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College- 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
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
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