Given the following information on a MPT, how much money is each individual investor receiving in year 5? (Note: You can perform this calculation with the spreadsheet or by completing it iteratively. To calculate how much each investor receives in year 5 you need first the starting pool balance in year 5. You can calculate the starting pool balance in year 5 by finding the new PV given an N, PMT and interest rate (since there is no prepayment). You can also complete the principal paydown schedule via a full amortization schedule worksheet or recursively via Excel or calculator) [Excel is strongly recommended to answer this question]

10 year FRM, fully amortizing, annual payments.

No prepayment or default 100 loans in the pool

Average starting balance of $500,000.00/loan

Mortgage rate 4.50%

Servicing fee of 0.50% of starting outstanding pool balance

There are 40 investors with equal shares