Please show me how to do the work. I have provided the answer but dont know how to do the work. please do work in excel and show answers.

3. Rental income starts at $100,000 in year one and grows by 2%. It is purchased at a 7.5% cap rate. Interest rate is 4.5% with monthly payments and amortized over 25 years. The sale will occur at the end of year five at a 7.5% cap rate. No closing costs. What is the IRR

0 4 6 Rent 110,408 Income Cap Rate Purchase Price Closing Costs growth of rent NNN lease 100,000 0.075 1,333,333.33 0 0.02 Debt Service 1 100,000 -62,253 37,747 20,676 2 102,000 -62,253 39,747 21,626 3 104,040 -62,253 41,787 22,620 106,121 -62,253 43,868 23,659 5 108,243 -62,253 45,990 24,746 Paydown Equity Increase 58,423 61,373 64,406 67,526 70,736 0.075 Terminal Cap Rate Sell 5 years Sale Mortgage 1,472,108 -820,007 Cash Flow -400,000 58,423 61,373 64,406 67,526 722,836 LTV Loan Interest Rate Term Compound t years 0.7 933,333 0.045 25 12 300 0.00375 5187.769794 r PMT IRR 23.68% Period 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 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 Begin 933,333 931,646 929,951 928,251 926,544 924,831 923,111 921,385 919,653 917,914 916,168 914,416 912,657 910,892 909, 120 907,341 905,556 903,764 901,965 900,160 898,348 896,529 894,703 892,871 891,031 889,185 887,331 885,471 883,604 881,730 879,848 877,960 876,064 874,162 872,252 870,335 868,411 866,480 864,542 862,596 860,643 858,683 856,715 854,740 852,757 850,767 848,770 846,765 844,753 842,733 840,705 838,670 836,627 834,577 832,519 830,453 828,379 826,298 824,209 822,112 PMT 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 Int 3,500 3,494 3,487 3,481 3,475 3,468 3,462 3,455 3,449 3,442 3,436 3,429 3,422 3,416 3,409 3,403 3,396 3,389 3,382 3,376 3,369 3,362 3,355 3,348 3,341 3,334 3,327 3,321 3,314 3,306 3,299 3,292 3,285 3,278 3,271 3,264 3,257 3,249 3,242 3,235 3,227 3,220 3,213 3,205 3,198 3,190 3,183 3,175 3,168 3,160 3,153 3,145 3,137 3,130 3,122 3,114 3,106 3,099 3,091 3,083 Prin 1,688 1,694 1,700 1,707 1,713 1,720 1,726 1,733 1,739 1,746 1,752 1,759 1,765 1,772 1,779 1,785 1,792 1,799 1,805 1,812 1,819 1,826 1,833 1,840 1,846 1,853 1,860 1,867 1,874 1,881 1,888 1,895 1,903 1,910 1,917 1,924 1,931 1,938 1,946 1,953 1,960 1,968 1,975 1,982 1,990 1,997 2,005 2,012 2,020 2,028 2,035 2,043 2,050 2,058 2,066 2,074 2,081 2,089 2,097 2,105 End 931,646 929,951 928,251 926,544 924,831 923,111 921,385 919,653 917,914 916,168 914,416 912,657 910,892 909,120 907,341 905,556 903,764 901,965 900, 160 898,348 896,529 894,703 892,871 891,031 889,185 887,331 885,471 883,604 881,730 879,848 877,960 876,064 874,162 872,252 870,335 868,411 866,480 864,542 862,596 860,643 858,683 56,715 854,740 852,757 850,767 848,770 846,765 844,753 842,733 840,705 838,670 836,627 834,577 832,519 830,453 828,379 826,298 824,209 822,112 820,007 0 4 6 Rent 110,408 Income Cap Rate Purchase Price Closing Costs growth of rent NNN lease 100,000 0.075 1,333,333.33 0 0.02 Debt Service 1 100,000 -62,253 37,747 20,676 2 102,000 -62,253 39,747 21,626 3 104,040 -62,253 41,787 22,620 106,121 -62,253 43,868 23,659 5 108,243 -62,253 45,990 24,746 Paydown Equity Increase 58,423 61,373 64,406 67,526 70,736 0.075 Terminal Cap Rate Sell 5 years Sale Mortgage 1,472,108 -820,007 Cash Flow -400,000 58,423 61,373 64,406 67,526 722,836 LTV Loan Interest Rate Term Compound t years 0.7 933,333 0.045 25 12 300 0.00375 5187.769794 r PMT IRR 23.68% Period 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 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 Begin 933,333 931,646 929,951 928,251 926,544 924,831 923,111 921,385 919,653 917,914 916,168 914,416 912,657 910,892 909, 120 907,341 905,556 903,764 901,965 900,160 898,348 896,529 894,703 892,871 891,031 889,185 887,331 885,471 883,604 881,730 879,848 877,960 876,064 874,162 872,252 870,335 868,411 866,480 864,542 862,596 860,643 858,683 856,715 854,740 852,757 850,767 848,770 846,765 844,753 842,733 840,705 838,670 836,627 834,577 832,519 830,453 828,379 826,298 824,209 822,112 PMT 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 5,188 Int 3,500 3,494 3,487 3,481 3,475 3,468 3,462 3,455 3,449 3,442 3,436 3,429 3,422 3,416 3,409 3,403 3,396 3,389 3,382 3,376 3,369 3,362 3,355 3,348 3,341 3,334 3,327 3,321 3,314 3,306 3,299 3,292 3,285 3,278 3,271 3,264 3,257 3,249 3,242 3,235 3,227 3,220 3,213 3,205 3,198 3,190 3,183 3,175 3,168 3,160 3,153 3,145 3,137 3,130 3,122 3,114 3,106 3,099 3,091 3,083 Prin 1,688 1,694 1,700 1,707 1,713 1,720 1,726 1,733 1,739 1,746 1,752 1,759 1,765 1,772 1,779 1,785 1,792 1,799 1,805 1,812 1,819 1,826 1,833 1,840 1,846 1,853 1,860 1,867 1,874 1,881 1,888 1,895 1,903 1,910 1,917 1,924 1,931 1,938 1,946 1,953 1,960 1,968 1,975 1,982 1,990 1,997 2,005 2,012 2,020 2,028 2,035 2,043 2,050 2,058 2,066 2,074 2,081 2,089 2,097 2,105 End 931,646 929,951 928,251 926,544 924,831 923,111 921,385 919,653 917,914 916,168 914,416 912,657 910,892 909,120 907,341 905,556 903,764 901,965 900, 160 898,348 896,529 894,703 892,871 891,031 889,185 887,331 885,471 883,604 881,730 879,848 877,960 876,064 874,162 872,252 870,335 868,411 866,480 864,542 862,596 860,643 858,683 56,715 854,740 852,757 850,767 848,770 846,765 844,753 842,733 840,705 838,670 836,627 834,577 832,519 830,453 828,379 826,298 824,209 822,112 820,007