\fM A D E F G K L B C H INPUT WAC 9.500% WAM 360 PASS_THROUGH RATE 9.000% POOL$ 100,000 PSA 165 Month Beginning Mortgage PMT Interest$ paid Scheduled Estimated Principal Total Principal Total Cash Flow Pool Number Balance CPR% SMM% Expected to Investors Principal PMT Pre-PMT paid to Investors to Investors Fees $100,000 6 00 V O UT A W N P 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30the original balance of the pool is $100,000 The gass-through rate is 9.0% WAM is 360 months, and W_AC is 9.5% Assume a gregazment 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 VARIABL (MARKED IN RED IN WORKSHEET) ALL YOUR SCHEDULE MUST RECOMPUTE AUTOMATICALLY, CORRECTLY