HW4Solution

.xlsx
Data Input Box: Number of mortgages in Average mortgage bala Initial mortgage pool ba Prepayment rate (CPR) Mortgage rate (annual) Servicing and Guarante Number of payments (a) Pool
Year Balance 1 35,000,000 2 28,717,340 3 23,241,228 4 18,483,242 5 14,364,809 6 10,816,450 7 7,777,300 8 5,195,145 9 3,027,686 10 1,247,997 11 0
Mo n initial pool nce alance ) ee Fee Total Scheduled Payments (b) (c) Scheduled Principal Principal and due to Interest Pmts
Uploaded by BarristerKudu3071 on coursehero.com