\begin{tabular}{|l|r|} \hline & A \\ \hline 1 & INPU \\ 2 & \\ 3 & Month \\ \hline & Numbe \\ \hline 5 & \\ \hline & 1 \\ \hline & 2 \\ \hline 1 & 3 \\ \hline & 4 \\ \hline 10 & 5 \\ \hline 11 & 6 \\ \hline 12 & 7 \\ \hline 13 & 8 \\ \hline 14 & 9 \\ \hline 23 & 10 \\ \hline 16 & 11 \\ \hline 17 & 12 \\ \hline 18 & 13 \\ \hline 32 & 14 \\ \hline 20 & 15 \\ \hline 21 & 16 \\ \hline 22 & 17 \\ \hline 23 & 18 \\ \hline 24 & 19 \\ \hline 25 & 20 \\ \hline 26 & 21 \\ \hline 27 & 22 \\ \hline 28 & 23 \\ \hline 29 & 24 \\ \hline 30 & 25 \\ \hline 31 & 26 \\ \hline 32 & 27 \\ \hline 33 & 28 \\ \hline 34 & 29 \end{tabular} the original balance of the pool is $100,000 The pass-through rate is 9.0% WAM is 360 months, and WAC is 9.5% Assume a prepayment rate of 165PSA Simulate the full schedule in next worksheet MAKE SURE ALL CELLS ARE CODED HOW YOUR WORK WILL BE JUDGED: I WILL CHANGE AN INPUT VARIABLE (MARKED IN RED IN WORKSHEET) ALL YOUR SCHEDULE MUST RECOMPUTE AUTOMATICALLY, CORRECTLY. \begin{tabular}{|l|r|} \hline & A \\ \hline 1 & INPU \\ 2 & \\ 3 & Month \\ \hline & Numbe \\ \hline 5 & \\ \hline & 1 \\ \hline & 2 \\ \hline 1 & 3 \\ \hline & 4 \\ \hline 10 & 5 \\ \hline 11 & 6 \\ \hline 12 & 7 \\ \hline 13 & 8 \\ \hline 14 & 9 \\ \hline 23 & 10 \\ \hline 16 & 11 \\ \hline 17 & 12 \\ \hline 18 & 13 \\ \hline 32 & 14 \\ \hline 20 & 15 \\ \hline 21 & 16 \\ \hline 22 & 17 \\ \hline 23 & 18 \\ \hline 24 & 19 \\ \hline 25 & 20 \\ \hline 26 & 21 \\ \hline 27 & 22 \\ \hline 28 & 23 \\ \hline 29 & 24 \\ \hline 30 & 25 \\ \hline 31 & 26 \\ \hline 32 & 27 \\ \hline 33 & 28 \\ \hline 34 & 29 \end{tabular} the original balance of the pool is $100,000 The pass-through rate is 9.0% WAM is 360 months, and WAC is 9.5% Assume a prepayment rate of 165PSA Simulate the full schedule in next worksheet MAKE SURE ALL CELLS ARE CODED HOW YOUR WORK WILL BE JUDGED: I WILL CHANGE AN INPUT VARIABLE (MARKED IN RED IN WORKSHEET) ALL YOUR SCHEDULE MUST RECOMPUTE AUTOMATICALLY, CORRECTLY