Financial Statement Analysis and Business Valuation of Tcs

Financial Statement Analysis and Business Valuation of TCS By: Prashant Chaudhary Table of Contents About TCS 3 Calculation of Beta 3 Cost of Capital 4 Concepts of Cost of Capital 4 Weighted Average Cost of Capital 6 Financial Ratios 8 Liquidity Ratios 8 Solvency Ratios 8 Profitability Ratios 9 Comparison with Competitors in the Industry 10 Free Cash Flow 11 Sales forecast 13 Reformulated balance sheet 14 Reformulated Income Statement 15 Appendix A: Balance Sheet 16 Appendix B: Profit amp; Loss account (in Rs. Crores) 17 Appendix C: Cash Flow (in Rs. Crores) 19 About TCS Tata Consultancy Services (TCS) is Software services consulting company headquartered in Mumbai, India. TCS is the largest†¦show more content†¦This is the rate of return that a firm would receive if it invested in a different vehicle with similar risk. Cost of debt is the effective rate that a company pays on its current debt. This can be measured in either before- or after-tax returns. A company will use various bonds, loans and other forms of debt, so this measure is useful for giving an idea as to the overall rate being paid by the company to use debt financing. The measure can also give investors an idea as to the riskiness of the company compared to others, because riskier companies generally have a higher cost of debt. Cost of debt = Kd = Interest/Total borrowing | | Year | 2008 | 2009 | 2010 | Interest expense | 3.4400 | 7.4400 | 9.5400 | Total borrowing | 18.2500 | 40.3700 | 35.7400 | Cost of debt (%) | 18.8493 | 18.4295 | 26.6928 | Tax calculation | | Year | 2008 | 2009 | 2010 | PBT | 5,003.86 | 5,139.68 | 6,370.38 | TAX paid | 457.58 | 340.37 | 737.89 | TAX Proportion | 0.0914 | 0.0662 | 0.1158 | Cost of Debt After Tax | 0.1268 | 0.1231 | 0.1830 | Cost of Debt After Tax (%) | 12.68% | 12.31% | 18.30% | A firms cost of equity represents the compensation that the market demands in exchange for owning the asset and bearing the risk of ownership. It is basically the return that stockholders require for a company. Cost of equity can be determined using the Capital Asset Pricing Model (CAPM). Cost of Equity =Show MoreRelatedThe Cash Flow Of The Free Cash Flows ( Fcf )1609 Words   |  7 PagesFirm Valuation As shown in Exhibit 4, in order to value a company we first started by calculating the free cash flows (FCF) year by year. In order to do so, we decided to use the forecasted revenue numbers from Capital IQ and calculate all the other metrics by using the trends we saw in last three years (Exhibit 3). The company can allocate free cash flow in several ways, including but not limited to: repurchasing stock, reinvesting for growth and paying out dividends. After calculating the freeRead MoreHope Case Essay1146 Words   |  5 PagesProblem statement: CHN Incorporated is evaluating the purchase of Hope Enterprises. The company could enhance its position in the mid-market gaming casino hotel business with the acquisition of Hope Enterprises. Hope Enterprises is considered a prime acquisition because of its strategic location, customer segment, booming market .The overall gaming casino business is predicted to boom in the coming year, with revenues increasing by 15%. However, CHN has to evaluate the synergies with Hope enterprisesRead MoreFinancial Analysis of Infosys Technologies Ltd.7418 Words   |  30 PagesTable of Contents IT Industry at a glance – Sector Analysis 4 Rise of Services as a whole: 4 IT Services: A major part of the services sector 5 Infosys Technologies Ltd – Financial Ratio Analysis 7 Liquidity Ratio: 7 Quick Ratio: 7 Current Ratio: 8 Leverage Ratio: 9 Debt-Equity Ratio: 9 Interest Coverage Ratio: 10 Profitability Ratio: 11 Return on Equity: ROE 12 Return on Capital Employed: ROCE 12 Valuation Ratio: 13 Dividend Yield: 14 Operating Income Growth (%): 15 Summary: 17 The Competitors 18Read MoreThe And Long Range Financial Problems Essay1730 Words   |  7 PagesLong-Range Financial Problems From your analysis of research materials, examine the company and provide a report on the short and long range financial problems that are evident from the review. If you find no short or long range financial problems, provide the evidence to justify this conclusion. Short range financial problems – or short-term debt is all debt due within a 12-month period, or within the fiscal year. If Amazon has more debt than cash or cash equivalents, they are in meager financial healthRead MoreJET BLUE ; PREPARING FOR FINANCING2874 Words   |  12 PagesPAU/LBS/2011/10/024 FINANCE - 2 EXAM ANALYSIS OF JET BLUE CASE: PREPARING FOR FINANCING SYNOPSIS OF THE CASE JetBlue Airways Corporation was formed in August 1998 as a low-fare, low-cost but high service passenger airline serving select United States market. JetBlues operations strategy was designed to achieve a low cost, whilst offering customers a pleasing and differentiated flying experience. JetBlue has had a successful business model and strong financial results during that period, and performedRead MoreBusiness Plan Proposal - Acquisition of 12 Containerships7474 Words   |  30 PagesCass Business School Academic Year 2005-2006 MSc Shipping, Trade Finance MSc Energy, Trade Finance Academic Year 2005 -2006 Business Plan Proposal: Acquisition of 12 Containership vessels to participate in the â€Å"Motorways of the Seas† European Union Programme. Group 17 International Commodity Trade Coursework -- Business Plan Cass Business School Academic Year 2005-2006 Table Of Contents EXECUTIVE SUMMARY.............................................................Read MoreCountry Road Limited6314 Words   |  26 Pages| 2010 | | | | | Country Road Limited | Business analysis and valuation | * Table of Contents Executive summary 3 1. The Retail Industry amp; its Prospects 4 1.1 Current amp; Future Overview 4 2 Corporate strategy 4 3 Earnings Manipulation Assessment amp; Findings 5 4 The Facts: Financial Ratio Analysis 6 5 Profitability and Operating management of CR 6 5.1 Dupont System Analysis 6 5.2 CR’s operating management 8 6 Investment management 8 6.1 WorkingRead MoreA Brief Note On Weighted Average Cost Of Capital2014 Words   |  9 Pagesthe WACC works and which methods to use for this particular company, AstraZeneca, with relevant data reference. What is WACC ? WACC = E/V x Re + D/V x Rd x (1-Tc) â€Å"A calculation of a company’s cost of capital in which every source of capital is weighted in proportion to how much capital it contributes to the company†. http://financial-dictionary.thefreedictionary.com/WACC WACC is the acronym of â€Å"Weighted Average Cost of Capital† which calculates the cost of a company capital from all sourcesRead MoreFinancial Analysis on Tata Consultancy Services11191 Words   |  45 PagesFINANCIAL ANALYSIS ON TATA CONSULTANCY SERVICES SUBMITTED TO PROF . D.V.RAMANA Debasis Sarangi(77) Dhanya K(78) Dinesh Kumar Mandal(80 TABLE OF CONTENTS 1. Acknowledgments†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.3 2. Executive Summary†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦...4 3. Environment Analysis†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦...5 4. IT Industry Overview†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦6 5. Company Analysis†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦10 6. Ratio Analysis†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦...15 Liquidity Ratios†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.15 EfficiencyRead MoreFlash Memory Inc. Essay4351 Words   |  18 PagesTO: FROM: DATE: SUBJECT: Mr. Hathaway Browne, CFO of Flash Memory Inc. MP.JAW Consultants October 11, 2010 Analysis of the Investment Opportunity and Financing Options ! As your financial consultants, we have conducted a comprehensive analysis of Flash Memory Inc. (FMI)’s current business situation, its new potential investment opportunity, and financing options. Our recommendations are as follows: 1. Pursue the suggested new product line. 2. Seek additional funding through equity financing