Consolidate the rest of the sheet show work, please

after completing the consolidation, you discovered that one of the subsidiaries submitted their financial information in Euros, not dollars. And the Euro is the subsidiary's functional currency. translate the subsidiary's statement of financial position and income statement to US $ from Euros (exchange rates are provided on the spreadsheet). And of course, your translation work must be clear and easy to audit.

Dailey Publication Abex Corp. Beta Company Corey Products $ $ 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 70,125 83,030,688 $ 100,130 94,717,272 $ 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 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 $ $ 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) Intercompany Accounts Asset Transfer. Asset Transfer, Land Machine Management Fee Total Consolidation Adjustments Investment Accouu Equity Income ntercompany Sale Profit in Inventory Consolidated S S 24,004,370 192.968,641 41,699,450 65,405 199,048 258,936,914 3,480,386 66,398,577 171,980,820 (56.824,300) 185.035,483 159.248,767 (80,629,499) 55.000.000 133,619,268 (20,000) (65,000) (20.000) (65.000 (106,981.579) (106,981.579) 2.787,385 S 580.379,050 118.730.065 56,605,746 3,019,390 6.924,705 185,279,906 184,530,035 54.989,500 15.841,502 (4,614.500) (96,656,777) (5,710.302) (4.614,500) (96,656,777) (5.795,302) (85,000) 17,000,000 68,000.030 54,738,077 139,738,107 S 580,379,050 S 2.080,458,110 975.801,979 1.104.656.131 393,800,998 349,219,752 274.917,677 77.302.074 9,415,630 3.269,290 (5.116,143) 11.262.483 3,163,653 S 7.798,830 85.000 85.000 (106,981.579) 1 Publication 2 3 Cash 1,178,998.00 4 Accounts receivable 23,200,750 5 Inventory 5,784,300 6 Prepaid expenses 5,890 7 Notes receivable 17,670 8 Current Assets 30.187,608 9 Land 294,500 10 Buildings 19,476,400 11 Equipment 14,583,397 12 Accumulated Depreciation (5,065,400) 13 PP&E.net 29.288,897 14 Patents/Intangibles 28.013,000 15 Accumulated Amortization (2,767,000) 16 Goodwill 6.750,000 17 Intangible Assets, Net 31.996,000 18 Investment in subsidiaries 19 Other noncurrent assets 100,130 20 TOTAL ASSETS 91.572,635.00 21 22 Accounts payable 10,602.445 23 Accrued expenses payable 27,094,887 24 Income taxes payable 141,360 25 Employee benefits payable 1.472,531 26 Current Liabilities 39.311.223 27 Long-term debt 5,890,015 28 Deferred income taxes 5,301,000 29 Pension and other liabilities 1,048.420 30 31 Common stock 1,610,000 32 Additional paid in capital (APIC) 39,200.477 33 Cumulative translation adjustment 34 Retained earnings (788.500) 35 Stockholders' Equity 40,021,977 36 TOTAL LIABILITIES AND EQUITY 91,572,635.00 37 38 39 Dailey Publication 40 Sales 310,928,251.00 1 Cost of goods sold 154,234,545 2 Gross Profit 156,693,706 43 Admin expense 58,854,276 44 Selling expense 52,191,527 45 R&D 41,086,947 46 Other operating expenses 14.104.580 47 Operating Income (9,543,626) 48 Interest expense 488,601 49 Other (income) expense (777,320 50 Income Before Income Taxes (9.254.907) 51 Income tax expense (2,175,845) 52 Net Income (7,079.061.78) 53 54 55 56 Exchange rates provided 1 Euro = x Dollars 57 58 Beginning of year 1.21 59 End of year 1.15 50 Weighted average during year 1.18 51 Historical rate for common stock and APIC 0.95 52 Historical rate for retained earnings* 1.07 53 * Including current and past years 34 Note: Exchange rates are assumed, do not 35 necessarily match actual rates. 36 f Dailey Publication Abex Corp. Beta Company Corey Products $ $ 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 70,125 83,030,688 $ 100,130 94,717,272 $ 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 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 $ $ 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) Intercompany Accounts Asset Transfer. Asset Transfer, Land Machine Management Fee Total Consolidation Adjustments Investment Accouu Equity Income ntercompany Sale Profit in Inventory Consolidated S S 24,004,370 192.968,641 41,699,450 65,405 199,048 258,936,914 3,480,386 66,398,577 171,980,820 (56.824,300) 185.035,483 159.248,767 (80,629,499) 55.000.000 133,619,268 (20,000) (65,000) (20.000) (65.000 (106,981.579) (106,981.579) 2.787,385 S 580.379,050 118.730.065 56,605,746 3,019,390 6.924,705 185,279,906 184,530,035 54.989,500 15.841,502 (4,614.500) (96,656,777) (5,710.302) (4.614,500) (96,656,777) (5.795,302) (85,000) 17,000,000 68,000.030 54,738,077 139,738,107 S 580,379,050 S 2.080,458,110 975.801,979 1.104.656.131 393,800,998 349,219,752 274.917,677 77.302.074 9,415,630 3.269,290 (5.116,143) 11.262.483 3,163,653 S 7.798,830 85.000 85.000 (106,981.579) 1 Publication 2 3 Cash 1,178,998.00 4 Accounts receivable 23,200,750 5 Inventory 5,784,300 6 Prepaid expenses 5,890 7 Notes receivable 17,670 8 Current Assets 30.187,608 9 Land 294,500 10 Buildings 19,476,400 11 Equipment 14,583,397 12 Accumulated Depreciation (5,065,400) 13 PP&E.net 29.288,897 14 Patents/Intangibles 28.013,000 15 Accumulated Amortization (2,767,000) 16 Goodwill 6.750,000 17 Intangible Assets, Net 31.996,000 18 Investment in subsidiaries 19 Other noncurrent assets 100,130 20 TOTAL ASSETS 91.572,635.00 21 22 Accounts payable 10,602.445 23 Accrued expenses payable 27,094,887 24 Income taxes payable 141,360 25 Employee benefits payable 1.472,531 26 Current Liabilities 39.311.223 27 Long-term debt 5,890,015 28 Deferred income taxes 5,301,000 29 Pension and other liabilities 1,048.420 30 31 Common stock 1,610,000 32 Additional paid in capital (APIC) 39,200.477 33 Cumulative translation adjustment 34 Retained earnings (788.500) 35 Stockholders' Equity 40,021,977 36 TOTAL LIABILITIES AND EQUITY 91,572,635.00 37 38 39 Dailey Publication 40 Sales 310,928,251.00 1 Cost of goods sold 154,234,545 2 Gross Profit 156,693,706 43 Admin expense 58,854,276 44 Selling expense 52,191,527 45 R&D 41,086,947 46 Other operating expenses 14.104.580 47 Operating Income (9,543,626) 48 Interest expense 488,601 49 Other (income) expense (777,320 50 Income Before Income Taxes (9.254.907) 51 Income tax expense (2,175,845) 52 Net Income (7,079.061.78) 53 54 55 56 Exchange rates provided 1 Euro = x Dollars 57 58 Beginning of year 1.21 59 End of year 1.15 50 Weighted average during year 1.18 51 Historical rate for common stock and APIC 0.95 52 Historical rate for retained earnings* 1.07 53 * Including current and past years 34 Note: Exchange rates are assumed, do not 35 necessarily match actual rates. 36 f