Cornerstones of Financial Accounting
4th Edition
ISBN: 9781337690881
Author: Jay Rich, Jeff Jones
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 12, Problem 97.1C
To determine
Concept introduction:
Horizontal analysis is a way of making a comparison of financial statements of two years in which one year is taken to be the base year and the comparison is done with the like items and results are given in terms of percentage.
Vertical analysis is a way of comparison of two items in the respective statement. This means that every item of balance sheet is being compared with the total assets of the company and every item of income statement is being compared with the total sales of the period of the company.
To prepare:
The common size income statements which are to be used for both vertical and horizontal analysis for
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Liverton Co.’s income statement for the year ended 31 March 2019 and statements of financial position at 31 March 2019 and 2018 were as follows in the images.
Calculate for the financial year ended 31 March 2019 and, where possible, for 31 March 2018, the following ratios:
i) Gross profit marginii) Assets usageiii) Current ratioiv) Acid testv) Inventories holding periodvi) Debt to Equity ratio
Below is the balance sheet and income statement for Chin Corporation. You are needed to analyze the financial statements. Use the horizontal, vertical, ratio methods to analyze the financial statements. For the vertical and horizontal analysis, type the accounts and dollar values for the years 2018 and 2017 (as listed on the financial statements even if there is no dollar value for an account). For the ratio analysis, make sure to compute 2 ratios from each section.
Income Statement
Period Ending:
12/31/2018
12/31/2017
Total Revenue
$76,512,000
$78,291,000
Cost of Revenue
$54,884,000
$56,586,000
Gross Profit
$21,628,000
$21,706,000
Operating Expenses
Research and Development
$0
$0
Sales, General, and Admin.
$13,886,000
$13,599,000
Non-Recurring Items
$0
$0
Other Operating Items
$0
$0
Operating Income
$7,832,000
$8,079,000
Add'l income/expense items
-$323,000…
Byers Company presents the following condensed income statement for 2019 and condensed December 31, 2019, balance sheet: Compute the following ratios for Byers ( round all computations to two decimals): ( 1) earnings per share, ( 2) gross profit margin, ( 3) operating profit margin, ( 4) net profit margin, ( 5) total asset turnover, ( 6) return on assets, (7) return on common equity, (8) receivables turnover (in days), and (9 ) interest coverage.
Chapter 12 Solutions
Cornerstones of Financial Accounting
Ch. 12 - Describe how some of the primary groups of users...Ch. 12 - Prob. 2DQCh. 12 - Prob. 3DQCh. 12 - Prob. 4DQCh. 12 - Prob. 5DQCh. 12 - Prob. 6DQCh. 12 - Prob. 7DQCh. 12 - Prob. 8DQCh. 12 - Prob. 9DQCh. 12 - Prob. 10DQ
Ch. 12 - Prob. 11DQCh. 12 - 12. Why are higher asset turnover ratios...Ch. 12 - Prob. 13DQCh. 12 - Prob. 14DQCh. 12 - Prob. 15DQCh. 12 - Prob. 16DQCh. 12 - Which of the following use financial statement...Ch. 12 - Prob. 2MCQCh. 12 - Prob. 3MCQCh. 12 - Prob. 4MCQCh. 12 - Prob. 5MCQCh. 12 - Prob. 6MCQCh. 12 - Prob. 7MCQCh. 12 - Which type of analysis compares a single...Ch. 12 - Which of the following types of analysis compares...Ch. 12 - Which of the following types of analysis is...Ch. 12 - Prob. 11MCQCh. 12 - Prob. 12MCQCh. 12 - Prob. 13MCQCh. 12 - Partial information from Fabray Companys balance...Ch. 12 - Hummel Inc. has $30,000 in current assets and...Ch. 12 - Prob. 16MCQCh. 12 - A firms quick ratio is typically computed as: a....Ch. 12 - Prob. 18MCQCh. 12 - Prob. 19MCQCh. 12 - Prob. 20MCQCh. 12 - Prob. 21MCQCh. 12 - Prob. 22MCQCh. 12 - Prob. 23MCQCh. 12 - When analyzing a companys debt to equity ratio,...Ch. 12 - Prob. 25MCQCh. 12 - Prob. 26MCQCh. 12 - Prob. 27MCQCh. 12 - Prob. 28MCQCh. 12 - Prob. 29MCQCh. 12 - Prob. 30MCQCh. 12 - Which of the following ratios is used to measure...Ch. 12 - Prob. 32MCQCh. 12 - Selected information for Berry Company is as...Ch. 12 - Which of the following ratios is used to measure a...Ch. 12 - Prob. 35MCQCh. 12 - Prob. 36MCQCh. 12 - Prob. 37MCQCh. 12 - Prob. 38MCQCh. 12 - Which of the following are not part of common...Ch. 12 - Prob. 40MCQCh. 12 - Prob. 41MCQCh. 12 - Prob. 42MCQCh. 12 - Which of the following is not included in the...Ch. 12 - When a Dupont analysis reveals that a company has...Ch. 12 - Prob. 45MCQCh. 12 - Cross Sectional Analysis Cross sectional analysis...Ch. 12 - Prob. 47CECh. 12 - Prob. 48CECh. 12 - Short-Term Liquidity Ratios Three ratios...Ch. 12 - Debt Management Ratios Selected data from the...Ch. 12 - Debt Management and Short-Term Liquidity Ratios...Ch. 12 - Asset Efficiency Ratios Selected financial...Ch. 12 - Profitability Ratios The following data came from...Ch. 12 - Prob. 54CECh. 12 - Prob. 55CECh. 12 - Prob. 56CECh. 12 - Prob. 57BECh. 12 - Prob. 58BECh. 12 - Prob. 59BECh. 12 - Short-Term Liquidity Ratios Larry, Curly, and Moe...Ch. 12 - Debt Management Ratios Glow Corporation provides...Ch. 12 - Debt Management and Short-Term Liquidity Ratios...Ch. 12 - Asset Efficiency Ratios Rumsford Inc.s financial...Ch. 12 - Prob. 64BECh. 12 - Profitability Ratios Tinker Corporation operates...Ch. 12 - Profitability Ratios Katrina Corp. is a publicly...Ch. 12 - Prob. 67BECh. 12 - Prob. 68ECh. 12 - Prob. 69ECh. 12 - Prob. 70ECh. 12 - Prob. 71ECh. 12 - Horizontal Analysis of Income Statements...Ch. 12 - Prob. 73ECh. 12 - Prob. 74ECh. 12 - Prob. 75ECh. 12 - Prob. 76ECh. 12 - Prob. 77ECh. 12 - Prob. 78ECh. 12 - Prob. 79ECh. 12 - Asset Efficiency Ratios Refer to financial...Ch. 12 - Prob. 81ECh. 12 - Prob. 82ECh. 12 - Prob. 83ECh. 12 - Prob. 84PSACh. 12 - Prob. 85PSACh. 12 - Prob. 86PSACh. 12 - A Using Common Size Statements The following...Ch. 12 - Prob. 88PSACh. 12 - Prob. 89PSACh. 12 - Prob. 90PSACh. 12 - A Comparing Financial Ratios Presented below are...Ch. 12 - A Preparation of Ratios Refer to the financial...Ch. 12 - Accounting Alternatives and Financial Analysis...Ch. 12 - Prob. 84PSBCh. 12 - Prob. 85PSBCh. 12 - Prob. 86PSBCh. 12 - Prob. 87PSBCh. 12 - Prob. 88PSBCh. 12 - Prob. 89PSBCh. 12 - Prob. 90PSBCh. 12 - Comparing Financial Ratios Presented below are...Ch. 12 - Prob. 92PSBCh. 12 - Problem 1 2-93B Accounting Alternatives and...Ch. 12 - Prob. 94CCh. 12 - Prob. 95.1CCh. 12 - Prob. 95.2CCh. 12 - Prob. 96.1CCh. 12 - Prob. 96.2CCh. 12 - Prob. 97.1CCh. 12 - Prob. 97.2CCh. 12 - Prob. 97.3CCh. 12 - Prob. 97.4CCh. 12 - Analyzing Growth Consolidated financial statements...Ch. 12 - Analyzing Growth Consolidated financial statements...Ch. 12 - Prob. 98.1CCh. 12 - Prob. 98.2CCh. 12 - Prob. 98.3CCh. 12 - CONTINUING PROBLEM: FRONT ROW ENTERTAINMENT The...Ch. 12 - Prob. 99.2CCh. 12 - Prob. 99.3CCh. 12 - Prob. 99.4CCh. 12 - Prob. 99.5C
Knowledge Booster
Similar questions
- Please 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_forwardVII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Securities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 245,000 220,000 Operating Expenses: Fixed Assets 200,000 160,000 Selling Expenses 22,000 25,000 Total Assets P445,000…arrow_forwardVII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Secuities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 220,000 200,000 160,000 P445,000 P380,000 245,000 Operating Expenses: Fixed Assets Selling Expenses 22,000 25,000 Total…arrow_forward
- Using the following select financial statement information from Black Water Industries, compute the accounts receivable turnover ratios for 2018 and 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Black Water Industries?arrow_forwardUse the information provided from Sapphire Ltd to calculate the ratios for 2022 (expressed to two decimal places) that would reflect each of the following:1. The profit of the company relative to sales after deducting the cost of sales.2. The ability of the company to profitably utilize its capital, which includes both debt and equity.3. The proportion of the total assets that are financed by total debt.4. The ability of the company to repay its short-term debts under distress conditions, on the assumption that inventories would have no value at all.5. The portion of the company's profit that is allocated to each outstanding ordinary share.6. An indication of the percentage of profit that has been put back into the company.arrow_forwardHello! look at the attached images and answee the following points: (a) Calculate ratios for the year ended 31 December 2021 (showing your workings) for Primrose Plc, equivalent to those provided above. Return on year-end capital employed Net asset turnover Gross profit margin Net profit margin Current ratio Closing inventory holding period Trade receivables’ collection period viii. Trade payables’ payment period Dividend yield Dividend cover (b) Analyse the financial performance and position of Primrose Plc for the year ended 31 December 2021 compared to 31 December 2020. (c) Explain the uses and the general limitations of ratio analysis. Thank you a lot!arrow_forward
- Required information [The following information applies to the questions displayed below.] Jordan Sales Company (organized as a corporation on April 1, 2017) has completed the accounting cycle for the second year, ended March 31, 2019. Jordan also has completed a correct trial balance as follows: JORDAN SALES COMPANY Trial Balance At March 31, 2019 Account Titles Debit Credit Cash $ 58,000 Accounts receivable 49,000 1,000 34,000 Office supplies inventory Automobiles (company cars) Accumulated depreciation, automobiles Office equipment Accumulated depreciation, office equipment Accounts payable Income taxes payable Salaries and commissions payable Note payable, long-term Capital stock (par $1; 33,000 shares) Paid-in capital Retained earnings (on April 1, 2018) Dividends declared and paid during the current year Sales revenue $ 14,000 3,000 1,000 22,000 2,000 33, 0өө 33,000 5,000 7,500 10,500 99,000 Cost of goods sold Operating expenses (detail omitted to conserve time) Depreciation…arrow_forward[The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2020, 2019, and 2018 2928 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets Long-term investments Plant assets, net Total assets Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity KORBIN COMPANY Comparative Balance Sheets December 31, 2020, 2019, and 2018 2020 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets Long-term investments Plant assets, net Total assets $ 481,536 289,885 191,651 68,378 43.338 111,716 79,935 14,868 $ 65,067 Liabilities and Equity Current liabilities…arrow_forwardepare an income statement for the year ended December 31, 2018, which includes amounts gross profit, income before income taxes, and net income. List expenses (other than cost of for goods sold and income tax expense) in order, from the largest to the smallest dollar balance. You may ignore earnings per share. pare a statement of retained earnings for the year ending December 31, 2018. Prepare thes a statement of financial position (balance sheet) as of December 31, 2018, following Include separate asset and liability categories for those items that are "current." Include and label amounts for total assets, total liabilities, total stockholders' equity, and total liabilities and stockholders' equity. Present deferred income taxes as a noncurrent liability. To the extent information is available that should be disclosed, include the parenthetical disclosure of that information.arrow_forward
- REQUIRED Use the information provided below to calculate the ratios for 2021 (expressed to two decimal places) that would reflect each of the following: The time taken by the company to settle its debts with trade suppliers The amount of debt that the company uses to finance its assets The operational effectiveness of the company before considering interest income,interest expense and company tax. What investors are willing to pay for the shares of the company with due considerationgiven to the profit generated by each share in the company. Comment on the FIVE (5) ratios of Oslo Limited as compared to the industry average provided in the additional information. INFORMATION The information given below was extracted from the books of Oslo Limited: OSLO LIMITED STATEMENT OF COMPREHENSIVE…arrow_forwardThe following are the balance sheet and income statement data of ABC Company: Requirements: 1. Prepare comparative balance sheets for 2019 and 2020.2. Prepare income statement for the year ended December 31, 2020.arrow_forwardThe following condensed information is reported by World of Stamp Collectibles. Income Statement Information Sales revenue Cost of goods sold Net income Balance Sheet Information Current assets Long-term assets Total assets Current liabilities Long-term liabilities Common stock Retained earnings Total liabilities and stockholders' equity Required: 1. Calculate the following profitability ratios for 2024: 2. Determine the amount of dividends paid to shareholders in 2024. Required 1 a. Gross profit ratio b. Return on assets c. Profit margin d. Asset turnover e. Return on equity % % % 2024 Complete this question by entering your answers in the tabs below. times % $7,612,000 5,031,532 321,780 Required 1 $1,530,000 2,130,000 $3,660,000 $1,130,000 1,570,000 730,000 230,000 $3,660,000 Required 2 J Calculate the following profitability ratios for 2024: (Round your answers to 1 decimal place.) Profitability Ratios 2023 Required 2 > $7,700,000 5,200,000 178,000 $1,430,000 1,830,000 $3,260,000…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College