Reference no: EM13846059
1. A bank offers different interest rates on deposit accounts. The rate is based on the size of the periodical deposit (CF) and the following table. Write a future value function BANKFV (CF, r, n)
For Periodical Deposits
|
The interest rate is
|
<=100
|
r
|
<=500
|
r+0.5%
|
<=1000
|
r+1.1%
|
<=5000
|
r+1.7%
|
>5000
|
r+2.1%
|
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAYgAAACNCAIAAAAim3p2AAAOR0lEQVR4nO2dP29cuRXF5zvoG6hw59KtGqcyXAip3Fi9+gB2JSDx1tsK2pSL7bTYNo1cuAgQIHCKLGADNrCACwcBAgOrarqbgjHDJe/j+8c3vOfO+VWjmeGbw/fIM3wc8mgnhBBijF1vAYQQkvM/Y/qZEEJ6oxhTB1fcAPSKQOvP2hYc0OLFl34aky2g9dOY+uJJP43JFtD6aUx98aRfN6b9fv/i2ePdbndxdX1QaauJFbm///L09HSXcHLy8MOnz33ljZJdiPdv30T9p6dPv9zf9xI2hdSYyvNvvy156tiIjBvT508fHp6cnJ+f2+8MGVnHiJ0h/Gm/OumFuLu92e12b96+l69fFca9tTSmeP5DizLuTZ46NiLjxnR3e3N6+vT165+M94SSoY4hItdXF/arU9Fvn4oxCcL599SxERkxpvDlfHF1HdrWze3doQWuoD5ievzsxX6/76dunKg/3MSF4RIKdWOyXyNPHRuREWMKo+6b27vgUPY7c4qbOab0Pg6FKcZk+XvOU8dGZMSY7m5vYh9OH0Mw1DHidL7xrk5j6oinjo1IzZhCB46TxPYbUwZ0xxDeynXFU8dGpGZM4T5u91uA7ubcGBMnvw+Pp46NSM2Ywh1E7L0Qv1KnQHcM4XKBrnjq2IgMGpPa+jOrMk5l8tv4fUSACyw74qljI8ItKXaB1s8tKX3xpJ/GZAto/TSmvnjST2OyBbR+GlNfPOlnUBwhxAqKMR3SGrcDvSLQ+rO2BQe0ePGln8ZkC2j9NKa+eNJPY7IFtH4aU1886deNSV0+A7EyyNO1gSM1plabqNVYCLUp/uWvfy9X4YWFnRO3LkCffPGlX9/Eqy44hkgO8XRt4CiNaX1QX8WYyqZYLgaetQ8J+uSLL/25MVW2aNGYDgC0/ooxydItQbOMqdz4MutDoU+++NKfG1NlCziWMQW1D87OHp6c2N/MEcn0P3724o9/+L3Nu+aS0RFTbDzpXvFsPJ7VNy14fXURnh9qilk2xtwW66ljI1IzpkoMEKIxGd/1WqLqhzjzMnmOKfWsWLV//+dfan3j448f/xnyC6XaFNMGHCMPp+tvdSq64En/bGMyHodSjjisKayj6s8GAmapjJjKoL74TPiB5ZfPv6j1Dcd59OT58yePsvGX2hTTSaW5MYeeOjYiR3QrZ1xtiVdjksQyoq3Ex6PGpP5ArF7c+NKv97/ODYb21LEROYrJbwi1JcdgTOmXX3YrN2RM4X/2xKFQ/eKGCe+//fyPuf9Kw1PHRuQolgtAqC1xbEzxB7JgTOGl0NhGR0xx8ntKUwzHf/Xq1dwZRk8dG5FVCyyNd3UaU0fqk9/pFEH4fS20ru+++1Mc4NSNKa4GqF/c+NFzz5injo0It6TYBVo/t6T0xZN+GpMtoPXTmPriST+NyRbQ+mlMffGkn0FxhBArKMZ0SGvcDvSKQOvP2hYc0OIdQGOyC7R+GhNZA43JLtD6aUxkDYczps+fPjx59DyuJYnbo9IFJuqTKbNKWWhb6db5uNYmrCRM1/JkJydgQf8U1Dq2Mib14PHJdNnkaOOJB0xPdTxUthIqim+VcicD6+mWBd2FUuVmQ3WfRrqKtdRTr9pQ2fTVbJGjJC08Pnl3ezNrKdmBjKnMBru+ugi1jQ+GnkyZVcpCx37/9k1Wkfv7L88fPQmLnmMbvb66KPckWtA/hbKO0s6Y1BMY+2Ta3EcbjxTtMPwZd/mqjadVyp1UjWlu0F22Jzl41vn5eSms4lmjVav73dC2kOhl5YLYZekOWxlTqMDly5fxmyp2Tkm+wdQn0+PMLWWhY19fXWQXI4pMH1xeflMuXLagfwplHaWdMVVOoCRNYrTxiNYO1UNF/eFBq5Q7mWlMlaC74AJpkWDQr1//NDTkmWJMZdVmlS1JV+2Xmuscwpg+vnsXLLPeICqtJDC3VPeOvd/vv7m8zGpRjpjU4ZIY0D8FtY7SyJjUg4cmHs5YPIejjUcmt8OoPzyYm3KXvmejoLvMs8I74wgl9fHw0p9/+CHzuClVq5etRI8MHX9xgujh5piOxJiCnrOzB9ndezrHNDRcEgP6pzBUxybGNHTweIuRGsSoMQWyd6Z3hWlPmzLHpKbcxQmg7YLusvDy+FI5KgnGHT5u7hxTvWwlrC09eFpwtEgKjWlDPn/6cPbgLDbiy99dqvf/b96+j2Pm9LJ11z+FoTo2MSb14NnEUBhTLDMmSYY8337/YxyIyfCIaTTlLttsvEXQXdbDs5cy37y5vSvvCkerNlp2osuko6TF/wyCxrQhao3CzK5aFzGmfwppHZsvF6hf8cXGpIqX6hxTPeVu1Jiyn6sWBN2Vs87xaJmXRdeeYkxp8dGyU27lMj0AxnQ8k9+RsrfECRS1LmJM/xQ6GtOUye/A0KtDjWduyl16y7ZR0F15i7f7LdHLsufV3zfLqoXB49yyKukpAjAmOY7lAu/fvolfZeVcUvwhHHrENFTHJsakHjx09WxQINOWC8jwF+RQ45mbcjc6YlofdJcNi9Lenv5sn1Y5jnpKPfUfHIfKyvBygVTS9dWF+v5RuhmTmuClPpn+YDy91HYVmUW50iyQDY5w55hkoI6tRkzqwdUFlqONJ5ZN22E889MXWO6qKXeZ12wRdBfLqjZULoCqG9NQ1epls7NXnvbwZKrN6K9yhwe9ItD6uSVlO+auCcqo/BC8XVmL65h6gV4RaP00pk2Zu8MjMrTubOuy5RqrOjQmu0DrpzFtSroCC4J0unAKujERQkhfFGNq5JKdQa8ItP6sbcEBLd4BNCa7QOunMZE10JjsAq2fxkTWcDhj2i4oTj3+dhWZBYPitji4uo5JfVI9lLofOFv7E8XXd7rOohJ7ki0mahUUN7SMbkrV6mUDDIqT+hvK429UkbkwKK75wbNIgHStYJkeVy8lItdXF3HFY9wwLC6C4tTAtlKPWrXRsjK88ptBcc/Tpe7p8TeqyAIYFNf84A13gFe2+w4Zk6AFxYm2Ynt61aaXLTnqoDj1+BtVZC4Mitvi4GpQnPrkaKnKdt/6iAklKE6twtDzFd9kUNwSYypf3bQi07lnUNw2By+D4oaeTCnfEBzqx++/LbeJTZljSjtemS5gIShOqkOb0emzSlkGxelHgDAmBsVtcfB0XJDNMZWRAxH1DVlaUGasaUHEoLgUdbQyWrVKWQbF6UeAMKYUtUYMiltw8IaNJ73pS+/1xEVQXIr6fKVqo2UZFPd/6m+AMyYGxS07+EbxpwuMyXJQXHY01UdmGdNoWZWjDopTj79dRabDoLgtDq4GxQ2lx0Uq8XLx+zzLkwoPKj9dGQ+KUwPbJgbFjZaV4eUCDIoDWGDJoLgtDj59gWXaeEYXWE6c/N7hBMWVgW3Tg+LqZcN7GBS3BPSKQOvnlpTtYFAcNugVgdZPY9qUIw2KI4SQvijGtMARDYJeEWj9WduCA1q8+NJPY7IFtH4aU1886acx2QJaP42pL57005hsAa2fxtQXT/qbGdPiTLhlQXFDpSxcGwbFgQItXnzpb2NMazLhnP2LcGFQHCzQ4sWX/gbGtCYTbtleuUopC9eGQXGgQIsXX/obGNOaTLj1+zCtbYJlUFwXSU2AFi++9G8yx3TMxsSguL7a1gAtXnzppzE1hkFxvdUtB1q8+NJPY9oQBsVhAS1efOnfxJiOfPI7wqA4LKDFiy/9W61jOtrlAgyK661uOdDixZf+rYxpeibcsqC4ofQ4C9eGQXGgQIsXX/q5JcUW0PppTH3xpJ/GZAto/TSmvnjSz6A4QogVFGM6pDVuB3pFoPVnbQsOaPHiSz+NyRbQ+mlMffGkn8ZkC2j9NKa+eNKPmsekfmiTiqyHeUygQIsXX/pR85jUD11fkSYwjwkUaPHiSz9kHpP6oesr0grmMYECLV586YfMY1I/dH1FmsA8pi6SmgAtXnzph0wXUF9tVZGVMI+pr7Y1QIsXX/ppTI1hHlNvdcuBFi++9NOYNoR5TFhAixdf+iHzmNQPbVWRhjCPCQto8eJLP2oek/qhTSqyEuYx9Va3HGjx4ks/ah6T+qFNKrIe5jGBAi1efOnnlhRbQOunMfXFk34aky2g9dOY+uJJP43JFtD6aUx98aSfQXGEECsoxnRIa9wO9IpA68/aFhzQ4sWXfhqTLaD105j64kk/jckW0PppTH3xpL+BMamZYVsHxQ2VsnBtGBQHCrR48aW/gTGpmWFH+594hUFxsECLF1/6GxhTmRm29V65SikL14ZBcaBAixdf+tcak5oZtnW6QKVU92vDoLgukpoALV586V9rTGpm2DEbE4Pi+mpbA7R48aV/rTGpmWHHbEwMiuutbjnQ4sWX/pbLBRZ4kD9jSmFQHBbQ4sWX/k2M6cgnvyMMisMCWrz40r/WmIYyw452uQCD4nqrWw60ePGlv9n/lVucCbcsKG4oPc7CtWFQHCjQ4sWXfm5JsQW0fhpTXzzppzHZAlo/jakvnvTTmGwBrZ/G1BdP+hkURwixgmJMh7TG7UCvCLT+rG3BAS1efOmnMdkCWj+NqS+e9NOYbAGtn8bUF0/6UYPi4kcb/IeXDIoDBVq8+NKPGhQnX9dYGlxgyaA4UKDFiy/9kEFx8nUAcvnypcERE4PiQIEWL770QwbFicjHd+/2+73BWzkGxXWR1ARo8eJLP2RQnPrqyoq0gkFxfbWtAVq8+NIPGRSnvrqyIq1gUFxvdcuBFi++9EMGxamvNqxIKxgUhwW0ePGlHzIoLr4KZ0wMirMMtHjxpR81KC5g0JgYFNdb3XKgxYsv/ahBcQGDxiQMioMFWrz40s8tKbaA1k9j6osn/TQmW0DrpzH1xZN+GpMtoPXTmPriST+D4gghVsiNiRBC7EBjIoSYg8ZECDHHfwE1A0gYWZXjHwAAAABJRU5ErkJggg==)
2. Write a payment schedule calculator macro. The macro is to ask the user for the sum of the loan, the number of payments, and the interest rate. Assume payment at the end of the period.
Hints:
You may want to use the worksheet function PMT
The following macro and its output might be interest
Sub StringConcat()
Dim S As String
S = "Col1" & Chr(9) & "Col2" ' Chr (9) is the Tab
S = S & Chr(13) & "aaa" & Chr(9) & "bbb"
MsgBox S
End Sub
3. Develop code for a function that behaves in the same manner as Excel's SUM function. The function should sum all numerical values in an array.
4. Develop code for a function that behaves in the same manner as Excel's NPV function that requires two inputs, the first an array of cash flows and the second the discount rate.
E.g Function NetPV( cvec,rate)
5.The spreadsheet shows cash flow over five years for an investment proposal. After an outflow at the start, the cumulated cash flows turn positive during the third year , the time at which this happens being known as the project's payback period (here 2.4 years).
The intermediate calculations determining the payback period are set out in the worksheet. They centre on cumulating cash flows at yearly intervals and testing to determine the time at which the cumulative sum first turns positive. Develop a Payback Function, say PayBack (cvec) that returns the payback period for any array of cash flows.
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUAAAAFZCAIAAABmK2GuAAAfpElEQVR4nO2dMW8bybKF+R/4DxgoU6hUiRwJCowXKRFz5g+QIwJrb+yUoG7ouxkNh+uEugADAxcweBf2AiYgAQIU0FhgIUCMlM0L6rluubtnyKkpUn2G9UXSaDg8Vd1numc0XdMpHMeBpfPcAhzH0fP/Bv7TcRwcEgZ+hrNHi4BOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PFWGXg6GZ+cXz49PfEeT09Pl+cns/mi7tdMJ+PxZKqTOJ2Me72zh9Uq2L68vzk+OL65X0pt/eFotXo46/UC5bsEuk9Ai1eAHm+VgUfDfqfTkcZbzGe0hUzSEZBh4u2z+YI2Jk1YDR8t+VkSw3+aTsZSmxtYB7R4BejxVhmYHNIfjniP0bDf7R7e3C8DT5LVy7yqMzB96uj04uL0qOyzfIqRX+EGbgK0eAXo8VYZODCeNIbawPTz66srHqhphKcJMG2hcwR9lraXGXh5f3PY7fZ6Z1dXr0lAoLPssFsFuk9Ai1eAHu+am1jszELMnwsxuWVooN7QwDTl/vzpI8+B6eD0RXffvmxoYFbIc/jiZwOXHXarQPcJaPEK0ONdY2A5i+b5c5EysByBeUs83w7mt3zM4IKWWWtguvSVU/3YwIrL7yZA9wlo8QrQ411jYPbe3fJOGi8YacknJ+eXf/39fZMRODZwIcZS+fFqA9PRut3D4+OD5BS67LBbBbpPQItXgB7v+v8DkwHevHkj70gHBqZr0YYGll/HX1RtYL7zzGcQvj4PbmLFd9S3B3SfgBavAD3e9QYmbwQ3gaQneYfgbjAfYRMDTydjGj/Zk/TZwMDyUHwH62G14ptVPI2nryg77FaB7hPQ4hWgx7vewPK2E49p8TWwvLmlMDCfBfiL5A1k3i5H+GBQDabx8ho4uMu1baD7BLR4Bejx+qOU9kAnEFq8AvR43cD2QCcQWrwC9HjdwPZAJxBavAL0eN3A9kAnEFq8AvR40wZ2HAeFhIF3eQppH55AINAbyw1sjycQCPTGcgPb4wkEAr2x3MD2eAKBQG8sN7A9nkAg0BvLDWyPYQIbVhd59uIkvMrluQSsBb23u4Ht4QSWVQ7b/FDbM3CyepniKwKCxSdu4G3jBrYnMHC8XmrzQ23bwOZrpNcWYMgN9N7uBrYnaeAiqpvJQ1+vd/b9778uz0+Cgie8surg+Piw25WFR+IjyMoKvGewsjKuWxI4jQZM3ieoYRhXMgu+8X/+9xe5gCxYGcbHT65gSx58B6D3djewPWUG5gJjy/ub06OLYKNcsRyX7+0PR9T7yVHJI3B9EtphMPiV/XN7+zWYyioM3IkqmcXf+Lh6jNdvy0IL8oDVB99xY4HiBran1jVw4FXaIXAOfypZloCPIKsOSgE0gCcXabMwNmGFgctWcctvTBZgkGuzeeeyOt5xkZatgt7b3cD2lBmYr37jWgXUranvfr29vTw/SZYHYg8kjxDbWwrYpFh3XQPH31hh4GDn5JmrcAPXxA1sT9kUmknOlvnnwatXh92uvD4MRuCy+XbZCHxyfvn+3dvOzzX6Kwwce8lH4GxxA9uzuYF5IA2qbcfle/n6MBj65BH4FhE5XN5DoktTOQuoKH7U6XTevntP+1cbOP5Gmv+Tnj/++EN+MLiG51m9G7gJbmB71hpYzmxfDAZnvV4wLgXle+M7tGVHqLgLLT1ToY3rbNP7LqoNHH+j3BLfhZY7x7fc3cAK3MD2NElgPCl1tgp6b3cD26NOIM2Hdzn+OOi93Q1sjzqB+T942D7Qe7sb2B5PIBDojZU2sOM4KCQMvMtTSPuATiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8aYN7DgOCgkD7/IU0j6gEwgtXgF6vG5ge6ATCC1eAXq8bmB7oBMILV4BerxuYHugEwgtXgF6vG5ge6ATCC1eAXq8VQYeDfvyPT30Gkh/cd5a4j4RvNpzQ4L3bm71U4yVeAUNletos4HpVbH8Wnd6cTO/IdopQ+ZUvshXvuB3E9Z26Pjgs/nC0MBNxFezDeU62mxg+Q5of3He5nAC6XWh8iS4mM/MDRyMjVYGbii+mm0o19FmAxc/BuHxZBoMv/JV68FL34PttHHw6tVht7snb77lBJZNPpOJYsPw2+tpt4Pj48NuNzkAbmID0iCH0NGwzw1B7UgWpQ+uFU/b5bxMqn19dcWhvX33niPi/Zsol1+XFK8wf8sNLPsQZ0cmSzbn8v7m9OiCmoQNLzvrDq6jcoATKHuYJJko2plOkXffvrAlOp3Oyfnl508f4wSutQH9LA3W7R7+9ts/pB/o+NyUm4ivMLBUS4L/8+e/43O3TvnN/ZJUlYmP1W7eWKCsvwtNg3A8/FISadyIncn7PMu86Hkpu4mQhBNFP8hMBqmTg4/cgcco2d3pU7KlWA/Nhk7OLx9XjzRC0gfpr2vFVxuYvjfoFXQoefdEp3w8mfKlXFK84gZN+w0cO5AtXTEJ5GnPPhuYemEcezJRxY8hpfPz1cdaA1eMY9zvpR6a2fLY+I/ffjvsdmfzxWjY7/XO1oo3NHBd5ePJlI+cFK+Y3+2jgYOzIyOT7iNw8aOvx1f+yUTxX8nGceoUBi4bx+iHN2/e9Hpnd8u7s17vxWBw1uv1h6O14oPbmVsycJly/jkpvkljgaIxcHB7Y3l/88vbfxYiyzzC7LmBCzGonpxfvn/3lialyURNJ2Pq4vzX5gaWJpStxveHaDcWOZsv1orn2S/fo9qGgcuUF+LmViy+YWMhojFw8fNd6M7PdwJpC50U3cCFsEHQ14NEyZTKGzlNDFz83FL8cRYgZwH017XiC3EN1eudXV293oaBy5RXi2/eWHD4o5T2QCcQWrwC9HjdwPZAJxBavAL0eN3A9kAnEFq8AvR43cD2QCcQWrwC9HjTBnYcB4WEgXd5Cmkf0AmEFq8APV43sD3QCYQWrwA9XjewPdAJhBavAD1eN7A90AmEFq8APV43sD3QCYQWrwA9XjdwI5IPiuaQwMV8llxDH0iNN+Ygvi7qYIs68dIDobk9FOwG1jOdjJOLUZ83gbxAIlgBGktNbsRq/YbBFlEBKfmEf3VtkExwAytZ3t8cHxzzA/TTyZjb+3kTOBr2Z/OF1JOUenv7Nakfq/UbBluUVIArRKWUspIVmeAGVrKYz2Sjyl9zSKDso0mp19cfkvpzEF8XdbDFBgZWF+vZDW5gJbLTFD+XucohgVJeUurV1euk/hzE10UdbFE5hSbT0nLFly9fxgsbc8ANrMQNnA9bMnBHFBuUZDWddgMrycTAcm297FWtNLB5sEX5FJpLglGFTVnCMatB2A2sJLjWyucmVqwnKfXzp49J/TmIr4s62KLcwFz6iwxM02k3cHuQb4qiduX/LuSQQNlHk1LL9Ocgvi7qYIsSA/O0mT8rq1Jn9a9gN7AeeXUk71I++7+R4n9mJqUmN2K1fsNgi8pr4KCobYYXwIUbeBtAJxBavAL0eN3A9kAnEFq8AvR43cD2QCcQWrwC9HjdwPZAJxBavAL0eNMGdhwHhYSBd3kKaR/QCYQWrwA9XjewPdAJhBavAD1eN7A90AmEFq8APV43sD3QCYQWrwA9XjewPdAJhBavAD1eN3BT4oJMeSaQngdcuzA9T/EKNnxueRvxBi80ZrZRVcsNrCdZkKnIL4H0lC+/m5s6FosPHvHNTbwCWbxuOhnLF6nHzzNzvGU1sWqtBy57oHp7VbXcwHrigkxEzgnkklHUp+O32ucsfkNGw34w0SgLttigpI7cORjV5SKnQpzQ5QoKPn1saRWEG7gpbuCsWK0eLo5Og/W6VgYONgYGLps5b7Wqlhu4KUAGpp4kl8XSjE6uUM9W/IZQtY3r6w9yGlwWbLFBTSx5ZFriz20dGLjsLsNWq2q5gZsCYWB5DRbfRMGtCx0jhzvybeCozetCByMwDb9k12AdMl0YX129rjDwhlfRdXEDNwXCwEwwaDB83Ziz+CRBoSxZ76qIKuwQ8iK5bAqdvNwN/hrc8aLiO/H5kXbeUlUtN3BTsAxcpO7xFMgGDgiugdUGDibMdJpIvsAluAaOzSmn1m7g7MjfwMv7my/f7vhnvgyWOxx2u+2YQgfT5vhsJYMtNqiJxX+KXRdPZ3hqfXJ++f7dW/LtVqtquYH1JAsyFfklMLi6ow5d9p/J3MQriC/4K/4NW3ENzLslh98yZK9gz2+vqpYb2B7oBEKLV4AerxvYHugEQotXgB6vG9ge6ARCi1eAHq8b2B7oBEKLV4Aeb9rAjuOgkDDwLk8h7QM6gdDiFaDH6wa2BzqB0OIVoMfrBrYHOoHQ4hWgx+sGtgc6gdDiFaDH6wa2BzqB0OIVoMfrBm6EXGjC5JxAqiJSsUPO4jcn2S6y1A5vRI/XDawkeHQ2WWYpN2RRtbbWxCprl+lkTE8ml60HBsUNbEDZApes4FIV0sDtK6kj4XbhQkK0XS4gQ4/XDWwAhIFHw/54Ml3MZ3to4GBVsPwVPV43sAFB/8gwgezbwMDBqrciS/FquF2CNduyagd6vG7gpsSrunNLoBxs2cByhzbVxGJku7iBnTTJsmm5JXA6GctKxclyELgldYKaWLQxaBc3sJMg6d4ivwTGJRTj6jC4Bo6J2yW4xvGbWE5RFMVo2E+OZjknMDkCt6kmVpFqFzmdJnu3poSQG1hJUGYp55pYEjZwW2tilbWLrEolB2f0eN3A9kAnEFq8AvR43cD2QCcQWrwC9HjdwPZAJxBavAL0eN3A9kAnEFq8AvR40wZ2HAeFhIF3eQppH9AJhBavAD1eN7A90AmEFq8APV43sD3QCYQWrwA9XjewPdAJhBavAD1eN7A90AmEFq8APV43cCPku5sZ6ARCi2eS7ZIEPV43sBJ6Pp5f35zzgv5k+at218QK2qUs2AI/XjewAUHJpdwSmKyesycldahdyoIt8ON1AxvgBs4TN7CzHlq/ln9JnWApf+trYsl2KQu2wI/XDaxHLj2VK8hzTmBQFTnemLP4DSlrF8LrQjshQV27zBPI1XOSGzMXX4u43iAhM4AerxvYBqA+sT8GLtYFW+DH6wZWsry/+fLtjn+Wl8E5JzCoQR9vzFn8JlS0i9zoU+h9J3gHT85llpLlr9paEyvZLmXBFvjxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4Bejxpg3sOA4KbmDHASZh4K0P/K0GOoHQ4hWgx+sGtgc6gdDiFaDH6wa2BzqB0OIVoMfrBrYHOoHQ4hWgx+sGtgc6gdDiFaDH6wY2YDTsy6eLs00gVYqSK+zowUOUtZCbQ89Oek0sZz20vjRzD0ijTidjehh4OhnT6vY2rQemtftU9Wo07FOAXhPLSbO8vzk9uri+/pC5geNVdUEZoOlkTCFkKL4Wi/lM+nM07I8nUy+p46Sh/sGvvaeNuSVwtXq4ODqVdWSKqKPzr7mJr0vQFnRielw9uoGdEO4rmRuYpwmyygwPuXKfdhhYnpikgb0mlvNf5KwsfwPzHR2S3R+O2mrg4HI3LovlNbGcoiiK6WTMV5X5G5jMSb/SGHV19bqVBg6QzcR4SR2nGA37nZ/huVluCQyugcnA19cf4qlmC25iBdBNinijG9j5L5mPwDxtpl+p+8qKjbQD/Zyb+CZMJ2N5kiK8JpYTkrmBi5JSyfRcR1DTK0PxtZCRsnu9JpZTA+gEQotXgB6vG9ge6ARCi1eAHq8b2B7oBEKLV4Aeb9rAjuOgkDDwLk8h7QM6gdDiFaDH6wa2BzqB0OIVoMfrBrYHOoHQ4hWgx+sGtgc6gdDiFaDH6wa2BzqB0OIVoMfrBrYn2wS2taTOYj7bpHpOEsR4JW5gJVhVWtpaUodbgc9ByXbBaqxauIGVYFVpaWtJHSonKNc2J9sFq7Fq4QZWAtQnWl9Sxw1MuIFrIGdlmVdpaX1JndjAQbsANVZd3MAGZF6lpfUldYJY5HbZLsmNiPFK3MA25FzkofUldcoMXKQu/ou8G6submAbcu4TrS+p4wYm3MBKMq/S0vqSOmUGDtoluRExXokbWAlWlZa2ltQJSguenF/e3n6N2wWrsWrhBrYHOoHQ4hWgx+sGtgc6gdDiFaDH6wa2BzqB0OIVoMfrBrYHOoHQ4hWgx5s2sOM4KCQMvMtTSPuATiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8aYN7DgOCgkD7/IU0j6gEwgtXgF6vG5ge6ATCC1eAXq8bmB7oBMILV4BerxuYHugEwgtXgF6vG5ge6ATCC1eAXq89gYeDfvBG1mfnp5+HQz4BdOt57n6BL0uNH5TbtwiDL13U34EvUPXBT3eNQam96/y+1Tlm6CL6O2stD1+2zK9Ep5fBt96dt8n6G3dlPbpZCzffzudjJOuLopiNOxTu5DzyeToHbou6PGuN/DLly+73UMaP2MD88/TyZh6w/L+5vjgWI639Er4bUeSD7vvE2UZXt7fnB5dXF9/iA28Wj1cHJ1yM/ER0Dt0XdDjXW/g8WTKrVthYB5mg31ocCibwrWSHfeJwIoSaqDFfJY08FmvR80kmwy9Q9cFPd6NDMyDavUIzL1E/rxv8+di532Ch1m6kJGZp5+TBi5+XDMfHB8fdrs8gKN36Lqgx7uRgemHk/PLx9Vj2TUwT7OLopCz6H2bPxfPYWB2IJ1h+8MR/UATnzID0z7UfG5gUDY1MPWSj58+l43AAfSnitldi3mWEZjnODTlubp6zZ6smEKTw9n2uxf/7KDHu6mBi6KYTsZHpxcXp0ebGJg6zedPH5Pn/nbzvNfAZODB4EXnZ+QUqYhczVc66B26Lujx1jAwnbPlf5UqDEy96vj4oGyHFrPjPiHHzyJ1zSK9yk22mM+kpfm2BXqHrgt6vDUMXPy47bGJgemvwVl/T9h9n6ALnOAmFsMGjq0ej8/oHbou6PH6o5T2QCcQWrwC9HjdwPZAJxBavAL0eN3A9kAnEFq8AvR43cD2QCcQWrwC9HjTBnYcB4WEgXd5Cmkf0AmEFq8APV43sD3QCYQWrwA9XjewPdAJhBavAD1eN7A90AmEFq8APV43sD3QCYQWrwA93jUGvvv2ZQ+fhWxIwz5Bz6vWXYMZPOVKyFI7tIUen5Rbgopl6B26LujxrjGwfNo5WQGrYvveou4T5Lf+cEQ/cIkifs45+bQzLzIhuHzCdDKmJ5ypLNZsvljMZ3ReCJpVNhl6h64Lerz1DBxXwKrYvreY9Im4tFgRlTRKfuqw253NF8HHabHR+3dveSkSOTleKozeoeuCHq/SwLJQTtn2vWV7Bl6bXjZwsCf9en39gXxLlSuT5RbQO3Rd0OPVGFjWQ6vYvrc07xPkwziTa+sTsW+D4r5UteNueUeTbdonuRoUvUPXBT1e5TWwrDJZtn1vadInKlb2JsdkiTyBJg0sh26aPP/193eyNDcceoeuC3q8mhGY52nV2/cWkz4RT2eqh99gsX61gVerh8GLAQ3Cs/mCf7USDwR6vMprYNmZyrbvLVZ9Qiazurx24N4iulqWfuaClfwPJPmfJPQOXRf0ePU3sbgIS9n2vUXdJ5b3N1++3fHP8jI4fmFN0DTJ/y3FddvpUFyDlnzrIzAuSgPLPlG2fW9p+H9gvqEQDL8yq3LILftHMT3aERwqvjvtdaGfW0Ij/FFKe6ATCC1eAXq8bmB7oBMILV4BerxuYHugEwgtXgF6vG5ge6ATCC1eAXq8aQM7joNCwsC7PIW0D+gEQotXgB6vG9ge6ARCi1eAHq8b2B7oBEKLV4AerxvYHugEQotXgB6vG9ge6ARCi1eAHu92DRzXZNrlx6uhJxBrHXzDF6bm0yeomE5FjPFDmvmI3w3o8VYZOHg0t7orJNmqgRvKa7eB4wek45VMnEAZVA7idwl6vOsNTM++09PzdZfs78DATeTVBcvAv7z9Z/Fj2UOyzCVVvTs+PnAD47KpgYsf8zGqpRSUQfz+91+X5yfcD9h4VPDh4PiYRwPqRmWFFIMFNNLA9O2yF5bJC47DO9D+g1evDrvdbvfw33/+R54dgiFLLr6jLXFf3ySnOUAlU4IlYrxcMTgr5SZ+26DHW8PA1A+o4iGXd+CNsX+k1fvDEfUY6ivJI9DOvMNg8Cv5/+T88vb2azzdLZMnbU9fGp81er0zKhBFu8mvDmSwZjo+nIE56mBuMhr2uTKWGxiXptfAgVdpB+4TwRxYmjw+QlyanD5OA3hcjbFMnjwOTSDps4EY+Wvw1awz2A40hWbovBPMnykusrQb+LklNKKGgfkUzpdVwYSTusLX29vL8xM5srFn2A/JI8T2DsbMagOzPJ70BrPoCgMHX806g+1wBi67Cx3U4pfpzUf8bkCPt8YUmknOlvlnusiUhWaDEbhsvl02AlNF8ngYKZOXfMlILKb1I3DF/5BiA/MZMBPxOwM93kYG5oFU2rUjLhR5y8n55edPH/lPySPwbSRyON8DOzm/fFw9xjeZy+TRcXg734+tMHBwfc4f5+00rejgXAPL23h8fUH5DDLmU+jnltAIjYHl3PXFYCCfBAjO+rTn66sr3j+wenCEirvQgS0r5BVR95U3sZIGDj4iOzRPyHu9s6ur17gG5vt2bmAJerzGT2KVTV/3Cug+AS1eAXq8lgam+bCXlYXuE9DiFaDHa2lgxcOJrQS6T0CLV4Aer69Gsgc6gdDiFaDHmzaw4zgoJAy8y1NI+4BOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4BejxuoHtgU4gtHgF6PG6ge2BTiC0eAXo8bqB7YFOILR4Bejxpg3sOA4KCQPv8hTSPqATCC1eAXq8bmB7oBMILV4BerxuYHugEwgtXgF6vG5ge6ATCC1eAXq8bmB7oBMILV4BerxuYHugEwgtXgF6vG5ge6ATCC1eAXq8bmB7oBMILV4BerxuYHugEwgtXgF6vG5ge6ATCC1eAXq8bmB7oBMILV4BerxuYHugEwgtXgF6vG5ge6ATCC1eAXq8bmB7oBMILV4BerxuYHugEwgtXgF6vG5ge6ATCC1eAXq8bmB7oBMILV4BerxuYHugEwgtXgF6vG5ge6ATCC1eAXq8aQM7joNCwsC7PIW0D+gEQotXgB6vG9ge6ARCi1eAHq8b2B7oBEKLV4AerxvYHugEQotXgB6vG9ge6ARCi1eAHq/SwKvVw1mvN5svtqULmefqE4v5rD8cVe8zGvY7nc7J+eXT0xNteXp6+nUwuLlf0q/oHbou6PGuMTC1N9PtHlJLP6OBR8N+spsGUseTqeIgJuy+Tzw9PV2en0hn8hai1zt7WK3Y4aNhn/Mjf34W8c8LerzrDSxbdzTsU1fYmb6YCgOz1OlkXK2zZQYeDfuz+WI6GQcGDs6w08mYUsROXsxncjQu8Dt0XdDjrWdgHniD/sGjH/eG5f3NYbcrB0P6bPVIzl2Q5nW//+t3OgjtH4wqwRgrpS7mMzawHJnHk2nyIFJb0KEb5nSXrDUw+5acvFo9XByd8uSZQO/QdUGPt56BqVuwDah/LO9vTo8u5HBHfuAP/uv33x9Xj/RB2sJdrcLAl+cn0oQ8YK4dgeW3Pz09fft2SzsEruaDyFg4QE0uf5CPgZOnS55RB41LoHfouqDHa2Pgw25XnuylVYjA5Mv7m+OD45v7ZbWB4+3FZtfAyYtz/tLgIIG26WTccHadg4GD7XFOaPL819/fydL8V/QOXRf0eA0MXIgJM22JDRxs4cnbhgaWl2prR+DghELdNxiL5EEW81nnZ1pm4CJK2mr1MHgxoEF4Nl/wrwV+h64Lerz1DLyYz+TlaHBS5yFurYHrjsC1DCz3kaPrhiNwczI3MOeW/4Ek/5OE3qHrgh5vDQPTyMbXlrGBg3FVXgPTVE0aTBqV+hZ9aq2By6a4wU0sOtHIEwdvDA4SqG1ObgaOpyQUO/vWR2Bc6v0fmDuBNJicgibnpTwY8n3pYDSm7b3e2fX1h7UG5v0r7kIHU3360heDAd90DQ4itZVdQutyuhuCZjo5v7y9/SojSt6fL0QzccOhd+i6oMfrj1LaA51AaPEK0ON1A9sDnUBo8QrQ43UD2wOdQGjxCtDjdQPbA51AaPEK0ONNG9hxHBRCAzuOg4gb2HGAcQM7DjD/Byg4/K3KbMAGAAAAAElFTkSuQmCC)