Horngren's Financial & Managerial Accounting, The Financial Chapters (Book & Access Card)
5th Edition
ISBN: 9780134078939
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.19E
To determine
Formula:
To compute: The dollar amount change and the percentage change in the working capital for three years 2014 – 2016.
Given info: Total current assets and total current liabilities
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
FIND THE ROE ( return on capital )for each year (2013-2018)using the following information
Years Revenue ($M) Net Income ($M)
2012 221.8 2.9
2013 473.8 20.2
2014 627.7 36.4
2015 947.8 45.0
2016 1,015.5 50.3
2017 1,046.2 64.9
2018 1,293.2 90.4
Exhibit 2
Years
Total Assets ($M)
Fixed Assets ($M)
Current Assets ($M)
Total Equity ($M)
Retained Earnings ($M)
2012
430
286
144
293
12.8
2013
956
501
455
558
33.0
2014
922
668
324
620
69.4
2015
1103
796
307
665
114.4
2016
1120
835
285
729
164.7
2017
1294
738
556
805
229.6
2018
2053
703
1350
934
320…
Previous
Nex
You are a financial Manager of Chevron Corp You need to assess the effectiveness of
working capital management.of the company for 2018 using the following data What is th
2018 Payable turnover?
2017 Accoun Receivable 15 353 000
2018 Account Receivable 15,050 000
2017 Inventory = 5 585 000
2018 Inventory = 5 704.000
2017 Accounts Payable = 14 565.000
2018 Accounts Payable = 13 953 000
2017 Sales = 134 674 000
2018 Sales = 158 902.000
2017 Cost of Sales = 96 114.000
2018 Cost of Sales = 113 997 000
2017 Purchases = 95 114 000
2018 Purchases
123 435.000
8. Trend Ratios, Application of some Financial Ratios and their Interpretation
Some of the balance sheet and income statement figures of Sapphire Mfg. CO. for 2016, 2017 and 20181 are as
follows.
2018
P30,000
2016
2017
Quick assets
P40,000
P48,000
65,000
25,000
80,000
50,000
Current assets
50,000
40,000
110,000
200,000
Investments
160,000
135,000
Plants, property and equipment, net
Total assets
250,000
265,000
Current liabilities
45,000
50,000
100,000
75,000
Long Term debt
Total stockholders' equity
40,000
50,000
105,000
125,000
125,000
Total liabilities and stockholders'
Equity
200,000
400,000
240,000
250,000
265,000
Sales
375,000
500,000
Cost of goods sold
Operating expenses (including
Depreciation of P10,000)
255,000
290,000
110,000
95,000
105,000
Net income
50,000
50,000
130,000
a) Compute for the trend ratios based on the above given data and give your interpretation of the 2017 and 2018
figures.
Chapter 15 Solutions
Horngren's Financial & Managerial Accounting, The Financial Chapters (Book & Access Card)
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
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
- Years 2014 2015 2016 2017 2018 expenditures of employees 125,32 129,12 132,34 143,94 147,42 What is the average increase per year from the data on employee expenditure abovearrow_forwardAssume the following sales data for a company: 2018 $980,000 2017 875,000 2016 700,000 If 2016 is the base year, what is the percentage increase in sales from 2016 to 2017? a. 125% b. 25% C. 140% d. 40%arrow_forwardGiven the historical income statement of Mega Trade Inc., how much would be added to the company's retained earning for the year 2016 (in millions)? Income Statement ( $ Million) Year End 2015 2016 2017 2019 Sales 1, 234.90 1,251.70 1,300.40 1,334.40 Cost of Sales -679.1 -659 -681.3 -667 Gross Operating Income Selling & Administration -339.7 -348.6 -351.2 -373.3 Depreciation -47.5 -52 -55.9 -75.2 Other Income / Expenses 11.8 7.6 7 8.2 Earnings Before Interest and Taxes Interest Income 1.3 1.4 1.7 2 Interest Expense -16.2 -15.1 -20.5 -23.7 Pre Tax Income Income Taxes -56.8 -64.2 -67.5 -72.6 Net Income Dividends -38.3 -38.7 -39.8 -40.1arrow_forward
- The 2023 annual report for Pronghorn Industries Inc. contained the following information: Dec. 31, 2022 Dec. 31, 2023 Total assets 561,000 605,000Total liabilities 65,400 88,900Net revenue 410,000 530,000Net income 54,000 32,000 Calculate the rate of return on assets using profit margin for 2023arrow_forwardStudypug.com The following are line items from the horizontal analysis of an income statement: Increase/(Decrease) Increase/(Decrease) 2017 2016 Amount Percent Fees earned $120,000 $100,000 $20,000 20% Wages expense 50,000 40,000 10,000 25% Supplies expense 600 700 (100) (15)% Employee training expense 700 850 (150) (18)% Which of the line items shows cause for concern? a.Fees earned b.Supplies expense c.Wages expense d.Employee training expensearrow_forwardYou are a financial Manager of Chevron Corp. You need to assess the effectiveness of working capital management of the company for 2018 using the following data. What is the 2018 Receivable turnover? 2017 Account Receivable = 15,353 000 2018 Account Receivable = 15.050,00O 2017 Inventory = 5,585.000 2018 Inventory = 5 704.00O 2017 Accounts Payable= 14 565 00I 2018 Accounts Payable = 13 953 000 2017 Sales 134,674 000 2018 Sales 158.902 000. 2017 Cost of Sales = 95 114.000 2018 Cost of Sales = 113 997 000 2017 Purchases= 95 114 000 2018 PurchaSes = 123 435 000arrow_forward
- The 2017 annual report of Tootsie Roll Industries contains the following information. (in millions) December 31, 2017 0000 December 31, 2016 Total assets $930.9 $920.1 Total liabilities 197.1 208.6 Net sales 515.7 517.4 Net income 80.7 67.2 Instructions Compute the following ratios for Tootsie Roll for 2017. a. Asset turnover. b. Return on assets. c. Profit margin on sales. d. How can the asset turnover be used to compute the return on assets?arrow_forwardI need assistance calculating ratios with the attached income statement and balance sheet: Fiscal 2017 Fiscal 2016 Gross margin, as reported 35.6% 35.2% Mark-to-market effects (0.1) (0.4) Restructuring costs 0.3 0.5 Project-related costs 0.3 0.3 Adjusted gross margin 36.1% 35.6% Calculate the following financial ratios for 2016 and 2017 4. Reutrn on assets (2015, total assets = $21,932.0 million) 5. Return on common stockholders' equity (2015, total stockholders' equity = $4996.7 million) 6. Current ratioarrow_forwardThe following are line items from the horizontal analysis of an income statement: Increase/ Increase/ (Decrease) (Decrease) 2017 2016 Amount Percent Fees earned $120,000 $100,000 $20,000 20% Wages expense 50,000 40,000 10,000 25% Supplies expense 600 700 (100) (15)% Employee training expense 700 850 (150) (18)% Which of the line items shows cause for concern? O a. Employee training expense O b. Supplies expense O c. Fees earned O d. Wages expensearrow_forward
- Given the historical income statement of Mega Trade Inc., how much would be added to the company's retained earning for the year 2016 (in millions)? Income Statement ($ Million) Income Statement ( $ Million) Year End 2015 2016 2017 2019 Sales 1, 234,90 1,251.40 1,300.40 1,334.40 Cost of Sales -679.1 -659 -681.3 -667 Gross Operating Income Selling & Administration -339.7 -348.6 -351.2 -373.3 Depreciation -47.5 -52 -55.9 -75.2 Other Income / Expenses 11.8 7.6 7 8.2 Earnings Before Interest and Taxes Interest Income 1.3 1.4 1.7 2 Interest Expense -16.2 -15.1 -20.5 -23.7 Pre Tax Income Income Taxes -56.8 -64.2 -67.5 -72.6 Net Income Dividends -38.3 -38.7 -39.8 -40.1arrow_forwardNet Profit Margin 2016= 1.957 % 2017= 1.997 % Current Ratio 2016= 2.50:1 or 2.50 times 2017= 2.34:1 or 2.34 times Non-current/fixed Asset turnover 2016 = 97.357 2017= 45.97 1. Make brief comments upon the changes, between the two years, in the ratios calculatedarrow_forwardQuestion Description Use the table below to answer the questions. 2014 Sales COGS Interest Depreciation Cash Accounts receivables Current liabilities Inventory Long-term debt Net fixed assets Shareholder's equity Taxes $6,318 3.945 303 1,204 672 601 414 1,215 4,780 7,700 4,994 217 1. What is the change in net working capital from 2014 to 2015? 2. What is the net capital spending for 2015? 2015 $7,202 4,460 277 1,196 418 578 463 1,598 4,103 7,330 5.358 317arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License