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