Question

In: Accounting

Ratio Analysis Review and compare the following ratios for both companies: Choose two publicly traded companies...

Ratio Analysis

Review and compare the following ratios for both companies: Choose two publicly traded companies in the same industry.

  • Working capital
  • Current ratio
  • Debt ratio
  • Net Profit Margin

Review the most recent ear

Review the Earning's call for both companies and report your findings to include, but not limited to, results and projections.

Solutions

Expert Solution

Ratio is one of the popular technique used by the financial analysts to do financial analysis for decision making purposes.

1.Working Capital :

Working Capital usually refers to the net current assets (Current Assets- Current liabilities) . Working capital is essential for a business concern to meet its day to day financial requirements. An effective working capital must be maintained by the management so that it keeps a balance between liquidity and implicit costs(lose of interest)

Gross Working Capital = Current Assets

Net Working Capital =Current Assets - Current Liabilities

2. Current Ratio :

The working capital ratio or current ratio indicates whether a company has enough short-term assets to cover its short-term debt. A good current ratio is considered anything between 1.2 and 2.0. These are usually maintained by conservative firms that are in afraid of chance of liquidity risk.

Current Ratio= Total Current assets/ Total Current liabilities

3. Debt Ratio :

The debt ratio  measures the extent of a company's leverage. The debt ratio is defined as the ratio of total debt to total assets. It can be interpreted as the proportion of a company's assets that are financed by debt . Even though financing through debt provides tax benefits(tax deductibility) , a high proportion of debt may lead to default risk and affect the credit worthiness of the firm.

Debt Ratio= Total Debt/Total Asset

4.Net Profit Margin :

Net profit margin is the percentage of revenue left after all expenses have been deducted from sales. The measurement reveals the amount of profit that a business can extract from its total sales. The net sales part of the equation is gross sales minus all sales deductions, such as sales allowances.

Net Profit Margin= Net Profit/ Net Sales

where,

Net sales= Gross Sales- Sales returns

Let's Compare HDFC Bank and ICICI Bank :

    INCOME DATA

   HDFC    ICICI

Interest income Rs m 852,878 621,624 137.2%
Other income Rs m 160,566 568,068 28.3%
Interest expense Rs m 423,815 342,621 123.7%
Net interest income Rs m 429,064 279,003 153.8%
Operating expense Rs m 239,272 557,556 42.9%
Gross profit Rs m 189,791 -278,553 -68.1%
Gross profit margin % 22.3 -44.8 -49.7%
Provisions/contingencies Rs m 65,718 191,949 34.2%
Profit before tax Rs m 283,612 97,565 290.7%
Extraordinary Inc (Exp) Rs m 0 0 -
Minority Interest Rs m 513 -13,874 -3.7%
Prior Period Items Rs m 5 0 -
Tax Rs m 99,031 6,570 1,507.3%
Profit after tax Rs m 185,100 77,122 240.0%
Net profit margin % 21.7 12.4 174.9%

  

BALANCE SHEET

HDFC ICICI

Advances Rs m 7,000,338 5,668,542 123.5%
Deposits Rs m 7,883,751 5,857,961 134.6%
Credit/Deposit ratio x 88.8 96.8 91.8%
Yield on advances % 9.7 7.6 126.7%
Cost of deposits % 4.2 4.1 102.6%
Net Interest Margin % 4.0 2.7 148.9%
Net fixed assets Rs m 38,106 94,650 40.3%
Share capital Rs m 5,190 12,858 40.4%
Free reserves Rs m 832,486 591,640 140.7%
Net worth Rs m 1,095,991 1,106,241 99.1%
Borrowings Rs m 1,564,421 2,294,018 68.2%
Investments Rs m 2,384,609 3,722,077 64.1%
Total assets Rs m 11,031,862 11,242,810 98.1%
Debt/equity ratio x 8.6 7.4 117.0%
Return on assets % 1.7 0.7 244.6%
Return on equity % 16.9 7.0 242.3%
Capital adequacy ratio % 14.8 18.4 80.3%
Net NPAs % 0.4 4.8 8.4%

Earnings Per Share = Income Available to common shareholders/ No. of Shareholders Outstanding

HDFC ICICI

Earnings per share (Unadj.) Rs 71.3 13.2 538.7%

Earnings Call

An earnings call is a public announcement, usually via conference call, of a company's profits, usually on a quarterly basis.


Related Solutions

Pick two publicly traded companies in the same industry and perform ratio analysis on each of...
Pick two publicly traded companies in the same industry and perform ratio analysis on each of the companies for two years. Which company you would purchase stock as an investment for yourself and why using the financial ratios helped in the analysis. Currently reviewing Apple and IBM, struggling with some of the ratio analysis.
Research publicly traded companies and select two companies in different sectors. Compare the capital structure for...
Research publicly traded companies and select two companies in different sectors. Compare the capital structure for each and explain your conclusions on the similarities and differences. What support can you provide for why each company adheres to their chosen structuring mechanisms?
Write an analysis in which you address the following: • Select two publicly-traded companies within the...
Write an analysis in which you address the following: • Select two publicly-traded companies within the same industry and present the DuPont analysis for each of these companies. Explain how the debt has served to influence the ROE DuPont performance results for each, and then describe how volatility plays a role in the debt choices in the context of this DuPont analysis. • Consider each of the following capital structure theories: the tradeoff theory, the signaling theory, the debt financing...
1. Select two companies from the same industry that are BOTH publicly traded. They need to...
1. Select two companies from the same industry that are BOTH publicly traded. They need to both be traded on the New York Stock Exchange or the NASDAC stock exchange. (DO NOT SELECT CLEARWATER PAPER I USE IT IN MY EXAMPLES) 2.  Upload a screenshot of the Edgar Database files at SEC.GOV that includes the 10-K files that you need to download for EACH Company. (see attached example) 3. Upload a recent article or press release for each company discussing company...
Ratio Analysis: Compare the two companies based on their ratios. Use the last column and describe how each company is doing in relation to the ratios
RATIOSCommunications/ElectronicsAT&TSprintANALYSISProfitability Ratios (%)Gross Margin59.0254.2358.08EBITDA Margin---Operating Margin16.2313.84-2.89Pre-Tax Margin13.799.59-10.1Effective Tax Rate1818.91-1.8Financial StrengthQuick Ratio10.520.26Current Ratio1.020.810.67LT Debt to Equity145.4687.2196.43Total Debt to Equity160.4496.06196.43Interest Coverage---Valuation RatiosPrice/Earnings Ratio65.9511.21203.67Price to Sales P/S1.911.181.09Price to Book P/B3.41.141.38Free Cash Flow per Share59.3318.63-Management Effectiveness (%)Return On Assets5.040.94-3.11Return On Investment6.496.97-3.59Return On Equity8.213.039.92EfficiencyReceivable Turnover13.888.448.86Inventory Turnover27.28-13.37Total Asset Turnover0.490.320.37Free Cash Flow/Net Income13.88-8.861- Ratio Analysis: Compare the two companies based on their ratios. Use the last column and describe how each company is doing in relation to the ratios. Explain the significance of how the company ratios...
discuss the advantage as well as limits of ratio analysis for publicly traded corporations
discuss the advantage as well as limits of ratio analysis for publicly traded corporations
Choose a publicly traded company and analyze the financial statements based on the various ratios discussed...
Choose a publicly traded company and analyze the financial statements based on the various ratios discussed in concept 5 (leverage, debt to equity, liquidity ratios, etc.). Provide an overview of how financially healthy the company is and predictions for the future of the company.
The average trailing PE ratio of publicly traded auto parts companies in the US is 20.0....
The average trailing PE ratio of publicly traded auto parts companies in the US is 20.0. You own a regional auto parts firm in the Northwest that is privately held and has no debt. In the last year, the firm earned $1.5 million. You are looking to sell your firm to a private equity firm and are arguing the valuation of the firm should be 20 * $1.5 million = $30 million dollars. Why might this be a biased estimate...
Discuss the advantage as well as limits of ratio analysis for publicly traded corporations. Please answer...
Discuss the advantage as well as limits of ratio analysis for publicly traded corporations. Please answer in 5-7 sentences.
Directions: Choose a publicly traded company and perform an expanded analysis on the financial statements. Use...
Directions: Choose a publicly traded company and perform an expanded analysis on the financial statements. Use the most current 10K statements available on SEC or annual statements in Yahoo Finance. Complete the following for your chosen firm in an Excel spreadsheet: The Company is TJ MAXX below is a link to the sec.com 10K statement. https://www.sec.gov/Archives/edgar/data/109198/000119312517099642/d269088d10k.htm https://www.sec.gov https://finance.yahoo.com/quote/TJX/financials?p=TJX If the first link does not work there is a second one and search for the company TJ MAXX Along with a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT