Question

In: Finance

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 credit)

$8,040

Cost of goods sold

(3,280)

Gross profit

$4,760

Operating expenses​ (includes $500​ depreciation)

(3,040)

Net operating income

$1,720

Interest expense

(352)

Earnings before taxes

$1,368

Income taxes

​(35%​)

(479)

Net income

. Calculate the following​ ratios:

Current ratio

Times interest earned

Inventory turnover

Total asset turnover

Operating profit margin

Operating return on assets

Debt ratio

Average collection period

Fixed asset turnover

Return on equity

Solutions

Expert Solution

Answer:

Current Ratio = Current Assets / Current Liabilities
Current Ratio = 3,670 / 1900
Current Ratio = 1.93

Operating Return on assets = Net Income / Operating Assets
Operating Return on assets = 889 / 8,270
Operating Return on assets = 10.75%

Times interest earned = EBIT / Interest Expense
Times interest earned = 1,720 / 352
Times interest earned = 4.89

Debt Ratio = Total debt / Total assets
Debt Ratio = 3,870 / 8,270
Debt ratio = 0.47

Inventory Turnover = Cost of goods sold / Inventory
Inventory Turnover = 3,280 / 1,090
Inventory Turnover = 3.01

Average collection period = (Accounts receivables / Net credit sales) * 365
Average collection period = (2,090 / 8,040) * 365
Average collection period = 94.88 days

Total asset turnover = Net sales / Total assets
Total asset turnover = (8,040 / 8,270)
Total asset turnover = 0.97

Fixed asset turnover = Net sales / Fixed assets
Fixed asset turnover = 8,040 / 4,600
Fixed asset turnover = 1.75

Operating profit margin = (Operating profit / Net sales) * 100
Operating profit margin = (4,760 / 8,040) * 100
Operating profit margin = 59.20%

Return on equity = Net income / Shareholder's equity
Return on equity = (889 / 4,400) * 100
Return on equity = 20.20%


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...
(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  ...
Below are the financial statements for J & P Industries Balance Sheet for J & P...
Below are the financial statements for J & P Industries Balance Sheet for J & P Industries 2018 Current assets Cash              215 Accounts receivable              310 Inventory              328      Total current assets              853 Fixed assets Net plant and equipment           6,527 Total assets           7,380 Current liabilities Accounts payable              298 Notes payable           1,427      Total currrent liabilities           1,725 Long-term debt           2,308 Owners' equity Common stock and paid in surplus           1,000 Retained earnings...
Identify 2 financial ratios that are useful in analyzing a balance sheet, income statement, or cash...
Identify 2 financial ratios that are useful in analyzing a balance sheet, income statement, or cash flow statement, and provide an example of how these ratios can be used by a firm's managers or other market analysts.
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below....
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below. Sales 443555 Operating Costs 326133 Depreciation 10000 Interest Expense 5000 Tax Expense 29408 Cash 1000 Receivables 30000 Inventories 54355 Fixed Assets, Net 50000 Payables 11000 Accrued Expenses 10000 Long-Term Loan 50000 Common Equity 64355 Prepare an income statement and a balance sheet for is company using the information provided. Calculate: 1. Current ratio 2. Quick ratio 3. NWC-to-total-Assets (Working capital to assets) 4. Ratio...
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below....
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below. Sales 499891 Operating Costs 359935 Depreciation 10000 Interest Expense 5000 Tax Expense 29408 Cash 1000 Receivables 30000 Inventories 59989 Fixed Assets, Net 50000 Payables 11000 Accrued Expenses 10000 Long-Term Loan 50000 Common Equity 69989 6. Interest coverage 7. Net profit margin 8. Sales to total assets (Asset turnover) 9. Return on assets 10. Equity multiplier 11. Return on equity
The balance sheet provides information concerning liquidity, financial flexibility, and information for calculating various financial ratios....
The balance sheet provides information concerning liquidity, financial flexibility, and information for calculating various financial ratios. The balance sheet serves as a major indicator of an enterprise's ability to survive. Nevertheless, the analysis of the balance sheet should be approached with a clear understanding of the limitations of the statement. What are the major limitations of the balance sheet that should be recognized in analyzing the statement? Explain how these affect the analysis of the balance sheet.
Given the income statement and balance sheet for Medical Equipment Corporation, compute the ratios that are...
Given the income statement and balance sheet for Medical Equipment Corporation, compute the ratios that are also shown for the industry average. For each ratio, indicate whether Medical Equipment Corporation is better (B) or worse (W) than the industry average. Show work Income Statement Sales (all credit) $1,607,500      Less: Cost of goods sold 1,353,000 Gross profit $254,500    Less: Selling and administrative expenses* 184,500 Operating profit (EBIT) $70,000      Less: Interest expense 24,500 Earnings before taxes (EBT) $45,500      Less...
FORECASTING FINANCIAL STATEMENTS - Company A reported an income statement and balance sheet as shown below:...
FORECASTING FINANCIAL STATEMENTS - Company A reported an income statement and balance sheet as shown below: Company A Income Statement For the Years Ended 2017 Sales 550.00 Cost of sales 275.00 Gross profit 275.00 SG&A 55.00 Depreciation 60.00 Interest 14.47 Pretax income 145.53 Tax 43.66 Net income 101.87 Company A Balance Sheet As of 2017 Cash 60.00 Accounts receivable 5.00 Inventory 8.00 Total current assets 73.00 PP&E - gross 600.00 Accumulated depreciation 200.00 PP&E - net 400.00 Total assets 473.00...
FORECASTING FINANCIAL STATEMENTS - Below is a pro-forma income statement and balance sheet for Company A...
FORECASTING FINANCIAL STATEMENTS - Below is a pro-forma income statement and balance sheet for Company A for a 5-year period and a terminal year, based on various assumptions, which already have been completed. Company A Income Statement For the Years Ended 2017 2018 2019 2020 2021 2022 Terminal year 2023 Sales     550.00            825.00               990.00                  1,138.50                    1,252.35                    1,340.01                        1,393.62                 1.50 (825*120%) (990*115%) (1138.50*110%) (1252.35*107%) (1340.01*104%) Cost of Sales     275.00            288.75              ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT