Question

In: Finance

(Ratio analysis​) The balance sheet and income statement for the A. Thiel Mfg. Company are given...

(Ratio analysis​) The balance sheet and income statement for the A. Thiel Mfg. Company are given in the popup​ window: Calculate the following​ ratios:

a. Current ratio

b. Operating return on assets

c. Times interest earned

d. Debt ratio

e. Inventory turnover

f. Average collection period

g. Total asset turnover

h. Fixed asset turnover

i. Operating profit margin

j. Return on equity

Cash   $ 500
Accounts receivable   2,000
Inventories   1,000
Current assets   $ 3,500
Net fixed assets   4,500
Total assets   $ 8,000
  
Accounts payable   $ 1,100
Accrued expenses   600
Short-term notes payable   300
Current liabilities   $ 2,000
Long-term debt   2,000
Owners' equity   4,000
Total liabilities and owners' equity 8,000

Sales (all credit)   $ 8,000
Cost of goods sold   (3,300)
Gross profit   $ 4,700
Operating expenses (includes $500 depreciation)   (3,000)
Operating profits   $ 1,700
Interest expense   (367)
Earnings before taxes   $ 1,333
Income taxes (21%)   (280)
Net income 1,053

Solutions

Expert Solution

a) Current ratio:

=> Current ratio = current assets/current liabilities

=> It is given that current asset = $ 3,500 and current liabilities = $ 2,000

=> Therefore current ratio = 3,500/2,000 = 1.75

b) Operating return on assets:

=> Operating return on assets = Operating income/Total assets ( Operating income is also called EBIT)

=> It is given that operating income = $ 1,700 and total assets = $ 8,000

=> Therefore operating return on assets = 1,700/8,000 = 0.2125 or 21.25%

c) Times interest earned:

=> Time interest earned = operating income / interest expense

=> operating income = $ 1,700 and interest expense = $ 367

=> Therefore time interest earned ratio = 1,700/367 = 4.632

d) Debt ratio

=> Debt ratio = total liabilities/total assets

=> It is given that total assets = $ 8,000 and total liabilities = current liabilities + long term debt= 2,000+2,000 = $ 4,000

=> Therefore debt ratio = 4,000/8,000 = 0.5 or 50%

e) Inventory turnover:

=> inventory turnover = cost of goods sold/ average inventory ( In this case we will take inventory of that particular year)

=> It is given that cost of goods sold = $ 3,300 , inventories = $ 1,000

=> Therefore inventory turnover = 3,300/1,000 = 3.3

f) Average collection period:

=> Average collection period = (average receivables / sales)*365 ( In this case we will take receivables of that particular year)

=> It is given that receivables = $ 2,000 , sales = $ 8,000

=> Therefore average collection period = (2,000/8,000)*365 = 91.25 days

g) Asset turnover ratio:

=> Asset turnover ratio = sales/ total assets

=> It is given that sales = $ 8,000, total assets = $ 8,000

=>Therefore asset turnover ratio = 8,000/8,000 = 1

h) Fixed asset turnover:

=> Fixed asset turnover = sales/ fixed assets

=> It is given that sales = $ 8,000, fixed assets = $ 4,500

=>Therefore fixed asset turnover = 8,000/4,500 = 1.778

I) Operating profit margin:

=> Operating profit margin = Operating income / sales

=> it is given that operating income = $ 1,700 and sales = $ 8,000

=> Therefore operating profit margin = 1,700 / 8,000 = 0.2125 or 21.25%

j) Return on equity:

=> Return on equity = net income / shareholder's equity

=> It is given that net income = $ 1,053 and shareholder's equity = $ 4,000

=> Therefore return on equity = 1,053/4,000 = 0.2633 or 26.33%


Related Solutions

The balance sheet and income statement for the J. P. Robard Mfg. Company are given below....
The balance sheet and income statement for the J. P. Robard Mfg. Company are given below. Calculate the following ratios: current ratio, debt ratio, times interest earned, average collection period, inventory turnover, fixed asset turnover, total assets turnover, gross profit margin, operating profit margin, operating return on assets, return on equity. DATA Balance Sheet: (000) Cash $500 Accounts receivable 2,000 Inventories 1,000    Current assets $3,500 Net fixed assets 4,500    Total assets $8,000 Accounts payable $1,100 Accrued expenses 600...
Calculating financial​ ratios)  The balance sheet and income statement for the J. P. Robard Mfg. Company...
Calculating financial​ ratios)  The balance sheet and income statement for the J. P. Robard Mfg. Company are as​ follows:   J. P. Robard​ Mfg., Inc. Balance Sheet​ ($000) Cash $490 Accounts receivable 2,090 Inventories 1,090 Current assets $3,670 Net fixed assets 4,600 Total assets $8,270 Accounts payable $1,020 Accrued expenses 630 ​Short-term notes payable 250 Current liabilities $1,900 ​Long-term debt 1,970 ​Owners' equity 4,400 Total liabilities and​ owners' equity $8,270 J. P. Robard​ Mfg., Inc. Income Statement​ ($000) Net sales​ (all...
Ratio Analysis of Comparative Financial Statements A comparative income statement and balance sheet of Miller Electronics...
Ratio Analysis of Comparative Financial Statements A comparative income statement and balance sheet of Miller Electronics Corporation for the last two years are shown. Miller Electronics Corporation Comparative Income Statement For Years Ended December 31, 20-2 and 20-1 20-2 20-1 Net Sales (all on account) $646,120    $414,520    Cost of goods sold 384,590    253,000    Gross profit $261,530    $161,520    Administrative expenses $63,249    $41,647    Selling expenses 66,183    44,283    Total operating expenses $129,432    $85,930    Operating income $132,098    $75,590    Interest expense 1,316    1,222    Income before...
Prepare a horizontal analysis of both the balance sheet and income statement.  Analysis Bal Sheet...
Prepare a horizontal analysis of both the balance sheet and income statement.  Analysis Bal Sheet Analysis Inc Stmt  Complete this question by entering your answers in the tabs below. Prepare a horizontal analysis of the balance sheet. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as 23.4).) Analysis Bal Sheet Analysis Inc Stmt $ $ $ $ $ $ $ $ STUART COMPANY Horizontal Analysis...
A comparative balance sheet and an income statement for Burgess Company are given below: Burgess Company...
A comparative balance sheet and an income statement for Burgess Company are given below: Burgess Company Comparative Balance Sheet (dollars in millions) Ending Balance Beginning Balance Assets Current assets: Cash and cash equivalents $ 48 $ 99 Accounts receivable 730 669 Inventory 695 646 Total current assets 1,473 1,414 Property, plant, and equipment 1,595 1,565 Less accumulated depreciation 824 678 Net property,plant, and equipment 771 887 Total assets $ 2,244 $ 2,301 Liabilities and Stockholders' Equity Current liabilities: Accounts payable...
A comparative balance sheet and an income statement for Burgess Company are given below: Burgess Company...
A comparative balance sheet and an income statement for Burgess Company are given below: Burgess Company Comparative Balance Sheet (dollars in millions) Ending Balance Beginning Balance Assets Current assets: Cash and cash equivalents $ 69 $ 141 Accounts receivable 940 858 Inventory 800 730 Total current assets 1,809 1,729 Property, plant, and equipment 1,805 1,754 Less accumulated depreciation 950 741 Net property,plant, and equipment 855 1,013 Total assets $ 2,664 $ 2,742 Liabilities and Stockholders' Equity Current liabilities: Accounts payable...
A comparative balance sheet and an income statement for Burgess Company are given below: Burgess Company...
A comparative balance sheet and an income statement for Burgess Company are given below: Burgess Company Comparative Balance Sheet (dollars in millions) Ending Balance Beginning Balance Assets Current assets: Cash and cash equivalents $ 49 $ 79 Accounts receivable 645 580 Inventory 660 615 Total current assets 1,354 1,274 Property, plant, and equipment 1,515 1,466 Less accumulated depreciation 765 641 Net property, plant, and equipment 750 825 Total assets $ 2,104 $ 2,099 Liabilities and Stockholders' Equity Current liabilities: Accounts...
A comparative balance sheet and an income statement for Burgess Company are given below: Burgess Company...
A comparative balance sheet and an income statement for Burgess Company are given below: Burgess Company Comparative Balance Sheet (dollars in millions) Ending Balance Beginning Balance Assets Current assets: Cash and cash equivalents $ 46 $ 95 Accounts receivable 710 651 Inventory 685 638 Total current assets 1,441 1,384 Property, plant, and equipment 1,575 1,547 Less accumulated depreciation 812 672 Net property, plant, and equipment 763 875 Total assets $ 2,204 $ 2,259 Liabilities and Stockholders' Equity Current liabilities: Accounts...
A comparative balance sheet and an income statement for Rowan Company are given below: Rowan Company...
A comparative balance sheet and an income statement for Rowan Company are given below: Rowan Company Comparative Balance Sheet (dollars in millions) Ending Balance Beginning Balance Assets Current assets: Cash and cash equivalents $ 70 $ 91 Accounts receivable 536 572 Inventory 620 580 Total current assets 1,226 1,243 Property, plant, and equipment 1,719 1,656 Less accumulated depreciation 640 480 Net property, plant, and equipment 1,079 1,176 Total assets $ 2,305 $ 2,419 Liabilities and Stockholders' Equity Current liabilities: Accounts...
A comparative balance sheet and an income statement for Rowan Company are given below: Rowan Company...
A comparative balance sheet and an income statement for Rowan Company are given below: Rowan Company Comparative Balance Sheet (dollars in millions) Ending Balance Beginning Balance Assets Current assets: Cash and cash equivalents $ 70 $ 91 Accounts receivable 536 572 Inventory 620 580 Total current assets 1,226 1,243 Property, plant, and equipment 1,719 1,656 Less accumulated depreciation 640 480 Net property, plant, and equipment 1,079 1,176 Total assets $ 2,305 $ 2,419 Liabilities and Stockholders' Equity Current liabilities: Accounts...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT