Assets Cash Accounts receivable Inventory Plant assets Less: Accumulated depreciation Total assets Liabilities 5: Stockholder's Equity Accounts payable Bonds payable Common stock Retained earnings Total liabilities 8: stockholder's equity 140,000 40,000 120,000 100,000 -20 000 M 30,000 100,000 200,000 50 000 380 000 $1.50 1.50 1.50 1.50 1.50 $1.50 1.50 1.50 1.50 $2 10,000 60,000 180,000 150,000 -30 000 M $45,000 150,000 300,000 75 000 $5 70,000 Sub Co adjusted its advance to Parent Co at year-end 2017 to reect the $1.40 current exchange rate. Sub Co recorded an exchange gain because there is no evidence that the advance is of a long-term investment nature. The entry recorded on Sub Co's books was: Advance to parent 4,000 _ Exchange gain _ 4,000 To adjust receivable denominated in U. S. doliars (($84,000/$1.40) - 56,000) Required: In the Excel le \"Case 1 - Advanced accounting topics" and the worksheet "Foreign Currency" you will nd Sub Co's adjusted trial balance at December 31, 2017 in British pounds. Please prepare the following