ING Offset Rec (JUN24)

ING Offset Rec (JUN24)

ING Offset Rec (JUN24)(Excel)

// Notes on PPM 3Y //

• PPM Intial: 150K

• Target PPM 3Y: 175K

• Target Total PPM: 150K+175K=325K

• Prepaid Mort (Current) = 290K

• Rem PPM: 35K [EFI-Holding]

[Allocations]

• PPM Initial: 150K [107.5K+42.5K]

• US-Inv: 50K [62.5K: 12.5K+50K]

• PPM 3Y: 50K [JUN24]

• EFI-Holding: 40K [Alloc 75K: 40K/35K]

• Total JUN24: 290K

// Notes on PPM 2Y // [Offset Simplifier]

• Target PPM 2Y: 125K

[Allocations]

• Net Principal: 31Kx2=62K

• EFI [MR]: 9.1Kx2=18.2K

• EFI [DFC]: 8.5Kx2=17K

• Net Prop: 11.3Kx2=22.6K

• Rem: Interest Savings

[References Pre-to-Post Prepaid Mort Allocations]

ING Offset Rec (JUN24)(Before Prepaid Mort)

ING Offset Rec (JUN24)(After Prepaid Mort)