Question Details

(Solved) Currency in Millions of Euros 31-Dec 31-Dec 2015 2016 EUR EUR As of: Assets Cash And Equivalents 2,302.00 3,382.00 Short-Term Investments 217 169...


Suppose Unilever PLC and Kraft-Heinz KHC are going to merge. Create a "Combined Proforma Income statement" and "Combined Proforma Balance Sheet" for 2017 and 2018 from the excel sheets provided below. Include all the values from the income statement and balance sheet. The income statement and balance sheet for unilever are in euros and must be converted into $ first. (Please add the details and excel formulas). I have included the format I require as xcz.xlsx.

Currency
in
Millions
of Euros 31-Dec 31-Dec 2015 2016 EUR EUR As of: Assets
Cash And Equivalents 2,302.00 3,382.00 Short-Term
Investments 217 169 Trading Asset
Securities 124 181 2,643.00 3,732.00 Accounts Receivable 2,917.00 3,329.00 Notes Receivable 269 208 Other Receivables 1,556.00 1,586.00 4,742.00 5,123.00 Inventory 4,335.00 4,278.00 Prepaid Expenses 561 504 Other Current Assets 405 247 12,686.00 13,884.00 Gross Property Plant
And Equipment 19,917.00 21,207.00 Accumulated
Depreciation -8,859.00 -9,534.00 NET PROPERTY PLANT
11,058.00
AND EQUIPMENT 11,673.00 TOTAL CASH AND
SHORT TERM
INVESTMENTS TOTAL RECEIVABLES TOTAL CURRENT
ASSETS Goodwill
16,213.00
Long-Term
592
Investments
Accounts Receivable,
413
Long Term 17,624.00
491
421 Loans Receivable,
Long Term 34 190 Deferred Tax Assets,
Long Term 1,185.00 1,354.00 8,846.00 9,809.00 1,271.00 983 52,298.00 56,429.00 Accounts Payable 8,296.00 8,591.00 Accrued Expenses
Short-Term
Borrowings
Current Portion Of
Long-Term
Debt/Capital Lease
Current Portion Of
Capital Lease
Obligations 4,175.00 4,123.00 174 184 4,615.00 5,266.00 37 9 Other Intangibles
Other Long-Term
Assets
TOTAL ASSETS LIABILITIES & EQUITY Current Income Taxes
1,127.00
Payable 844 Other Current
Liabilities, Total 1,632.00 1,548.00 20,019.00 20,556.00 Long-Term Debt 9,696.00 11,011.00 Capital Leases 158 134 Minority Interest 643 626 TOTAL CURRENT
LIABILITIES Pension & Other Post3,254.00
Retirement Benefits 3,867.00 Deferred Tax Liability
Non-Current 1,744.00 2,061.00 Other Non-Current
Liabilities 1,345.00 1,820.00 36,216.00 39,449.00 Common Stock
Additional Paid In
Capital
Retained Earnings 484 484 152 134 22,619.00 23,179.00 Treasury Stock -4,119.00 -4,164.00 Comprehensive
Income And Other -3,697.00 -3,279.00 TOTAL COMMON
EQUITY 15,439.00 16,354.00 TOTAL EQUITY 16,082.00 16,980.00 52,298.00 56,429.00 TOTAL LIABILITIES TOTAL LIABILITIES
AND EQUITY Currency
in
Millions
of US
Dollars 31-Dec 31-Dec 2015 2016 As of:
Reclassified Assets
Cash And Equivalents 4,837.00
TOTAL CASH AND
SHORT TERM
INVESTMENTS 4,204.00 4,837.00 4,204.00 Accounts Receivable 1,454.00 898 Other Receivables -- -- 1,454.00 898 Inventory 2,618.00 2,684.00 Prepaid Expenses -- -- Other Current Assets 871 967 9,780.00 8,753.00 Gross Property Plant
And Equipment 7,430.00 8,518.00 Accumulated
Depreciation -906 -1,830.00 TOTAL RECEIVABLES TOTAL CURRENT
ASSETS NET PROPERTY PLANT
6,524.00
AND EQUIPMENT
Goodwill
Long-Term
Investments
Other Intangibles
Other Long-Term
Assets
TOTAL ASSETS 6,688.00 43,051.00 44,125.00 -- -- 62,120.00 59,297.00 1,498.00 1,617.00 122,973.00 120,480.00 Accounts Payable 2,844.00 3,996.00 Accrued Expenses
Short-Term
Borrowings
Current Portion Of
Long-Term
Debt/Capital Lease
Current Income Taxes
Payable 1,585.00 1,321.00 4 645 79 2,046.00 417 255 Other Current
Liabilities, Total 2,003.00 1,238.00 TOTAL CURRENT
LIABILITIES 6,932.00 9,501.00 Long-Term Debt 25,151.00 29,713.00 Minority Interest 231 216 LIABILITIES & EQUITY Pension & Other Post2,405.00
Retirement Benefits 2,038.00 Deferred Tax Liability
Non-Current 21,497.00 20,848.00 Other Non-Current
Liabilities 752 806 TOTAL LIABILITIES 56,737.00 62,906.00 TOTAL PREFERRED
EQUITY 8,320.00 -- Common Stock
Additional Paid In
Capital
Retained Earnings 12 12 58,375.00 58,593.00 -- 588 Treasury Stock -31 -207 Comprehensive
Income And Other -671 -1,628.00 TOTAL COMMON
EQUITY 57,685.00 57,358.00 TOTAL EQUITY 66,236.00 57,574.00 122,973.00 120,480.00 TOTAL LIABILITIES
AND EQUITY

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 05, 2019

PRICE: $15

Solution~000200190901.zip (25.37 KB)

Buy this answer for only: $18

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 05, 2019

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now