You are the Consolidation Accountant for Abex Corporation. Assume that 2021 is the first year that Abex is preparing consolidated financial statements with its three
You are the Consolidation Accountant for Abex Corporation. Assume that 2021 is the first year that Abex is preparing consolidated financial statements with its three subsidiaries. (Thats a very silly assumption, dont think about it too deeply. It allows us to not be concerned with prior consolidation adjustments.) Do read the instructions completely and carefully before starting.
Critical assumptions about the financial statements:
- You are being presented with a statement of financial position and a statement of income for each company, separately. These are not trial balances, though you could prepare one if you wish (I dont recommend that). Download the spreadsheet, it has all of the data.
- Recall that consolidating financial statements means that you will be recording adjustments to the statements, not offsetting journal entries. If you wish to reformat the statements to consolidate, you may. But the end result must be a consolidated statement of financial position and a consolidated statement of income, presented as they would be shown in a companys annual report.
Related to the item above, I likely mislead you (I should probably just say I did mislead you) on the adjustments comment in consolidating financial statements. Make sure you understand this. Any adjustments made to the statement of financial position necessarily are in the form of offsetting debits and credits. Otherwise, the statement of financial position wouldnt balance, right? However, adjustments to the statement of income may be different. There may be some that affect only one account in the statement of income. Profit in inventory is an example of this. Youll debit or credit one account in the statement of income, but there wont be an offsetting entry to another account. When recording profit in inventory in the statement of financial position, however, there will be a debit and credit that offset. The offsetting debit or credit is in retained earnings.
- Each company has completed the closing process and is presenting financial statements in accordance with GAAP.
- Abex uses the equity method of accounting. Abex owns 100% of the three subsidiaries and has recorded the income of the subsidiaries in its equity accounts. Abexs statement of income includes equity income in the caption Other (income) expense. The other item in the caption for Abex is Royalty Income on a patent it developed and licensed to an unrelated company.
The information provided on the next page was obtained from accounting personnel at the four companies. You have no reason to believe it is not complete and accurate. As noted above, we are assuming that no transactions took place in the past, before the current fiscal year (2021).
- This is important: The following are requirements for your submission.
o You must use the provided spreadsheet as your submission, you cannot submit a Word document. You may add additional sheets explaining your adjustments and for the final presentation of consolidated statements.
o You must use formulas wherever possible (subtotals, for example).
o Your adjustments must be supported and explained, either on the consolidation
spreadsheet or on a separate worksheet (in the same Excel workbook).
o The end result must be a consolidated (not consolidating) statement of financial
condition and a consolidated statement of income. (Consolidated statements show only the consolidated amounts and do not show the individual companies in the consolidation.) The statements must be in a format that could be printed and given to senior executives, a bank, investors, etc.
o The consolidated statements must be on a separate worksheet in your Excel file. The statements should be appropriately formatted (look at a public companys annual report for guidance on formatting). I should be able to print your consolidated statements and show them to an investor, analyst, etc. They must look professional!
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e3d1996fa9_361669e3d19130c6.jpg)
Abex Corp. Beta Company Corey Products Dailey Publication $ Cash Accounts receivable Inventory Prepaid expenses Notes receivable Current Assets Land Buildings Equipment Accumulated Depreciation PP&E, net Patents/Intangibles Accumulated Amortization Goodwill Intangible Assets, Net Investment in subsidiaries Other noncurrent assets TOTAL ASSETS 10,210,821 $ 142,500,033 8,237,800 49,500 151,333 161,149,487 2,500,000 39,310,777 124,379,923 (43,081,000) 123,109,700 89,210,267 (64,842,999) 825,777 $ 9,887,450 12,789,450 4,125 12,375 23,519,177 391,386 3,135,000 18,312,500 (3,547,500) 18,291,386 14,012,500 (5,362,500) 32,500,000 41,150,000 11,788,774 $ 17,380,408 14,887,900 5,890 17,670 44,080,642 294,500 4,476,400 14,725,000 (5,065,400) 14,430,500 28,013,000 (7,657,000) 15,750,000 36,106,000 1,178,998 23,200,750 5,784,300 5,890 17,670 30,187,608 294,500 19,476,400 14,583,397 (5,065,400 29,288,897 28,013,000 (2,767,000) 6,750,000 31,996,000 24,367,268 106,981,579 2,517,000 418,125,034 $ on the 70,125 83,030,688 100,130 94,717,272 S 100,130 91,572,635 $ $ Accounts payable Accrued expenses payable Income taxes payable Employee benefits payable Current Liabilities Long-term debt Deferred income taxes Pension and other liabilities 90,100,000 23,077,321 1,201,030 2,948,401 117,326,752 111,500,000 40,675,000 8,800,175 7,425,250 1,897,575 99,000 1,031,251 10,453,076 41,250,000 3,712,500 734,250 10,602,370 4,535,963 1,578,000 1,472,522 18,188,855 25,890,020 5,301,000 5,258,657 10,602,445 27,094,887 141,360 1,472,531 39,311,223 5,890,015 5,301,000 1,048,420 Common stock Additional paid in capital Retained earnings 5 Stockholders' Equity TOTAL LIABILITIES AND EQUITY 17,000,000 68,000,030 54,823,077 139,823,107 418,125,034 1,237,500 21,232,500 4,410,862 26,880,862 83,030,688 1,767,000 36,223,800 2,087,940 40,078,740 94,717,272 $ 1,610,000 39,200,477 (788,500) 40,021,977 91,572,635 $ S Sales Cost of goods sold Gross Profit Admin expense Selling expense R&D Other operating expenses Operating Income Interest expense Other (income)/expense Income Before Income Taxes Income tax expense Net Income Abex Corp. Beta Company Corey Products Dailey Publication $ 1,429,942,416 $ 112,607,965 $ 226,979,478 $ 310,928,251 663,901,836 52,282,269 105,383,329 154,234,545 766,040,580 60,325,696 121,596,149 156,693,706 270,667,671 21,315,079 42,963,972 58,854,276 240,026,048 18,902,051 38,100,126 52,191,527 188,956,676 14,880,338 29,993,716 41,086,947 51,069,372 4,021,713 8,106,409 14,104,580 15,320,812 1,206,514 2,431,923 (9,543,626) 2,247,052 176,955 356,682 488,601 (3,574,856 (281,519) (567,448) (777,320) 16,648,615 1,311,078 2,642,690 (9,254,907) 4,596,243 221,880 821,375 (2,175,845) $ 12,052,372 $ 1,089,198 $ 1,821,315 $ (7,079,062) Abex Corp. Beta Company Corey Products Dailey Publication $ Cash Accounts receivable Inventory Prepaid expenses Notes receivable Current Assets Land Buildings Equipment Accumulated Depreciation PP&E, net Patents/Intangibles Accumulated Amortization Goodwill Intangible Assets, Net Investment in subsidiaries Other noncurrent assets TOTAL ASSETS 10,210,821 $ 142,500,033 8,237,800 49,500 151,333 161,149,487 2,500,000 39,310,777 124,379,923 (43,081,000) 123,109,700 89,210,267 (64,842,999) 825,777 $ 9,887,450 12,789,450 4,125 12,375 23,519,177 391,386 3,135,000 18,312,500 (3,547,500) 18,291,386 14,012,500 (5,362,500) 32,500,000 41,150,000 11,788,774 $ 17,380,408 14,887,900 5,890 17,670 44,080,642 294,500 4,476,400 14,725,000 (5,065,400) 14,430,500 28,013,000 (7,657,000) 15,750,000 36,106,000 1,178,998 23,200,750 5,784,300 5,890 17,670 30,187,608 294,500 19,476,400 14,583,397 (5,065,400 29,288,897 28,013,000 (2,767,000) 6,750,000 31,996,000 24,367,268 106,981,579 2,517,000 418,125,034 $ on the 70,125 83,030,688 100,130 94,717,272 S 100,130 91,572,635 $ $ Accounts payable Accrued expenses payable Income taxes payable Employee benefits payable Current Liabilities Long-term debt Deferred income taxes Pension and other liabilities 90,100,000 23,077,321 1,201,030 2,948,401 117,326,752 111,500,000 40,675,000 8,800,175 7,425,250 1,897,575 99,000 1,031,251 10,453,076 41,250,000 3,712,500 734,250 10,602,370 4,535,963 1,578,000 1,472,522 18,188,855 25,890,020 5,301,000 5,258,657 10,602,445 27,094,887 141,360 1,472,531 39,311,223 5,890,015 5,301,000 1,048,420 Common stock Additional paid in capital Retained earnings 5 Stockholders' Equity TOTAL LIABILITIES AND EQUITY 17,000,000 68,000,030 54,823,077 139,823,107 418,125,034 1,237,500 21,232,500 4,410,862 26,880,862 83,030,688 1,767,000 36,223,800 2,087,940 40,078,740 94,717,272 $ 1,610,000 39,200,477 (788,500) 40,021,977 91,572,635 $ S Sales Cost of goods sold Gross Profit Admin expense Selling expense R&D Other operating expenses Operating Income Interest expense Other (income)/expense Income Before Income Taxes Income tax expense Net Income Abex Corp. Beta Company Corey Products Dailey Publication $ 1,429,942,416 $ 112,607,965 $ 226,979,478 $ 310,928,251 663,901,836 52,282,269 105,383,329 154,234,545 766,040,580 60,325,696 121,596,149 156,693,706 270,667,671 21,315,079 42,963,972 58,854,276 240,026,048 18,902,051 38,100,126 52,191,527 188,956,676 14,880,338 29,993,716 41,086,947 51,069,372 4,021,713 8,106,409 14,104,580 15,320,812 1,206,514 2,431,923 (9,543,626) 2,247,052 176,955 356,682 488,601 (3,574,856 (281,519) (567,448) (777,320) 16,648,615 1,311,078 2,642,690 (9,254,907) 4,596,243 221,880 821,375 (2,175,845) $ 12,052,372 $ 1,089,198 $ 1,821,315 $ (7,079,062)