MPI Incorporated has $7 billion in assets, and its tax rate is 35%. Its basic earning power (BEP) ratio is 11%, and its return on assets (ROA) is 4%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet What is MPI's times-interest-earned (TIE) ratio? Round your answer to two decimal places

MPI Incorporated has $7 billion in assets, and its tax rate is 35%. Its basic earning power (BEP) ratio is 11%, and its return on assets (ROA) is 4%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet What is MPI's times-interest-earned (TIE) ratio? Round your answer to two decimal places

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter9: Metric-analysis Of Financial Statements

Section: Chapter Questions

Problem 9.1E

See similar textbooks

Similar questions

This year Last year 1050 Assets Cash 1530 Marketable securities Accounts receivable Inventories Total current assets 1810 1220 2050 1770 2900 2790 8290 6830 Gross fixed assets 29480 28090 Less: Accumulated depreciation 14680 13140 Net fixed assets 14800 14950 Total assets Liabilities and Stockholders' Equity 23090 21780 Accounts payable Notes payable Accruals 1560 1540 2760 2160 190 350 Total current liabilities 4510 4050 Long-term debt Common stock Retained earnings Total stockholders' equity 5220 4970 9950 9950 3410 2810 13360 12760 Total liabilities and stockholders' equity 23090 21780
Requirement 1. Compute these ratios: Working Capital Current Debt-to- Ratio Cash Ratio Debt Ratio Equity Ratio Round ratios to two 14.44 212400 7.73 decimal places or format as percentages or Accounts Days Sales currency as appropriate. Inventory Days Sales in Gross ProfitReceivable in Turnover Inventory Percentage Turnover Receivables 2019 Total Assets = Rate of Rate of Asset Return on Return on Turnover Stockholders' Earnings Total Assets Ratio Equity Per Share 2019 SHE = Price/ Earnings *Current Stock Price is Dividend $10.00 per share Ratio* Dividend Yield Payout Dividend per share= Requirement 2. Based on the ratios computed above, analyze the company's ability to pay its debts (both current and long term). Refer to at least 3 specific ratios in your analysis. Requirement 3: Based on the ratios computed above, analyze the company's management of inventory. Refer to at least 2 specific ratios in your analysis. Requirement 4: Based on the ratios computed above, analyze the company's…
Calculate the following ratios based on the balance sheet, income statement and cash flow prepared in question ROE Return on Capital Employed (post-tax) Net Profit Margin EBITDA Margin Effective Tax Rate Operating Cost Ratio Gross Profit Margin Total Asset Turnover Ratio Fixed Asset Turnover Ratio Receivables Turnover Ratio Leverage Ratio [Avg. Total Assets / Avg. Total Equity] FCF / EBITDA Interest Coverage Ratio Debt Service Coverage Ratio Basic EPS (Assume Face Value of each share is INR 10) Debt : Equity Ratio Income Statement (INR Cr) Units Mar/14 Saleable Units 4,570 Revenues Gross Revenues INR Cr 2,116 Less: Environment Cess INR Cr 5 Net Revenues INR Cr 2,121 Growth (%) -1.9% Expenses O&M Expenses (% of Project Costs) INR Cr 146 YoY Escalation 5.72% EBITDA INR Cr 1,974 Margin (%) 93.1% Book Depreciation INR Cr 439 Interest Expenses INR…
Selected ratios formulars Unilever 2021 BOPP 2021 ROCE PBIT / net assets * 100 (32,424/39,406 *100 = - 82% 102,154 / 192,758 *100 =53% Net Assets Turnover Revenue / Net Assets 526,912 / 39,406 = 13 times 214,174 / 192,758 = 1 time Gross Profit Margin Gross profit / revenue *100 97,046 / 526,912 *100 18.4% 115,462 / 214,174 * 100 54% Net Profit Before Tax PBT / revenue * 100 (35,005) / 526,912* 100 = -6.6% 104,778 / 214,174* 100 =48.9% Current Ratio Current assets / current liabilities 214,665/341,171 = 0.5 139,104 / 30,368 = 4.5 Quick Ratio Current assets – inventory / current liabilities 214,665-91,627 /341,171 = 0.4 139,104 -13,248/ 30,368 = 4.1 Inventory Days Inventory / cost of sales * 365 days 91,627/ 429,866 *365 = 77 days 13,248 / 101,397 *365 = 47 days Receivable Days Receivables / cost of sales * 365 days 24,515 / 429,866 *365 =20 days 92,860 / 101,397 *365 =334 days Payable Days…
Ratios Analyses: McCormick Refer to the information for McCormick above. Additional information for 20X3 it as follows (amounts in millions): Required: Next Level Compute the following for 20X3. Provide a brief description of what each ratio reveals about McCormick 1. return on common equity 2. debt-to-assets 3. debt-toequity 4. current 5. quick (McCormick uses cash and equivalents, short-term securities and receivables in their quick ratio calculation.) 6. inventory turnover days 7. accounts receivable turnover days 8. accounts payable turnover days 9. operating cycle (in days) 10. total asset turnover Use the following information for 14-17 and 14-18: The Hershey Company is one of the worlds leading producers of chocolates, candies, and confections. It sells chocolates and candies, mints and gums, baking ingredients, toppings, and beverages. Hersheys consolidated balance sheets for 20X2 and 20X3 follow.
Return on assets The following data (in millions) were adapted from recent financial statements of Tootsie Roll Industries Inc. (TR): The percent a company adds to its cost of sales to determine selling price is called a markup. What is Tootsie Roll’s markup percent? Round to one decimal place.
Use the following information for Cronos Group, Inc. (CRON): EBIT / Revenue 25.50% Government Tax Rate 42.50% Revenue / Assets 1.95 times Current Ratio 3.15 times EBT / EBIT 0.80 times Assets / Equity 2.00 times Its interest coverage ratio is closest to: A. 2.50. B. 5.00. C. 7.15. D. 9.25.
Solar Solutions began operations on January 1, 2015, and is now in its sixth year of operations. It is a retail sales company with a large amount of online sales. The adjusted trial balance as of December 31, 2020 appears below, along with prior year balance sheet data and some additional transaction data for 2020. SOLAR SOLUTIONS Adjusted Trial Balance 12/31/2020 2020 2019 Account Title Adjusted Trial Balance Post-Closing Trial Balance $ 125,600 Debit Credit 35,000 6,000 Debit Credit Cash Accounts Receivable Prepaid Insurance Inventory Office Equipment Machinery & Tools |Accumulated Depreciation Accounts Payable Salaries Payable Sales Tax Payable Note Payable-Long Term Common Stock, $10 par Retained Earnings $ 122,200 125,600 55,000 35,000 15,600 5,000 6,000 47,000 46,000 15,600 21,000 63,000 47,000 (16,000) $ 234,200 59,000 21,000 21,000 16,000 11,200 16,800 2,600 2,700 2,000 31,000 4,000 22,100 240,000 160,000 28,600 28,600 Dividends 10,000 Sales Revenue 235,000 Cost of Goods Sold…
Solution to Ratio Analysis Questions Selected ratios formulars Unilever 2021 BOPP 2021 ROCE PBIT / net assets * 100 (32,424/39,406 *100 = - 82% 102,154 / 192,758 *100 =53% Net Assets Turnover Revenue / Net Assets 526,912 / 39,406 = 13 times 214,174 / 192,758 = 1 time Gross Profit Margin Gross profit / revenue *100 97,046 / 526,912 *100 18.4% 115,462 / 214,174 * 100 54% Net Profit Before Tax PBT / revenue * 100 (35,005) / 526,912* 100 = -6.6% 104,778 / 214,174* 100 =48.9% Current Ratio Current assets / current liabilities 214,665/341,171 = 0.5 139,104 / 30,368 = 4.5 Quick Ratio Current assets – inventory / current liabilities 214,665-91,627 /341,171 = 0.4 139,104 -13,248/ 30,368 = 4.1 Inventory Days Inventory / cost of sales * 365 days 91,627/ 429,866 *365 = 77 days 13,248 / 101,397 *365 = 47 days Receivable Days Receivables / cost of sales * 365 days 24,515 / 429,866 *365 =20 days 92,860 /…
Which statement is correct? O A. current ratio 1.00 D. gross margin > net margin
Trend Analysis incorporates this into the calculations: income ratio debt ratio Analysis year dollar amount assets
I Current ratioli. Times interest earnedjli. Inventory turnover¡v. Total asset turnoverv. Operating profit marginVi. Debt ratiovi. Average collection periodVii Fixed asset turnoverixReturn on equity