2. A hedge fund bought 1000 acres in Mexico at the beginning of 2016 for 2500 MXN per acre. The purchase was done in pesos with 10% down and the rest financed for ten years at an annual rate of 5%. (The change in the value of the property is based on the housing index.) Determine the monthly payment in pesos. How much money is owed on the loan after 5 years in pesos? What percentage of the equity after 5 years was due to the change in the value of the property in pesos? I After 5 years what is the price of an acre in pesos? What was the annual return in USD if the property is sold after 5 years? How much would the property need to be sold for if the fund wished to have an annual return of 10% in USD? E D F G H 150 982 156.447 B 1 Date MXN per USC Housing index 2 2016-01-01 MXN 18 21 144 318 3 2016-02-01 MXN 18.07 145 105 4 2016-03-01 MXN 1721 147967 5 2016-04-01 MXN 17.19 153.877 8 2016-05-01 MXN 1841 7 2016-06-01 MXN 18.49 8 2016-07-01 MXN 18.78 158,308 9 2016-08-01 MXN 18 A5 159.417 10 2016-09-01 MXN 19.34 159 098 159 579 11 2016-10-01 MXN 18.79 12 2016-11-01 MXN 20.48 189.387 13 2016-12-01 MXN 20.62 159 308 14 2017-01-01 MXN 20.84 159.402 15 2017-02-01 MXN 2000 159 908 16 2017-03-01 MXN 18.83 161.224 17 2017-04-01 MXN 18.93 163.000 18 2017-05-01 MXN 18.66 164.713 19 2017-06-01 MXN 18.08 166 240 20 2017-07-01 MXN 17.88 167.163 21 2017-08-01 MXN 17.79 167 478 22 2017-09-01 MXN 18.15 167 270 23 2017-10-01 MXN 1913 166 939 24 2017-11-01 MXN 18.63 166.889 2017-12-01 MXN 19.84 168.498 26 2018-01-01 MXN 18.62 166.300 27 2018-02-01 MXN 16.84 106.693 26 2018-03-01 MXN 18.17 168.151 20 2018-01-01 MXN 18.77 170.026 30 2018-05-01 MXN 20.00 171.904 31 2018-06-01 MXN 19.65 173,506 22 2018-07-01 MXN 1860 174,551 33 2018-08-01 MXN 1921 174.900 34 2013-09-01 MXN 18.71 175. 113 35 2016-10-01 MXN 20.26 175. 124 36 2018-11-01 MXN 20.30 175 225 37 2018-12-01 MXN 1964 175 203 38 2019-01-01 MXN 19.05 175. 120 30 2019-02-01 MXN 19.27 175.361 40 2019-03-01 MXN 19.40 176.680 41 2019-04-01 MXN 18.99 178.574 2 2019-05-01 MXN 19.65 180.430 2019-08-01 MXN 1921 182.016 44 2019-07-01 MXN 18.99 183.132 45 2019-08-01 MXN 2007 183.783 46 2019-09-01 MXN 19.74 184087 47 2019-10-01 MXN 19.17 184.160 48 2019-11-01 MXN 19.54 184.306 49 2019-12-01 MXN 18.80 184,584 50 2020-01-01 MXN 18.89 184.837 61 2020-02-01 MXN 19.73 185.221 S2 2020-03-01 MXN 23.45 186 727 2020-04-01 MXN 23.98 188.734 2020-05-01 MXN 22.17 190.735 55 2020-06-01 MXN 23.08 192.472 56 2020-07-01 MXN 22 23 193730 57 2020-08-01 MXN 21 88 194.679 58 2020-09-01 MXN 22.09 50 195.000 2020 10-01 MXN2128 196 348 60 2020 11-01 MXN 2015 196 739 61 2020-12-01 MXN19.89 196.151 62 2021-01-01 MXN 2020 196.426 83 66 65
