INTERMEDIATE ACCOUNTING(LL) W/CENGAGENO
2nd Edition
ISBN: 9781305617001
Author: WAHLEN
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Question
thumb_up100%
Chapter 4, Problem 17P
To determine
Calculate the common-size
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
For fiscal year 2018, Walmart Inc. (WMT) had total revenues of $500.34 billion, net income of $9.86 billion, total
assets of $204.52 billion, and total shareholders' equity of $77.87 billion.
a. Calculate Walmart's ROE directly, and using the DuPont Identity.
b. Comparing with the data for Costco, use the DuPont Identity to understand the difference between the
two firms' ROES.
Data table
For fiscal year 2018, Costco Wholesale Corporation (COST) had a net profit margin of 2.08%, asset
turnover of 3.55, and a book equity multiplier of 3.37. Costco's ROE (DuPont) is 24.88%.
10. Review the select information for Bean Superstore and
Legumes Plus (industry competitors), and then complete the
following.
A. Compute the accounts receivable turnover ratios for each
company
for 2018 and 2019.
B. Compute the number of days' sales in receivables ratios for
each company for 2018 and 2019.
C. Determine which company is the better investment and why.
Round answers to two decimal places.
BEAN SUPERSTORE
LEGUMES PLUS
Comparative Balance Sheet
December 31, 2017, 2018, and 2019
Comparative Balance Sheet
December 31, 2017, 2018, and 2019
2019
2018
2017
2019
2018
2017
Assets
Cash
$345,600
67,000
145,830
100,465
$330,460
62,000
178,011
101,202
$300,000
59,000
155,205
103,085
$407,000
85,430
128,080
182,006
$386,450
82,670
40,036
23,400
$356,367
79,230
52,142
111,701
Accounts Receivable
Inventory
Equipment
Total Assets
$658,895
$671,673
$617,290
$802,516
$532,556
$599,440
Liabilities
Salaries Payable
Accounts Payable
Notes Payable
$ 91,455
$ 90,200
70,000
41,000
$ 88,563…
You are provided with the Income Statement and the Balance Sheet of HTS software, Inc. for 2011.
Required:
(b) Analyze the current financial position for the company from a time series and cross section viewpoint.
(c) Break your analysis into an evaluation of the firm’s liquidity, activity, debt, profitability and market ratios.
Historical and Industry Average Ratios
HTS Software , Inc.
Ratio
2010
2011
Industry2011
Current Ratio
2.6
—
2.7
Quick Ratio
1.8
—
1.75
Inventory Turnover
4.5
—
4.7
Average Collection Period
40days
—
42 days
Total Asset Turnover
1.2
—
1
Debt Ratio
20%
—
21%
Times Interest Earned
9
—
8.9
Gross Profit Margin
43%
—
44%
Operating Profit Margin
30%
—
32%
Net Profit Margin
20%
—
21%
Return on total assets
12%
—
13%
Return on Equity
Price/Earnings Ratio
15%
7.3
—
—
16%
8
Balance SheetHTS Software, Inc.December 31,…
Chapter 4 Solutions
INTERMEDIATE ACCOUNTING(LL) W/CENGAGENO
Ch. 4 - What is the accounting equation? The balance sheet...Ch. 4 - Prob. 2GICh. 4 - How does the balance sheet at the end of an...Ch. 4 - What does recognition mean in accounting?Ch. 4 - Prob. 5GICh. 4 - Prob. 6GICh. 4 - What is equity? How is equity determined?Ch. 4 - What is a mixed attribute measurement model? Why...Ch. 4 - Identify at least five alternatives for measuring...Ch. 4 - Identify at least three alternatives for measuring...
Ch. 4 - Prob. 11GICh. 4 - Prob. 12GICh. 4 - Prob. 13GICh. 4 - Prob. 14GICh. 4 - Prob. 15GICh. 4 - Prob. 16GICh. 4 - Define (a) common stock, (b) additional paid-in...Ch. 4 - Prob. 18GICh. 4 - Prob. 19GICh. 4 - What are investments by owners? Distributions to...Ch. 4 - What accounting policies are disclosed in the...Ch. 4 - Give several examples of financial instruments and...Ch. 4 - Prob. 23GICh. 4 - Prob. 24GICh. 4 - Prob. 25GICh. 4 - Prob. 26GICh. 4 - Prob. 27GICh. 4 - Prob. 28GICh. 4 - Prob. 29GICh. 4 - Prob. 30GICh. 4 - Prob. 31GICh. 4 - Prob. 32GICh. 4 - Prob. 33GICh. 4 - Prob. 34GICh. 4 - A donated fixed asset (from a governmental unit)...Ch. 4 - Prob. 2MCCh. 4 - Prob. 3MCCh. 4 - Prob. 4MCCh. 4 - Prob. 5MCCh. 4 - Rent revenue collected 1 month in advance should...Ch. 4 - Prob. 7MCCh. 4 - Prob. 8MCCh. 4 - Which of the following should be disclosed in the...Ch. 4 - Prob. 10MCCh. 4 - Prob. 1RECh. 4 - Dorothy Corporation had the following accounts in...Ch. 4 - Dorothy Corporation had the following accounts in...Ch. 4 - Based on the information in RE4-2 and RE4-3,...Ch. 4 - Prob. 5RECh. 4 - Oz Corporation has the following assets at...Ch. 4 - Prob. 7RECh. 4 - Prob. 8RECh. 4 - Scarecrow Inc. issues 50,000 shares of 2 par value...Ch. 4 - Tinman Corporation reports the following balances...Ch. 4 - Prob. 1ECh. 4 - Plant and Equipment Your analysis of Moen...Ch. 4 - Prob. 3ECh. 4 - Prob. 4ECh. 4 - Classifications on Balance Sheet The balance sheet...Ch. 4 - Balance Sheet Baggett Companys balance sheet...Ch. 4 - Prob. 7ECh. 4 - Prob. 8ECh. 4 - Prob. 9ECh. 4 - Prob. 10ECh. 4 - Prob. 11ECh. 4 - Prob. 12ECh. 4 - Prob. 1PCh. 4 - Prob. 2PCh. 4 - Prob. 3PCh. 4 - Prob. 4PCh. 4 - Prob. 5PCh. 4 - Prob. 6PCh. 4 - Prob. 7PCh. 4 - Prob. 8PCh. 4 - Prob. 9PCh. 4 - Prob. 10PCh. 4 - Balance Sheet The following is an alphabetical...Ch. 4 - Prob. 12PCh. 4 - Prob. 13PCh. 4 - Comprehensive: Balance Sheet, Schedules, and Notes...Ch. 4 - Prob. 15PCh. 4 - Prob. 16PCh. 4 - Prob. 17PCh. 4 - Prob. 18PCh. 4 - Prob. 1CCh. 4 - Prob. 2CCh. 4 - Prob. 3CCh. 4 - Valuation of Assets and Stock A friend has come to...Ch. 4 - Prob. 5CCh. 4 - Prob. 6CCh. 4 - Analyzing Starbuckss Accounting Policies A company...Ch. 4 - Prob. 8CCh. 4 - Prob. 9C
Knowledge Booster
Similar questions
- Green Technologies is a leading global end-to-end technology provider, with a portfolio of hardware, software and service solutions. In a recent annual report, the balance sheet included the following information ($ in millions): Current assets: Receivables, less allowance of $289 in 2020 and $280 in 2019 Req 1 In addition, the income statement reported sales revenue of $105,232 million for the current year. All sales are made on a credit basis. The statement of cash flows indicates that cash collected from customers during the current year was $104,868 million. There could have been significant recoveries of accounts receivable previously written off. Required: 1. Compute the following ($ in millions): Req 2A 2020 a. The amount of bad debts written off by Green during 2020 (Hint. Treat it as a plug in the gross accounts receivable account). b. The amount of bad debt expense that Green included in its income statement for 2020 (Hint. Treat it as a plug in the allowance for…arrow_forwardYou are provided with the Income Statement and the Balance Sheet of HTS software, Inc. for 2011. Required: (b) Analyze the current financial position for the company from a time series and cross section viewpoint. (c) Break your analysis into an evaluation of the firm’s liquidity, activity, debt, profitability and market ratios. Historical and Industry Average Ratios HTS Software , Inc. Ratio 2010 2011 Industry2011 Current Ratio 2.6 2.08 2.7 Quick Ratio 1.8 1.32 1.75 Inventory Turnover 4.5 6 4.7 Average Collection Period 40days 9.125 42 days Total Asset Turnover 1.2 1.69 1 Debt Ratio 20% 28.2% 21% Times Interest Earned 9 5.9% 8.9 Gross Profit Margin 43% 42.8% 44% Operating Profit Margin 30% 25.5% 32% Net Profit Margin 20% 17% 21% Return on total assets 12% 4.11% 13% Return on Equity Price/Earnings Ratio 15% 7.3 19% 4.4 16% 8…arrow_forward10. Review the select information for Bean Superstore and Legumes Plus (industry competitors), and then complete the following. A. Compute the accounts receivable turnover ratios for each company for 2018 and 2019. B Compute the number of days sales in receivables ratios for each company for 2018 and 2019 C. Determine which company is the better investment and why. Round answers to two decimal places.arrow_forward
- Avon Products, Inc., located in New York City, is one of the world’s largest producers of beauty and related products. The company's consolidated balance sheets for the 2016 and 2015 fiscal years included the following ($ in thousands): 2016 2015 Current assets: Receivables, less allowances of $131,100 in2016 and $86,700 in 2015 $ 458,900 $ 440,000 A disclosure note accompanying the financial statements reported the following ($ in thousands): Year Ended 2016 2015 (In thousands) Calculation of account receivables, net: Receivables $ 590,000 $ 526,700 Less: allowance for doubtful accounts (122,900 ) (77,600 ) Less: reserve for product returns (8,200 ) (9,100 ) Trade accounts receivable, net: $ 458,900 $ 440,000 Assume that the company reported bad debt expense in 2016 of $191,000 and had products returned for credit totaling $187,000 (sales price). Net sales for 2016 were…arrow_forwardCompleting a comprehensive financial statement analysis In its annual report, XYZ Athletic Supply, Inc. includes the following five-year financial summary: Requirements Analyze the company’s financial summary for the fiscal years 2014-2018 to decide whether to invest in the common stock of XYZ. Include the following sections in your analysis. Trend analysis for net sales revenue and net income (use 2014 as the base year). Profitability analysis. Evaluation of the ability to sell merchandise inventory. Evaluation of the ability to pay debts. Evaluation of dividends. Should you invest in the common stock of XYZ Athletic Supply, Inc.? Fully explain your final decision.arrow_forwardCompare Delta to two of its competitors, JetBlue and Southwest, by answering the following questions. You do not need to calculate all of the ratios for JetBlue and Southwest, only the ones required to answer the questions below: How much bigger is Delta from each of its competitors, by Revenue, in each year from 2018-2022? Plot the Revenue number for each company for these years on a single line graph. Which company has the highest Net Income in each year from 2018-2022? Which company has the highest Net Profit Margin in 2018? In 2022? Which company is the most profitable based on Gross Profit percentage each year from 2018-2022? (This is a trick question.) Which company is best at using its short-term assets to pay off its short-term liabilities in 2019? Which company has the best cash ratio in 2019? Is it the same company that is best at using its short-term assets to pay short-term liabilities? If not, why do you think it's different? Which company is the most leveraged in 2022?arrow_forward
- Find online the annual 10-K report for Costco Wholesale Corporation (COST) for fiscal year 2015 (filed in October 2015). a. Compute Costco's net profit margin, total asset turnover, and equity multiplier. b. Verify the DuPont Identity for Costco's ROE. c. If Costco's managers wanted to increase its ROE by 1 percentage point, how much higher would their asset turnover need to be? a. Compute Costco's net profit margin, total asset turnover, and equity multiplier. The net profit margin is %. (Round to two decimal places.) The total asset turnover is (Round to two decimal places.) The equity multiplier is (Round to two decimal places.) b. Verify the DuPont Identity forCostco's ROE. The ROE is %. (Round to two decimal places.) c. If Costco's managers wanted to increase its ROE by 1 percentage point, how much higher would their asset turnover need to be? The total assets turnover should be (Round to two decimal places.) The total asset turnover should be % (Round to two decimal places and…arrow_forwardWorking with the Takeaways throughout this chapter we have considered the financial statements of Apple Inc. and have undertaken select financial analysis using the Takeaways. Utilize these same tools to analyze the financial data of Logitech International, a manufacturer of computer peripherals. The following information was reported by Logitech in the company’s financial statements as of year-end March 31, 2017 and 2016.1. Calculate the return on sales ratio for each year and comment on Logitech’s profitability.2. Calculate the current ratio for each year and comment on Logitech’s liquidity.3. Calculate the debt-to-total-assets ratio for each year and comment on Logitech’s solvency. 4. Calculate the free cash flow for each year and comment on what this means for Logitech. 5. Apple’s fiscal year-end occurs near the end of September, whereas Logitech uses a March year-end. How might this affect a comparison of the financial results of the two companies?arrow_forwardGemstone Products located in New York City, is one of the world's largest producers of beauty and related products. The company's consolidated balance sheets for the 2016 and 2015 fiscal years included the following ($ in thousands): 2016 2015 Current assets: Receivables, less allowances of $131,720 in 2016 and $87,320 in 2015 $ 459,700 $ 440,400 A disclosure note accompanying the financial statements reported the following ($ in thousands) Year Ended 2016 (In thousands) 2015 (In thousands) Calculation of account receivables, net: Receivables $ 591,420 $ 527,720 Less: allowance for doubtful accounts (122,960) (77,660) Less: reserve for product returns (8,760) (9,660) Trade accounts receivable, net: $ 459,700 $ 440,400 Assume that the company reported bad debt expense in 2016 of $191,400 and had products returned for credit totaling $187,060 (sales price). Net sales for 2016 were $5,598,800 ($ in thousands). Required: What is the amount of…arrow_forward
- Please find below Financial Statement extracts of Nestle from year 2017 and 2018. Based on this information please answer following question from a perspective of Financial Analyst (justify your answers with data as well the reason for choosing your ratios for your analysis) .The company's total assets at year-end 2016 were 131,900 million. What reasonable conclusions an analyst might make about the companies efficiency, Companies solvency, Liquidity and Profitability? 2018 2017 * Sales 91,439 89,590 Profit for the year 10,468 7,511 Assets 2018 2017 * Total current assets 41,003 31,884 Total assets 137,015 133,210 Total liabilities and equity 137,015 133,210arrow_forwardFind the cost of products sold for the third quarter of 2017 in the Notes to the Consolidated Financial Statements. (Enter your answer in millions.)arrow_forwardA company’s comparative statements are given below. Please conduct the following analyses (hint: use of a spreadsheet is recommended for ease of computation):a. Horizontal analysis (trend analysis) on the income statement b. Vertical analysis (common size financial statement analysis) on the income statement c. Calculate the three profitability ratios for the year 2017 and show how ROE can be derived from the DuPont formula for this company. d. What do the analyses tell you about the company’s financial performance?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education