Hi, please help! Advanced Accounting, Chapters 9&10. Excel worksheet. Please include formulas!

Compte, Incorporated ( 0 U.S. based company, establishes a subsidiary in Croatis on January 1, 2023. The following accocmt balances for the year ending December 31,2024 , are stated in kuna (K), the local currency: The following U.S, dollor per kuna exchange rates are applicable: Required: a. Assuming that the kuna is the functional currency, what exchange rate would be used to report each of these accourts in US. doller consolidated financiai statements? - Sales - Inventory - Equipment - Pent expense - Dividends - Notes recelvable - Accumulated depreciation-equipment - Salary payable - Depreciabon expense b. Assuming that the US. dolle: is the functional currency, what exchenge rate would be used to report each of these accounts in US. doller consolidated financial statements? - Sales - Inventory - Equipment - Pent expense Oividends - Notes rocelvabie - Accumulated deprecintion-equipment - Solery peyobie - Depreciasion expense Navigation 1. Use the Open Excel in New Tab buttion to launch this question. Compte, Incorporated (a U.S.-based company), establishes a subsidiary in Croatia on January 1, 2023. The following account balances for the year ending December 31,2024 , are stated in kuna (K), the local currency: The following U.S. dollar per kuna exchange rates are applicable: 23 24 Required: 25 Note: Use cells A2 to 822 from the given information to complete this question. For all requiremeats, raund your answers to 2 decimal places. 26 Braded Worksheet Note: Use cells A2 to 822 from the given information to complete this question. For all requirements, round your answers to 2 decimal places. a. Assuming that the kuna is the functional currency, what exchange rate would be used to report each of these accounts in U.S. dollar consolidated financial statements? 5tudents: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. Nothing in this area will be graded, but it will be submitted with your assignment. Compte, Incorporated ( 0 U.S. based company, establishes a subsidiary in Croatis on January 1, 2023. The following accocmt balances for the year ending December 31,2024 , are stated in kuna (K), the local currency: The following U.S, dollor per kuna exchange rates are applicable: Required: a. Assuming that the kuna is the functional currency, what exchange rate would be used to report each of these accourts in US. doller consolidated financiai statements? - Sales - Inventory - Equipment - Pent expense - Dividends - Notes recelvable - Accumulated depreciation-equipment - Salary payable - Depreciabon expense b. Assuming that the US. dolle: is the functional currency, what exchenge rate would be used to report each of these accounts in US. doller consolidated financial statements? - Sales - Inventory - Equipment - Pent expense Oividends - Notes rocelvabie - Accumulated deprecintion-equipment - Solery peyobie - Depreciasion expense Navigation 1. Use the Open Excel in New Tab buttion to launch this question. Compte, Incorporated (a U.S.-based company), establishes a subsidiary in Croatia on January 1, 2023. The following account balances for the year ending December 31,2024 , are stated in kuna (K), the local currency: The following U.S. dollar per kuna exchange rates are applicable: 23 24 Required: 25 Note: Use cells A2 to 822 from the given information to complete this question. For all requiremeats, raund your answers to 2 decimal places. 26 Braded Worksheet Note: Use cells A2 to 822 from the given information to complete this question. For all requirements, round your answers to 2 decimal places. a. Assuming that the kuna is the functional currency, what exchange rate would be used to report each of these accounts in U.S. dollar consolidated financial statements? 5tudents: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. Nothing in this area will be graded, but it will be submitted with your assignment