mortgage-refinance

Mortgage Refinance Spreadsheet

Instructions at DCF Models Website (http://www.dcf-models.com)

Change Cells in Red Only

Mortgage Terms

Comparison of Options

Mortgage Details

At Completion Date

Original Loan Terms

Refinance Loan Terms

Effective Date

1-Jan-08

1-Jan-08

1-Jan-08

Principal Outstanding

$115,000.00

$115,000.00

$115,000.00

SUMMARY

Amortization (Remaining)

300 months

300 months

300 months

Discount Rate

6.25%

Term (Remaining)

60 months

60 months

60 months

Present Values

Original Rate (Semiannual)

4.38%

4.38%

6.25%

Payments

Interest

Principal

Refinance Rate (Semiannual)

6.25%

Results (Discounted at 6.25%)

$6,397

$8,906

($2,508)

Change in Payments

$6,397

Change in Interest

$8,906

Change in Principal

($2,508)

Monthly Payment

$628.53

$628.53

$752.95

Payment

Amortization

Term

Amortization

Amortization

Difference

Discount

Date

Remaining

Remaining

Interest Paid

Principal

Balance

Interest Paid

Principal

Balance

Interest Paid

Principal

Total

Factor

NPV

NPV

Interest

Principal

1-Feb-08

299 months

59 months

$415

$213

$114,787

$591

$162

$114,838

$176

($51)

$124

0.9948

$175

($51)

1-Mar-08

298 months

58 months

$415

$214

$114,573

$590

$162

$114,676

$176

($51)

$124

0.9897

$174

($51)

1-Apr-08

297 months

57 months

$414

$215

$114,359

$590

$163

$114,513

$176

($51)

$124

0.9845

$173

($50)

1-May-08

296 months

56 months

$413

$215

$114,143

$589

$164

$114,348

$176

($51)

$124

0.9794

$172

($50)

1-Jun-08

295 months

55 months

$412

$216

$113,927

$588

$165

$114,183

$176

($51)

$124

0.9744

$171

($50)

1-Jul-08

294 months

54 months

$412

$217

$113,710

$587

$166

$114,018

$175

($51)

$124

0.9693

$170

($49)

1-Aug-08

293 months

53 months

$411

$218

$113,493

$586

$167

$113,851

$175

($51)

$124

0.9643

$169

($49)

1-Sep-08

292 months

52 months

$410

$218

$113,274

$585

$168

$113,683

$175

($51)

$124

0.9593

$168

($49)

1-Oct-08

291 months

51 months

$409

$219

$113,055

$585

$168

$113,515

$175

($51)

$124

0.9543

$167

($49)

1-Nov-08

290 months

50 months

$408

$220

$112,835

$584

$169

$113,346

$175

($51)

$124

0.9494

$166

($48)

1-Dec-08

289 months

49 months

$408

$221

$112,614

$583

$170

$113,175

$175

($51)

$124

0.9445

$165

($48)

1-Jan-09

288 months

48 months

$407

$222

$112,392

$582

$171

$113,004

$175

($51)

$124

0.9396

$164

($48)

1-Feb-09

287 months

47 months

$406

$222

$112,170

$581

$172

$112,833

$175

($51)

$124

0.9347

$164

($47)

1-Mar-09

286 months

46 months

$405

$223

$111,947

$580

$173

$112,660

$175

($50)

$124

0.9299

$163

($47)

1-Apr-09

285 months

45 months

$404

$224

$111,722

$579

$174

$112,486

$175

($50)

$124

0.9250

$162

($47)

1-May-09

284 months

44 months

$404

$225

$111,498

$578

$175

$112,311

$175

($50)

$124

0.9202

$161

($46)

1-Jun-09

283 months

43 months

$403

$226

$111,272

$577

$175

$112,136

$175

($50)

$124

0.9155

$160

($46)

1-Jul-09

282 months

42 months

$402

$226

$111,045

$577

$176

$111,960

$175

($50)

$124

0.9107

$159

($46)

1-Aug-09

281 months

41 months

$401

$227

$110,818

$576

$177

$111,782

$174

($50)

$124

0.9060

$158

($45)

1-Sep-09

280 months

40 months

$400

$228

$110,590

$575

$178

$111,604

$174

($50)

$124

0.9013

$157

($45)

1-Oct-09

279 months

39 months

$400

$229

$110,361

$574

$179

$111,425

$174

($50)

$124

0.8966

$156

($45)

1-Nov-09

278 months

38 months

$399

$230

$110,131

$573

$180

$111,245

$174

($50)

$124

0.8920

$155

($44)

1-Dec-09

277 months

37 months

$398

$231

$109,901

$572

$181

$111,064

$174

($50)

$124

0.8874

$154

($44)

1-Jan-10

276 months

36 months

$397

$231

$109,669

$571

$182

$110,882

$174

($50)

$124

0.8828

$154

($44)

1-Feb-10

275 months

35 months

$396

$232

$109,437

$570

$183

$110,699

$174

($49)

$124

0.8782

$153

($43)

1-Mar-10

274 months

34 months

$395

$233

$109,204

$569

$184

$110,516

$174

($49)

$124

0.8737

$152

($43)

1-Apr-10

273 months

33 months

$395

$234

$108,970

$568

$185

$110,331

$174

($49)

$124

0.8691

$151

($43)

1-May-10

272 months

32 months

$394

$235

$108,735

$567

$186

$110,145

$174

($49)

$124

0.8646

$150

($43)

1-Jun-10

271 months

31 months

$393

$236

$108,499

$566

$187

$109,959

$173

($49)

$124

0.8601

$149

($42)

1-Jul-10

270 months

30 months

$392

$237

$108,263

$565

$188

$109,771

$173

($49)

$124

0.8557

$148

($42)

1-Aug-10

269 months

29 months

$391

$237

$108,025

$564

$189

$109,583

$173

($49)

$124

0.8513

$147

($42)

1-Sep-10

268 months

28 months

$390

$238

$107,787

$563

$190

$109,393

$173

($49)

$124

0.8468

$147

($41)

1-Oct-10

267 months

27 months

$389

$239

$107,548

$562

$190

$109,203

$173

($49)

$124

0.8425

$146

($41)

1-Nov-10

266 months

26 months

$389

$240

$107,308

$561

$191

$109,011

$173

($48)

$124

0.8381

$145

($41)

1-Dec-10

265 months

25 months

$388

$241

$107,067

$561

$192

$108,819

$173

($48)

$124

0.8338

$144

($40)

1-Jan-11

264 months

24 months

$387

$242

$106,826

$560

$193

$108,625

$173

($48)

$124

0.8294

$143

($40)

1-Feb-11

263 months

23 months

$386

$243

$106,583

$559

$194

$108,431

$173

($48)

$124

0.8251

$142

($40)

1-Mar-11

262 months

22 months

$385

$243

$106,340

$558

$195

$108,235

$172

($48)

$124

0.8209

$142

($39)

1-Apr-11

261 months

21 months

$384

$244

$106,095

$557

$196

$108,039

$172

($48)

$124

0.8166

$141

($39)

1-May-11

260 months

20 months

$383

$245

$105,850

$556

$197

$107,841

$172

($48)

$124

0.8124

$140

($39)

1-Jun-11

259 months

19 months

$382

$246

$105,604

$554

$198

$107,643

$172

($48)

$124

0.8082

$139

($38)

1-Jul-11

258 months

18 months

$382

$247

$105,357

$553

$199

$107,444

$172

($47)

$124

0.8040

$138

($38)

1-Aug-11

257 months

17 months

$381

$248

$105,109

$552

$201

$107,243

$172

($47)

$124

0.7998

$137

($38)

1-Sep-11

256 months

16 months

$380

$249

$104,860

$551

$202

$107,042

$172

($47)

$124

0.7957

$137

($38)

1-Oct-11

255 months

15 months

$379

$250

$104,611

$550

$203

$106,839

$172

($47)

$124

0.7915

$136

($37)

1-Nov-11

254 months

14 months

$378

$251

$104,360

$549

$204

$106,635

$171

($47)

$124

0.7874

$135

($37)

1-Dec-11

253 months

13 months

$377

$251

$104,109

$548

$205

$106,431

$171

($47)

$124

0.7834

$134

($37)

1-Jan-12

252 months

12 months

$376

$252

$103,856

$547

$206

$106,225

$171

($47)

$124

0.7793

$133

($36)

1-Feb-12

251 months

11 months

$375

$253

$103,603

$546

$207

$106,018

$171

($47)

$124

0.7753

$133

($36)

1-Mar-12

250 months

10 months

$374

$254

$103,349

$545

$208

$105,810

$171

($46)

$124

0.7713

$132

($36)

1-Apr-12

249 months

9 months

$373

$255

$103,094

$544

$209

$105,601

$171

($46)

$124

0.7673

$131

($35)

1-May-12

248 months

8 months

$372

$256

$102,838

$543

$210

$105,391

$170

($46)

$124

0.7633

$130

($35)

1-Jun-12

247 months

7 months

$372

$257

$102,581

$542

$211

$105,180

$170

($46)

$124

0.7593

$129

($35)

1-Jul-12

246 months

6 months

$371

$258

$102,323

$541

$212

$104,968

$170

($46)

$124

0.7554

$129

($35)

1-Aug-12

245 months

5 months

$370

$259

$102,064

$540

$213

$104,755

$170

($46)

$124

0.7515

$128

($34)

1-Sep-12

244 months

4 months

$369

$260

$101,804

$539

$214

$104,541

$170

($45)

$124

0.7476

$127

($34)

1-Oct-12

243 months

3 months

$368

$261

$101,544

$538

$215

$104,325

$170

($45)

$124

0.7437

$126

($34)

1-Nov-12

242 months

2 months

$367

$262

$101,282

$536

$217

$104,109

$170

($45)

$124

0.7399

$125

($33)

1-Dec-12

241 months

1 months

$366

$263

$101,019

$535

$218

$103,891

$169

($45)

$124

0.7360

$125

($33)

1-Jan-13

240 months

-

$365

$264

$100,756

$534

$219

$103,672

$169

($45)

$124

0.7322

$124

($33)

1-Feb-13

239 months

-

$364

$264

$100,491

$533

$220

$103,452

-

-

-

0.7322

-

-

1-Mar-13

238 months

-

$363

$265

$100,226

$532

$221

$103,231

-

-

-

0.7322

-

-

1-Apr-13

237 months

-

$362

$266

$99,959

$531

$222

$103,009

-

-

-

0.7322

-

-

1-May-13

236 months

-

$361

$267

$99,692

$530

$223

$102,786

-

-

-

0.7322

-

-

1-Jun-13

235 months

-

$360

$268

$99,424

$529

$224

$102,562

-

-

-

0.7322

-

-

1-Jul-13

234 months

-

$359

$269

$99,154

$527

$226

$102,336

-

-

-

0.7322

-

-

1-Aug-13

233 months

-

$358

$270

$98,884

$526

$227

$102,109

-

-

-

0.7322

-

-

1-Sep-13

232 months

-

$357

$271

$98,613

$525

$228

$101,881

-

-

-

0.7322

-

-

1-Oct-13

231 months

-

$356

$272

$98,341

$524

$229

$101,652

-

-

-

0.7322

-

-

1-Nov-13

230 months

-

$355

$273

$98,067

$523

$230

$101,422

-

-

-

0.7322

-

-

1-Dec-13

229 months

-

$354

$274

$97,793

$521

$231

$101,190

-

-

-

0.7322

-

-

1-Jan-14

228 months

-

$353

$275

$97,518

$520

$233

$100,958

-

-

-

0.7322

-

-

1-Feb-14

227 months

-

$352

$276

$97,242

$519

$234

$100,724

-

-

-

0.7322

-

-

1-Mar-14

226 months

-

$351

$277

$96,965

$518

$235

$100,489

-

-

-

0.7322

-

-

1-Apr-14

225 months

-

$350

$278

$96,686

$517

$236

$100,253

-

-

-

0.7322

-

-

1-May-14

224 months

-

$349

$279

$96,407

$515

$237

$100,015

-

-

-

0.7322

-

-

1-Jun-14

223 months

-

$348

$280

$96,127

$514

$239

$99,776

-

-

-

0.7322

-

-

1-Jul-14

222 months

-

$347

$281

$95,846

$513

$240

$99,536

-

-

-

0.7322

-

-

1-Aug-14

221 months

-

$346

$282

$95,564

$512

$241

$99,295

-

-

-

0.7322

-

-

1-Sep-14

220 months

-

$345

$283

$95,280

$511

$242

$99,053

-

-

-

0.7322

-

-

1-Oct-14

219 months

-

$344

$284

$94,996

$509

$244

$98,809

-

-

-

0.7322

-

-

1-Nov-14

218 months

-

$343

$285

$94,711

$508

$245

$98,564

-

-

-

0.7322

-

-

1-Dec-14

217 months

-

$342

$286

$94,424

$507

$246

$98,318

-

-

-

0.7322

-

-

1-Jan-15

216 months

-

$341

$287

$94,137

$506

$247

$98,071

-

-

-

0.7322

-

-

1-Feb-15

215 months

-

$340

$288

$93,849

$504

$249

$97,822

-

-

-

0.7322

-

-

1-Mar-15

214 months

-

$339

$289

$93,559

$503

$250

$97,572

-

-

-

0.7322

-

-

1-Apr-15

213 months

-

$338

$290

$93,269

$502

$251

$97,321

-

-

-

0.7322

-

-

1-May-15

212 months

-

$337

$292

$92,977

$500

$253

$97,068

-

-

-

0.7322

-

-

1-Jun-15

211 months

-

$336

$293

$92,685

$499

$254

$96,815

-

-

-

0.7322

-

-

1-Jul-15

210 months

-

$335

$294

$92,391

$498

$255

$96,559

-

-

-

0.7322

-

-

1-Aug-15

209 months

-

$334

$295

$92,096

$496

$256

$96,303

-

-

-

0.7322

-

-

1-Sep-15

208 months

-

$333

$296

$91,800

$495

$258

$96,045

-

-

-

0.7322

-

-

1-Oct-15

207 months

-

$332

$297

$91,504

$494

$259

$95,786

-

-

-

0.7322

-

-

1-Nov-15

206 months

-

$331

$298

$91,206

$493

$260

$95,526

-

-

-

0.7322

-

-

1-Dec-15

205 months

-

$330

$299

$90,907

$491

$262

$95,264

-

-

-

0.7322

-

-

1-Jan-16

204 months

-

$328

$300

$90,607

$490

$263

$95,001

-

-

-

0.7322

-

-

1-Feb-16

203 months

-

$327

$301

$90,305

$488

$264

$94,736

-

-

-

0.7322

-

-

1-Mar-16

202 months

-

$326

$302

$90,003

$487

$266

$94,470

-

-

-

0.7322

-

-

1-Apr-16

201 months

-

$325

$303

$89,700

$486

$267

$94,203

-

-

-

0.7322

-

-

1-May-16

200 months

-

$324

$304

$89,395

$484

$269

$93,935

-

-

-

0.7322

-

-

1-Jun-16

199 months

-

$323

$306

$89,090

$483

$270

$93,665

-

-

-

0.7322

-

-

1-Jul-16

198 months

-

$322

$307

$88,783

$482

$271

$93,393

-

-

-

0.7322

-

-

1-Aug-16

197 months

-

$321

$308

$88,475

$480

$273

$93,120

-

-

-

0.7322

-

-

1-Sep-16

196 months

-

$320

$309

$88,167

$479

$274

$92,846

-

-

-

0.7322

-

-

1-Oct-16

195 months

-

$319

$310

$87,857

$477

$276

$92,571

-

-

-

0.7322

-

-

1-Nov-16

194 months

-

$317

$311

$87,546

$476

$277

$92,294

-

-

-

0.7322

-

-

1-Dec-16

193 months

-

$316

$312

$87,233

$475

$278

$92,015

-

-

-

0.7322

-

-

1-Jan-17

192 months

-

$315

$313

$86,920

$473

$280

$91,736

-

-

-

0.7322

-

-

1-Feb-17

191 months

-

$314

$314

$86,605

$472

$281

$91,454

-

-

-

0.7322

-

-

1-Mar-17

190 months

-

$313

$316

$86,290

$470

$283

$91,172

-

-

-

0.7322

-

-

1-Apr-17

189 months

-

$312

$317

$85,973

$469

$284

$90,887

-

-

-

0.7322

-

-

1-May-17

188 months

-

$311

$318

$85,655

$467

$286

$90,602

-

-

-

0.7322

-

-

1-Jun-17

187 months

-

$309

$319

$85,336

$466

$287

$90,315

-

-

-

0.7322

-

-

1-Jul-17

186 months

-

$308

$320

$85,016

$464

$289

$90,026

-

-

-

0.7322

-

-

1-Aug-17

185 months

-

$307

$321

$84,695

$463

$290

$89,736

-

-

-

0.7322

-

-

1-Sep-17

184 months

-

$306

$323

$84,372

$461

$292

$89,445

-

-

-

0.7322

-

-

1-Oct-17

183 months

-

$305

$324

$84,048

$460

$293

$89,151

-

-

-

0.7322

-

-

1-Nov-17

182 months

-

$304

$325

$83,724

$458

$295

$88,857

-

-

-

0.7322

-

-

1-Dec-17

181 months

-

$302

$326

$83,398

$457

$296

$88,561

-

-

-

0.7322

-

-

1-Jan-18

180 months

-

$301

$327

$83,070

$455

$298

$88,263

-

-

-

0.7322

-

-

1-Feb-18

179 months

-

$300

$328

$82,742

$454

$299

$87,964

-

-

-

0.7322

-

-

1-Mar-18

178 months

-

$299

$330

$82,412

$452

$301

$87,663

-

-

-

0.7322

-

-

1-Apr-18

177 months

-

$298

$331

$82,082

$451

$302

$87,361

-

-

-

0.7322

-

-

1-May-18

176 months

-

$297

$332

$81,750

$449

$304

$87,057

-

-

-

0.7322

-

-

1-Jun-18

175 months

-

$295

$333

$81,416

$448

$305

$86,752

-

-

-

0.7322

-

-

1-Jul-18

174 months

-

$294

$334

$81,082

$446

$307

$86,445

-

-

-

0.7322

-

-

1-Aug-18

173 months

-

$293

$336

$80,747

$444

$308

$86,137

-

-

-

0.7322

-

-

1-Sep-18

172 months

-

$292

$337

$80,410

$443

$310

$85,827

-

-

-

0.7322

-

-

1-Oct-18

171 months

-

$291

$338

$80,072

$441

$312

$85,515

-

-

-

0.7322

-

-

1-Nov-18

170 months

-

$289

$339

$79,732

$440

$313

$85,202

-

-

-

0.7322

-

-

1-Dec-18

169 months

-

$288

$340

$79,392

$438

$315

$84,887

-

-

-

0.7322

-

-

1-Jan-19

168 months

-

$287

$342

$79,050

$436

$316

$84,571

-

-

-

0.7322

-

-

1-Feb-19

167 months

-

$286

$343

$78,707

$435

$318

$84,252

-

-

-

0.7322

-

-

1-Mar-19

166 months

-

$284

$344

$78,363

$433

$320

$83,933

-

-

-

0.7322

-

-

1-Apr-19

165 months

-

$283

$345

$78,018

$432

$321

$83,611

-

-

-

0.7322

-

-

1-May-19

164 months

-

$282

$347

$77,671

$430

$323

$83,288

-

-

-

0.7322

-

-

1-Jun-19

163 months

-

$281

$348

$77,323

$428

$325

$82,964

-

-

-

0.7322

-

-

1-Jul-19

162 months

-

$279

$349

$76,974

$427

$326

$82,637

-

-

-

0.7322

-

-

1-Aug-19

161 months

-

$278

$350

$76,624

$425

$328

$82,309

-

-

-

0.7322

-

-

1-Sep-19

160 months

-

$277

$352

$76,272

$423

$330

$81,979

-

-

-

0.7322

-

-

1-Oct-19

159 months

-

$276

$353

$75,919

$422

$331

$81,648

-

-

-

0.7322

-

-

1-Nov-19

158 months

-

$274

$354

$75,565

$420

$333

$81,315

-

-

-

0.7322

-

-

1-Dec-19

157 months

-

$273

$356

$75,209

$418

$335

$80,980

-

-

-

0.7322

-

-

1-Jan-20

156 months

-

$272

$357

$74,853

$416

$337

$80,643

-

-

-

0.7322

-

-

1-Feb-20

155 months

-

$270

$358

$74,495

$415

$338

$80,305

-

-

-

0.7322

-

-

1-Mar-20

154 months

-

$269

$359

$74,135

$413

$340

$79,965

-

-

-

0.7322

-

-

1-Apr-20

153 months

-

$268

$361

$73,774

$411

$342

$79,623

-

-

-

0.7322

-

-

1-May-20

152 months

-

$267

$362

$73,413

$409

$344

$79,280

-

-

-

0.7322

-

-

1-Jun-20

151 months

-

$265

$363

$73,049

$408

$345

$78,934

-

-

-

0.7322

-

-

1-Jul-20

150 months

-

$264

$365

$72,685

$406

$347

$78,587

-

-

-

0.7322

-

-

1-Aug-20

149 months

-

$263

$366

$72,319

$404

$349

$78,238

-

-

-

0.7322

-

-

1-Sep-20

148 months

-

$261

$367

$71,951

$402

$351

$77,888

-

-

-

0.7322

-

-

1-Oct-20

147 months

-

$260

$369

$71,583

$400

$352

$77,535

-

-

-

0.7322

-

-

1-Nov-20

146 months

-

$259

$370

$71,213

$399

$354

$77,181

-

-

-

0.7322

-

-

1-Dec-20

145 months

-

$257

$371

$70,842

$397

$356

$76,825

-

-

-

0.7322

-

-

1-Jan-21

144 months

-

$256

$373

$70,469

$395

$358

$76,467

-

-

-

0.7322

-

-

1-Feb-21

143 months

-

$255

$374

$70,095

$393

$360

$76,107

-

-

-

0.7322

-

-

1-Mar-21

142 months

-

$253

$375

$69,720

$391

$362

$75,746

-

-

-

0.7322

-

-

1-Apr-21

141 months

-

$252

$377

$69,343

$389

$363

$75,382

-

-

-

0.7322

-

-

1-May-21

140 months

-

$251

$378

$68,965

$388

$365

$75,017

-

-

-

0.7322

-

-

1-Jun-21

139 months

-

$249

$379

$68,586

$386

$367

$74,649

-

-

-

0.7322

-

-

1-Jul-21

138 months

-

$248

$381

$68,205

$384

$369

$74,280

-

-

-

0.7322

-

-

1-Aug-21

137 months

-

$246

$382

$67,823

$382

$371

$73,909

-

-

-

0.7322

-

-

1-Sep-21

136 months

-

$245

$383

$67,440

$380

$373

$73,536

-

-

-

0.7322

-

-

1-Oct-21

135 months

-

$244

$385

$67,055

$378

$375

$73,162

-

-

-

0.7322

-

-

1-Nov-21

134 months

-

$242

$386

$66,669

$376

$377

$72,785

-

-

-

0.7322

-

-

1-Dec-21

133 months

-

$241

$388

$66,281

$374

$379

$72,406

-

-

-

0.7322

-

-

1-Jan-22

132 months

-

$239

$389

$65,892

$372

$381

$72,025

-

-

-

0.7322

-

-

1-Feb-22

131 months

-

$238

$390

$65,501

$370

$383

$71,643

-

-

-

0.7322

-

-

1-Mar-22

130 months

-

$237

$392

$65,110

$368

$385

$71,258

-

-

-

0.7322

-

-

1-Apr-22

129 months

-

$235

$393

$64,716

$366

$387

$70,872

-

-

-

0.7322

-

-

1-May-22

128 months

-

$234

$395

$64,322

$364

$389

$70,483

-

-

-

0.7322

-

-

1-Jun-22

127 months

-

$232

$396

$63,925

$362

$391

$70,093

-

-

-

0.7322

-

-

1-Jul-22

126 months

-

$231

$398

$63,528

$360

$393

$69,700

-

-

-

0.7322

-

-

1-Aug-22

125 months

-

$230

$399

$63,129

$358

$395

$69,305

-

-

-

0.7322

-

-

1-Sep-22

124 months

-

$228

$400

$62,728

$356

$397

$68,909

-

-

-

0.7322

-

-

1-Oct-22

123 months

-

$227

$402

$62,327

$354

$399

$68,510

-

-

-

0.7322

-

-

1-Nov-22

122 months

-

$225

$403

$61,923

$352

$401

$68,110

-

-

-

0.7322

-

-

1-Dec-22

121 months

-

$224

$405

$61,518

$350

$403

$67,707

-

-

-

0.7322

-

-

1-Jan-23

120 months

-

$222

$406

$61,112

$348

$405

$67,302

-

-

-

0.7322

-

-

1-Feb-23

119 months

-

$221

$408

$60,704

$346

$407

$66,895

-

-

-

0.7322

-

-

1-Mar-23

118 months

-

$219

$409

$60,295

$344

$409

$66,486

-

-

-

0.7322

-

-

1-Apr-23

117 months

-

$218

$411

$59,885

$342

$411

$66,075

-

-

-

0.7322

-

-

1-May-23

116 months

-

$216

$412

$59,472

$340

$413

$65,662

-

-

-

0.7322

-

-

1-Jun-23

115 months

-

$215

$414

$59,059

$338

$415

$65,246

-

-

-

0.7322

-

-

1-Jul-23

114 months

-

$213

$415

$58,644

$335

$417

$64,829

-

-

-

0.7322

-

-

1-Aug-23

113 months

-

$212

$417

$58,227

$333

$420

$64,409

-

-

-

0.7322

-

-

1-Sep-23

112 months

-

$210

$418

$57,809

$331

$422

$63,988

-

-

-

0.7322

-

-

1-Oct-23

111 months

-

$209

$420

$57,389

$329

$424

$63,564

-

-

-

0.7322

-

-

1-Nov-23

110 months

-

$207

$421

$56,968

$327

$426

$63,137

-

-

-

0.7322

-

-

1-Dec-23

109 months

-

$206

$423

$56,545

$325

$428

$62,709

-

-

-

0.7322

-

-

1-Jan-24

108 months

-

$204

$424

$56,121

$322

$431

$62,279

-

-

-

0.7322

-

-

1-Feb-24

107 months

-

$203

$426

$55,695

$320

$433

$61,846

-

-

-

0.7322

-

-

1-Mar-24

106 months

-

$201

$427

$55,268

$318

$435

$61,411

-

-

-

0.7322

-

-

1-Apr-24

105 months

-

$200

$429

$54,839

$316

$437

$60,974

-

-

-

0.7322

-

-

1-May-24

104 months

-

$198

$430

$54,409

$314

$439

$60,534

-

-

-

0.7322

-

-

1-Jun-24

103 months

-

$197

$432

$53,977

$311

$442

$60,093

-

-

-

0.7322

-

-

1-Jul-24

102 months

-

$195

$434

$53,543

$309

$444

$59,649

-

-

-

0.7322

-

-

1-Aug-24

101 months

-

$193

$435

$53,108

$307

$446

$59,202

-

-

-

0.7322

-

-

1-Sep-24

100 months

-

$192

$437

$52,672

$304

$449

$58,754

-

-

-

0.7322

-

-

1-Oct-24

99 months

-

$190

$438

$52,233

$302

$451

$58,303

-

-

-

0.7322

-

-

1-Nov-24

98 months

-

$189

$440

$51,794

$300

$453

$57,850

-

-

-

0.7322

-

-

1-Dec-24

97 months

-

$187

$441

$51,352

$297

$456

$57,394

-

-

-

0.7322

-

-

1-Jan-25

96 months

-

$186

$443

$50,909

$295

$458

$56,937

-

-

-

0.7322

-