PLEASE READ!!!!! SHOW ALL WORK ON EXCEL!!!!!! I have already posted these questions once, and the answers did not do what I asked. Please show the equations and calculations for each of the numbers that changes. I already have the answers, I DO NOT need another chart just with the answers copied and pasted from somewhere else. Please show ALL work on EXCEL with the equations (example: B2*(B1-C1)/C2 --> next cell with answer). THANK YOU!

2. Assume that FASB 8 is still in effect instead of FASB 52. Construct a consolidated balance sheet for Centralia Corporation and its affiliates after a depreciation of the euro from 1.1000/$1.00 to 1.1786/$1.00 that is the counterpart to Exhibit 10.7 in the text. Centralia and its affiliates carry inventory and fixed assets on the books at historical values.

EXHIBIT 10.7 Consolidated Balance Sheet for Centralia Corporation and Its Mexican and Spanish Affiliates, December 31, 2016: Post-Exchange Rate Change (in ooo dollars) Centralia Corp. (Parent) Mexican Affiliate Spanish Affiliate Consolidated Balance Sheet 600 $ 700 $ 950a 1,450b 3,000 900 887 $ 2,250 3,237 5,900 1,500 1,400 Assets Cash Accounts receivable Inventory Investment in Mexican affiliate Investment in Spanish affiliate Net fixed assets Total Assets d 9,000 4,600 3,733 17,333 $ 28,720 $ 1,157 Liabilities and Net Worth Accounts payable Notes payable Long-term debt Common stock Retained earnings $ 1,800 2,200 7,110 3,500 3,950 $ 700b 1,700 2,700 1,043e 2,987 $ 3,657 4,943 12,797 3,500 3,950 (127) $ 28,720 Total liabilities and net worth EXHIBIT 10.7 Consolidated Balance Sheet for Centralia Corporation and Its Mexican and Spanish Affiliates, December 31, 2016: Post-Exchange Rate Change (in ooo dollars) Centralia Corp. (Parent) Mexican Affiliate Spanish Affiliate Consolidated Balance Sheet 600 $ 700 $ 950a 1,450b 3,000 900 887 $ 2,250 3,237 5,900 1,500 1,400 Assets Cash Accounts receivable Inventory Investment in Mexican affiliate Investment in Spanish affiliate Net fixed assets Total Assets d 9,000 4,600 3,733 17,333 $ 28,720 $ 1,157 Liabilities and Net Worth Accounts payable Notes payable Long-term debt Common stock Retained earnings $ 1,800 2,200 7,110 3,500 3,950 $ 700b 1,700 2,700 1,043e 2,987 $ 3,657 4,943 12,797 3,500 3,950 (127) $ 28,720 Total liabilities and net worth