Spreadsheet: 780860d1652822922-comparison-rate-calculator-formula-apr-for-subterms
Sheet: Sheet1

loan | 150000 |  | pmt# | cash flow
loan fees
full term | 300 | months | 1
[NAME] term | 24 | months | 2
[NAME] term rate | 0.02 |  | 3
[NAME] rate | 0.04 |  | 4
 |  |  | 5
FULL TERM WITHOUT INTRO TERM |  |  | 6
pmt |  | B9:  =PMT(B6/12,B3,-B1) | 7
APR |  | B10:  =12*RATE(B3,B9,-(B1-B2)) | 8
 |  |  | 9
SAME PMT FOR INTRO AND [NAME] |  |  | 10
pmt (Solver) | 762.5593538389589 | B13:  762.[PHONE] | 11
bal after [NAME] term |  | B14:  =FV(B5/12,B4,B13,-B1) | 12
bal after [NAME] |  | B15:  =FV(B6/12,B3-B4,B13,-B14) | 13
APR |  | B16:  =12*RATE(B3,B13,-(B1-B2)) | 14
 |  |  | 15
INTRO TERM IS INT-ONLY |  |  | 16
pmt for [NAME] term |  | B19:  =B1*B5/12 | 17
bal after [NAME] term |  | [NAME]:  =FV(B5/12,B4,B19,-B1) | 18
pmt for rem term |  | B21:  =PMT(B6/12,B3-B4,-B20) | 19
APR |  | B22:  =12*IRR(E2:E302) | 20
 |  |  | 21
APR (Solver) | 0.03706670979491565 | B24:  0.0370667097949157 | 22
NPV |  | [NAME]:  =PV(B24/12,B4,-B19,-PV(B24/12,B3-B4,-B21))-(B1-B2) | 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
 |  |  | 61
 |  |  | 62
 |  |  | 63
 |  |  | 64
 |  |  | 65
 |  |  | 66
 |  |  | 67
 |  |  | 68
 |  |  | 69
 |  |  | 70
 |  |  | 71
 |  |  | 72
 |  |  | 73
 |  |  | 74
 |  |  | 75
 |  |  | 76
 |  |  | 77
 |  |  | 78
 |  |  | 79
 |  |  | 80
 |  |  | 81
 |  |  | 82
 |  |  | 83
 |  |  | 84
 |  |  | 85
 |  |  | 86
 |  |  | 87
 |  |  | 88
 |  |  | 89
 |  |  | 90
 |  |  | 91
 |  |  | 92
 |  |  | 93
 |  |  | 94
 |  |  | 95
 |  |  | 96
 |  |  | 97
 |  |  | 98
 |  |  | 99
 |  |  | 100
 |  |  | 101
 |  |  | 102
 |  |  | 103
 |  |  | 104
 |  |  | 105
 |  |  | 106
 |  |  | 107
 |  |  | 108
 |  |  | 109
 |  |  | 110
 |  |  | 111
 |  |  | 112
 |  |  | 113
 |  |  | 114
 |  |  | 115
 |  |  | 116
 |  |  | 117
 |  |  | 118
 |  |  | 119
 |  |  | 120
 |  |  | 121
 |  |  | 122
 |  |  | 123
 |  |  | 124
 |  |  | 125
 |  |  | 126
 |  |  | 127
 |  |  | 128
 |  |  | 129
 |  |  | 130
 |  |  | 131
 |  |  | 132
 |  |  | 133
 |  |  | 134
 |  |  | 135
 |  |  | 136
 |  |  | 137
 |  |  | 138
 |  |  | 139
 |  |  | 140
 |  |  | 141
 |  |  | 142
 |  |  | 143
 |  |  | 144
 |  |  | 145
 |  |  | 146
 |  |  | 147
 |  |  | 148
 |  |  | 149
 |  |  | 150
 |  |  | 151
 |  |  | 152
 |  |  | 153
 |  |  | 154
 |  |  | 155
 |  |  | 156
 |  |  | 157
 |  |  | 158
 |  |  | 159
 |  |  | 160
 |  |  | 161
 |  |  | 162
 |  |  | 163
 |  |  | 164
 |  |  | 165
 |  |  | 166
 |  |  | 167
 |  |  | 168
 |  |  | 169
 |  |  | 170
 |  |  | 171
 |  |  | 172
 |  |  | 173
 |  |  | 174
 |  |  | 175
 |  |  | 176
 |  |  | 177
 |  |  | 178
 |  |  | 179
 |  |  | 180
 |  |  | 181
 |  |  | 182
 |  |  | 183
 |  |  | 184
 |  |  | 185
 |  |  | 186
 |  |  | 187
 |  |  | 188
 |  |  | 189
 |  |  | 190
 |  |  | 191
 |  |  | 192
 |  |  | 193
 |  |  | 194
 |  |  | 195
 |  |  | 196
 |  |  | 197
 |  |  | 198
 |  |  | 199
 |  |  | 200
 |  |  | 201
 |  |  | 202
 |  |  | 203
 |  |  | 204
 |  |  | 205
 |  |  | 206
 |  |  | 207
 |  |  | 208
 |  |  | 209
 |  |  | 210
 |  |  | 211
 |  |  | 212
 |  |  | 213
 |  |  | 214
 |  |  | 215
 |  |  | 216
 |  |  | 217
 |  |  | 218
 |  |  | 219
 |  |  | 220
 |  |  | 221
 |  |  | 222
 |  |  | 223
 |  |  | 224
 |  |  | 225
 |  |  | 226
 |  |  | 227
 |  |  | 228
 |  |  | 229
 |  |  | 230
 |  |  | 231
 |  |  | 232
 |  |  | 233
 |  |  | 234
 |  |  | 235
 |  |  | 236
 |  |  | 237
 |  |  | 238
 |  |  | 239
 |  |  | 240
 |  |  | 241
 |  |  | 242
 |  |  | 243
 |  |  | 244
 |  |  | 245
 |  |  | 246
 |  |  | 247
 |  |  | 248
 |  |  | 249
 |  |  | 250
 |  |  | 251
 |  |  | 252
 |  |  | 253
 |  |  | 254
 |  |  | 255
 |  |  | 256
 |  |  | 257
 |  |  | 258
 |  |  | 259
 |  |  | 260
 |  |  | 261
 |  |  | 262
 |  |  | 263
 |  |  | 264
 |  |  | 265
 |  |  | 266
 |  |  | 267
 |  |  | 268
 |  |  | 269
 |  |  | 270
 |  |  | 271
 |  |  | 272
 |  |  | 273
 |  |  | 274
 |  |  | 275
 |  |  | 276
 |  |  | 277
 |  |  | 278
 |  |  | 279
 |  |  | 280
 |  |  | 281
 |  |  | 282
 |  |  | 283
 |  |  | 284
 |  |  | 285
 |  |  | 286
 |  |  | 287
 |  |  | 288
 |  |  | 289
 |  |  | 290
 |  |  | 291
 |  |  | 292
 |  |  | 293
 |  |  | 294
 |  |  | 295
 |  |  | 296
 |  |  | 297
 |  |  | 298
 |  |  | 299
 |  |  | 300