Irr Calculation
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Irr Calculation as PDF for free.
More details
- Words: 1,063
- Pages: 7
Cost Security Deposit Residual value Net Financing amount Insurance premium Monthly Payment IRR
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
50%
5,000,000 2,500,000 2,500,000 2,500,000 p.a. 86,663 In arrear
15%
Mark up Principle Installement Insurance 31,250 55,413 86,663 30,557 56,106 86,663 29,856 56,807 86,663 29,146 57,517 86,663 28,427 58,236 86,663 27,699 58,964 86,663 26,962 59,701 86,663 26,216 60,448 86,663 25,460 61,203 86,663 24,695 61,968 86,663 23,920 62,743 86,663 23,136 63,527 86,663 22,342 64,321 86,663 21,538 65,125 86,663 20,724 65,939 86,663 19,900 66,764 86,663 19,065 67,598 86,663 18,220 68,443 86,663 17,365 69,299 86,663 16,498 70,165 86,663 15,621 71,042 86,663 14,733 71,930 86,663 13,834 72,829 86,663 12,924 73,739 86,663 12,002 74,661 86,663 11,069 75,594 86,663 10,124 76,539 86,663 9,167 77,496 86,663 8,198 78,465 86,663 7,218 79,446 86,663 6,225 80,439 86,663 5,219 81,444 86,663 4,201 82,462 86,663 3,170 83,493 86,663 2,127 84,537 86,663 1,070 85,593 86,663
Instt. With Ins. Principle o/s 2,444,587 2,388,481 2,331,673 2,274,156 2,215,920 2,156,955 2,097,254 2,036,806 1,975,603 1,913,635 1,850,892 1,787,365 1,723,043 1,657,918 1,591,979 1,525,215 1,457,617 1,389,174 1,319,875 1,249,710 1,178,668 1,106,739 1,033,909 960,170 885,509 809,914 733,375 655,879 577,414 497,968 417,530 336,085 253,623 170,130 85,593 0
Cost Security Deposit Residual value Net Financing amount Insurance premium Monthly Payment IRR
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
50%
4.25%
6,500,000 1,600,000 1,600,000 4,900,000 p.a. 170,003 In advance
16%
Mark up Principle Installement Insurance 63,067 106,936 170,003 61,641 108,362 170,003 60,196 109,807 170,003 58,732 111,271 170,003 57,248 112,754 170,003 55,745 114,258 170,003 54,221 115,781 170,003 52,678 117,325 170,003 51,113 118,889 170,003 49,528 120,475 170,003 47,922 122,081 170,003 46,294 123,709 170,003 44,645 125,358 170,003 42,973 127,030 170,003 41,279 128,723 170,003 39,563 130,440 170,003 37,824 132,179 170,003 36,062 133,941 170,003 34,276 135,727 170,003 32,466 137,537 170,003 30,632 139,371 170,003 28,774 141,229 170,003 26,891 143,112 170,003 24,983 145,020 170,003 23,049 146,954 170,003 21,090 148,913 170,003 19,104 150,899 170,003 17,092 152,911 170,003 15,053 154,949 170,003 12,987 157,015 170,003 10,894 159,109 170,003 8,772 161,230 170,003 6,623 163,380 170,003 4,444 165,558 170,003 2,237 167,766 170,003
Instt. With Ins. Principle o/s 4,623,061 4,514,699 4,404,892 4,293,622 4,180,867 4,066,609 3,950,828 3,833,503 3,714,613 3,594,139 3,472,058 3,348,349 3,222,991 3,095,962 2,967,238 2,836,799 2,704,620 2,570,679 2,434,952 2,297,415 2,158,045 2,016,816 1,873,704 1,728,684 1,581,730 1,432,817 1,281,919 1,129,008 974,059 817,043 657,935 496,704 333,324 167,766 0
1,220,099
###
Advance Payment Security Deposit Ist Rental Ist Year Insurance Documentation Charges
5,950,097
-
1,600,000 170,003 276,250 4,500 2,050,753
276,250
-
2,050,753
Cost Security Deposit Residual value Net Financing amount
50%
Insurance premium Monthly Payment IRR
4.25% 86,663
p.a. In advance
212,500.00
15.00%
Mark up 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
5,000,000 2,500,000 2,500,000 2,500,000
30,167 30,544 29,842 29,132 28,413 27,685 26,948 26,201 25,445 24,680 23,905 23,121 22,327 21,522 20,708 19,884 19,049 18,204 17,348 16,482 15,604 14,716 13,817 12,906 11,984 11,051 10,105 9,148 8,180 7,199 6,205 5,199 4,181 3,150 2,106 1,049
Principle Installement Insurance Instt. With Ins. Principle o/s 56,497 86,663 16,380 103,044 2,443,503 56,120 86,663 16,380 103,044 2,387,384 56,821 86,663 16,380 103,044 2,330,563 57,531 86,663 16,380 103,044 2,273,032 58,250 86,663 16,380 103,044 2,214,781 58,979 86,663 16,380 103,044 2,155,803 59,716 86,663 16,380 103,044 2,096,087 60,462 86,663 16,380 103,044 2,035,625 61,218 86,663 16,380 103,044 1,974,407 61,983 86,663 16,380 103,044 1,912,423 62,758 86,663 16,380 103,044 1,849,665 63,543 86,663 16,380 103,044 1,786,123 64,337 86,663 16,380 103,044 1,721,786 65,141 86,663 16,380 103,044 1,656,645 65,955 86,663 16,380 103,044 1,590,690 66,780 86,663 16,380 103,044 1,523,910 67,614 86,663 16,380 103,044 1,456,296 68,460 86,663 16,380 103,044 1,387,836 69,315 86,663 16,380 103,044 1,318,521 70,182 86,663 16,380 103,044 1,248,339 71,059 86,663 16,380 103,044 1,177,280 71,947 86,663 16,380 103,044 1,105,332 72,847 86,663 16,380 103,044 1,032,486 73,757 86,663 16,380 103,044 958,728 74,679 86,663 16,380 103,044 884,049 75,613 86,663 16,380 103,044 808,436 76,558 86,663 16,380 103,044 731,879 77,515 86,663 16,380 103,044 654,364 78,484 86,663 16,380 103,044 575,880 79,465 86,663 16,380 103,044 496,415 80,458 86,663 16,380 103,044 415,957 81,464 86,663 16,380 103,044 334,493 82,482 86,663 16,380 103,044 252,011 83,513 86,663 16,380 103,044 168,498 84,557 86,663 16,380 103,044 83,941 85,614 86,663 16,380 103,044 (1,673)
618,206 Advance Payment Security Deposit Ist Rental Ist Year Insurance
2,501,673
3,119,880
589,688
2,500,000 103,044
3,709,567
Documentation Charges
3,000 2,606,044
6,315,611 TOTAL
Cost Security Deposit Residual value Net Financing amount
20%
Insurance premium Monthly Payment IRR
4.25% 29,748
p.a. In advance
39,950.00
24.62%
Mark up 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
940,000 188,000 188,000 752,000
15,428 15,134 14,834 14,528 14,216 13,897 13,572 13,240 12,902 12,556 12,203 11,843 11,476 11,101 10,719 10,328 9,930 9,523 9,108 8,685 8,253 7,812 7,362 6,902 6,434 5,955 5,467 4,969 4,461 3,942 3,413 2,872 2,321 1,758 1,184 598
Principle Installement Insurance Instt. With Ins. Principle o/s 14,320 29,748 3,079 32,827 737,680 14,614 29,748 3,079 32,827 723,066 14,914 29,748 3,079 32,827 708,152 15,220 29,748 3,079 32,827 692,932 15,532 29,748 3,079 32,827 677,400 15,851 29,748 3,079 32,827 661,550 16,176 29,748 3,079 32,827 645,374 16,508 29,748 3,079 32,827 628,866 16,846 29,748 3,079 32,827 612,020 17,192 29,748 3,079 32,827 594,828 17,545 29,748 3,079 32,827 577,283 17,905 29,748 3,079 32,827 559,378 18,272 29,748 3,079 32,827 541,106 18,647 29,748 3,079 32,827 522,460 19,029 29,748 3,079 32,827 503,430 19,420 29,748 3,079 32,827 484,010 19,818 29,748 3,079 32,827 464,192 20,225 29,748 3,079 32,827 443,967 20,640 29,748 3,079 32,827 423,328 21,063 29,748 3,079 32,827 402,265 21,495 29,748 3,079 32,827 380,769 21,936 29,748 3,079 32,827 358,833 22,386 29,748 3,079 32,827 336,447 22,846 29,748 3,079 32,827 313,601 23,314 29,748 3,079 32,827 290,287 23,793 29,748 3,079 32,827 266,494 24,281 29,748 3,079 32,827 242,214 24,779 29,748 3,079 32,827 217,435 25,287 29,748 3,079 32,827 192,148 25,806 29,748 3,079 32,827 166,342 26,335 29,748 3,079 32,827 140,006 26,876 29,748 3,079 32,827 113,131 27,427 29,748 3,079 32,827 85,704 27,990 29,748 3,079 32,827 57,714 28,564 29,748 3,079 32,827 29,150 29,150 29,748 3,079 32,827 (0)
318,928 Advance Payment Security Deposit Ist Rental Ist Year Insurance
752,000
1,070,928
110,861
188,000 32,827
1,181,789
Documentation Charges
3,000 223,827
1,405,617 TOTAL
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
50%
5,000,000 2,500,000 2,500,000 2,500,000 p.a. 86,663 In arrear
15%
Mark up Principle Installement Insurance 31,250 55,413 86,663 30,557 56,106 86,663 29,856 56,807 86,663 29,146 57,517 86,663 28,427 58,236 86,663 27,699 58,964 86,663 26,962 59,701 86,663 26,216 60,448 86,663 25,460 61,203 86,663 24,695 61,968 86,663 23,920 62,743 86,663 23,136 63,527 86,663 22,342 64,321 86,663 21,538 65,125 86,663 20,724 65,939 86,663 19,900 66,764 86,663 19,065 67,598 86,663 18,220 68,443 86,663 17,365 69,299 86,663 16,498 70,165 86,663 15,621 71,042 86,663 14,733 71,930 86,663 13,834 72,829 86,663 12,924 73,739 86,663 12,002 74,661 86,663 11,069 75,594 86,663 10,124 76,539 86,663 9,167 77,496 86,663 8,198 78,465 86,663 7,218 79,446 86,663 6,225 80,439 86,663 5,219 81,444 86,663 4,201 82,462 86,663 3,170 83,493 86,663 2,127 84,537 86,663 1,070 85,593 86,663
Instt. With Ins. Principle o/s 2,444,587 2,388,481 2,331,673 2,274,156 2,215,920 2,156,955 2,097,254 2,036,806 1,975,603 1,913,635 1,850,892 1,787,365 1,723,043 1,657,918 1,591,979 1,525,215 1,457,617 1,389,174 1,319,875 1,249,710 1,178,668 1,106,739 1,033,909 960,170 885,509 809,914 733,375 655,879 577,414 497,968 417,530 336,085 253,623 170,130 85,593 0
Cost Security Deposit Residual value Net Financing amount Insurance premium Monthly Payment IRR
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
50%
4.25%
6,500,000 1,600,000 1,600,000 4,900,000 p.a. 170,003 In advance
16%
Mark up Principle Installement Insurance 63,067 106,936 170,003 61,641 108,362 170,003 60,196 109,807 170,003 58,732 111,271 170,003 57,248 112,754 170,003 55,745 114,258 170,003 54,221 115,781 170,003 52,678 117,325 170,003 51,113 118,889 170,003 49,528 120,475 170,003 47,922 122,081 170,003 46,294 123,709 170,003 44,645 125,358 170,003 42,973 127,030 170,003 41,279 128,723 170,003 39,563 130,440 170,003 37,824 132,179 170,003 36,062 133,941 170,003 34,276 135,727 170,003 32,466 137,537 170,003 30,632 139,371 170,003 28,774 141,229 170,003 26,891 143,112 170,003 24,983 145,020 170,003 23,049 146,954 170,003 21,090 148,913 170,003 19,104 150,899 170,003 17,092 152,911 170,003 15,053 154,949 170,003 12,987 157,015 170,003 10,894 159,109 170,003 8,772 161,230 170,003 6,623 163,380 170,003 4,444 165,558 170,003 2,237 167,766 170,003
Instt. With Ins. Principle o/s 4,623,061 4,514,699 4,404,892 4,293,622 4,180,867 4,066,609 3,950,828 3,833,503 3,714,613 3,594,139 3,472,058 3,348,349 3,222,991 3,095,962 2,967,238 2,836,799 2,704,620 2,570,679 2,434,952 2,297,415 2,158,045 2,016,816 1,873,704 1,728,684 1,581,730 1,432,817 1,281,919 1,129,008 974,059 817,043 657,935 496,704 333,324 167,766 0
1,220,099
###
Advance Payment Security Deposit Ist Rental Ist Year Insurance Documentation Charges
5,950,097
-
1,600,000 170,003 276,250 4,500 2,050,753
276,250
-
2,050,753
Cost Security Deposit Residual value Net Financing amount
50%
Insurance premium Monthly Payment IRR
4.25% 86,663
p.a. In advance
212,500.00
15.00%
Mark up 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
5,000,000 2,500,000 2,500,000 2,500,000
30,167 30,544 29,842 29,132 28,413 27,685 26,948 26,201 25,445 24,680 23,905 23,121 22,327 21,522 20,708 19,884 19,049 18,204 17,348 16,482 15,604 14,716 13,817 12,906 11,984 11,051 10,105 9,148 8,180 7,199 6,205 5,199 4,181 3,150 2,106 1,049
Principle Installement Insurance Instt. With Ins. Principle o/s 56,497 86,663 16,380 103,044 2,443,503 56,120 86,663 16,380 103,044 2,387,384 56,821 86,663 16,380 103,044 2,330,563 57,531 86,663 16,380 103,044 2,273,032 58,250 86,663 16,380 103,044 2,214,781 58,979 86,663 16,380 103,044 2,155,803 59,716 86,663 16,380 103,044 2,096,087 60,462 86,663 16,380 103,044 2,035,625 61,218 86,663 16,380 103,044 1,974,407 61,983 86,663 16,380 103,044 1,912,423 62,758 86,663 16,380 103,044 1,849,665 63,543 86,663 16,380 103,044 1,786,123 64,337 86,663 16,380 103,044 1,721,786 65,141 86,663 16,380 103,044 1,656,645 65,955 86,663 16,380 103,044 1,590,690 66,780 86,663 16,380 103,044 1,523,910 67,614 86,663 16,380 103,044 1,456,296 68,460 86,663 16,380 103,044 1,387,836 69,315 86,663 16,380 103,044 1,318,521 70,182 86,663 16,380 103,044 1,248,339 71,059 86,663 16,380 103,044 1,177,280 71,947 86,663 16,380 103,044 1,105,332 72,847 86,663 16,380 103,044 1,032,486 73,757 86,663 16,380 103,044 958,728 74,679 86,663 16,380 103,044 884,049 75,613 86,663 16,380 103,044 808,436 76,558 86,663 16,380 103,044 731,879 77,515 86,663 16,380 103,044 654,364 78,484 86,663 16,380 103,044 575,880 79,465 86,663 16,380 103,044 496,415 80,458 86,663 16,380 103,044 415,957 81,464 86,663 16,380 103,044 334,493 82,482 86,663 16,380 103,044 252,011 83,513 86,663 16,380 103,044 168,498 84,557 86,663 16,380 103,044 83,941 85,614 86,663 16,380 103,044 (1,673)
618,206 Advance Payment Security Deposit Ist Rental Ist Year Insurance
2,501,673
3,119,880
589,688
2,500,000 103,044
3,709,567
Documentation Charges
3,000 2,606,044
6,315,611 TOTAL
Cost Security Deposit Residual value Net Financing amount
20%
Insurance premium Monthly Payment IRR
4.25% 29,748
p.a. In advance
39,950.00
24.62%
Mark up 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
940,000 188,000 188,000 752,000
15,428 15,134 14,834 14,528 14,216 13,897 13,572 13,240 12,902 12,556 12,203 11,843 11,476 11,101 10,719 10,328 9,930 9,523 9,108 8,685 8,253 7,812 7,362 6,902 6,434 5,955 5,467 4,969 4,461 3,942 3,413 2,872 2,321 1,758 1,184 598
Principle Installement Insurance Instt. With Ins. Principle o/s 14,320 29,748 3,079 32,827 737,680 14,614 29,748 3,079 32,827 723,066 14,914 29,748 3,079 32,827 708,152 15,220 29,748 3,079 32,827 692,932 15,532 29,748 3,079 32,827 677,400 15,851 29,748 3,079 32,827 661,550 16,176 29,748 3,079 32,827 645,374 16,508 29,748 3,079 32,827 628,866 16,846 29,748 3,079 32,827 612,020 17,192 29,748 3,079 32,827 594,828 17,545 29,748 3,079 32,827 577,283 17,905 29,748 3,079 32,827 559,378 18,272 29,748 3,079 32,827 541,106 18,647 29,748 3,079 32,827 522,460 19,029 29,748 3,079 32,827 503,430 19,420 29,748 3,079 32,827 484,010 19,818 29,748 3,079 32,827 464,192 20,225 29,748 3,079 32,827 443,967 20,640 29,748 3,079 32,827 423,328 21,063 29,748 3,079 32,827 402,265 21,495 29,748 3,079 32,827 380,769 21,936 29,748 3,079 32,827 358,833 22,386 29,748 3,079 32,827 336,447 22,846 29,748 3,079 32,827 313,601 23,314 29,748 3,079 32,827 290,287 23,793 29,748 3,079 32,827 266,494 24,281 29,748 3,079 32,827 242,214 24,779 29,748 3,079 32,827 217,435 25,287 29,748 3,079 32,827 192,148 25,806 29,748 3,079 32,827 166,342 26,335 29,748 3,079 32,827 140,006 26,876 29,748 3,079 32,827 113,131 27,427 29,748 3,079 32,827 85,704 27,990 29,748 3,079 32,827 57,714 28,564 29,748 3,079 32,827 29,150 29,150 29,748 3,079 32,827 (0)
318,928 Advance Payment Security Deposit Ist Rental Ist Year Insurance
752,000
1,070,928
110,861
188,000 32,827
1,181,789
Documentation Charges
3,000 223,827
1,405,617 TOTAL
Related Documents
Irr Calculation
June 2020 15
Irr
August 2019 20
Irr
November 2019 19
Irr
August 2019 19
Irr Bp220
December 2019 15
Calculation
May 2020 31More Documents from ""
Ias 33 Eps
June 2020 16
The Rope
June 2020 18
Fixed Assets Ias 16
June 2020 21
Introduction To Financial Statements And Audit
June 2020 15
Irr Calculation
June 2020 15