Conduct Quantitative Analysis of the Companies (financial)
Company 1: Aetna
Company 2: Davita
1. Present a comprehensive financial statement analysis of the target acquisitions. Prepare the common size statements and all the ratios and amounts for the measures given below for the most recent year for both of your companies and present in a clear tabular form. Then discuss each category given below. ◦Prepare common-size financial statements for both target acquisitions:
◦Complete both a horizontal and vertical analysis for each target acquisition
◦Compare the common-size financial statements between the two companies using cross-sectional analysis
◦Calculate and interpret relevant profitability, solvency, liquidity, leverage, market value ratios for each company that will be useful in comparing the target acquisition
2. For each company, graphically trend the net income and cash flow from operations over the last five years. Based on a comparison of the income statement to the statement of cash flows, what accounts explain the greatest differences between net income (loss) and cash flow from operations. Comment on the quality of the earnings numbers.
3. Calculate and interpret the net present value (NPV) of the companies’ annual free cash flow (FCF) for a 5-year period (nper) taking into account a constant growth rate (which will need to be calculated), and a discount rate that is equal to your companies weighted average cost of capital (WACC), which is 7%. http://www.investopedia.com/articles/fundamental-analysis/11/present-value-free-cash-flow.asp (Links to an external site.)Links to an external site.
Company 2: DaVita
4. Any notable similarities and differences in financial reporting practices of the two acquisition targets that could potentially impact your analysis should be reported along with your team mitigation strategy. For example, perhaps the firms are using the same or different methods of accounting for property, plant, and equipment (PP&E), inventory, intangibles, etc.