Particulars Amount (in millions) Sales £260,174 COGS £161,782 EBIT £63,930 EBITDA £76,477 Interest Expense £3,576 Net Income £55,256 Total Debt £108,047 Total Assets £338,516 Net Fixed Assets £37,378 Total Equity £90,488 Current Assets £162,819 Current Liabilities £105,718 Cash & Cash Equivalents £48,844 Accounts Receivables £22,926 Inventories £4,106 Accounts Payable £46,236 Particulars Amount (in millions) Sales £260,174 (a) You are required to calculate the following ratios: Current Ratio Quick Ratio Cash Ratio Debt to Equity Ratio Debt Ratio Receivables Turnover Ratio Inventory Turnover Ratio Gross Margin Operating Profit Margin Net Margin (a) You are required to calculate the following ratios: Current Ratio Quick Ratio Cash Ratio Debt to Equity Ratio Debt Ratio Receivables Turnover Ratio Inventory Turnover Ratio Gross Margin Operating Profit Margin Net Margin

Particulars Amount (in millions) Sales £260,174 COGS £161,782 EBIT £63,930 EBITDA £76,477 Interest Expense £3,576 Net Income £55,256 Total Debt £108,047 Total Assets £338,516 Net Fixed Assets £37,378 Total Equity £90,488 Current Assets £162,819 Current Liabilities £105,718 Cash & Cash Equivalents £48,844 Accounts Receivables £22,926 Inventories £4,106 Accounts Payable £46,236 Particulars Amount (in millions) Sales £260,174 (a) You are required to calculate the following ratios: Current Ratio Quick Ratio Cash Ratio Debt to Equity Ratio Debt Ratio Receivables Turnover Ratio Inventory Turnover Ratio Gross Margin Operating Profit Margin Net Margin (a) You are required to calculate the following ratios: Current Ratio Quick Ratio Cash Ratio Debt to Equity Ratio Debt Ratio Receivables Turnover Ratio Inventory Turnover Ratio Gross Margin Operating Profit Margin Net Margin

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

Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of goods sold 660.0 Gross profit 135.0 Selling expenses 73.5 EBITDA 61.5 Depreciation expenses 12.0 Earnings before interest and taxes (EBIT) 49.5 Interest expenses 4.5 Earnings before taxes (EBT) 45.0 Taxes (40%) 18.0 Net income 27.0 a. Calculate the ratios you think would be useful in this analysis. b. Construct a DuPont equation, and compare the companys ratios to the industry average ratios. c. Do the balance-sheet accounts or the income statement figures seem to be primarily responsible for the low profits? d. Which specific accounts seem to be most out of line relative to other firms in the industry? e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?
Cash $ 200,490 Sales $ 8,104,080 Debt Investments (trading) (at cost, $145,000) 157,080 Cost of Goods Sold 4,800,000 Debt Investments (long-term) 302,490 Equity Investments (long-term) 280,490 Notes Payable (short-term) 94,080 Accounts Payable 459,080 Selling Expenses 2,004,080 Investment Revenue 64,820 Land 264,080 Buildings 1,043,490 Dividends Payable 139,490 Accrued Liabilities 100,080 Accounts Receivable 439,080 Accumulated Depreciation-Buildings 152,000 Allowance for Doubtful Accounts 29,080 Administrative Expenses 901,820 Interest Expense 212,820 Inventory 600,490 Gain 81,820 Notes Payable (long-term) 903,490 Equipment 604,080 Bonds Payable 1,003,490 Accumulated Depreciation-Equipment…
Sales : $250,000Costs : $134,000Depreciation : $10,200Operating expenses : $6,000Interest expenses : $20,700Taxes : $18,420Dividends : $10,600Addition to Retained Earnings : $50,080Long term debt repaid : $9,300New Equity issued : $8,470New fixed assets acquired : $15,000 You are required to:iv) Calculate the cash flow from assets v) Calculate net capital spending vi) Calculate change in NWC
Sales : $250,000Costs : $134,000Depreciation : $10,200Operating expenses : $6,000Interest expenses : $20,700Taxes : $18,420Dividends : $10,600Addition to Retained Earnings : $50,080Long term debt repaid : $9,300New Equity issued : $8,470New fixed assets acquired : $15,000You are required to:i) Calculate the operating cash flow ii) Calculate the cash flow to creditors iii) Calculate the cash flow to shareholders iv) Calculate the cash flow from assets v) Calculate net capital spending vi) Calculate change in NWC
Sales : $250,000Costs : $134,000Depreciation : $10,200Operating expenses : $6,000Interest expenses : $20,700Taxes : $18,420Dividends : $10,600Addition to Retained Earnings : $50,080Long term debt repaid : $9,300New Equity issued : $8,470New fixed assets acquired : $15,000 You are required to:i) Calculate the operating cash flow ii) Calculate the cash flow to creditors iii) Calculate the cash flow to shareholders
Fixed assets 267.5 million Sales 1,100.0 million Net Income 52.0 million Current liabilities 106.8 million Current ratio 3.10x Days sales outstanding 41.25 days Return on equity 12.50% Compute the return on assets.
Consider the following financial information and answer the questions that follow:Sales : $250,000Costs : $134,000Depreciation : $10,200Operating expenses : $6,000Interest expenses : $20,700Taxes : $18,420Dividends : $10,600Addition to Retained Earnings : $50,080Long term debt repaid : $9,300New Equity issued : $8,470New fixed assets acquired : $15,000You are required to:iv) Calculate the cash flow from assetsv) Calculate net capital spendingvi) Calculate change in NWC
Patel Corporation Balance Sheet December 31, 2021 $ 630,000 189,000 275,000 1,875,000 Cash $ Accounts receivable ( net) Inventories Plant and equipment net of depreciation Patents Other intangible assets Total Assets $ 750,000 350,000 Accounts payable 1.950,000 Income taxes payable 2,439,000 Miscellaneous accrued payables Bonds payable (8% , due 2023) 1,963,000 Preferred slock ($100 par, 6% 261,000 cumulative nonparticipating) 75,000 Common stock (no par, 60,000 7,058.000 shares authorized, issued and outstanding) Retained earnings Treasury stock- - 1.500 shares of preferred Total Equities 1,125,000 2,439,000 (225,000) underline 5 7,058,000 Patel Corporation Income Statement Year ended December 31, 2021 Net sales $ Cose goods sold Gross profit Operating expenses (including bond interest expense) Income before income taxes Income tax Net income 9,000,000 6,000,000 3,000,000 1,500,000 1,500,000 450,000 1, 05 Additional information: There are no preferred dividends in arrears, the…
Patel Corporation Balance Sheet December 31, 2021 $ 630,000 189,000 275,000 1,875,000 Cash $ Accounts receivable ( net) Inventories Plant and equipment net of depreciation Patents Other intangible assets Total Assets $ 750,000 350,000 Accounts payable 1.950,000 Income taxes payable 2,439,000 Miscellaneous accrued payables Bonds payable (8% , due 2023) 1,963,000 Preferred slock ($100 par, 6% 261,000 cumulative nonparticipating) 75,000 Common stock (no par, 60,000 7,058.000 shares authorized, issued and outstanding) Retained earnings Treasury stock- - 1.500 shares of preferred Total Equities 1,125,000 2,439,000 (225,000) underline 5 7,058,000 Patel Corporation Income Statement Year ended December 31, 2021 Net sales $ Cose goods sold Gross profit Operating expenses (including bond interest expense) Income before income taxes Income tax Net income 9,000,000 6,000,000 3,000,000 1,500,000 1,500,000 450,000 1, 05 Additional information: There are no preferred dividends in arrears, the…
SME Balance Sheet 2021 2020 Assets (in millions) Cash 85.960 56.460 Receivables 89.560 80.670 Inventories 55.750 41.260 Other Current Assets 9.950 6.760 Total Current Assets    241.220    185.150 Net Property, Plant, and Equipment 78.970 68.930 Goodwill and Other Intangible Assets 103.110 104.360 Other Non-Current Assets 6.900 4.200 Total Assets    430.200    362.640 Total Liabilities and Shareholders' Equity Payables 83.240         57.48 Current Debt 2.700           2.64 Total Current Liabilities       85.940      60.120 Long-Term Debt 122.000      119.62 Other Liabilities 21.880         22.58 Total Liabilities    229.820    202.320 Common Stock 200.380      160.32 Total Equity       200.38      160.32 Total Liabilities and Equity 430.200 362.640 INCOME STATEMENT 2021 Total Revenue (M)       488.10…
SME Balance Sheet 2021 2020 Assets (in millions) Cash 85.960 56.460 Receivables 89.560 80.670 Inventories 55.750 41.260 Other Current Assets 9.950 6.760 Total Current Assets    241.220    185.150 Net Property, Plant, and Equipment 78.970 68.930 Goodwill and Other Intangible Assets 103.110 104.360 Other Non-Current Assets 6.900 4.200 Total Assets    430.200    362.640 Total Liabilities and Shareholders' Equity Payables 83.240         57.48 Current Debt 2.700           2.64 Total Current Liabilities       85.940      60.120 Long-Term Debt 122.000      119.62 Other Liabilities 21.880         22.58 Total Liabilities    229.820    202.320 Common Stock 200.380      160.32 Total Equity       200.38      160.32 Total Liabilities and Equity 430.200 362.640 INCOME STATEMENT 2021 Total Revenue (M)       488.10…
SME Balance Sheet 2021 2020 Assets (in millions) Cash 85.960 56.460 Receivables 89.560 80.670 Inventories 55.750 41.260 Other Current Assets 9.950 6.760 Total Current Assets    241.220    185.150 Net Property, Plant, and Equipment 78.970 68.930 Goodwill and Other Intangible Assets 103.110 104.360 Other Non-Current Assets 6.900 4.200 Total Assets    430.200    362.640 Total Liabilities and Shareholders' Equity Payables 83.240         57.48 Current Debt 2.700           2.64 Total Current Liabilities       85.940      60.120 Long-Term Debt 122.000      119.62 Other Liabilities 21.880         22.58 Total Liabilities    229.820    202.320 Common Stock 200.380      160.32 Total Equity       200.38      160.32 Total Liabilities and Equity 430.200 362.640 INCOME STATEMENT 2021 Total Revenue (M)       488.10…