Question: can you answer this in an excel sheet format Please Consolidated Balance Sheet Working Paper, Bargain Purchase begin{tabular}{|l|r|r|} hline multicolumn{1}{|c|}{ Balance Sheets (in millions) }

 can you answer this in an excel sheet format Please Consolidated

Balance Sheet Working Paper, Bargain Purchase \begin{tabular}{|l|r|r|} \hline \multicolumn{1}{|c|}{ Balance Sheets (inmillions) } & Paxon & Saxon \\ \hline Assets & & \\

can you answer this in an excel sheet format Please

Consolidated Balance Sheet Working Paper, Bargain Purchase \begin{tabular}{|l|r|r|} \hline \multicolumn{1}{|c|}{ Balance Sheets (in millions) } & Paxon & Saxon \\ \hline Assets & & \\ \hline Cash and receivables & $2,860 & $720 \\ \hline Inventory & 1,700 & 900 \\ \hline Equity method investments & -- & 300 \\ \hline Land & 650 & 175 \\ \hline Buildings and equipment, net & 2,400 & 600 \\ \hline Total assets & $7,610 & $2,695 \\ \hline Liabilities and Shareholders' Equity & & \\ \hline Current liabilities & 1,500 & 1,000 \\ \hline Long-term debt & 2,000 & 845 \\ \hline Common stock, par value & 500 & 50 \\ \hline Additional paid-in capital & 1,200 & 200 \\ \hline Retained earnings & 2,410 & 600 \\ \hline Total liabilities and shareholders' equity & $7,610 & $2,695 \\ \hline \end{tabular} Several of Saxon's assets had fair values that were different from their book values. Estimates of the fair values of these items follow: \begin{tabular}{|l|r|} \hline \multicolumn{1}{|c|}{ (in millions) } & Estimated Fair Value \\ \hline Inventory & $500 \\ \hline Equity method investments & 400 \\ \hline Land & 450 \\ \hline Buildings and equipment, net & 1,100 \\ \hline \end{tabular} (b) Prepare a working paper to consolidate the balance sheets of Paxon and Saxon at January 1, 2022. Remember to use negative signs with your credit balance answers in the Dr(Cr) columns. (c) Present the consolidated balance sheet, in good form, at the date of acquisition

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!