(Calculating financial ratios) Use the balance sheet and income statement for th
ID: 2766869 • Letter: #
Question
(Calculating financial ratios) Use the balance sheet and income statement for the J. P. Robard Mfg. Company to calculate the following ratios:
Current ratio (Round to two decimal places.) Times interest earned (Round to two decimal places.) Inventory turnover (Round to two decimal places.) Total asset turnover (Round to two decimal places.) Operating profit margin (Round to one decimal places.) Operating return on assets (Round to one decimal places.) Debt ratio (Round to one decimal places.) Average collection period (Round to one decimal places.) Fixed asset turnover (Round to two decimal places.) Return on equity (Round to one decimal places.) times times days J. P. Robard Mfg., Inc. Balance Sheet (S000) Cash Accounts receivable Inventories $460 1,920 S3,290 4,480 7,770 Current assets Net fixed assets Total assets S1,170 570 260 S2,000 1,920 3.850 $7,770 Accounts payable Accrued expenses Short-term notes payable Current liabilities Long-term debt Owners' equity Total liabilities and owners' equity J. P. Robard Mfg., Inc. Income Statement (S000) $7,990 (3,340) S4,650 (3,000) S1,650 (363) S1,287 (515) $772 Net sales (all credit) Cost of goods sold Gross profit Operating expenses (includes $500 depreciation) Net operating income Interest expense Earnings before taxes Income taxes (40%) Net incomeExplanation / Answer
All figures in $,000
Current Ratio = Current Assets/Current Liabilities
=> $3,290/$2,000 = 1.645
Times Interest Earned = EBIT/Interest Expense
=> $1,650/$363 = 4.54
Inventory Turnover = COGS/Inventory
=> $3,340/$910 = 3.67
Total Asset Turnover = Sales/Total Assets
=> $7,990/$7,770 = 1.028
Operating Profit Margin = Operating Earnings/Revenue
=> $1,650/$7,990 = 0.2065 or 20.6%
Operating Return on Assets = EBIT/Average total assets
=> $1,650/$7,770 = 0.212 or 21.2%
Debt Ratio = Total Debt / Total Assets
=> ($2,000 + $1,920) / $7,770 = 0.5045 or 50.5%
Average Collection Period = (Average Account Receivable)/(Annual Sales/365)
=> ($1,920)/($7,990/365) = 87.71 days
Fixed asset turnover = Net Sales/Average fixed assets
=> $7,990/$4,480 = 1.78
Return to Equity = Net Income/Shareholder’s Equity
=> $772/$3,850 = .2005 or 20.1%
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.