You are the accountant for Affiliated Companies, Inc. As shown below, Affiliated acquired two other companies on December 1, 20X0. The CFO of affiliated just presented you with a three-page list of account balances for the three companies for 201, sorted from the highest dollar amount to the lowest. She has asked you to produce the consolidated financial statements for 20X1. She did the consolidation work last year, the results of which are shown on Page 2 . She also asked you to use a pivot table to organize and make sense of the data on page 3 and then perform the consolidations process. Your consolidations worksheet with have two Subsidiary columns - one for Subsidiary A, and the other for Subsidiary B. Remember that cost of goods sold is equal to beginning inventory, plus purchases, less ending inventory. That will be important for you to get your financial statements to balance. \begin{tabular}{|l|l|} \hline 47 & \\ \hline 48 & Cash \\ \hline 49 & Accounts receivable \\ \hline 50 & Inventory \\ \hline 51 & Equipment \\ \hline 52 & Accumulated depreciatic \\ \hline 53 & Land \\ \hline 54 & Patent \\ \hline 55 & Goodwill \\ \hline 56 & Total \\ \hline \end{tabular} Accounts payable Fair value per share Shares acquired Useful life of equipment Useful life of patent Note payable Life \begin{tabular}{|r|r|r|} \hline 880 \\ 98,700 \\ 10 \\ 9 \\ 8 \\ \hline 5.30% \\ \hline \end{tabular} Rate You are the accountant for Affiliated Companies, Inc. As shown below, Affiliated acquired two other companies on December 1, 20X0. The CFO of affiliated just presented you with a three-page list of account balances for the three companies for 201, sorted from the highest dollar amount to the lowest. She has asked you to produce the consolidated financial statements for 20X1. She did the consolidation work last year, the results of which are shown on Page 2 . She also asked you to use a pivot table to organize and make sense of the data on page 3 and then perform the consolidations process. Your consolidations worksheet with have two Subsidiary columns - one for Subsidiary A, and the other for Subsidiary B. Remember that cost of goods sold is equal to beginning inventory, plus purchases, less ending inventory. That will be important for you to get your financial statements to balance. \begin{tabular}{|l|l|} \hline 47 & \\ \hline 48 & Cash \\ \hline 49 & Accounts receivable \\ \hline 50 & Inventory \\ \hline 51 & Equipment \\ \hline 52 & Accumulated depreciatic \\ \hline 53 & Land \\ \hline 54 & Patent \\ \hline 55 & Goodwill \\ \hline 56 & Total \\ \hline \end{tabular} Accounts payable Fair value per share Shares acquired Useful life of equipment Useful life of patent Note payable Life \begin{tabular}{|r|r|r|} \hline 880 \\ 98,700 \\ 10 \\ 9 \\ 8 \\ \hline 5.30% \\ \hline \end{tabular} Rate
