Horngren's Financial & Managerial Accounting, The Financial Chapters, Student Value Edition (5th Edition)
5th Edition
ISBN: 9780133851731
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 15, Problem 15.24E
Using ratios to reconstruct a
The following data are adapted from the financial statements of Jim’s Shops, Inc.:
Total Current Assets | $ 1,054,000 |
1,600,000 | |
Total Liabilities | 1,480,000 |
0 | |
Debt Ratio | 74% |
1.55 |
Prepare Jim's condensed balance sheet as of December 31, 2016.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Consider the given income statement and balance sheet and calculate the following ratios : /5 Return on Assets Return on Equity Debt Ratio Current Ratio Write your comment about each of the ratios calculated what it describes. Following are the Financial Statements of CSU CORPORATION for the year ended Dec. 31, 2020 Assets : 2019 Cash $1400 Accounts Receivable 4000 Supplies 1800 Equipment 16000 Total Assets $23,200 Liabilities and Shareholders’ Equity : Liabilities : Notes Payable $5000 Accounts Payable…
Prepare a common-size balance sheet from the following information for Blossom Supply Company. (Round answers to 1 decimal place, e.g. 52.7%.)
Blossom Supply CompanyBalance Sheet as of June 30, 2017($ thousands)
Assets:
% of Assets
Liabilities and Equity:
% of Assets
Cash and marketable securities
$ 399,000
enter percentages of assets %
Accounts payable
$ 820,000
enter percentages of assets %
Accounts receivable
708,000
enter percentages of assets %
Notes payable
110,000
enter percentages of assets %
Inventory
1,155,000
enter percentages of assets %
Accrued income taxes
43,800
enter percentages of assets %
Other current assets
42,400
enter percentages of assets %
Total current liabilities
$ 973,800
enter percentages of assets %
Total current assets
$ 2,304,400
enter percentages of assets %
Long-term debt
1,158,000
enter percentages of assets %
Net plant and…
Compute DuPont Analysis Ratios
Selected balance sheet and income statement information for Humana Inc., a health and well-being company, follows.
2018
2017
Company
($ millions) Ticker Revenue income Assets Assets
Humana Inc HUM $66,832 $11,603 $35,333 $37,098
2018
Compute the following 2018 ratios for Humana.
a. Return on equity (ROE)
$
$
Note: 1. Select the appropriate numerator and denominator used to compute ROE from the drop-down menu options. 2. Enter the numerator and denominator amounts to compute ROE.
Numerator
Denominator
0 $
$
2018
Net 2018 2017 Stockholders' Stockholders'
0 $
♦
0
b. Profit margin (PM)
Note: 1. Select the appropriate numerator and denominator used to compute PM from the drop-down menu options. 2. Enter the numerator and denominator amounts to compute PM.
Numerator
Denominator
0 $
◆
Equity
$20,081
0
ROE
0
PM
c. Financial leverage (FL)
Note: 1. Select the appropriate numerator and denominator used to compute FL from the drop-down menu options. 2. Enter the…
Chapter 15 Solutions
Horngren's Financial & Managerial Accounting, The Financial Chapters, Student Value Edition (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
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
- Juroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: Note: Round answers to two decimal places. 1. Calculate the times-interest-earned ratio. 2. Calculate the debt ratio. 3. Calculate the debt-to-equity ratio.arrow_forwardComparative financial statement data of Garfield, Inc. follow: Market price of Garfield’s common stock: $69.36 at December 31, 2018, and $38.04 at December 31, 2017. Common shares outstanding: 14,000 on December 31, 2018 and 12,000 on December 31, 2017 and 2016. All sales are on credit. Compute the following ratios for 2018 and 2017: 2018 2017 a. Current ratio b. Cash ratio c. Times-interest-earned ratio d. Inventory turnover e. Gross profit percentage f. Debt to equity ratio g. Rate of return on common stockholders’ equity h. Earnings per share of common stock i. Price/earnings ratio Decide (a) whether Garfield’s ability to pay debts and to sell inventory improved or deteriorated during 2018 and (b) whether the investment attractiveness of its common stock appears to have increased or decreased.arrow_forwardUsing these data from the comparative balance sheet of Sheridan Company, perform vertical analysis. (Round percentages to 1 decimal place, e.g. 12.5%.) Dec. 31, 2017Dec. 31, 2016AmountPercentageAmountPercentageAccounts receivable$ 540,000 Enter percentages % $ 363,000 Enter percentages %Inventory$ 783,000 Enter percentages % $ 642,000 Enter percentages %Total assets$3,120,000 Enter percentages % $2,704,000 Enter percentages %arrow_forward
- Using the following selected items from the comparative statements of financial position of Whispering Winds Limited, illustrate horizontal and vertical analyses by calculating the percentages of a base amount. (Round answers to O decimal places, e.g. 55%.) Accounts receivable Inventory Total assets Accounts receivable Inventory Total assets Accounts receivable Inventory Total assets December 31, 2024 December 31, 2023 $700,024 $551,200 1,412,768 1,187,200 4,876,000 4,240,000 HORIZONTAL December 31, 2024 % December 31, 2024 % % ANALYSIS VERTICAL ANALYSIS % December 31, 2023 December 31, 2023 % % % % % %arrow_forwardInstructions Using the financial statements and additional information, compute the following ratios for the El Camino Company for 2021. Show all computations. Computations 1. Current ratio 2. Return on common stockholders' equity 3. Price-earnings ratio 4. Inventory turnover 5. Accounts receivable turnover 6. Times interest earned 7. Profit margin 8. Days in inventory 9. Payout ratio 10. Return on assetsarrow_forwardThe following ratios have been computed for Pina Colada Company for 2022. Profit margin ratio 20 % Current ratio 2.5 :1 Times interest earned 12 times Debt to assets ratio 24 % Accounts receivable turnover 5 times Use the above ratios and information from the Pina Colada Company financial statements to fill in the missing information on the financial statements.The 2022 financial statements for Pina Colada Company with missing information follows: (Include calculations) PINA COLADA COMPANYComparative Balance SheetDecember 31, 2022 2021 Assets Cash $ 26,500 $ 37,100 Debt Investments 15,900 15,900 Accounts receivable (net) 53,000 Inventory 53,000 Property, plant, and equipment (net) 212,000 169,600 Total assets Liabilities and stockholders' equity Accounts payable $ 15,900 $ 26,500 Short-term notes payable 37,100 31,800 Bonds payable Enter…arrow_forward
- Using the following selected items from the comparative balance sheet of Oriole Products.Determine the horizontal analysis. (Round percentages to 2 decimal places, e.g. 12.21%. Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) ORIOLEPRODUCTSComparative Balance SheetDecember 31 2014 2013 Horizontal analysis Amount Percentage Amount Percentage Current assets $110,880 enter percentages % $128,216 enter percentages % Long-term assets 174,240 enter percentages % 117,304 enter percentages % Total assets 3,168,000 enter percentages % 2,728,000 enter percentages % Determine the vertical analysis. (Round percentages to 1 decimal place, e.g. 12.2%.) ORIOLEPRODUCTSComparative Balance SheetDecember 31 2014 2013 Vertical analysis Amount Percentage Amount Percentage Current assets $110,880…arrow_forwardFormulating Financial Statements from Raw Data and Calculating Ratios Following is selected financial information from JM Smucker Co. for the year ended April 30, 2018 ($ millions). Current assets, end of year Cash, end of year $1,710.5 Long-term liabilities, end of year 211.9 Stockholders' equity, end of year (305.4) Cash from operating activities 4,973.1 Total assets, beginning of year 8,151.1 Revenue (1,006.1) Total expenses, other than cost of product sold Dividends paid 385.3 * Cash from financing activities includes the effects of foreign exchange rate fluctuations. Cash from investing activities Cost of products sold Total liabilities, end of year Cash from financing activities* Stockholders' equity, beginning of year 7,535.2 a. Prepare the income statement for the year ended April 30, 2018. Note: Do not use negative signs with any of your answers. JM Smucker Co Income Statement ($ millions) For the year ended April 30, 2018 Revenues $ Cost of product sold Gross profit Expenses…arrow_forwardUsing these data from the comparative balance sheets of Concord Company, perform a vertical analysis. Accounts receivable (net) Inventory Total assets (Round percentages to 1 decimal place, e.g. 12.1%.) December 31, 2022 December 31, 2021 $418,320 $425,250 816,720 787,500 2,490,000 3,150,000 December 31, 2022 December 31, 2021 Amount Percentage Amount Percentage Accounts receivable (net) $418,320 % $425,250 % Inventory Total assets 816,720 % 787,500 % 2,490,000 % 3,150,000 %arrow_forward
- The condensed financial statements of John Cully Company, for the years ended June 30, 2017 and 2016, are presented below. Compute the following ratios for 2017 and 2016. Current ratio Inventory turnover. (Inventory on 6/30/15 was $599.0.) Profit margin. Return on assets. (Assets on 6/30/15 were $3,349.9.) Return on common stockholders’ equity. (Stockholders’ equity on 6/30/15 was $1,795.9.) Debt to assets ratio. Times interest earned.arrow_forwardCompute DuPont Analysis Ratios Selected balance sheet and income statement information for Humana Inc., a health and well‑being company, follows. 2018 2017 2018 2018 Net 2018 2017 Stockholders’ Stockholders’ Company ($ millions) Ticker Revenue income Assets Assets Equity Equity Humana Inc HUM $66,610 $11,381 $35,111 $36,876 $19,859 $19,540 Compute the following 2018 ratios for Humana. a. Return on equity (ROE) Note: 1. Select the appropriate numerator and denominator used to compute ROE from the drop-down menu options. 2. Enter the numerator and denominator amounts to compute ROE. Numerator Denominator ROE Answer Answer Answer Answer b. Profit margin (PM) Note: 1. Select the appropriate numerator and denominator used to compute PM from the drop-down menu options. 2. Enter the numerator and denominator amounts to compute PM. Numerator Denominator PM Answer Answer Answer Answer c. Financial leverage…arrow_forwardProfitability ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 2017, 20Y6, and 20Y5: December 31 20Y7 December 31 20Y6 December 31 20Y5 Total assets $307,000 $277,000 $247,000 Notes payable (8% interest) 100,000 100,000 100,000 Common stock 40,000 40,000 40,000 Preferred 6% stock, $100 par (no change during year) Retained earnings 20,000 109,920 20,000 80,240 20,000 60,000 The 20Y7 net income was $30,880, and the 2016 net income was $21,440. No dividends on common stock were declared between 2015 and 2017. Preferred dividends were declared and paid in full in 2016 and 2017. a. Determine the return on total assets, the return on stockholders' equity, and the return on common stockholders' equity for the years 2016 and 2017. When required, round your answers to one decimal place. 20Y7 20Y6 Return on total assets Return on stockholders' equity Return on common stockholders' equity % % % % % % b. The profitability ratios indicate…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License