One additional requirement. The purchase price could change, so you must create the spreadsheet so that the
Question:
One additional requirement. The purchase price could change, so you must create the spreadsheet so that the purchase price can be easily changed, adjusting statement of financial position. The most recent statement of financial position for
RedCo appears on the next page.
REDCO
Statement of Financial Position
As of a recent date
dollars in millions
Cash $ 285
Accounts receivable, net 105
Inventory (FIFO)
Ingredients 21
Finished goods 27
Property, Plant & Equipment
Land 2
Building 52
Right of use assets 24
Machinery & Equipment 209
Less, accumulated depreciation (50)
Goodwill 536
Intangible assets, net 1,853
Other noncurrent assets 13
Total Assets $3,077
Current portion of long-term debt $ 12
Accounts payable 69
Accrued liabilities 8
Other current liabilities 2
Long-term debt 975
Deferred income tax liabilities 256
Common stock 1
Additional paid-in capital 649
Retained earnings 1,105
Total Liabilities and Equity $3,077