With given data please fill in blanks, inventory turnover, DSO, etc.... Thanks!!!! 033A1 Ratios ▼ 20392 Net Profit M3 Operating Pr4 Basic Earning5 Return on AsReturn on EqXB19 Current Ratio20 Quick Ratio21#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!11 Inventory Turnover12 DSO13 Fixed Assets Turnover14 Total Assets Turnover151617 Two Liquidity ratios18 Ratios2039fx6789 Four asset management ratios10 Ratios ▼ 20392040E25 Leverage Ratio26 Debt-to-Equity27 Liabilities-to-Assets28 Equity Multiplier29 Times Intrest Earned30 EBITDA Coverage31323334с2040E2223 Six Debt management ratios24 Ratios ▼ 2039#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!▼ 2040E▼ 2040ED| Industry ANot GivenNot givenNot givenNot GivenNot givenIndustry A Comment✓ IndustryECommentNet Profit slightly increases from last year.IndustryCommentFCommentGHAssets (million $)CashS-T investmentsIAssets (million $)Accounts receivable (A/R)InventoriesTotal current assets (CA)Gross fixed assets (FA)Less: DepreciationNet FATotal assetsTotal equityTotal L&ELiabilities and Equity (million $)Accounts payable (A/P)Notes payableAccrualsTotal current liabilities (CL)Long-Term deptTotal liabilitiesCommon stockRetained earningsJKL2039100306008001530500013003700523020395003002501050120022501000200030005250M2039N2040E2040120606307008105000110039004710400150300850120020501000230033005350OP(million $)SalesCOGSDepreciationOther expensesTot. op. sostsEBITIntrest expensePre-tax earningsTax rateTaxes @25%Net incomeQRS20397000500030045057501250110114025%285855TU2040E7600540040043062301370100127025%317.5952.5V

The asset management ratios are calculated as shown below. Inventory turnover=Cost of goods…

rofit M #DIV/0! ating Pr #DIV/0! Earning #DIV/0! n on As #DIV/0! non Eq #DIV/0! asset management ratios 2039 s 2040E tory Turnover Assets Turnover Assets Turnover Liquidity ratios 2039 #DIV/0! Not Given Net Profit slightly increases from last year. #DIV/0! Not given #DIV/0! Not given #DIV/0! Not Given #DIV/0! Not given s int Ratio Ratio 2040E Industry Comment Industry Comment Assets (million $) Assets (million $) Cash S-T investments Accounts receivable (A/R) Inventories Total current assets (CA) Gross fixed assets (FA) Less: Depreciation Net FA Total assets Liabilities and Equity (million $) Accounts payable (A/P) Notes payable Accruals Total current liabilities (CL) 2039 100 30 600 800 1530 5000 1300 3700 5230 2039 500 300 250 1050 2039 2040E 2040 120 60 630 700 810 5000 1100 3900 4710 400 150 300 850 (million $) Sales COGS Depreciation Other expenses Tot. op. sosts EBIT Intrest expense Pre-tax earnings Tax rate Taxes @25% Net income 2039 7000 5000 300 450 5750 1250 110 1140 25% 285 855 20408

rofit M #DIV/0! ating Pr #DIV/0! Earning #DIV/0! n on As #DIV/0! non Eq #DIV/0! asset management ratios 2039 s 2040E tory Turnover Assets Turnover Assets Turnover Liquidity ratios 2039 #DIV/0! Not Given Net Profit slightly increases from last year. #DIV/0! Not given #DIV/0! Not given #DIV/0! Not Given #DIV/0! Not given s int Ratio Ratio 2040E Industry Comment Industry Comment Assets (million $) Assets (million $) Cash S-T investments Accounts receivable (A/R) Inventories Total current assets (CA) Gross fixed assets (FA) Less: Depreciation Net FA Total assets Liabilities and Equity (million $) Accounts payable (A/P) Notes payable Accruals Total current liabilities (CL) 2039 100 30 600 800 1530 5000 1300 3700 5230 2039 500 300 250 1050 2039 2040E 2040 120 60 630 700 810 5000 1100 3900 4710 400 150 300 850 (million $) Sales COGS Depreciation Other expenses Tot. op. sosts EBIT Intrest expense Pre-tax earnings Tax rate Taxes @25% Net income 2039 7000 5000 300 450 5750 1250 110 1140 25% 285 855 20408

Fundamentals of Financial Management (MindTap Course List)

15th Edition

ISBN:9781337395250

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter4: Analysis Of Financial Statements

Section: Chapter Questions

Problem 24P: Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of...

See similar textbooks

Similar questions

Q. Calculate the current assets and current liabilities from the data given below. Current ratio. 1.8 Quick ratio. 1.2 Inventory turnover ( on c.g.s). 12 Gross profit rate. 25% Credit period. 1month Working capital. 640000
Data needed: SFP Asset section 1. Cash 16.3% 2. AR 6.3% 3. Short term investment 0.2% 4. Inventory 2.2% 5. Prepaid expenses 0.4% 6. PPE 74.7% Data needed: SFP Liabilities and OE section. 1. Current liab 16% 2. Non-current liab 34.2% 3. OE 49.9% Data needed: SCI 1. COGS 38.6% 2. Selling and admin exp 6.8% 3. Interest exp 0.1% 4. Income tax exp 0.5% 5. Net income 54%
Operating profit 43-7 Sales revenue 910-4 Share capital and reserves 182-3 Long-term borrowing 77-9 Inventory 46-2 Receivables 97-8 Payables 51:3 Calculate the following: GReturn on Cepitatemployest (i Assetturnover (ii) Current ratio (iv) Acid test (quick) ratio
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 /…
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…
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
Current Asset Current Liabilities COGS Inventory Total Liabilities Total Assets Net Sales Operating Income Gross Profit EBIT EBT Cash Flow Operation Retained Earning Owner's Equity 2018 80,073,836 26,882,064 51,678,144 14,854,944 80,133,248 124,776,768 160,099,728 75,249,200 108,421,584 56,436,900 45,149,520 49,716,192 28,967,893 44,643,520 2017 54,919,520 13,083,840 35,379,840 9,575,808 64,875,200 100,945,824 98,157,888 32,775,808 62,778,048 24,581,856 19,665,485 26,781,248 29,361,440 36,070,624
Ratio Industry Ratios GnG Ratios 1. Current Ratio 5.3 2. Acid Test Ratio 5.1 3. Gross Profit Ratio 30% 4. Net Income Margin 7.5% 5. Receivable Turnover Ratio 9 6. Return on Asset Ratio 12% 7. Debt to Asset Ratio 1:4 Interpretation and verbal analysis compared to industry ratios: 1. Liquidity 2. Profitability 3. Solvency Computations:
Partial Income Statement Excel Exercise Compute the Following ՀԱՐ Sales COGS SG&A Depreciation Debt Int. Rate Tax Rate* 2019 100 40 EBITDA EBIT 25 Interest 10 EBT 0.08 Tax 0.25 Net Income ? ? ? ? ? ? Partial Balance Sheet Debt and Loans 150 Total Equity 150 Total Assets 300 Inv. Change 10 A/R Change A/P Change 35 20 Net Profit Margin Equity Multiplier Verify Dupont ROE ? סיי ? ? ? ? ? * Assume all taxes paid in current period (no accrued taxes) for rest of course CF from Operations ROE Asset Turnover CED Tt O 24
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…
Ratio Industry Ratios GnG Ratios 1. Current Ratio 5.3 7.08 2. Acid Test Ratio 5.1 6.8 3. Gross Profit Ratio 30% 40% 4. Net Income Margin 7.5% 18.2% 5. Receivable Turnover Ratio 9 14.41 6. Return on Asset Ratio 12% 9.29% 7. Debt to Asset Ratio 1:4 1 : 1 Interpretation and verbal analysis compared to industry ratios: 1. Liquidity 2. Profitability 3. Solvency
Industry Ratios Ratio GnG Ratios 1. Current Ratio 5.3 7.08 2. Acid Test Ratio 5.1 6.8 3. Gross Profit Ratio 30% 40% 4. Net Income Margin 7.5% 18.2% 5. Receivable Turnover Ratio 14.41 6. Return on Asset Ratio 12% 9.29% 7. Debt to Asset Ratio 1:4 LA 1 Interpretation and verbal analysis compared to industry ratios: Liquidity 1. 2. Profitability 3. Solvency