You have landed a winter internship at the private wealth management division of Suncorp in Brisbane. The MD of the division has asked you to do some basic calculations needed for a presentation to investors in Southeast Queensland. You are given two datasets that are provided in the next two pages. I have also provided you with this data in an excel spreadsheet (FINM3403_2022_TakeHome.XLSX) that you can utilise to figure out the answers. Do not cut-and-paste excel spreadsheets in the document you submit. (a) Worksheet "Table Q3.1" contains the average monthly returns for USA, Australia, India and China in their local currencies and the average monthly exchange rate returns over the 28 years (1994 to 2021). (b) Worksheet "Table Q3.2" contains market indices for MSCI USA, Australia, Hong Kong and Japan (denominated in local currency) and exchange rates relative to USD for the last six months (December 2021 - May 2022). (2) The last few months have been traumatic for investors. Using the MSCI indices for USA, Australia, Hong Kong, and Japan and their exchange rates, you are asked to explain in a very brief note to Suncorp's inexperienced local investors how they would have fared should they have invested in each of these markets. Use data provided in Worksheet "Table Q3.2". (6 points; Max 250 words) Table Q3.2 Local Currency Market Indices Exchange Rates Date YEN/USD HKD/USD AUD/USD 115.16 7.796 1.375 115.23 7.798 1.419 USA AUSTRALIA HONG KONG JAPAN 31/12/2021 20958.00 12685.24 104396.03 2917.83 31/01/2022 19771.38 11943.73 105462.33 2771.52 28/02/2022 19192.14 12274.60 31/03/2022 19866.90 13173.02 29/04/2022 18065.84 13102.88 31/05/2022 18206.27 12839.56 102715.27 2739.54 115.18 7.814 1.378 102939.05 2877.20 121.38 7.831 1.332 97972.62 2800.84 129.56 7.846 1.407 100708.10 2826.90 128.65 7.846 1.394 Note: 1. Currencies are denoted as number of numerator currency per denominator currency. You have landed a winter internship at the private wealth management division of Suncorp in Brisbane. The MD of the division has asked you to do some basic calculations needed for a presentation to investors in Southeast Queensland. You are given two datasets that are provided in the next two pages. I have also provided you with this data in an excel spreadsheet (FINM3403_2022_TakeHome.XLSX) that you can utilise to figure out the answers. Do not cut-and-paste excel spreadsheets in the document you submit. (a) Worksheet "Table Q3.1" contains the average monthly returns for USA, Australia, India and China in their local currencies and the average monthly exchange rate returns over the 28 years (1994 to 2021). (b) Worksheet "Table Q3.2" contains market indices for MSCI USA, Australia, Hong Kong and Japan (denominated in local currency) and exchange rates relative to USD for the last six months (December 2021 - May 2022). (2) The last few months have been traumatic for investors. Using the MSCI indices for USA, Australia, Hong Kong, and Japan and their exchange rates, you are asked to explain in a very brief note to Suncorp's inexperienced local investors how they would have fared should they have invested in each of these markets. Use data provided in Worksheet "Table Q3.2". (6 points; Max 250 words) Table Q3.2 Local Currency Market Indices Exchange Rates Date YEN/USD HKD/USD AUD/USD 115.16 7.796 1.375 115.23 7.798 1.419 USA AUSTRALIA HONG KONG JAPAN 31/12/2021 20958.00 12685.24 104396.03 2917.83 31/01/2022 19771.38 11943.73 105462.33 2771.52 28/02/2022 19192.14 12274.60 31/03/2022 19866.90 13173.02 29/04/2022 18065.84 13102.88 31/05/2022 18206.27 12839.56 102715.27 2739.54 115.18 7.814 1.378 102939.05 2877.20 121.38 7.831 1.332 97972.62 2800.84 129.56 7.846 1.407 100708.10 2826.90 128.65 7.846 1.394 Note: 1. Currencies are denoted as number of numerator currency per denominator currency