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
Videos
Textbook Question
Chapter 5, Problem 15PC
Refer to the profitability ratios of Coca-Cola in Problem 4.26 in Chapter 4. Exhibit 5.17 presents risk ratios for Coca-Cola for 2006–2008. As we did within the chapter for PepsiCo, we utilize Coca-Cola’s footnote disclosures to extract the amount of trade accounts payable included within the line item accounts payable and accrued expenses.
Exhibit 5.17
REQUIRED
- a. Assess the changes in the short-term liquidity risk of Coca-Cola between 2006 and 2008.
- b. Assess the changes in the long-term solvency risk of Coca-Cola between 2006 and 2008.
- c. Compare the short-term liquidity ratios of Coca-Cola with those of PepsiCo discussed in the chapter. Which firm appears to have more short-term liquidity risk? Explain.
- d. Compare the long-term solvency ratios of Coca-Cola with those of PepsiCo discussed in the chapter. Which firm appears to have more long-term solvency risk? Explain.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Upon further investigation, you hare found
that the amount of account payables for
Companies A and X at the start of the
year is 20,000 and 30,000, respectively.
Apart from that, the amount of credit
purchase for Companies A and Bis
250,000 and 280,000, respectively.
Based on all this information, recommend
on which company that gire lower risk to
your company. The recommendation must be
ustified by the following analysis:.
a) Liquidity analysis.
b) Solvency analysis.
c) Any other financial analysis that you.
think can help in making your decision.
Table: Balance Sheet for Company A and Company B
Assets
280,000
110,000
140,000
100,000
100,000
730,000
Fixed Assets
Other Non-Current Assets
250,000
80,000
120,000
80,000
120,000
650,000
Account Receivables
Inventory
Cash
ТОTAL
Liabilities
Capital
Long Term Debt
Account Payables
Other Current Liabilities
ТОTAL
250,000
120,000
160,000
120,000
650,000
280,000
140,000
180,000
130,000
730,00
The following ratios were extracted from the books of Cartel limited.
Liquidity ratios (Current and Quick ratios)
Liquidity ratios
2002
2003
2004
Industry Average
Current Ratio
2.33
1.46
2.58
2.70
Quick Ratio
0.85
0.50
0.93
1.00
i) What can you say about the company's liquidity position in 2002, 2003, and as projected for 2004?
ii) How are these liquidity ratios useful to the managers of the company?
b) Asset management ratios (Inventory turnover, days sales outstanding , fixed assets turnover, operating capital requirement, and total assets turnover)
Asset Management ratios
2002
2003
2004
Industry Average
Inventory Turnover
4.80
4.53
4.10
6.10
Days Sales Outstanding
37.4
39.5…
The new owners of Pak. Electric Co. have hired you to help them diagnose and cure problems that the company has had in maintaining adequate liquidity. As a first step, you perform a liquidity analysis. You then do an analysis of the company’s short-term activity ratios. Your calculations and appropriate industry norms are listed.RatiosCurrent RatioPak. Electric Co. 4.5Industry Average 4.0Quick RatioPak. Electric Co. 2.0Industry Average 3.1Inventory TurnoverPak. Electric Co. 6.0Industry Average 10.4Average Collection PeriodPak. Electric Co. 73 daysIndustry Average 52 daysAverage Payment PeriodPak. Electric Co. 31 days40 daysa. What recommendations relative to the amount and the handling of inventory could you make to the new owners?b. What recommendations relative to the amount and the handling of accounts receivable could you make to the new owners?
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
- Refer to the financial state-ment data for Abercrombie Fitch in Problem 4.25 in Chapter 4. Exhibit 5.16 presents risk ratios for Abercrombie Fitch for fiscal Year 3 and Year 4. Exhibit 5.16 REQUIRED a. Compute the amounts of these ratios for fiscal Year 5. b. Assess the changes in the short-term liquidity risk of Abercrombie Fitch between fiscal Year 3 and fiscal Year 5 and the level of that risk at the end of fiscal Year 5. c. Assess the changes in the long-term solvency risk of Abercrombie Fitch between fiscal Year 3 and fiscal Year 5 and the level of that risk at the end of fiscal Year 5.arrow_forwardThe following ratios were extracted from the books of Cartel limited. Liquidity ratios (Current and Quick ratios) Liquidity ratios 2002 2003 2004 Industry Average Current Ratio 2.33 1.46 2.58 2.70 Quick Ratio 0.85 0.50 0.93 1.00 i) What can you say about the company's liquidity position in 2002, 2003, and as projected for 2004? ii) How are these liquidity ratios useful to the managers of the company?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_forward
- 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,…arrow_forwardWhich of the following statements are false? Select all that apply a. Liquidity ratios are used to measure the speed with which various accounts are converted into sales. b. When ratios of different years are being compared, inflation should be taken into consideration c. Return on total assets (ROA) is sometimes called return on investment d. Generally, inventory is concerned with the most liquid asset that a firm possesses. e. A P/E ratio of 20 indicates that investors are willing to pay $20 for each $1 of earnings.arrow_forwardHow should the company respond to the ongoing situation to mitigate risk of failing the working capital given the following financial ratio? 1. Liquidity ratio : current ratio: 2.61xquick ratio: 2.56cash ratio: 0.85 2. Accounts receivable turnover: 4.08Ave collection period: 89.46 days 3. Inventory turnover: 38.76ave age of inventory: 9.42 4. Average payable turnover: 1.04ave payment period: 350.96 Note: Their working capital is 22,887,683 Current asset (37,127,683) - current liabilities (14,260,065) = 22,887,683arrow_forward
- (Liquidity analysis) The most recent balance sheet of Raconteurs, Inc., (in millions) is found here: LOADING... . a. Calculate Raconteurs' current ratio and acid-test (quick) ratio. b. Benchmark ratios for the current and acid-test (quick) ratio are 1.46 and 1.23, respectively. What can you say about the liquidity of Raconteur's operations based on these two ratios? Current assets Cash and marketable securities $10.2 Accounts receivable $39.8 Inventory $60.4 Total current assets $110.4 Current liabilities Accrued wages and taxes $4.7 Accounts payable $34.9 Notes payable $29.2 Total current liabilities $68.8arrow_forwardYou are provided with the Income Statement and the Balance Sheet of HTS software, Inc. for 2011.Required: (a) Calculate the ratios stated in the table below for HTS Software, Inc. for 2011 (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.arrow_forwardWhich of the following events will cause a company’s current ratio to decrease? a. The sale of inventory for credit (accounts receivable) b. Issuing stock for cash c. The sale of inventory for cash d. Paying off long-term debt with casharrow_forward
- Assume that the company has a current ratio of 1.2. Now which of the above actions would improve this ratio. Which of the following actions would improve (i.e., increase) this ratio?• Use cash to pay off current liabilities.• Collect some of the current accounts receivable.• Use cash to pay off some long-term debt.• Purchase additional inventory on credit (i.e., accounts payable).• Sell some of the existing inventory at cost.arrow_forwardYou are provided with the Income Statement and the Balance Sheet of HTS software, Inc. for 2011. Required: (a) Calculate the ratios stated in the table below for HTS Software, Inc. for 2011 (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…arrow_forwardYou are provided with the Income Statement and the Balance Sheet of HTS software, Inc. for 2011. Required: (a) Calculate the ratios stated in the table below for HTS Software, Inc. for 2011 (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…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 Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License