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!

1. Assume that FASB 8 is still in effect instead of FASB 52. Construct a translation exposure report for Centralia Corporation and its affiliates that is the counterpart to Exhibit 10.6 in the text. Centralia and its affiliates carry inventory and fixed assets on the books at historical values.

EXHIBIT 10.6 Translation Exposure Report for Centralia Corporation and Its Mexican and Spanish Affiliates, December 31, 2016 (in 000 currency units) Canadian Dollar Mexican Peso Euro Swiss Franc CD200 825 SF 0 Assets Cash Accounts receivable Inventory Net fixed assets Exposed assets 0 Ps 6,000 9,000 15,000 46,000 Ps 000 1,045 1,650 4,400 7,920 o lo 0 0 0 0 CD200 SF CD O 1,364 SF 0 0 935 375 Liabilities Accounts payable Notes payable Long-term debt Exposed liabilities Net exposure 0 Ps 7,000 17,000 27,000 Ps 51,000 Ps 25,000 0 CD 0 3,520 5,819 2,101 SF 375 (SF 375) CD200 EXHIBIT 10.6 Translation Exposure Report for Centralia Corporation and Its Mexican and Spanish Affiliates, December 31, 2016 (in 000 currency units) Canadian Dollar Mexican Peso Euro Swiss Franc CD200 825 SF 0 Assets Cash Accounts receivable Inventory Net fixed assets Exposed assets 0 Ps 6,000 9,000 15,000 46,000 Ps 000 1,045 1,650 4,400 7,920 o lo 0 0 0 0 CD200 SF CD O 1,364 SF 0 0 935 375 Liabilities Accounts payable Notes payable Long-term debt Exposed liabilities Net exposure 0 Ps 7,000 17,000 27,000 Ps 51,000 Ps 25,000 0 CD 0 3,520 5,819 2,101 SF 375 (SF 375) CD200