Sounds like you're diving deep into the mortgage payment matrix! If you've got the total loan deets, fixed interest rate, and average CPR, you should be able to whip up a column of CPR rates. Consider using a formula that incorporates your known values and the average CPR to calculate the CPR rates for each period. If you find yourself lost in the numbers, may be a pro touch could help. Ever thought about reaching out to a mortgage expert, like Mortgage Broker in Chester? They might have some nifty tricks up their sleeve!
... View more
