Need an excel sheet done for question 2 please!
02: Create a financial analysis of Santiago's choices. Use it to recommend a solution to his problem. To answer Question 1, you can refer to the topics of capital control and capital flight in chapter 3. Your answer to Question 1 can be a paragraph in length. For Question 2, you can use the Excel file, Minicase 1 solutions format.xlsx, to develop solutions of equivalent Venzuelan bolivars need to be prepared. The US$10,000 will be acquired through the CADIVI application. Apparently, there are two possible solutions to acquire the remaining US$ 20,000, either through the gray market or through the black market. Assuming that on March 10th, 2004 the CANTV ADR traded at $18.40 per share, and CANTV shares closed at Bs8938/share on the Caracas bourse. Each New York ADR was equivalent to 7 shares of CANTV in Caracas. You can calculate the implied gray market exchange rate, and consequently the black market exchange rate. Marking up the implicit gray market rate by 20% will be the black market exchange rate. 02: Create a financial analysis of Santiago's choices. Use it to recommend a solution to his problem. To answer Question 1, you can refer to the topics of capital control and capital flight in chapter 3. Your answer to Question 1 can be a paragraph in length. For Question 2, you can use the Excel file, Minicase 1 solutions format.xlsx, to develop solutions of equivalent Venzuelan bolivars need to be prepared. The US$10,000 will be acquired through the CADIVI application. Apparently, there are two possible solutions to acquire the remaining US$ 20,000, either through the gray market or through the black market. Assuming that on March 10th, 2004 the CANTV ADR traded at $18.40 per share, and CANTV shares closed at Bs8938/share on the Caracas bourse. Each New York ADR was equivalent to 7 shares of CANTV in Caracas. You can calculate the implied gray market exchange rate, and consequently the black market exchange rate. Marking up the implicit gray market rate by 20% will be the black market exchange rate