Conduct quantitative analysis | Accounting homework help

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.

   

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.