Economics 334 homework assignment

Note this is related In the margin] iafm Table 41.6 earth-Iodide 5 "Debt Crisis Statistics\". After reviewing the table in the Excel spreadsheet {1930 printed below], calculate the appropriate debt statistics {ratios} in columns W to AH and answer the questions below 1. Choose 2 possible indicators [i.e. debt-service ratioI debt-stock ratio, short-term debt stocks ratio, commercial bank debt stocks ratio} and address which 3 countries had the worst debt problem in 1931] and why? 1. Using the same indicators, which 3 countries had the worst debt: problem in 1935 and why? 3. Using the same indicators, which 3 countries had the worst debt problem in 1991] and why? 4. What is 1 country that seems to have improved, and another worsened, over the decade? A B C D E F G H K L 1 FOREIGN DEBT INDICATORS OF LAC COUNTRIES 1980 to 1990 2 Total Debt Stocks Commercial Bank Debt (non-multila Short-term Debt Total De 3 Country 1980 1985 1990 1980 1985 1990 1980 1985 1990 Country 19 4 Argent 27151.1 50997.6 62730.3 6064.6 20716.1 22660.9 10383.4 6731.4 10444.6 Argent 417 5 Bolivia 2702.4 4804.6 3779.3 603.2 901.4 213.2 302.5 656.1 154.3 Bolivia 36 6 Brazil 70565 106473 123439 24329.2 50049.5 47460.7 13539.5 9378.4 23716.2 Brazil 129 7 Chile 12081.3 20383.9 18576 2420.4 10011.9 4748 2560 1668 3382 Chile 270 8 Colomiba 6940.5 14245.5 17993 1371 3405.9 4208.1 2337 3104.1 1438.3 Colomiba 95 9 CostaR 2744.1 4400.3 3755.5 711.9 1530.2 41.1 575.4 376.7 377.3 CostaR 35 10 Ecuador 5996.9 8702.8 12109.3 1697.1 4959.6 4884.8 1575 989.3 1814.3 Ecuador 100 11 ElSalva 911.1 1850.8 2148.4 7.9 121 126.8 220 84.1 209.9 ElSalva 9 12 Guatem 1179.9 2677.5 3080.4 14.2 255.8 166.1 335 267 409.1 Guatem 14 13 Hond 1472.5 2730.2 3268.6 204.9 340.6 205.1 272.2 302.8 199.2 Hond 20 14 Mexico 57364.7 96861.9 104430.7 25636.6 55668.6 6629.9 16163 5450 16082 Mexico 1095 15 Nicarag 2190 5758.4 10707.8 746.3 1318.6 1305.3 472.2 841 2426.7 Nicarag 11 16 Panama 2974.5 4758.5 6678.5 1161 1763.1 2101.8 680.6 1124 2418.4 Panama 48 17 Peru 9385.9 12883.9 20067.4 1694.1 3005.2 3158.8 2084 1959 5349.9 Peru 215 18 Paraguay 954.5 1816.9 729.5 105.2 347.7 262.8 174.2 179.2 373 Paraguay 14 19 Uruguay 1659.8 3919.4 5180.5 501.9 1883.6 1575.6 322 814 1200.6 Uruguay 23 20 Venezuel 29344.4 30565 34272 8158.9 14875.6 363.5 15549.6 8951.1 2000 Venezuel 29 21 Average: 13859.92 21990.01 25467.42 4436.965 10067.91 5888.9706 3973.271 2522.129 4235.047 2198.9A1 X fx FOREIGN DEBT INDICATORS OF LAC COUNTRIES 1980 to 1990 L M N O P Q R S T U V W UGULWY 2 Total Debt Service Exports G&S GDP/GNI % Com80 3 1980 1985 1990 Country 1980 1985 1990 1980 1985 1990 Country 4 4178.3 6203.3 6184.9 Argent 9897 10047 14800 209036.5 88416.7 141352.9 Argent 5 365.5 365.5 228.3 Bolivia 1030.1 719.9 976.7 4537.5 5372.7 4867.7 Bolivia 6 12986 11959 18542 Brazil 21869 27720 35170 237388.5 211348.5 464927.3 Brazil 7 2705.6 2271.4 2302.1 Chile 5968 4496 10221 26679.5 16486 30328 Chile 8 951.1 1980.3 3815.5 Colomiba 5328 4505 8679 38901 40642 46908.1 Colomiba 9 354.4 526.6 501.2 CostaR 1195.1 1213.8 1963.2 6076.4 4933.7 7180.4 CostaR 10 1008.2 1098 1084.4 Ecuador 2887 3302 3362 11733.5 15956.6 10686.1 Ecuador 11 95.8 258.9 208.1 ElSalva 1214.2 902.9 973.1 3574 5366.4 5327.9 ElSalva 12 144.9 334.7 213.7 Guatem 1731 1160.8 1567.5 7879.4 11860 7650.2 Guatem 13 207.4 228.3 455.1 Hond 941.6 909.4 1032.5 2566 3639.5 3048.9 Hond 14 10957.7 15287.8 11311.4 Mexico 22622 31566 48805 223503.9 182275.8 262952.8 Mexico 15 114.7 63.8 15.8 Nicarag 494.8 344.4 392.2 1410.1 2970.5 2221.7 Nicarag 16 487.8 469.1 345.1 Panama 3421.7 3313 4438.3 3810.3 5402 5313.2 Panama 17 2150.7 1097.7 475.9 Peru 4631 3744 4120 20659.1 17991.2 33913.5 Peru 18 145.3 157.6 113.7 Paraguay 564.3 618.3 2514.4 4448.1 4545.1 5264.7 Paraguay 19 230.1 568.4 986.8 Uruguay 1526 1257.1 2158.5 9606.1 4729.7 9298.8 Uruguay 20 299.2 5094 22518 Venezuel 19968 15275 18806 69777.5 59816.5 48597.8 Venezuel 21 2198.982 2821.435 4076.588 6193.459 6534.976 9410.553 51858.08 30353.66 46281.75 22A1 X v fx FOREIGN DEBT INDICATORS OF LAC COUNTRIES 1980 to 1990 W X Y Z AA AB AC AD AE AF AG AH Debt by types of lenders, maturity Debt Service Ratio Debtstockratio 2 % Com80 %Com85 %Com90 %Shor80 %Shor85 %Shor90 DSRat80 DSRat85 DSRat90 DGDP80 DGDP85 DGDP90 3 ry 4 t 5 6 7 8 iba 9 R 10 or 11 a 12 m 13 14 0 15 g 16 na 17 18 uay 19 ay 20 uel 21