Spreadsheet: 889956d1741025633-if-statement-works-except-for-the-last-row-copy
Sheet: Sheet1

PAYMENT CALCULATOR |  |  |  | Date Due | Payment No | Payment Amt | Interest | Principal | [NAME] | Loan | Comments
 |  |  |  | PAYMENT SCHEDULE
SUMMARY INFORMATION
Loan Amount $ | 265845.41 |  |  | Date | Payment No | Payment Amt | Interest | Principal | [NAME] | Loan
Annual Interest Rate | 0.04
Life of Loan (in years) | 10
Number of Payments per Year | 12 |  |  |  |  |  |  |  |  | Balance
Total Number of Payments
Payments per Period |  |  |  | 2022-02-01 00:00:00 | 1 |  |  |  |  |  | Inv #36 pd, [NAME]
Sum of Payments |  |  |  | 2022-03-01 00:00:00 | 2 |  |  |  |  |  | Inv #38 pd, trf [NAME]
Interest Costs |  |  |  | 2022-04-01 00:00:00 | 3 |  |  |  |  |  | Inv #39 pd, trf IN410
 |  |  |  | 2022-05-01 00:00:00 | 4 |  |  |  |  |  | Inv #41 pd, trf LQ345
 |  |  |  | 2022-06-01 00:00:00 | 5 |  |  |  |  |  | Inv #43 pd, trf WY104
 |  |  |  | 2022-07-01 00:00:00 | 6 |  |  |  |  |  | Inv #   pd, trf
 |  |  |  | 2022-08-01 00:00:00 | 7
 |  |  |  | 2022-09-01 00:00:00 | 8
 |  |  |  | 2022-10-01 00:00:00 | 9
 |  |  |  | 2022-11-01 00:00:00 | 10
 |  |  |  | 2022-12-01 00:00:00 | 11
 |  |  |  | 2023-01-01 00:00:00 | 12
 |  |  |  | 2023-02-01 00:00:00 | 13
 |  |  |  | 2023-03-01 00:00:00 | 14
 |  |  |  | 2023-04-01 00:00:00 | 15 |  |  |  | 20000 |  | pd $20,000.00 extra principal
 |  |  |  | 2023-05-01 00:00:00 | 16
 |  |  |  | 2023-06-01 00:00:00 | 17 |  |  |  | 20000 |  | pd $20,000.00 extra principal
 |  |  |  | 2023-07-01 00:00:00 | 18 |  |  |  | 20000 |  | pd $20,000.00 extra principal |  |  | chq# 8764
 |  |  |  | 2023-08-01 00:00:00 | 19 |  |  |  | 40000 |  | pd $20,000.00 extra principal |  |  | chq# 8789
 |  |  |  | 2023-09-01 00:00:00 | 20 |  |  |  | 20000 |  | pd $40,000.00 extra principal |  |  | chq# 8805
 |  |  |  | 2023-10-01 00:00:00 | 21 |  |  |  | 20000 |  | pd $20,000.00 extra principal |  |  | chq# 8833
 |  |  |  | 2023-11-01 00:00:00 | 22
 |  |  |  | 2023-12-01 00:00:00 | 23 |  |  |  | 40000 |  | pd $40000 extra principal Dec 1 chq
 |  |  |  | 2024-01-01 00:00:00 | 24 |  |  |  |  |  | pd chq # 8911 Jan 1 2024
 |  |  |  | 2024-02-01 00:00:00 | 25 |  |  |  |  |  | e-transfer jan 31
 |  |  |  | 2024-03-01 00:00:00 | 26 |  |  |  |  |  | e-transfer March 4
 |  |  |  | 2024-04-01 00:00:00 | 27 |  |  |  |  |  | e-transfer Apr 1
 |  |  |  | 2024-05-01 00:00:00 | 28 |  |  |  |  |  | e-transfer May 2
 |  |  |  | 2024-06-01 00:00:00 | 29 |  |  |  |  |  | e-transfer June 3
 |  |  |  | 2024-07-01 00:00:00 | 30 |  |  |  |  |  | e-transfer June 28-24
 |  |  |  | 2024-08-01 00:00:00 | 31 |  |  |  |  |  | e-transfer July 31-24
 |  |  |  | 2024-09-01 00:00:00 | 32 |  |  |  |  |  | e-transfer Aug 30-24
 |  |  |  | 2024-10-01 00:00:00 | 33 |  |  |  |  |  | e-transfer Oct 1-24
 |  |  |  | 2024-11-01 00:00:00 | 34 |  |  |  |  |  | e-transfer Nov 1-24
 |  |  |  | 2024-12-01 00:00:00 | 35 |  |  |  |  |  | e-transfer Dec 2-24
 |  |  |  | 2025-01-01 00:00:00 | 36 |  |  |  |  |  | e-transfer Dec 20-24
 |  |  |  | 2025-02-01 00:00:00 | 37
 |  |  |  | 2025-03-01 00:00:00 | 38
 |  |  |  | 2025-04-01 00:00:00 | 39
 |  |  |  | 2025-05-01 00:00:00 | 40
 |  |  |  | 2025-06-01 00:00:00 | 41
 |  |  |  | 2025-07-01 00:00:00 | 42
 |  |  |  | 2025-08-01 00:00:00 | 43
 |  |  |  | 2025-09-01 00:00:00 | 44
 |  |  |  | 2025-10-01 00:00:00 | 45
 |  |  |  | 2025-11-01 00:00:00 | 46
 |  |  |  | 2025-12-01 00:00:00 | 47
 |  |  |  | 2026-01-01 00:00:00 | 48
 |  |  |  | 2026-02-01 00:00:00 | 49
 |  |  |  | 2026-03-01 00:00:00 | 50
 |  |  |  | 2026-04-01 00:00:00 | 51
 |  |  |  | 2026-05-01 00:00:00 | 52
 |  |  |  | 2026-06-01 00:00:00 | 53
 |  |  |  | 2026-07-01 00:00:00 | 54
 |  |  |  | 2026-08-01 00:00:00 | 55
 |  |  |  | 2026-09-01 00:00:00 | 56
 |  |  |  | 2026-10-01 00:00:00 | 57
 |  |  |  | 2026-11-01 00:00:00 | 58
 |  |  |  | 2026-12-01 00:00:00 | 59
 |  |  |  | 2027-01-01 00:00:00 | 60
 |  |  |  | 2027-02-01 00:00:00 | 61
 |  |  |  | 2027-03-01 00:00:00 | 62
 |  |  |  | 2027-04-01 00:00:00 | 63
 |  |  |  | 2027-05-01 00:00:00 | 64
 |  |  |  | 2027-06-01 00:00:00 | 65
 |  |  |  | 2027-07-01 00:00:00 | 66
 |  |  |  | 2027-08-01 00:00:00 | 67
 |  |  |  | 2027-09-01 00:00:00 | 68
 |  |  |  | 2027-10-01 00:00:00 | 69
 |  |  |  | 2027-11-01 00:00:00 | 70
 |  |  |  | 2027-12-01 00:00:00 | 71
 |  |  |  | 2028-01-01 00:00:00 | 72
 |  |  |  | 2028-02-01 00:00:00 | 73
 |  |  |  | 2028-03-01 00:00:00 | 74
 |  |  |  | 2028-04-01 00:00:00 | 75
 |  |  |  | 2028-05-01 00:00:00 | 76
 |  |  |  | 2028-06-01 00:00:00 | 77
 |  |  |  | 2028-07-01 00:00:00 | 78
 |  |  |  | 2028-08-01 00:00:00 | 79
 |  |  |  | 2028-09-01 00:00:00 | 80
 |  |  |  | 2028-10-01 00:00:00 | 81
 |  |  |  | 2028-11-01 00:00:00 | 82
 |  |  |  | 2028-12-01 00:00:00 | 83
 |  |  |  | 2029-01-01 00:00:00 | 84
 |  |  |  | 2029-02-01 00:00:00 | 85
 |  |  |  | 2029-03-01 00:00:00 | 86
 |  |  |  | 2029-04-01 00:00:00 | 87
 |  |  |  | 2029-05-01 00:00:00 | 88
 |  |  |  | 2029-06-01 00:00:00 | 89
 |  |  |  | 2029-07-01 00:00:00 | 90
 |  |  |  | 2029-08-01 00:00:00 | 91
 |  |  |  | 2029-09-01 00:00:00 | 92
 |  |  |  | 2029-10-01 00:00:00 | 93
 |  |  |  | 2029-11-01 00:00:00 | 94
 |  |  |  | 2029-12-01 00:00:00 | 95
 |  |  |  | 2030-01-01 00:00:00 | 96
 |  |  |  | 2030-02-01 00:00:00 | 97
 |  |  |  | 2030-03-01 00:00:00 | 98
 |  |  |  | 2030-04-01 00:00:00 | 99
 |  |  |  | 2030-05-01 00:00:00 | 100
 |  |  |  | 2030-06-01 00:00:00 | 101
 |  |  |  | 2030-07-01 00:00:00 | 102
 |  |  |  | 2030-08-01 00:00:00 | 103
 |  |  |  | 2030-09-01 00:00:00 | 104
 |  |  |  | 2030-10-01 00:00:00 | 105
 |  |  |  | 2030-11-01 00:00:00 | 106
 |  |  |  | 2030-12-01 00:00:00 | 107
 |  |  |  | 2031-01-01 00:00:00 | 108
 |  |  |  | 2031-02-01 00:00:00 | 109
 |  |  |  | 2031-03-01 00:00:00 | 110
 |  |  |  | 2031-04-01 00:00:00 | 111
 |  |  |  | 2031-05-01 00:00:00 | 112
 |  |  |  | 2031-06-01 00:00:00 | 113
 |  |  |  | 2031-07-01 00:00:00 | 114
 |  |  |  | 2031-08-01 00:00:00 | 115
 |  |  |  | 2031-09-01 00:00:00 | 116
 |  |  |  | 2031-10-01 00:00:00 | 117
 |  |  |  | 2031-11-01 00:00:00 | 118
 |  |  |  | 2031-12-01 00:00:00 | 119
 |  |  |  | 2032-01-01 00:00:00 | 120
 |  |  |  | 2032-02-01 00:00:00 | 121
 |  |  |  | 2032-03-01 00:00:00