Financial Reporting, Financial Statement Analysis and Valuation
8th Edition
ISBN: 9781285190907
Author: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 5, Problem 1AIC
Compute the values of each of the ratios in Exhibit 5.27 for Starbucks for 2012. Starbucks had 749.3 million common shares outstanding at the end of fiscal 2012, and the market price per share was $50.71. For days accounts receivable outstanding, use only specialty revenues in your calculations, because accounts receivable are primarily related to licensing and food service operations, not the retail operations.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
eBook
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…
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…
Calculate the following financial ratios for Phone Corporation: (Use 365 daysin a year. Do not round intermediate calculations. Round your finalanswers to 2 decimal places.)1. Return on Assets (use average balance sheet figures)2. Return on capital (use average balance sheet figures) %3. Days in inventory (use start of year balance sheet figures) %4. Inventory turnover (use start of year balance sheet figures5. Average collection period (use start of year balance sheet figures)6. Operating profit margin %7. Long term debt ratio (use end of year balance sheet figures)8. Total Debt ratio (use end of year balance sheet figures)
Chapter 5 Solutions
Financial Reporting, Financial Statement Analysis and Valuation
Ch. 5 - Prob. 1QECh. 5 - Prob. 2QECh. 5 - A firm has experienced an increasing current ratio...Ch. 5 - A firm has experienced a decrease in its current...Ch. 5 - Prob. 5QECh. 5 - A firm had the following values for the four debt...Ch. 5 - Prob. 7QECh. 5 - Prob. 8QECh. 5 - Prob. 9QECh. 5 - Prob. 10QE
Ch. 5 - Market equity beta measures the covariability of a...Ch. 5 - Altmans bankruptcy risk model utilizes the values...Ch. 5 - Calculating and Interpreting Risk Ratios. Refer to...Ch. 5 - Refer to the financial state-ment data for...Ch. 5 - Refer to the profitability ratios of Coca-Cola in...Ch. 5 - Delta Air Lines, Inc., is one of the largest...Ch. 5 - Prob. 17PCCh. 5 - Prob. 18PCCh. 5 - Prob. 19PCCh. 5 - Prob. 20PCCh. 5 - Prob. 21PCCh. 5 - Prob. 22PCCh. 5 - Compute the values of each of the ratios in...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- The following select financial statement information from Candid Photography. Compute the accounts receivable turnover ratios and the number of days sales in receivables ratios for 2018 and 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Candid Photography if industry average for accounts receivable turnover ratio is 3 times and days sales in receivables ratio is 150 days?arrow_forwardUsing the following select financial statement information from Mover Supply Depot, 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 Mover Supply Depot if the industry average is 4 times?arrow_forwardPlease help. Thanksarrow_forward
- Win's Companies, a home improvement store chain, reported the following summanzed figures E (Click the icon to view the income statement.) E (Click the icon to view the balance sheets.) Win's has 20,000 common shares outstanding during 2018. Read the requirements Requirement 1. Compute Win's Companies' current ratio at May 31, 2018 and 2017 Begin by selecting the formula to calculate Win's Companies' current ratio. Then enter the amounts and calcu ale the current ratio for 2018 and then 2017. (Round your answers to two decimal places, X.XX.) Current ratio (i Balance Sheets Income Statement Win's Companies Win's Companies Balance Sheet Income Statement May 31, 2018 and 2017 Years Ended May 31, 2018 and 2017 Assets Liabilities 2018 2017 2018 2017 2018 2017 Net Sales Revenue 24 57 200 $ 39,800 Cash $. 2.300 $ 1300 Total Current Liabilities 22,000 $ 12,900 Cost of Goods Sold 22.500 25,500 12,200 11,300 Short-term Invesiments 29 000 13.000 Long-term Liabilities Interest Expense 500 320…arrow_forwardThis problem is based on the 2017 annual report of Campbell Soup Company. Answer the following questions. Refer to the Selected Financial Data for parts (a) to (d).Required: Find the net sales in 2014. (Enter your answer in millions.) Calculate the operating income (earnings before interest and taxes) in 2013. (Enter your answer in millions.) Calculate the difference between operating income (earnings before interest and taxes) and net income (net earnings) in 2015. (Enter your answer in millions.) Find the year(s) in which net income (net earnings) decreased compared to the previous year. attatched are the charts needed for the following questions, I have tried to figure these out but I come up with incorrect answers. Thank Youarrow_forwardHigh's Companies Balance Sheet May 31, 2018 and 2017 Assets Liabilities 2018 2017 2018 2017 Cash 24 2,000 S 1,600 Total Current Liabilities 23.000 S 13,600 13,000 Short-term Investments 24,000 14,000 Long-term Liabilities 12,400 Accounts Receivable 7.200 5.600 Total Liabilities 36,600 25.400 Merchandise nventory 7.100 7 200 Stockholders' Equity Other Current Assets 11,000 2400 Common Stock 9,000 9.000 Total Current Assets 51,300 36 700 19,400 30,800 Retained Eanings 23000 All Other Assets 31,000 45,700 Total Equity 53,800 28,400 Total Assets 82,300 $ Total Liabilities and Equity 82,300 $ 53,800arrow_forward
- Millennial Manufacturing has net credit sales for 2018 in the amount of $1,443,630, beginning accounts receivable balance of $588,900, and an ending accounts receivable balance of $624,450. A. Compute the accounts receivable turnover ratio and the number of days' sales in receivables ratio for 2018. Round answers to two decimal places. times days B. What do the outcomes tell a potential investor about Millennial Manufacturing if industry average is 2.6 times and number of day's sales ratio is 180 days? Accounts receivable turnover ratio Sales in receivables ratio a. Millennial Manufacturing collects its accounts more quickly than its competitors. b. A lender may favour Millennial Manufacturing over its competitors because of its faster collection period. c. Without prior years' data it is hard to tell if Millennial Manufacturing is really more efficient than its competitors. d. All of the above statements may be correct.arrow_forwardFor questions # 33 - 40, refer to the following financial information for Disney (DIS). Use Excel formulas for all calculations. 36. How many days sales in receivables did Disney average in fiscal 2023? (round to nearest number) For balance sheet accounts, use the average of the beginning-of-year and end-of-year balances. 37. What was Disney's Interest Coverage ratio in fiscal 2023? (round to nearest number) 38. What was Disney's Return on Equity in fiscal 2023? (round to nearest percentage) For balance sheet accounts, use the average of the beginning-of-year and end-of-year balances. 39. What is Disney's PE ratio based on its current market price? (round to 1 decimal place) 40. How much did Disney pay out in dividends during fiscal 2023? For questions # 33-40, refer to the following financial information for Disney (DIS). Use Excel formulas for all calculations. ($ millions) BALANCE SHEET: Assets: Cash Accounts Receivable Inventory Other Current Assets Fixed Assets, net Other…arrow_forwardsolve with all workarrow_forward
- Alex is currently considering to invest his money in one of the companies betweenCompany A and Company B. The summarized final accounts of the companies for theirlast completed financial year are as follows: (refer to the images) Required:a. Calculate the following ratios for Company A and Company B. State clearly theformulae used for each ratio:i. Gross Profit Marginii. Net Profit Marginiii. Inventory Turnover Period (days)iv. Receivables Collection Period (days)v. Payables Payment Period (days)vi. Current Ratiovii. Quick Ratiob. Comment on each of the ratios calculated in part (a) above.arrow_forwardExercise 16-8 (Algo) Selected Financial Ratios [LO16-2, LO16-3, LO16-4] The financial statements for Castile Products, Incorporated, are given below: Castile Products, Incorporated Balance Sheet December 31 Assets Current assets: $ 22,000 160,000 380,000 Cash Accounts receivable, net Merchandise inventory 11,000 573,000 Prepaid expenses Total current assets Property and equipment, net 820,000 Total assets $ 1,393,000 Liabilities and Stockholders' Equity Liabilities: $ 260,000 370,000 630,000 Current liabilities Bonds payable, 11% Total liabilities Stockholders' equity: Common stock, $10 par value Retained earnings Total stockholders' equity $ 110,000 653,000 763,000 Total liabilities and stockholders' equity $ 1,393,000 Castile Products, Incorporated Income Statement For the Year Ended December 31 $ 3,300,000 1,137,500 2,162,500 630,000 1,532,500 40,700 Sales Cost of goods sold Gross margin Selling and administrative expenses Net operating income Interest expense 1,491,800 447,540 Net…arrow_forwardPlease help me. Fast solution please. Thankyou.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License