Question

In: Finance

a. What kind of ratios to find from the consolidated statement of operations and consolidated balance...

a. What kind of ratios to find from the consolidated statement of operations and consolidated balance sheet of a particular industry for: understanding the financial performance, as well as near-term future for a company. b. Using consolidated statement of operations and consolidated balance sheet as well as that of competitors what ratio tools do we need to analyse their performance. Moreovers what ratio and other tools do we use for making comparison except common size and comparitive statement.

Solutions

Expert Solution

For near term future analysis of a company, the ratios used are

a) Current Ratio = Current Assets/Current Liabilities
The current ratio helps to analyze whether the company has sufficient current assets to pay of the liabilities. Current assets and liabilities have a maturity of less than a year. Higher the ratio, the company will be able to fulfill it's future short term liabilities

b) Net Profit Margin = Net Profit / Total Sales
This ratio helps to analyze the amount of net profit a company makes for every dollar of sales done.

c) Return of Assets = Net Income / Total Assets
This ratio helps in analyzing how much percentage of profit does a company make while utilizing its resources

d) Asset Turnover = Sales / Total Assets
This ratio helps in analyzing how efficiently the company uses its assets in the form of sales

e) Cash Flow from Operations to Debt Ratio = Cash Flow from Operations / Total Debt
This ratio determines the coverage ratio for the amount of debt the company has. If CFO is higher than debt then the company will be able to pay off its liabilities.

f) Return on Equity = Net Income / Shareholder's Equity
This ratio analyzes the amount of profit or returns the company makes on the shareholder's capital. If the return on equity is higher than the cost of capital then it will be beneficial for the company as well as shareholders

Ratios used for competitor Analysis are

a) Liquidity Ratio
i) Current Ratio = Current Assets/Current Liabilities

The current ratio helps to analyze whether the company has sufficient current assets to pay of the liabilities. Current assets and liabilities have a maturity of less than a year. Higher the ratio, the company will be able to fulfill it's future short term liabilities

ii) Quick Ratio = (Current Assets - Inventories) / Current Liabilities
It helps to analyze whether the company has enough of its most liquid assets (cash and marketable securities, accounts receivables) in order to cover its short term obligations

iii) Cash Conversion Cycle = Days Sales Outstanding + Days Inventory Outstandanding - Days Payables Outstanding
Lower the cash conversion cycle, the better it is for the company. So that it won't have to invest a lot of cash for its working capital management.

b) Profitability Ratio
i) Operating Income Margin = Operating Income / Total Sales

It helps to analyze how much profit a company makes from its main, ongoing operations. The higher the margin, the better it is.

ii) Net Profit Margin = Net Profit / Total Sales
This ratio helps to analyze the amount of net profit a company makes for every dollar of sales done.

c) Financial Leverage
i) Debt Ratio = Total Debt / Total Assets
Debt ratio help to analyze how much of the assets is funded by debt. Lower the debt ratio, lower is the chances of the company defaulting

ii) Debt To Equity Ratio = Total Debt/Total Equity
This helps in analyzing the capital structure of the company. Higher the ratio, higher the chances of default

iii) Interest Coverage Ratio = EBIT/Total Interest Expense
It is used to determine how easily a company can pay off its interest expense in a given year. Higher the ratio, the better it is


Related Solutions

prepare a common size income statement from the following income statement: CONSOLIDATED STATEMENTS OF OPERATIONS -...
prepare a common size income statement from the following income statement: CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) 12 Months Ended shares in Millions, $ in Millions Feb. 01, 2020 Feb. 02, 2019 Feb. 03, 2018 Total net sales $10,716 $11,664 $12,554 Credit income and other 451 355 319 Total revenues 11,167 12,019 12,873 Costs and expenses/(income): Cost of goods sold (exclusive of depreciation and amortization shown separately below) 7,013 7,870 8,208 Selling, general and administrative (SG&A) 3,585 3,596 3,845...
IAS 7 - Consolidated Cash Flow Statement The following are the consolidated financial statement from the...
IAS 7 - Consolidated Cash Flow Statement The following are the consolidated financial statement from the records of MT Bhd (MTB) for 2011 incorporating its subsidiary JK Bhd (JKB). Consolidated Statement of Comprehensive Income for the year ended 31 December 2011 (RM)’000 (RM)’000 Sales 6,220 Cost of Goods Sold (2,700) Gross Profit 3,520 Less Expenses: Depreciation 180 Insurance Expenses 24 Other Expenses 1,076 (1,280) Operating Income 2,240 Gain on sale of Plant 20 Total Comprehensive Income 2,260 Profit after tax...
A consolidated income statement and selected comparative consolidated balance sheet data for Palano Company and subsidiary...
A consolidated income statement and selected comparative consolidated balance sheet data for Palano Company and subsidiary follow: Palano Company and Subsidiary Consolidated Income Statement for the Year Ended December 31, 2015 Sales $701,000 Cost of sales 263,000 Gross profit 438,000 Operating expenses:    Depreciation expense $76,000    Selling expenses 122,000    Administrative expenses 85,000 283,000 Consolidated net income 155,000 Less noncontrolling interest in consolidated net income 38,750 Controlling interest in consolidated net income $116,250 December 31 2014 2015 Accounts receivable $229,000 $318,000 Inventory...
Comprehensive Problem 4 The following are the consolidated statement of earnings and the balance sheet of...
Comprehensive Problem 4 The following are the consolidated statement of earnings and the balance sheet of Home Depot, Inc and Subsidiaries. THE HOME DEPOT, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF EARNINGS Fiscal Year Ended(1) amounts in millions, except per share data January 31,2016 February 1, 2015 February 2, 2014 NET SALES $ 66,192 $ 71,299 $ 77,359 Cost of Sales 43,752 47,292 51,341 GROSS PROFIT 22,440 24,007 26,018 Operating Expenses: Selling, General and Administrative 15,886 17,828 17,051 Depreciation and Amortization...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Information from the balance sheet, income statement, and...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Information from the balance sheet, income statement, and statement of cash flows for Nike follows. Refer to these financial statements to answer the requirements. NIKE, INC. Consolidated Statements of Income Year Ended December 31 (In millions) 2019 2018 Revenues $39,117 $36,397 Cost of sales 21,643 20,441 Gross profit 17,474 15,956 Demand creation expense 3,753 3,577 Operating overhead expense 8,949 7,934 Total selling and administrative expense 12,702 11,511 Interest expense (income), net 49...
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
Compute and Interpret Coverage, Liquidity and Solvency Ratios Selected balance sheet and income statement information from...
Compute and Interpret Coverage, Liquidity and Solvency Ratios Selected balance sheet and income statement information from CVS Health Corp. for 2014 through 2016 follows ($ millions). Total Current Assets Total Current Liabilities EBIT (Operating income) Interest Expense, Gross Total Liabilities Equity 2016 $31,042 $26,250 $10,338 $1,058 $57,628 $36,834 2015 29,158 23,169 9,454 838 55,234 37,203 2014 25,983 19,027 8,799 600 36,224 37,963 a. Compute times interest earned ratio for each year and discuss any trends for each. Round answers to...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information from...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information from Verizon Communications follows. ($ millions) 2005 2004 Current assets $ 16,448 $ 19,479 Current liabilities 25,063 23,129 Total debt 39,010 39,267 Total liabilities 101,696 103,345 Equity 66,434 62,613 Earnings before interest and taxes 12,787 12,496 Interest expense 2,180 2,384 Net cash flow from operating activities $ 22,012 $ 21,820 (a) Compute the current ratio for each year and discuss any trend in liquidity. (Round...
Compute and Interpret Coverage, Liquidity and Solvency Ratios Selected balance sheet and income statement information from...
Compute and Interpret Coverage, Liquidity and Solvency Ratios Selected balance sheet and income statement information from CVS Health Corp. for 2014 through 2016 follows ($ millions). Total Current Assets Total Current Liabilities EBIT (Operating income) Interest Expense, Gross Total Liabilities Equity 2016 $33,930 $26,250 $10,504 $1,058 $57,628 $39,722 2015 32,046 23,169 9,620 838 55,234 40,091 2014 28,871 19,027 8,965 600 36,224 40,851 a. Compute times interest earned ratio for each year and discuss any trends for each. Round answers to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT