Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have built an excel spreadsheet for united healthcare (UNH) under excel tab asreported. I have the necessary income statement, balance sheet & other ratios

I have built an excel spreadsheet for united healthcare (UNH) under excel tab "asreported." I have the necessary income statement, balance sheet & other ratios (found at bottom of document). I am supposed to make a graph (which i've done already) and also find the historical analysis why the ratio increased or decreased from 2012-2013 . I have been provided an example paragraph of how to write it (which is below). I am having trouble trying to look over my excel sheet and reference what is necessary for PM, net income and sales.... I can further find reasons why certain acquisitions may of occurred.

-I'm having trouble finding necessary numbers/percentages to explain.

Example paragraph to be written:

From 2012 to 2013, the profit margin ratio (PM) increased from 2.5% to 2.7%.Net income increased by 16.3% while sales increased by 15%.The increase in sales of 16.3% was the result of the following things. First, the expansion of XYZ into Central America of its new defibrillator products (Annual report 2013), its acquisition of CBA Biomedical (Wall Street Journal 6/7/2013), and its creation of its new electric heart massage machine (Bloomberg 2/34/2013).Net Income grew by a faster rate than sales primarily because administrative expenses were only 12% of sales in 2013, whereas they were 13.5% in 2012 (vertical common size analysis).This improved efficiency in administrative expenses appears to have been a planned event as a result of outsourcing some of its admin function (annual report).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance Turning Money into Wealth

Authors: Arthur J. Keown

8th edition

134730364, 978-0134730363

More Books

Students also viewed these Finance questions