On January 1, 2019, Cayce Corporation acquired 100 percent of Simbel Company for consideration transferred with a fair value of $137,700. Cayce is a U.S.-based company headquartered in Buffalo, New York, and Simbel is in Cairo, Egypt. Cayce accounts for its investment in Simbel under the initial value method. Any excess of fair value of consideration transferred over book value is attributable to undervalued land on Simbel's books. Simbel had no retained earnings at the date of acquisition. The following are the 2020 financial statements for the two operations. Information for Cayce and for Simbel is in U.S. dollars ($) and Egyptian pounds (E), respectively. Cayce Corporation $ 222,400 (105,000) (21,800) (8,400) (25,200) 17,600 0 Sales Cost of goods sold Salary expense Rent expense Other expenses Dividend income-from Simbel Gain on sale of building, 10/1/20 Net income Retained earnings, 1/1/20 Net income Dividends Retained earnings, 12/31/20 Cash and receivables Inventory Prepaid expenses Investment in Simbel (initial value) Property, plant, and equipment (net) Total assets Accounts payable Notes payable-due in 2023 Common stock Additional paid-in capital Retained earnings, 12/31/20 Total liabilities and equities $ 79,600 $ 332,000 79,600 (38,000) $ 373,600 $ 112,200 99,400 30,000 137,700 442,800 $ 822, 100 $ 66,400 155,300 134,000 92,800 373,600 $ 822, 100 Simbel Company E 864,500 (453,700) (79,600) (48,800) (63,200) 0 44,000 E 263,200 E 144,200 263,200 (64,000) E 343,400 E 161,400 327,800 0 0 469,000 E 958,200 E 58,200 144,200 254,000 158,400 343,400 E 958,200 Additional Information Additional Information During 2019, the first year of joint operation, Simbel reported income of E 177,000 earned evenly throughout the year. Simbel declared a dividend of E 32,800 to Cayce on June 1 of that year. Simbel also declared the 2020 dividend on June 1. On December 9, 2020, Simbel classified a E 11,400 expenditure as a rent expense, although this payment related to prepayment of rent for the first few months of 2021. The exchange rates for 1 E are as follows: January 1, 2019 June 1, 2019 Weighted average rate for 2019 December 31, 2019 June 1, 2020 October 1, 2020 Weighted average rate for 2020 December 31, 2020 $ 0.300 0.290 0.288 0.280 0.275 0.273 0.274 0.270 Translate Simbel's 2020 financial statements into U.S. dollars and prepare a consolidation worksheet for Cayce and its Egyptian subsidiary. Assume that the Egyptian pound is the subsidiary's functional currency. Complete this question by entering your answers in the tabs below. Translation Worksheet Consolidation Worksheet Prepare a Translation worksheet. (Round "Exchange Rate" answers to 3 decimal places. Round your "Dollars" answers to the nearest whole number. Input all amounts as positive values.) Exchange Rate U.S. Dollars 0 CAYCE CORPORATION TRANSLATION WORKSHEET Egyptian Account Pounds Sales Cost of goods sold Salary expense Rent expense (adjusted) Other expenses Gain on sale of building, 10/1/20 Net income Retained earnings, 1/1/20 Net income Dividends Retained earnings, 12/31/20 0 Cash and receivables Inventory Prepaid expenses (adjusted) Property, plant, and equipment (net) Total assets Accounts payable Notes payable-due in 2023 Common stock Additional paid-in capital Retained earnings, 12/31/20 Subtotal 0 Cumulative translation adjustment Total liabilities and equities 0 0 0 0 Consolidation Entries Consolidated Balances Dollars Account Cayce Dollars Simbel Dollars Debit Credit 0 0 0 0 0 Sales Cost of goods sold Salary expense Rent expense Other expenses Dividend incomefrom Simbel Gain on sale of building, 10/1/20 Net income Retained earnings, 1/1/20 Net income Dividends Retained earnings, 12/31/20 Cash and receivables Inventory Prepaid expenses Investment in Simbel (initial value) Property, plant, and equipment (net) Total assets Accounts payable Notes payabledue in 2023 Common stock Additional paid-in capital Retained earnings, 12/31/20 Subtotal Cumulative translation adjustment Total liabilities and equities 0 0 0 0 0 0 0 0 0 0 0 On January 1, 2019, Cayce Corporation acquired 100 percent of Simbel Company for consideration transferred with a fair value of $137,700. Cayce is a U.S.-based company headquartered in Buffalo, New York, and Simbel is in Cairo, Egypt. Cayce accounts for its investment in Simbel under the initial value method. Any excess of fair value of consideration transferred over book value is attributable to undervalued land on Simbel's books. Simbel had no retained earnings at the date of acquisition. The following are the 2020 financial statements for the two operations. Information for Cayce and for Simbel is in U.S. dollars ($) and Egyptian pounds (E), respectively. Cayce Corporation $ 222,400 (105,000) (21,800) (8,400) (25,200) 17,600 0 Sales Cost of goods sold Salary expense Rent expense Other expenses Dividend income-from Simbel Gain on sale of building, 10/1/20 Net income Retained earnings, 1/1/20 Net income Dividends Retained earnings, 12/31/20 Cash and receivables Inventory Prepaid expenses Investment in Simbel (initial value) Property, plant, and equipment (net) Total assets Accounts payable Notes payable-due in 2023 Common stock Additional paid-in capital Retained earnings, 12/31/20 Total liabilities and equities $ 79,600 $ 332,000 79,600 (38,000) $ 373,600 $ 112,200 99,400 30,000 137,700 442,800 $ 822, 100 $ 66,400 155,300 134,000 92,800 373,600 $ 822, 100 Simbel Company E 864,500 (453,700) (79,600) (48,800) (63,200) 0 44,000 E 263,200 E 144,200 263,200 (64,000) E 343,400 E 161,400 327,800 0 0 469,000 E 958,200 E 58,200 144,200 254,000 158,400 343,400 E 958,200 Additional Information Additional Information During 2019, the first year of joint operation, Simbel reported income of E 177,000 earned evenly throughout the year. Simbel declared a dividend of E 32,800 to Cayce on June 1 of that year. Simbel also declared the 2020 dividend on June 1. On December 9, 2020, Simbel classified a E 11,400 expenditure as a rent expense, although this payment related to prepayment of rent for the first few months of 2021. The exchange rates for 1 E are as follows: January 1, 2019 June 1, 2019 Weighted average rate for 2019 December 31, 2019 June 1, 2020 October 1, 2020 Weighted average rate for 2020 December 31, 2020 $ 0.300 0.290 0.288 0.280 0.275 0.273 0.274 0.270 Translate Simbel's 2020 financial statements into U.S. dollars and prepare a consolidation worksheet for Cayce and its Egyptian subsidiary. Assume that the Egyptian pound is the subsidiary's functional currency. Complete this question by entering your answers in the tabs below. Translation Worksheet Consolidation Worksheet Prepare a Translation worksheet. (Round "Exchange Rate" answers to 3 decimal places. Round your "Dollars" answers to the nearest whole number. Input all amounts as positive values.) Exchange Rate U.S. Dollars 0 CAYCE CORPORATION TRANSLATION WORKSHEET Egyptian Account Pounds Sales Cost of goods sold Salary expense Rent expense (adjusted) Other expenses Gain on sale of building, 10/1/20 Net income Retained earnings, 1/1/20 Net income Dividends Retained earnings, 12/31/20 0 Cash and receivables Inventory Prepaid expenses (adjusted) Property, plant, and equipment (net) Total assets Accounts payable Notes payable-due in 2023 Common stock Additional paid-in capital Retained earnings, 12/31/20 Subtotal 0 Cumulative translation adjustment Total liabilities and equities 0 0 0 0 Consolidation Entries Consolidated Balances Dollars Account Cayce Dollars Simbel Dollars Debit Credit 0 0 0 0 0 Sales Cost of goods sold Salary expense Rent expense Other expenses Dividend incomefrom Simbel Gain on sale of building, 10/1/20 Net income Retained earnings, 1/1/20 Net income Dividends Retained earnings, 12/31/20 Cash and receivables Inventory Prepaid expenses Investment in Simbel (initial value) Property, plant, and equipment (net) Total assets Accounts payable Notes payabledue in 2023 Common stock Additional paid-in capital Retained earnings, 12/31/20 Subtotal Cumulative translation adjustment Total liabilities and equities 0 0 0 0 0 0 0 0 0 0 0