Please show Excel work: December 31, 2015 January 2, 2016 Assets In...
60.1K
Verified Solution
Link Copied!
Question
Finance
Please show Excel work:
December 31, 2015 January 2, 2016 Assets In Euros () Exchange Rate (US$/euro) Translated Accounts (US$) Exchange Rate (US$/euro) Translated Accounts (US$) Cash 1,600,000 1.2000 $ 1,920,000 1.0000 $ 1,600,000 Accounts receivable 3,200,000 1.2000 3,840,000 1.0000 3,200,000 Inventory 2,400,000 1.2000 2,880,000 1.0000 2,400,000 Net plant and equipment 4,800,000 1.2000 5,760,000 1.0000 4.800,000 Total 12,000,000 $14,400.000 $12,000,000 Liabilities and Net Worth Accounts payable 800,000 1.2000 $ 960,000 1.0000 $ 800,000 Short-term bank debt 1,600,000 1.2000 1,920,000 1.0000 1,600,000 Long-term debt 1,600,000 1.2000 1,920,000 1.0000 1,600,000 Common stock 1,800,000 1.2760 2,296,800 1.2760 2,296,800 Retained earnings 6,200,000 1.2000(a) 7,440,000 1.2000(b) 7,440,000 $ (136.800) $(1,736,800) Translation adjustment (CTA) Total 12,000,000 $14,400,000 $12,000,000 (a) Dollar retained earnings before depreciation are the cumulative sum of additions to retained earnings of all prior years, translated at exchange rates in each year. (b) Translated into dollars at the same rate as before depreciation of the euro. December 31, 2015 January 2, 2016 Assets In Euros () Exchange Rate (US$/euro) Translated Accounts (US$) Exchange Rate (US$/euro) Translated Accounts (US$) Cash 1,600,000 1.2000 $ 1,920,000 1.0000 $ 1,600,000 Accounts receivable 3,200,000 1.2000 3,840,000 1.0000 3,200,000 Inventory 2,400,000 1.2000 2,880,000 1.0000 2,400,000 Net plant and equipment 4,800,000 1.2000 5,760,000 1.0000 4.800,000 Total 12,000,000 $14,400.000 $12,000,000 Liabilities and Net Worth Accounts payable 800,000 1.2000 $ 960,000 1.0000 $ 800,000 Short-term bank debt 1,600,000 1.2000 1,920,000 1.0000 1,600,000 Long-term debt 1,600,000 1.2000 1,920,000 1.0000 1,600,000 Common stock 1,800,000 1.2760 2,296,800 1.2760 2,296,800 Retained earnings 6,200,000 1.2000(a) 7,440,000 1.2000(b) 7,440,000 $ (136.800) $(1,736,800) Translation adjustment (CTA) Total 12,000,000 $14,400,000 $12,000,000 (a) Dollar retained earnings before depreciation are the cumulative sum of additions to retained earnings of all prior years, translated at exchange rates in each year. (b) Translated into dollars at the same rate as before depreciation of the euro
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!