Spreadsheet: 800699d1665816156-look-up-cell-numbers-and-sum-in-between-lookup-cell-and-sum
Sheet: Sheet2

Begin | 2022-09-01 00:00:00
End | 2023-09-01 00:00:00 |  | The date always changed.  Example: Change cell B5 to 05/1/2023, the cell M10 will be $13,275
 |  |  | Need a formula if the cell B5 changed to whatever date, the sum on cell M10 will be changed corrodingly.
 |  | PV | Incremental borrowing rate |  | Interest | Principal |  | Monthly Rent Payment | Liabilities | Amortization | Asset | Expenses
2022-04-01 00:00:00 | 1 | 108297.7534556488 | 0.9975062344139651 | 2992.518703241895 | 270.744383639122 | 2729.255616360878 |  | 3000 | 105568.4978392879 | 2881.755616360878 | 105415.9978392879
2022-05-01 00:00:00 | 2 | 105568.4978392879 | 0.9950186876947283 | 2985.056063084185 | 263.9212445982197 | 2736.07875540178 |  | 3000 | 102832.4190838861 | 2888.57875540178 | 102527.4190838861
2022-06-01 00:00:00 | 3 | 102832.4190838861 | 0.9925373443338937 | 2977.612033001681 | 257.0810477097153 | 2742.918952290285 |  | 3000 | 100089.5001315959 | 2895.418952290285 | 99632.00013159585
2022-07-01 00:00:00 | 4 | 100089.5001315959 | 0.9900621888617394 | 2970.186566585218 | 250.2237503289896 | 2749.77624967101 |  | 3000 | 97339.72388192485 | 2902.27624967101 | 96729.72388192485
2022-08-01 00:00:00 | 5 | 97339.72388192485 | 0.9875932058471215 | 2962.779617541365 | 243.3493097048121 | 2756.650690295188 |  | 3000 | 94583.07319162966 | 2909.150690295188 | 93820.57319162966
2022-09-01 00:00:00 | 6 | 94583.07319162966 | 0.9851303798973783 | 2955.391139692135 | 236.4576829790742 | 2763.542317020926 |  | 3000 | 91819.53087460874 | 2916.042317020926 | 90904.53087460874
2022-10-01 00:00:00 | 7 | 91819.53087460874 | 0.9826736956582328 | 2948.021086974698 | 229.5488271865218 | 2770.451172813478 |  | 3000 | 89049.07970179526 | 2922.951172813478 | 87981.57970179526
2022-11-01 00:00:00 | 8 | 89049.07970179526 | 0.9802231378136985 | 2940.669413441095 | 222.6226992544881 | 2777.377300745512 |  | 3000 | 86271.70240104974 | 2929.877300745512 | 85051.70240104974
2022-12-01 00:00:00 | 9 | 86271.70240104974 | 0.9777786910859835 | 2933.33607325795 | 215.6792560026244 | 2784.320743997376 |  | 3000 | 83487.38165705236 | 2936.820743997376 | 82114.88165705236
2023-01-01 00:00:00 | 10 | 83487.38165705236 | 0.9753403402353952 | 2926.021020706185 | 208.7184541426309 | 2791.281545857369 |  | 3000 | 80696.10011119499 | 2943.781545857369 | 79171.10011119499
2023-02-01 00:00:00 | 11 | 80696.10011119499 | 0.9729080700602447 | 2918.724210180734 | 201.7402502779875 | 2798.259749722013 |  | 3000 | 77897.84036147298 | 2950.759749722013 | 76220.34036147298
2023-03-01 00:00:00 | 12 | 77897.84036147298 | 0.9704818653967527 | 2911.445596190258 | 194.7446009036824 | 2805.255399096317 |  | 3000 | 75092.58496237666 | 2957.755399096317 | 73262.58496237666
2023-04-01 00:00:00 | 13 | 75092.58496237666 | 0.9680617111189552 | 3049.394390024709 | 187.7314624059416 | 2962.268537594058 |  | 3150 | 72130.31642478259 | 2964.768537594058 | 70297.81642478259
2023-05-01 00:00:00 | 14 | 72130.31642478259 | 0.965647592138609 | 3041.789915236618 | 180.3257910619565 | 2969.674208938044 |  | 3150 | 69160.64221584455 | 2972.174208938044 | 67325.64221584455
2023-06-01 00:00:00 | 15 | 69160.64221584455 | 0.9632394934050964 | 3034.204404226054 | 172.9016055396114 | 2977.098394460389 |  | 3150 | 66183.54382138416 | 2979.598394460389 | 64346.04382138416
2023-07-01 00:00:00 | 16 | 66183.54382138416 | 0.9608373999053329 | 3026.637809701799 | 165.4588595534604 | 2984.541140446539 |  | 3150 | 63199.00268093761 | 2987.041140446539 | 61359.00268093762
2023-08-01 00:00:00 | 17 | 63199.00268093761 | 0.9584412966636738 | 3019.090084490573 | 157.997506702344 | 2992.002493297656 |  | 3150 | 60207.00018763996 | 2994.502493297656 | 58364.50018763996
2023-09-01 00:00:00 | 18 | 60207.00018763996 | 0.9560511687418192 | 3011.561181536731 | 150.5175004690999 | 2999.4824995309 |  | 3150 | 57207.51768810906 | 3001.9824995309 | 55362.51768810906
2023-10-01 00:00:00 | 19 | 57207.51768810906 | 0.9536670012387226 | 3004.051053901976 | 143.0187942202726 | 3006.981205779727 |  | 3150 | 54200.53648232933 | 3009.481205779727 | 52353.03648232933
2023-11-01 00:00:00 | 20 | 54200.53648232933 | 0.9512887792904963 | 2996.559654765063 | 135.5013412058233 | 3014.498658794177 |  | 3150 | 51186.03782353516 | 3016.998658794177 | 49336.03782353516
2023-12-01 00:00:00 | 21 | 51186.03782353516 | 0.9489164880703206 | 2989.08693742151 | 127.9650945588379 | 3022.034905441162 |  | 3150 | 48164.002918094 | 3024.534905441162 | 46311.502918094
2024-01-01 00:00:00 | 22 | 48164.002918094 | 0.9465501127883499 | 2981.632855283302 | 120.410007295235 | 3029.589992704765 |  | 3150 | 45134.41292538923 | 3032.089992704765 | 43279.41292538923
2024-02-01 00:00:00 | 23 | 45134.41292538923 | 0.9441896386916208 | 2974.197361878606 | 112.8360323134731 | 3037.163967686527 |  | 3150 | 42097.2489577027 | 3039.663967686527 | 40239.7489577027