EMI = P×r×(1+r)n/[(1+r)n-1]
Where,
P=Principal=300000
r=monthly interest=0.05/12=0.004167
n=tenure=number of years×12=20×12=240
Therefore,
EMI =
300000×0.004167×(1+0.004167)240/[(1+0.004167]240-1]
= 1250.1×2.71286/1.71286
= $1,979.93
(9) (c) $1980
(10)
(d) May 31st,
2032
(11)
Note: It is assumed that payment is yearly payment and it is
received at the end of every year
Present Value of Perpetuity = Payment Receivable in 1st
year/(discount rate - growth rate)
= 500/(2%-1%)
= 50000
(e)
$50,000
(If this was helpful then please rate positively. Thank
You:)
H I J K B C D E F G Closing Opening Principal Principal Principal Interest Repayment (Installment- (previous (opening* (Installment- Principal Month opening) (0.052) Installment Interest) Repayment) January, 2020 300000 1250 1980 7302 99270 February, 2020 299270 1246.958 1980 733.041667 298536.9583 March, 2020 298536.9583 1243.904 1980 736.096007 297800.8623 April, 2020 297800.8623 1240.837 1980 739.163074 297061.6993 May, 2020 297061.6993 1237.757 1980 742.24292 296319.4563 June, 2020 296319.4563 1234.664 1980 745.335599 295574.1207 July, 2020 295574.1207 1231.559 1980 748.441164 294825.6796 August, 2020 294825.6796 1228.44 1980 751.559668 294074.1199 September, 2020 294074.1199 1225.309 1980 754.691167 293319.4287 October, 2020 293319.4287 1222.164 1980 757.835714 292561.593 November, 2020 292561.593 1219.007 1980 760.993362 291800.5997 December, 2020 291800.5997 1215.836 1980 764.164168 291036.4355 January, 2021 291036.4355 1212.652 1980 767.348185 290269.0873 February, 2021 290269.0873 1209.455 1980 770.54547 289498.5418 March, 2021 289498.5418 1206.244 1980 773.756076 288724.7858 April, 2021 288724.7858 1203.02 1980 776.980059 287947.8057 May, 2021 287947.8057 1199.783 1980 780.217476 287167.5882 June, 2021 287167.5882 1196.532 1980 783.468382 286384.1198 July, 2021 286384.1198 1193.267 1980 786.732834 285597.387 August, 2021 285597.387 1189.989 1980 790.010887 284807.3761 September, 2021 284807.3761 1186.697 1980 793.302599 284014.0735 October, 2021 284014.0735 1183.392 1980 796.608027 283217.4655 November, 2021 283217.4655 1180.073 1980 799.927227 282417.5383 December, 2021 282417.5383 1176.74 1980 803.260257 281614.278 January, 2022 281614.278 1173.393 1980 806.607175 280807.6708 February, 2022 280807.6708 1170.032 1980 809.968038 279997.7028 March, 2022 279997.7028 1166.657 1980 813.342905 279184.3599 April, 2022 279184.3599 1163.268 1980 816.731834 278367.6281 May, 2022 278367.6281 1159.865 1980 820.134883 277547.4932 June, 2022 277547.4932 1156.448 1980 823.552112 276723.9411 July, 2022 276723.9411 1153.016 1980 826.983579 275896.9575 August, 2022 275896.9575 1149.571 1980 830.429344 275066.5281 September, 2022 275066.5281 1146.111 1980 833.889466 274232.6387 October, 2022 274232.6387 1142.636 1980 837.364006 273395.2747 November, 2022 273395.2747 1139.147 1980 840.853022 272554.4216 December, 2022 272554.4216 1135.643 1980 844.356576 271710.0651 January, 2023 271710.0651 1132.125 1980 847.874729 270862.1903 February, 2023 270862.1903 1128.592 1980 851.40754 270010.7828 March, 2023 270010.7828 1125.045 1980 854.955072 269155.8277 April, 2023 269155.8277 1121.483 1980 858.517384 268297.3103 May, 2023 268297.3103 1117.905 1980 862.09454 267435.2158 June, 2023 267435.2158 1114.313 1980 865.686601 266569.5292 July, 2023 266569.5292 1110.706 1980 869.293628 265700.2356 August, 2023 265700.2356 1107.084 1980 872.915685 264827.3199 September, 2023 264827.3199 1103.447 1980 876.552834 263950.7671 October, 2023 263950.7671 1099.795 1980 880.205137 263070.5619 November, 2023 263070.5619 1096.127 1980 883.872659 262186.6893 December, 2023 262186.6893 1092.445 1980 887.555461 261299.1338 January, 2024 261299.1338 1088.746 1980 891.253609 260407.8802 February, 2024 260407.8802 1085.033 1980 894.967166 259512.913 March, 2024 259512.913 1081.304 1980 898.696196 258614.2168 April, 2024 258614.2168 1077.559 1980 902.440763 257711.7761 May, 2024 257711.7761 1073.799 1980 906.200933 256805.5751 June, 2024 256805.5751 1070.023 1980 909.97677 255895.5984 July, 2024 255895.5984 1066.232 1980 913.76834 254981.83 August, 2024 254981.83 1062.424 1980 917.575708 254064.2543 September, 2024 254064.2543 1058.601 1980 921.39894 253142.8554 October, 2024 253142.8554 1054.762 1980 925.238103 252217.6173 November, 2024 252217.6173 1050.907 1980 929.093261 251288.524 December, 2024 251288.524 1047.036 1980 932.964483 250355.5595 January, 2025 250355.5595 1043.148 1980 936.851835 249418.7077 February, 2025 249418.7077 1039.245 1980 940.755385 248477.9523 March, 2025 248477.9523 1035.325 1980 944.675199 247533.2771 April, 2025 247533.2771 1031.389 1980 948.611345 246584.6658 May, 2025 246584.6658 1027.436 1980 952.563893 245632.1019 June, 2025 245632.1019 1023.467 1980 956.532909 244675.569 July, 2025 244675.569 1019.482 1980 960.518463 243715.0505 August, 2025 243715.0505 1015,479 1980 964.520623 242750.5299 September, 2025 242750.5299 1011.461 1980 968.539459 241781.9904 October, 2025 241781.9904 1007.425 1980 972.57504 240809.4154 November, 2025 240809.4154 1003.373 1980 976.627436 239832.7879 December, 2025 239832.7879 999.3033 1980 980.696717 238852.0912 January, 2026 238852.0912 995.217 1980 984.782953 237867.3083 February, 2026 237867.3083 991.1138 980 988.886216 236878.4221
H I J K 13 100 101 102 103 104 105 106 107 108 109 110 111 F G 1980 993.006575 235885.4155 1980 997.144102 234888.2714 1980 1001.29887 233886.9725 1980 1005.47095 232881.5016 1980 1009.66041 231871.8412 1980 1013.86733 230857.9738 1980 1018.09178 229839.882 1980 1022.33382 228817.5482 1980 1026.59355 227790.9547 1980 1030.87102 226760.0836 1980 1035.16632 225724.9173 1980 1039.47951 224685.4378 1980 1043.81068 223641.6271 1980 1048.15989 222593.4673 1980 1052.52722 221540.94 1980 1056.91275 220484.0273 1980 1061.31655 219422.7107 1980 1065.73871 218356.972 1980 1070.17928 217286.7927 1980 1074.63836 216212.1544 1980 1079.11602 215133.0384 1980 1083.61 234 214049.426 1980 1088.12739 212961.2986 1980 1092.66126 211868.6374 1980 1097.21401 210771.4234 1980 1101.78574 209669.6376 1980 1106.37651 208563.2611 1980 1110.98641 207452.2747 1980 1115.61552 206336.6592 1980 1120.26392 205216.3953 1980 1124.93169 204091.4636 1980 1129.6189 202961.8447 1980 1134.32565 201827.519 1980 1139.052 200688.467 1980 1143.79805 199544.669 1980 1148.56388 198396.1051 1980 1153.34956 197242.7555 1980 1158.15519 196084.6003 1980 1162.98083 194921.6195 1980 1167.82659 193753.7929 1980 1172.69253 192581.1004 1980 1177.57875 191403.5216 1980 1182.48533 190221.0363 1980 1187.41235 189033.624 1980 1192.3599 187841.2641 1980 1197.32807 186643.936 1980 1202.31693 185441.6191 1980 1207.32659 184234.2925 1980 1212.35711 183021.9354 1980 1217.4086 181804.5268 1980 1222.48114 180582.0456 1980 1227.57481 179354.4708 1980 1232.6897 178121.7811 1980 1237.82591 176883.9552 1980 1242.98352 175640.9717 1980 1248.16262 174392.8091 1980 1253.3633 173139.4458 1980 1258.58564 171880.8601 1980 1263.82975 170617.0304 1980 1269.09571 169347.9347 1980 1274.38361 168073.5511 1980 1279.69354 166793.8575 1980 1285.02559 165508.8319 1980 1290.37987 164218.4521 1980 1295.75645 162922.6956 1980 1301.15543 161621.5402 1980 1306.57692 160314.9633 1980 1312.02099 159002.9423 1980 1317.48774 157685.4545 1980 1322.97727 156362.4773 1980 1328.48968 155033.9876 1980 1334.02505 153699.9625 1980 1339.58349 152360.379 1980 1345.16509 151015.214 1980 1350.76994 149664.444 1980 1356.39815 148308.0459 1980 1362.04981 146945.9961 1980 1367.72502 145578.271 March, 2026 236878.4221 986.9934 April, 2026 235885.4155 982.8559 May, 2026 234888.2714 978.7011 June, 2026 233886.9725 974.5291 July, 2026 232881.5016 970.3396 August, 2026 231871.8412 966.1327 September, 2026 230857.9738 961.9082 October, 2026 229839.882 957.6662 November, 2026 228817.5482 953.4065 December, 2026 227790.9547 949.129 January, 2027 226760.0836 944.8337 February, 2027 225724.9173 940.5205 March, 2027 224685.4378 936.1893 April, 2027 223641.6271 931.8401 May, 2027 222593.4673 927.4728 June, 2027 221540.94 923.0873 July, 2027 220484.0273 918.6834 August, 2027 219422.7107 914.2613 September, 2027 218356.972 909.8207 October, 2027 217286.7927 905.3616 November, 2027 216212.1544 900.884 December, 2027 215133.0384 896.3877 January, 2028 214049.426 891.8726 February, 2028 212961.2986 887.3387 March, 2028 211868.6374 882.786 April, 2028 210771.4234 878.2143 May, 2028 209669.6376 873.6235 June, 2028 208563.2611 869.0136 July, 2028 207452.2747 864.3845 August, 2028 206336.6592 859.7361 September, 2028 205216.3953 855.0683 October, 2028 204091.4636 850.3811 November, 2028 202961.8447 845.6744 December, 2028 201827.519 840.948 January, 2029 200688.467 836.2019 February, 2029 199544.669 831.4361 March, 2029 198396,1051 826.6504 April, 2029 197242.7555 821.8448 May, 2029 196084.6003 817.0192 June, 2029 194921.6195 812.1734 July, 2029 193753.7929 807.3075 August, 2029 192581.1004 802.4213 September, 2029 191403.5216 797.5147 October, 2029 190221.0363 792.5877 November, 2029 189033.624 787.6401 December, 2029 187841.2641 782.6719 January, 2030 186643.936 777,6831 February, 2030 185441.6191 772.6734 March, 2030 184234.2925 767.6429 April, 2030 183021.9354 762.5914 May, 2030 181804.5268 757.5189 June, 2030 180582.0456 752.4252 July, 2030 179354.4708 747.3103 August, 2030 178121.7811 742.1741 September, 2030 176883.9552 737.0165 October, 2030 175640.9717 731.8374 November, 2030 174392.8091 726.6367 December, 2030 173139.4458 721.4144 January, 2031 171880.8601 716.1703 February, 2031 170617.0304 710.9043 March, 2031 169347.9347 705.6164 April, 2031 168073.5511 700.3065 May, 2031 166793.8575 694.9744 June, 2031 165508.8319 689.6201 July, 2031 164218.4521 684.2436 August, 2031 162922.6956 678.8446 September, 2031 161621.5402 673.4231 October, 2031 160314.9633 667.979 November, 2031 159002.9423 662.5123 December, 2031 157685.4545 657.0227 January, 2032 156362.4773 651.5103 February, 2032 155033.9876 645.9749 March, 2032 153699.9625 640.4165 April, 2032 152360.379 634.8349 May, 2032 151015.214 629.2301 June, 2032 149664.444 623.6019 July, 2032 148308.0459 617.9502 August, 2032 146945.9961 612.275 117 118 119 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 155
F к 166 167 168 169 170 1980 1373.42387 144204.8472 1980 1379.14647 142825.7007 1980 1384.89291 141440.8078 1980 1390.6633 140050.1445 1980 1396.45773 138653.6868 1980 1402.27631 137251.4105 1980 1408.11912 135843.2913 1980 1413.98629 134429.305 1980 1419.8779 133009.4271 1980 1425.79405 131583.6331 1980 1431.73486 130151.8982 1980 1437.70042 128714.1978 1980 1443.69084 127270.507 1980 1449.70622 125820.8007 1980 1455.74666 124365.0541 1980 1461.81227 122903.2418 1980 1467.90316 121435.3386 1980 1474.01942 119961.3192 1980 1480.16117 118481.1581 1980 1486.32851 116994.8295 1980 1492.52154 115502 303 1980 1498.74038 114003.5676 1980 1504.98513 112498.5825 1980 1511.25591 110987.3266 . OWN 1980 1530.22543 106415.6724 1980 1543.00387 103336.0672 9 1980 1555.88902 100230.7451 1980 1562.3719 98668.37319 1980 1568.88178 97099.49141 1980 1575.41879 95524.07263 1980 1581.98303 93942.0896 191 192 1980 1595.19369 90758.32128 193 September, 2032 145578.271 606.5761 October, 2032 144204.8472 600.8535 November, 2032 142825.7007 595.1071 December, 2032 141440.8078 589.3367 January, 2033 140050.1445 583.5423 February, 2033 138653.6868 577.7237 March, 2033 137251.4105 571.8809 April, 2033 135843.2913 566.0137 May, 2033 134429.305 560.1221 June, 2033 133009.4271 554.2059 July, 2033 131583.6331 548.2651 August, 2033 130151.8982 542.2996 September, 2033 128714.1978 536.3092 October, 2033 127270.507 530.2938 November, 2033 125820.8007 524.2533 December, 2033 124365.0541 518.1877 January, 2034 122903.2418 512.0968 February, 2034 121435.3386 505.9806 March, 2034 119961.3192 499.8388 April, 2034 118481.1581 493.6715 May, 2034 116994.8295 487.4785 June, 2034 115502.308 481.2596 July, 2034 114003.5676 475.0149 August, 2034 112498,5825 468.7441 September, 2034 110987.3266 462.4472 October, 2034 109469.7738 456.1241 November, 2034 107945.8978 449.7746 December, 2034 106415.6724 443.3986 January, 2035 104879.071 436.9961 February, 2035 103336.0672 430.5669 March, 2035 101786.6341 424.111 April, 2035 1 00230.7451 417.6281 May, 2035 9 8668.37319 411.1182 June, 2035 97099.491 41 404,5812 July, 2035 95524.07263 398.017 August, 2035 93942.0896 391.4254 September, 2035 92353.51497 384.8063 October, 2035 90758.32128 378.1597 November, 2035 89156.48096 371.4853 December, 2035 87547.96629 364.7832 January, 2036 85932.74949 358.0531 February, 2036 84310.80261 351.295 March, 2036 82682.09762 344.5087 April, 2036 81046.60636 337.6942 May, 2036 79404.30055 330.8513 June, 2036 77755.1518 323.9798 July, 2036 76099.1316 317.0797 August, 2036 74436.21132 310.1509 September, 2036 72766.3622 303.1932 October, 2036 71089.55538 296.2065 November, 2036 69405.76186 289.1907 December, 2036 67714.95253 282.1456 January, 2037 66017.09817 275.0712 February, 2037 64312.16941 267.9674 March, 2037 62600.13678 260.8339 April, 2037 60880.97068 253.6707 May, 2037 59154.6414 246.4777 June, 2037 57421.11907 239.2547 July, 2037 55680.37373 232.0016 August, 2037 53932.37529 224.7182 September, 2037 52177.09352 217.4046 October, 2037 50414.49807 210.0604 November, 2037 48644.55848 202.6857 December, 2037 4686724414 195.2802 January, 2038 45082.52433 187.8439 February, 2038 43290.36818 180.3765 March, 2038 41490.74471 172.8781 April, 2038 39683.62282 165.3484 May, 2038 37868.97124 157.7874 June, 2038 36046.75862 150.1948 July, 2038 34216.95345 142.5706 August, 2038 32379.52409 134.9147 September, 2038 30534.43878 127.2268 October, 2038 28681.6656 119.5069 November, 2038 26821.17254 111.7549 December, 2038 24952.92743 103.9705 January, 2039 23076.89796 96.15374 February, 2039 21193.0517 88.30438 194 195 196 197 198 199 200 201 202 203 204 205 206 1980 1608.51466 87547.96629 1980 1615.21681 85932.74949 1980 1621.94688 84310.80261 207 209 208 210 211 NNNNNNNNNNNNNNNNNNNNNN WWW WNNNNNNNNNN OOO OON 1980 1635.49126 81046.60636 1980 1642.30581 79404.30055 1980 1649.14875 77755.1518 1980 1656.0202 76099.1316 1980 1662.92028 74436.21132 1980 1669.84912 72766.3622 1980 1676.80682 71089.55538 1980 1683.79352 69405.76186 1980 1690.80933 67714.95253 1980 1697.85436 66017.09817 1980 1704.92876 64312.16941 1980 1712.03263 62600.13678 1980 1719.1661 60880.97068 1980 1726.32929 59154.6414 1980 1733.52233 57421.11907 1980 1740.74534 55680.37373 1980 1747.99844 53932.37529 1980 1755.28177 52177.09352 1980 1762.59544 50414.49807 1980 1769.93959 48644.55848 1980 1777.31 434 46867.24414 1980 1784.71982 45082.52433 1980 1792.15615 43290.36818 1980 1799.62347 41490.74471 1980 1807.1219 39683.62282 1980 1814.65157 37868.97124 1980 1822.21262 36046.75862 1980 1829.80517 34216.95345 1980 1837.42936 32379.52409 1980 1845.08532 30534.43878 1980 1852.77317 28681.6656 1980 1860.49306 26821.17254 1980 1868.24511 24952.92743 1980 1876.02947 23076.89796 1980 1883.84626 21193.0517 1980 1891.69562 19301.35608
H I JK в C D E F G March, 2039 19301.35608 80.42232 1980 1899.57768 17401.7784 April, 2039 17401.7784 72.50741 1980 1907.49259 15494.28581 May, 2039 1 5494.28581 64.55952 1980 1915.44048 13578.84533 June, 2039 1 3578.84533 56.57852 1980 1923.421 48 11655.42386 July, 2039 11655.42386 48.56427 1980 1931.43573 9723.988123 1980 1939.48338 7784.50474 September, 2039 7784.50474 32.43544 1980 1947.56456 5836.940177 October, 2039 5836.940177 24.32058 1980 1955.67942 3881.260761 November, 2039 3881 260761 16.17192 1980 1963.82808 1917.432681 December, 2039 1917.432681 7.989303 1925.422 1917.43268 278 279 280 281 282 283 284 285 322222222 300 301 302 303 304 305 306 307 308 309 310 311