Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started