Calculating Financial Ratios [LO2] Based on the balance sheets given for Just Dew It, calculate the following financial ratios for each year:
a. Current ratio.
b. Quick ratio.
c. Cash ratio.
d. NWC to total assets ratio.
e. Debt–equity ratio and equity multiplier.
f. Total debt ratio and long-term debt ratio.
a)
To calculate: The current ratio.
Introduction:
The financial ratios are important tools for effective decision-making. It compares different figures taken from the financial statement to obtain information about the performance of the firm.
Answer to Problem 17QP
The current ratio for the year 2014 and 2015 are 1.44 times and 1.51 times respectively.
Explanation of Solution
Given information:
- The total current assets (2014) is $90,717.
- The total current liabilities (2014) is $62,939.
- The total current assets (2015) is $100,617.
- The total current liabilities (2015) is $66,442.
Given the balance sheet of Corporation JD is as follows:
Corporation JD | |||||
Assets | Liabilities | ||||
2014 | 2015 | 2014 | 2015 | ||
Current Assets | Current liabilities | ||||
Cash | $11,135 | $13,407 | Accounts payable | $45,166 | $48,185 |
Accounts receivable | $28,419 | $30,915 | Notes payable | $17,773 | $18,257 |
Inventory | $51,163 | $56,295 | Total | $62,939 | $66,442 |
Total | $90,717 | $100,617 | |||
Long-term debt | $44,000 | $39,000 | |||
Owners' equity | |||||
Common stock and paid-in surplus | $50,000 | $50,000 | |||
Retained earnings | $260,234 | $302,735 | |||
Net plant and equipment | $326,456 | $357,560 | Total | $310,234 | $352,735 |
Total assets | $417,173 | $458,177 | Total liabilities and owners' equity | $417,173 | $458,177 |
Formula to calculate the current ratio:
Compute current ratio for the year 2014:
Compute current ratio for the year 2015:
Hence, the current ratio for the year 2014 and 2015 are 1.44 times and 1.51 times respectively.
b)
To calculate: The quick ratio.
Introduction:
The financial ratios are important tools for effective decision-making. It compares different figures taken from the financial statement to obtain information about the performance of the firm.
Answer to Problem 17QP
The quick ratio for the year 2014 and 2015 are 0.63 times and 0.67 times respectively.
Explanation of Solution
Given information:
- The total current asset (2014) is $90,717.
- Inventory (2014) is $51,163.
- The total current liabilities (2014) is $62,939.
- The total current asset (2015) is $100,617.
- Inventory (2015) is $56,295.
- The total current liabilities (2015) is $66,442.
Formula to calculate the current ratio:
Compute quick ratio for the year 2014:
Compute quick ratio for the year 2015:
Hence, the quick ratio for the year 2014 and 2015 are 0.63 times and 0.67 times respectively.
c)
To calculate: The cash ratio.
Introduction:
The financial ratios are important tools for effective decision-making. It compares different figures taken from the financial statement to obtain information about the performance of the firm.
Answer to Problem 17QP
The cash ratio for the year 2014 and 2015 are 0.18 times and 0.20 times respectively.
Explanation of Solution
Given information:
- Cash (2014) is $11,135.
- Total current liabilities (2014) is $62,939.
- Cash (2015) is $13,407.
- Total current liabilities (2015) is $66,442.
Formula to calculate the cash ratio:
Compute cash ratio for the year 2014:
Compute quick ratio for the year 2015:
Hence, the cash ratio for the year 2014 and 2015 are 0.18 times and 0.20 times respectively.
d)
To calculate: The net working capital to the ratio of total assets.
Introduction:
The financial ratios are important tools for effective decision-making. It compares different figures taken from the financial statement to obtain information about the performance of the firm.
Answer to Problem 17QP
The net working capital to total asset ratio for the year 2014 and 2015 are 0.0666 or 6.66% and 0.0746 or 7.46% respectively.
Explanation of Solution
Given information:
- The total current asset (2014) is $90,717.
- The total asset (2014) is $417,173.
- The total current liabilities (2014) is $62,939.
- The total current asset (2015) is $100,617.
- The total asset (2015) is $458,177.
- The total current liabilities (2015) is $66,442.
Formula to calculate the net working capital:
Note: It is required to calculate the net working capital to total asset ratio.
Compute the net working capital for the year 2014:
Compute the net working capital for the year 2015:
Hence, the net working capital for the year 2014 and 2015 are $27,778 and $34,175 respectively.
Formula to calculate the net working capital to total asset ratio:
Compute the net working capital to total asset ratio for the year 2014:
Compute the net working capital to total asset ratio for the year 2015:
Hence, the net working capital to total asset ratio for the year 2014 and 2015 are0.0666 or 6.66% and 0.0746 or 7.46% respectively.
e)
To calculate: Equity multiplier ratio.
Introduction:
The financial ratios are important tools for effective decision-making. It compares different figures taken from the financial statement to obtain information about the performance of the firm.
Answer to Problem 17QP
The equity multiplier ratio for the year 2014 and 2015 are 1.34 times and 1.30 times respectively.
Explanation of Solution
Given information:
- The total current liabilities (2014) is $62,939.
- The total long term debts (2014) is $44,000.
- The total equity (2014) is $310,234.
- The total current liabilities (2015) is $66,442.
- The total long term debts (2015) is $39,000.
- The total equity (2015) is $352,735.
Formula to calculate the total debt value:
Note: It is required to compute the value of total debt to calculate the total debt ratio.
Compute the total debt value for the year 2014:
Compute the total debt value for the year 2015:
Hence, the total debt value for the year 2014 and 2015 are $106,939 and $105,442 respectively.
Formula to calculate the total debt ratio:
Compute the total debt ratio for the year 2014:
Compute the total debt ratio for the year 2015:
Hence, the total debt ratio for the year 2014 and 2015 are 0.34 times and 0.30 times respectively.
Formula to calculate the equity multiplier ratio:
Compute the equity multiplier ratio for the year 2014:
Compute the equity multiplier ratio for the year 2015:
Hence, the equity multiplier ratio for the year 2014 and 2015 are 1.34 times and 1.30 times respectively.
f)
To calculate: The ratio of total debt and long-term debt.
Introduction:
The financial ratios are important tools for effective decision-making. It compares different figures taken from the financial statement to obtain information about the performance of the firm.
Answer to Problem 17QP
The long-debt ratio for the year 2014 and 2015 are 0.12 times and 0.10 times respectively.
Explanation of Solution
Given information:
- The total asset (2014) is $417,173.
- The total equity (2014) is $310,234.
- The total long-term debt (2014) is $44,000.
- The total asset (2015) is $458,177.
- The total equity (2015) is $352,735.
- The total long-term debt (2015) is $39,000.
Formula to calculate the total debt ratio:
Compute the total debt ratio for the year 2014:
Compute the total debt ratio for the year 2015:
Hence, the total debt ratio for the year 2014 and 2015 are 0.26 times and 0.23 times respectively.
Formula to calculate the long-term debt ratio:
Compute the long-debt ratio for the year 2014:
Compute the long-debt ratio for the year 2015:
Hence, the long-debt ratio for the year 2014 and 2015 are 0.12 times and 0.10 times respectively.
Want to see more full solutions like this?
Chapter 3 Solutions
FUND.OF CORP.FIN.(LL)-W/ACCESS >CUSTOM<
- Liquidity Ratios JRLs financial statements contain the following information: Required: 1. What is its current ratio? 2. What is its quick ratio? 3. What is its cash ratio? 4. Discuss JRLs liquidity using these ratios.arrow_forwardCategory of industry is real estate. The analysis of Total Debt Ratio is as follows: 2015: 39.73% 2016: 46.81% 2017: 48.38% 2018: 42.27% 2019: 42.44% a. What is the simple trend analysis for that Total Debt Ratio and why it is increasing and decreasing? b. Compare the ratio with the industry average.arrow_forwardThe following is selected financial data from Block Industries: How much does Block Industries have in current liabilities? A. $19,800 B. $18,300 C. $12,300 D. $25,800arrow_forward
- From the Google Finance site, look at Hewlett Packards profitability ratios (as measured by its profit margin, ROA, and ROE). How do these ratios compare with those of its peers?arrow_forwardCompose a financial analysis based on your evaluation of the ratios. For EACH of the five (5) classifications of ratios. one paragraph. 3A. Comparison between 2020E and 2019 ratios - (a) Liquidity ratios (1) What happened? Did each of the ratios increase, decrease, or not change? (2) What had caused the movement or non-movement for each ratio? and (3) Is this a good thing or a bad thing for the company? (b) Solvency ratios (1) What happened? Did each of the ratios increase, decrease, or not change? (2) What had caused the movement or non-movement for each ratio? and (3) Is this a good thing or a bad thing for the company? (c) Asset utilization ratios (1) What happened? Did each of the ratios increase, decrease, or not change? (2) What had caused the movement or non-movement for each ratio? and (3) Is this a good thing or a bad thing for the company? (d) Profitability ratios (1) What happened? Did each of the ratios increase, decrease, or not change? (2) What had caused the movement or…arrow_forward1.If Gwen, Inc. has a total debt ratio of 0.8, a total asset turnover of 0.33, and a net profit margin of 10%. Calculate the return on equity (ROE). Enter percentages as decimals and round to 4 decimals.arrow_forward
- FINA's business risk (Ru) is 9% in the industry. The debt-to-equity ratio is 0.4. The cost of debt is 3%. The tax rate is 20%. What is the required return of equity (Re)?arrow_forwardSome of the financial ratios of V, W, X, Y, and Z companies are calculated and presented in the following table. Ratio V W X Y Z Quick Ratio 4.1 times 2.4 times 3.9 times 2.8 times 3.2 times Return on sales 12% 8% 10% 16% 14% Inventory Turnover Ratio 9.7 times 12.6 times 10.4 times 11.5 times 7.8 times Debt-to- equity Ratio 0.45 0.64 0.21 0.36 0.81 You are an individual investor assessing the publicly traded companies V, W, X, Y, and Z based on their profitability. If you are to choose one of the companies to invest your money, which one would you choose? Explain your reason You are the loans manager of a bank assessing the applications of companies V, W, X, Y, and Z for long-term debt. If you are to choose one of the companies to lend money, which one would you choose? Explain your reason You are the loans manager of a bank assessing the applications of companies V, W, X, Y, and Z for short-term debt. If you…arrow_forwardURGENT !! Use the ratios and the financial information listed below and calculate and comment on 5 of the ratios. Note the industry average for the ratio is given below to aid in your discussion. (A simple answer of the company is better than the industry is not sufficient) Current ratio (current assets / current liabilities) - Industry Average 2 : 1 Working capital (current assets – current liabilities) - Industry Average $60,000 Accounts receivable turnover (net credit sales / average accounts receivable) - Industry Average 17.25 Average collection period (365 days / accounts receivable turnover) – Industry Average 21 Days Inventory turnover (cost of goods sold / average inventory) - Industry Average 8.5 Days in inventory (365 days / inventory turnover) - Industry Average 43 Days Debt to assets ratio (total liabilities / total assets) - Industry Average 45% Free cash flow (net cash provided by operating activities – capital expenditures – cash dividends) - Industry Average…arrow_forward
- Give typing answer with explanation and conclusion 27. EFN Define the following: S = Previous year’s sales A = Total assets E = Total equity g = Projected growth in sales PM = Profit margin b = Retention (plowback) ratio Assuming that all debt is constant, show that EFN can be written as EFN = −PM(S)b + [A − PM(S)b] × g Hint: Asset needs will equal A × g. The addition to retained earnings will equal PM(S)b × (1 + g).arrow_forwardI need help figuring: G. operating profit margin H. Long-term debt ratio (use end of year balance sheet figure) I. Total debt ratio (use end of your balance sheet figures) J. Times interest earn K. Cash coverage ratio L. Current ratio (use end of your balance sheet figures) M. Quick ratio (use end of your balance sheet figures)arrow_forward
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningFundamentals of Financial Management, Concise Edi...FinanceISBN:9781305635937Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeFundamentals of Financial Management, Concise Edi...FinanceISBN:9781285065137Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning