Hi Pari,
It looks correct, but needs a 3rd schedule. The common terminology and approach in the industry for partials is to define schedules A, B, and C:
- Schedule A: Borrowers Schedule - The total remaining payments on the note at the notes rate. This is what the borrower is paying too.
- Schedule B: Purchasers Schedule - The payments purchased by the buyer/investor at the notes rate.
- Schedule C: Purchasers Basis - The payments purchased by the buyer/investor at the sold rate.
You currently have schedules A and C in your sheet. Schedule B is important because your partials contract must call out how to handle early payoff, and the PV can be different between schedules B and C. The contract would define one of these schedules to govern early payoff distribution between buyer and seller.
So for example, if the investor purchased the partial at a discount to get a higher yield than the rate of the note, schedule C would have a lower PV than schedule B (because of the discount). If the contract calls for schedule C to be used, the investor would receive a payoff that is lower than if schedule B were used.
Hope that makes sense to you.