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 (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
Get step-by-step solutions from verified subject matter experts
