A pass$-$through is issued with the following characteristics:

Mortgage pool: $$5$ million

All mortgages are FRM at $10\%$ per year, $3-$year maturity, yearly payment

Pass$-$through: $$5$ million, yearly payment

Fee payment: $1\mathrm{.}5\%$ of outstanding loan balance

Assume prepayment rate: $3\%$ of the mortgage pool for the $1^{st}$ year, $5\%$ for the $2^{nd}$ year

From the information above, we have the following table:

$\backslash$table$[[$Year$,\backslash$table$[[$Beginning$],[$balance$]],\backslash$table$[[$Mortgage$],[$payment$]],\backslash$table$[[$Interest$],[$payment$]],\backslash$table$[[$Principal$],[$payment$]],\backslash$table$[[$Pre$-],[$payment$]],\backslash$table$[[$Fee$],[$payment$]],\backslash$table$[[$Payment to$],[$investors$]],\backslash$table$[[$Ending$],[$balance$]]],[1,$$$5,000,000,$$$2,010,574,500,000,$$$1,510,574,150,000,$$$75,000,$$$1,935,574,$$$3,339,],[2,$$$3,339,426,1,924,146,$$$333,943,$$$1,590,203,$$$166,971,50,091,$$$1,874,054,1,582,2$