Need the excel part/question 2 done please!
Minicase 1: The Venezuelan Bolivar Black Market Objective: Analyze the devaluation of Venzuelan bolivar and develop possible solutions for a case study Due date: November 3rd, 11:59 pm This minicase weighs 5% of your overall grade. Requirements Please read the following minicase and answer these two questions: Q1: Why does a country like Venezuela impose capital controls? Q2: 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. Minicase 1: The Venezuelan Bolivar Black Market Objective: Analyze the devaluation of Venzuelan bolivar and develop possible solutions for a case study Due date: November 3rd, 11:59 pm This minicase weighs 5% of your overall grade. Requirements Please read the following minicase and answer these two questions: Q1: Why does a country like Venezuela impose capital controls? Q2: 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
