Concept Introduction:
Financial Statement analysis is done using the components of financial statement. These components are
Acid test ratio: Acid test ration is also called Quick ratio. This ratio is calculated by dividing the quick assets (Cash, Cash equivalents, Short term investments and current receivables) by total current liabilities for the year. The formula for Acid test ratio is as follows:
Accounts receivable turnover ratio: This is an efficiency ratio that indicates the conversion of accounts receivable into cash. This ratio is calculated by dividing the Net credit Sales by the Average accounts receivable. The formula to calculate this ratio is as follows:
Days Sales in receivable ratio: This is an efficiency ratio that indicates the period for which credit sales remain as receivable. The ratio is calculated by dividing 365 days by the Accounts receivable turnover ratio. The formula to calculate this ratio is as follows:
Inventory Turnover Ratio: Inventory Turnover Ratio measures the efficiency of the company in converting its inventory into sales. It is calculated by dividing the Cost of goods sold by Average inventory. The formula of the Inventory Turnover Ratio is as follows:
Note: Average inventory is calculated with the help of following formula:
Day’s sales in inventory: Days sales in inventory represent the number of days the inventory waits for the sale. It is calculated by dividing the 365 days by Inventory Turnover Ratio. The formula of the Days sales in inventory is as follows:
Debt to Equity Ratio:
Debt to equity ratio is calculated to determine the leverage position of the company. It compares the total liabilities of the company with it total shareholders’ equity. The debt to equity ratio is calculated by dividing the Total Liabilities by Total Stockholder’s Equity. The formula to calculate Debt to equity ratio is as follows:
Times interest earned Ratio:
A company pays its interest expenses from the Net operating Income available. To find the company’s ability to pay the interest expenses, the ratio of Net operating income to Interest expense should be calculated. Times Interest earned ratio shows the number of times interest expenses are covered by the net operating income. It is calculated by dividing the Net operating Income by Interest Expense. The formula is as under:
Times interest earned Ratio = Net Operating Income / Interest Expense
(Note: The numerator of the formula “Net operating income” is equal to the Income before deduction of Interest and taxes)
Profit Margin Ratio:
Profit Margin Ratio is a profitability ratio that represents the percentage income earned on the sales. It is calculated by dividing the Net Income by the Sales. The formulas to calculate the Profit margin is as follows:
Total Asset Turnover Ratio:
Asset Turnover Ratio is an efficiency ratio that represents the sales earned on the average assets invested in the business. It is calculated by dividing the Sales by Average total assets. The formulas to calculate the Asset Turnover Ratio is as follows:
Return on total Assets: The Return on total assets is profitability ratio that measures the percentage of profit earned on average assets invested in the business. Return on asset is calculated by dividing the net income by average total assets. The formula to calculate Return on assets is as follows:
Note: Average total assets are calculated as an average of beginning and ending total assets. The formula to calculate the average total assets is as follows:
Return on Common Stockholder’s Equity:
Return on Equity is the rate of return earned by the Stockholders on their investment in the company. It is calculated with the help of following formula:
The Average stock holder’s equity calculated with the help of following formula:
To calculate: The ratio analysis for the given case

Answer to Problem 4BPSB
Solution: The ratio analysis for the given case is as follows:
1 | Current Ratio | 2.5 |
2 | Acid Test Ratio | 1.6 |
3 | Days Sales Uncollected | 13.8 |
4 | Inventory Turnover | 15.3 |
5 | Days Sales in inventory | 23.6 |
6 | Debt to Equity Ratio | 0.68 |
7 | Times Interest Earned | 13.7 |
8 | Profit Margin Ratio | 7.5% |
9 | Total Assets Turnover | 3.0 |
10 | Return on Total Assets | 22.4% |
11 | Return on Common stock holder's Equity | 38.3% |
Explanation of Solution
1 | Current Ratio: | |
Cash | $ 6,100 | |
Short term Investments | $ 6,900 | |
Accounts Receivable, net | $ 12,100 | |
Notes Receivable (trade) | $ 3,000 | |
Merchandise Inventory | $ 13,500 | |
Prepaid Expenses | $ 2,000 | |
Total Current Assets (A) | $ 43,600 | |
Accounts Payable | $ 11,500 | |
Accrued wages payable | $ 3,300 | |
Income Tax Payable | $ 2,600 | |
Total Current Liabilities (B) | $ 17,400 | |
Current Ratio (A/B) | 2.5 | |
2 | Acid Test Ratio: | |
Cash | $ 6,100 | |
Short term Investments | $ 6,900 | |
Accounts Receivable, net | $ 12,100 | |
Notes Receivable (trade) | $ 3,000 | |
Total Liquid Assets (A) | $ 28,100 | |
Accounts Payable | $ 11,500 | |
Accrued wages payable | $ 3,300 | |
Income Tax Payable | $ 2,600 | |
Total Current Liabilities (B) | $ 17,400 | |
Acid Test Ratio (A/B) | 1.6 | |
3 | Days Sales Uncollected: | |
Accounts Receivable (A) | $ 12,100 | |
Credit Sales (B) | $ 315,500 | |
Days Sales Uncollected = (A*360/B) | 13.8 | |
4 | Inventory Turnover: | |
Cost of Goods sold (A) | $ 236,100 | |
Beginning Inventory (B) | $ 17,400 | |
Ending Inventory (C) | $ 13,500 | |
Average inventory (D) = (B+C)/2 | $ 15,450 | |
Inventory Turnover = (A/D) | 15.3 | |
5 | Days Sales in inventory: | |
Inventory Turnover (A) | 15.3 | |
Days Sales in inventory = (360/A) | 23.6 | |
6 | Debt to Equity Ratio: | |
Accounts Payable | $ 11,500 | |
Accrued wages payable | $ 3,300 | |
Income Tax Payable | $ 2,600 | |
Long term notes payable | $ 30,000 | |
Total Debts (A) | $ 47,400 | |
Common Stock | $ 35,000 | |
$ 35,100 | ||
Total Equity (B) | $ 70,100 | |
Debt to Equity Ratio =(A/D) | 0.68 | |
7 | Times Interest Earned: | |
Income before taxes (A) | $ 28,000 | |
Add: Interest Expense (B) | $ 2,200 | |
Income before interest and taxes (C) =A+B | $ 30,200 | |
Times Interest Earned =(C/B) | 13.7 | |
8 | Profit Margin Ratio: | |
Net Income (A) | $ 23,800 | |
Sales (B) | $ 315,500 | |
Profit Margin Ratio =(A/B) | 7.5% | |
9 | Total Assets Turnover: | |
Sales (A) | $ 315,500 | |
Beginning Total Assets (B) | $ 94,900 | |
Ending Total Assets (C) | $ 117,500 | |
Average Total Assets (D) = (B+C)/2 | $ 106,200 | |
Inventory Turnover = (A/D) | 3.0 | |
10 | Return on Total Assets: | |
Net Income (A) | $ 23,800 | |
Beginning Total Assets (B) | $ 94,900 | |
Ending Total Assets (C) | $ 117,500 | |
Average Total Assets (D) = (B+C)/2 | $ 106,200 | |
Return on Total Assets = (A/D) | 22.4% | |
11 | Return on Common stock holder's Equity: | |
Net Income (A) | $ 23,800 | |
Beginning Common | $ 54,300 | |
Ending Common Stockholder's Equity (C) | $ 70,100 | |
Average Common Stockholder's Equity (D) = (B+C)/2 | $ 62,200 | |
Return on Common stock holder's Equity = (A/D) | 38.3% |
Want to see more full solutions like this?
Chapter 17 Solutions
FUNDAMENTAL ACCT PRIN TEXT+CONNECT CODE
- Do fast answer general accounting questionarrow_forwardConsider the following information for Trent Company: Net cash provided by operating activities $1,000,000 Common stock issued as a result of a stock dividend (fair value) 100,000 Common stock issued for cash 400,000 Proceeds from sale of building 300,000 Trent Company should report a net increase in cash of:arrow_forwardPlease explain the solution to this general accounting problem with accurate principles.arrow_forward
- Can you help me solve this general accounting question using the correct accounting procedures?arrow_forwardI need the correct answer to this general accounting problem using the standard accounting approach.arrow_forwardI am searching for the accurate solution to this general accounting problem with the right approach.arrow_forward
- Please provide the correct answer to this general accounting problem using valid calculations.arrow_forwardCan you solve this general accounting problem using appropriate accounting principles?arrow_forwardSarah is the president and general manager of the operation. Sarah has been very proactive in growing the business. She has met with her banker to discuss expanding the facilities and equipment with another $150,000 loan. Their first loan for $150,000 was secured by the industrial-size food production equipment purchased with the loan. The banker now demands an audit of the corporate financial statements before releasing another loan to the company. Sarah has offered to place the corporate account receivables up as collateral to secure the second loan. Based on revenue projections by her sister Jillian's sales team, Sarah believes that the company will not have trouble paying down the loan in a short period of time. Kim's assistant, Henry, monitors the production and shipment of Smackey Dog Food's regular line of products. Henry takes pride in his work and is involved in every facet of the operation. With only one other warehouse employee to help, Henry personally is involved in…arrow_forward
- 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





