Task 1:
Download the official 2019 annual financial statements for United Health Group Inc. from the internet. Extract
the
following information for the firm’s fiscal years 2018 and 2019: (a) total revenues, (b) depreciation and
amortization,
(c) operating income after depreciation, (d) net earnings attributable to common shareholders, (e) common
shareholders’ equity (f) total equity (g) total non‐current liabilities, and (h) total assets.
Furthermore, calculate the following financial ratios for 2019: (1) net profit margin, (2) net operating margin (3)
return
on equity, (4) return on assets, (5) total asset turnover, (6) debt/equity ratio (7) debt ratio. Provide your
calculations in
an excel sheet (i.e. explicitly provide the formulas for your calculated ratios as well as the underlying figures).
Try to
present the information in an easily understandable format. Please label the table of your excel file “task 1”.
Task 2:
On Dec 31, 2019 Paula, Peter and Phil, started the company 3p.com. The business idea is to buy a newly
developed
easily useable heart monitor device, called iMon, and resell it to elderly private patients. In case of an
emergency the
device will rapidly connect to the nearest ambulance via a mobile phone.

• Each of the three founders paid in € 40.000 equity capital in cash.
• In addition, Paula brought in new a building which serves to hold the inventory (value of building: € 150.000;
  expected life time 50 years; value of land: € 50.000)
• Peter provided the company with a 2‐year old van currently valued at € 26.000 (expected remaining use: 3
  years;
  assumed value in 3 years: € 5.000).
• Phil attributed office furniture and appliances worth € 20.000 (expected use: 5 years; scrap value: € 0).
• Together, they acquire a 2‐year loan from a Bank (amount € 50,000, interest 5% per quarter).
• Paula buys 500 iMon units for € 150 each plus shipment costs of € 500 (payable next month).
  Insert another table into your excel file (labelled “task 2”) and record the above accounting events in a
  systematic
  manner (use a separate column for each record, just as in the lecture). Please provide also the Balance Sheet
  of
  3p.com for the year end 2019 (Income Statement and Cash Flow Statement NOT required).
  Task 3:
  During the first quarter of 2020 the following events take place at 3p.com:
• On Jan. 1, Phil rents a shop located at the heart of the city (monthly rent € 10,000; payable at first day each
  month)
  and Peter buys shop furniture for € 29,000 (transportation costs € 200 and installment costs € 800; expected
  use 5
  years; scrap value € 0).
• During the quarter, 3p.com orders 1,400 additional iMon units at € 150 (shipment € 500) to be paid in April.
• It sells 1,800 units at a price of € 350 during the quarter (cash payment).
• Gasoline for deliveries costs € 600 per month (paid in cash).
• As the business runs well, they hire a sales clerk (starting Feb 1; € 2000 monthly wage incl. everything; paid
  in cash)
  and buy an additional delivery van for € 33,000 cash on March, 1 (expected use: 5 years; value in 5 years: €
  3.000).
  Insert another table into your excel file (labelled “task 3”) and record all necessary accounting events (separate
  column for each record) and prepare the Balance Sheet for homefit.de as of March 31, 2019 along with their
  Income
  Statement and Cash Flow Statement for the first quarter of 2019. Don’t forget taxes (25%) and think about
  other
  necessities!
  Please hand in ONE Excel file containing your answers and calculations for task 1, 2 and 3. Please also upload
  the
  financial statement of United Health Grp., which you used to answer task