need to complete consolidation work problem. I think I copied all the relevant data into the spreadsheet - let me know if something is missing. info tab has details

Parent Company current exchange rate historical rate for stock avg rate sub A 0.1458 0.0985 ? sub B 1.1171 1.0883 ? US Dollars US sub C elimination entries DR CR Total Currency sub B EURO sub A YEN US Income Statement: sales widgets sales thingies sales stuff sales more sales spares other income 521,304.60 267,341.40 2,950.67 905.82 1,394,947.40 606,875.58 210,790.06 150,123.48 615,393.04 - 2,929,215.50 745,353.89 393,444.81 34,946.30 1,705,105.29 125,835.80 (1,308,576.68) (597,408.30) Total Revenues 792,502.49 2,978,129.56 5,933,901.59 (2,332,548.54) 3,913,839.53 284,971.93 (4,029,218.71) 394,678.03 6,074.54 0.15 1,207,254.73 1,810,206.27 (1,228,501.79) 110,804.08 157.29 11,647.87 42,182.04 48,187.91 1,354,867.07 2,003,443.20 (1,322,862.75) 2,108,993.16 63,728.01 8,131.09 7,967.60 63,254.55 4,683.29 - 20,000.00 - Beginning Inventory Purchases Less: Ending Inventory Salaries & Benefits Other Materials Freight Travel Service Other Research & Development: Salaries & Benefits Other R&D - (408,790.51) (17,773.05) - - 1,248,722.05 543,259.85 188,693.99 134,386.79 550,884.47 - 2,929,215.50 745,353.89 393,444.81 34,946.30 1,705,105.29 125,835.80 7,371,985.10 5,435,545.19 2,665,947.15 5,933,901.59 6,475,961.33 4,098,621.41 (6,580,583.25) 2,219,797.24 394,835.31 81,450.42 50,313.13 56,155.65 83,254.55 4,683.29 - 26,843,892.54 1,954,540.02 (27,635,244.93) 2,706,982.34 41,663.51 1.00 - 1,080,704.26 1,620,451.41 (1,099,724.10) 99,189.04 140.80 10,426.88 37,760.31 43,136.61 56,623.89 4,192.36 - 1,354,867.07 2,003,443.20 (1,322,862.75) 2,108,993.16 63,728.01 8,131.09 7,967.60 20,000.00 - 570,345.47 2,069,876.22 4,244,267.38 4,569,713.58 3,911,834.48 1,852,901.46 4,244,267.38 Gross Profit 222,157.02 908,253.34 1,689,634.21 2,802,271.52 1,523,710.71 813,045.69 1,689,634.21 Sales Salaries & Benefits Advertising & Trade Shows Sales Travel Sales Other 41,898.61 1,537.06 10,923.98 10,823.54 118,415.27 11,384.25 10,641.94 2,229.87 461,164.74 36,677.08 83,634.05 - 621,478.62 49,598.39 105,199.97 13,053.41 287,370.45 10,542.22 74,924.42 74,235.56 106,002.39 10,190.90 9,526.40 1,996.12 461,164.74 36,677.08 83,634.05 - Total Sales 65,183.19 142,671.33 581,475.87 789,330.39 447,072.65 127,715.81 581,475.87 Admin Sales & Benefits Admin Travel Audit & Payroll Services Other Admin 70,023.05 10,571.48 9,371.46 8,186.00 167,659.75 2,094.26 24,957.30 18,347.48 408,852.76 22,200.18 88,920.15 49,150.97 646,535.56 34,865.92 123,248.91 75,684.46 480,267.83 72,506.69 64,276.16 56,145.43 150,084.82 1,874.73 22,341.15 16,424.21 408,852.76 22,200.18 88,920.15 49,150.97 Total G&A 98,151.99 213,058.80 569,124.06 880,334.85 673,196.11 190,724.91 569,124.06 70,664.74 4,113.53 114,059.91 11,367.76 3,486.35 5,950.72 21,498.69 42,378.65 2,920.32 20,503.08 5,529.56 14,789.15 548.90 41,161.08 60,432.53 118,024.00 5,898.06 15,945.60 49,104.80 67,208.28 10,302.92 599.75 16,629.93 1,657.42 508.31 867.61 3,134.51 - Total Other Overhead EBIT (2,314,775.49) 3,575,477.38 1,833,617.28 20,237.77 6,212.76 Cost of Goods Sold Depreciation Insurance Rent Supplies Taxes (Other) Utilities Other Organization & Other Cost Currency Conversion - 3,536,890.82 1,022,162.57 604,234.87 185,069.78 1,914,658.49 108,968.57 - - 47,341.19 3,262.29 22,903.99 6,177.07 16,520.96 613.18 - 41,161.08 60,432.53 118,024.00 5,898.06 15,945.60 49,104.80 67,208.28 - 98,805.19 64,294.57 157,557.93 13,732.55 16,453.91 66,493.37 70,955.97 - 33,700.46 96,818.68 357,774.35 - 488,293.49 231,141.70 86,669.66 357,774.35 25,121.38 455,704.53 181,259.93 - 644,312.79 172,300.25 407,935.31 181,259.93 Interest Expense Taxes 12,424.99 - 8,172.84 12,441.50 151,958.25 - 154,783.02 12,441.50 85,219.39 - 7,316.12 11,137.32 151,958.25 - Net Earnings 12,696.39 435,090.20 29,301.68 477,088.27 87,080.86 389,481.87 29,301.68 426,501.30 300,350.55 385,572.39 26,413.42 670,475.19 1,263,005.68 95,991.54 260,618.79 (109,331.18) 2,942,749.61 1,322,862.75 (315,281.25) 92,094.18 987,645.30 2,676,562.96 1,804,426.68 (315,281.25) 379,126.39 600,192.63 1,130,611.12 85,929.23 233,299.43 (109,331.18) 2,942,749.61 1,322,862.75 (315,281.25) 92,094.18 1,138,837.65 2,290,091.21 3,933,094.11 2,050,032.41 3,933,094.11 110,791.60 6,223.18 (55,721.95) - 395,858.05 80,237.39 (208,358.78) - 354,362.23 71,826.51 (186,517.57) - 559,435.10 505,179.46 (978,553.48) 30,362.10 61,292.83 Total Assets (17,773.05) Balance Sheet Cash Accounts Receivable Inventory WIP Prepayment (1,829,542.88) 5,532,480.09 2,925,248.95 2,060,017.50 2,644,529.41 181,161.97 7,810,957.83 559,435.10 505,179.46 (978,553.48) 30,362.10 (30,362.10) 1,066,084.74 591,640.04 (1,242,634.21) - 759,887.50 42,683.02 (382,180.72) - 267,736.66 116,423.18 (30,362.10) 1,200,130.48 2,557,827.87 4,049,517.29 Accounts Payable Accrued Expenses Notes Payable Other Liabilities Warranty Reserve 1,215,796.45 205,408.67 - 186,434.44 836,443.77 77,082.76 794,295.71 - 102,297.74 230,746.14 2,467,270.89 - Total Current Liabilities 1,421,205.12 1,894,256.68 2,800,314.77 11,171.00 217,309.99 435,090.20 396,672.00 823,228.84 29,301.68 Total Current Assets Furniture & Fixtures Machinery & Equipment Accumulated Depreciation Long Term Investment Total Fixed Assets Stock holders Equity Capital Stock Retained Earnings Net Income (Loss) Total Stockholder's Equity Total Liabilities & Stock. Equity 08/27/2017 14,797.17 (248,568.20) 12,696.39 (221,074.64) 663,571.19 1,200,130.48 2,557,827.87 - 9,479.10 (9,479.10) - (1,829,542.88) 415,090.58 420,389.80 239,671.17 116,423.18 7,807,475.64 8,231,347.63 2,289,703.58 4,049,517.29 (1,829,542.88) 288,732.18 1,067,189.91 1,930,607.22 999,704.39 - 8,338,795.94 1,408,838.64 - 166,891.45 748,763.56 69,002.56 711,033.67 - 102,297.74 230,746.14 2,467,270.89 - (1,829,542.88) 4,286,233.70 9,747,634.58 1,695,691.24 2,800,314.77 10,000.00 194,530.47 389,481.87 396,672.00 823,228.84 29,301.68 - 401,757.17 782,491.53 477,088.27 101,489.50 (1,704,857.31) 87,080.86 1,249,202.52 1,691,699.07 (1,516,286.95) 594,012.34 1,249,202.52 4,049,517.29 7,807,475.64 8,231,347.63 2,289,703.58 4,049,517.29 (30,362.10) - file:///var/filecabinet/temp/converter_assets/e2/25/e2255fedd5c965afe2f4bbf943ccc12450008046.xlsConsolidated detail Consolidation Adjustments 2016 receivables and payables sub B note payable sub B ar1 sub B ar2 sub B ar3 sub B invoices to parent 2016 ending balance (1,019,536.23) 1,665,582.24 70,529.56 155,709.78 (339,699.15) 532,586.20 sub a note payable sub A as1 sub A ar2 sub A ar3 986,799.07 150,000.00 24,737.56 135,420.05 1,296,956.68 Total inter company receivable 1,829,542.88 Intercompany sales sub B widgets thingies spares sub A widgets thingies spares Total widgets thingies spares 1,153,700.88 451,688.61 398,518.39 2,003,907.88 154,875.80 145,719.69 10,272.12 310,867.61 1,308,576.68 597,408.30 408,790.51 2,314,775.49 2016 intercompany interest income 17,773.05