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.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more