ASSIGNMENT INFORMATION Due Date Points Possible Monday, April 3, 2023 100 11:59 PM Suppose that the original balance of the pool is $100,000,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 separate worksheet provided, named "Schedule" 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. MUST BE DROPPED IN HUSKY BY DUE DATE: APRIL 3, MIDNIGHT 4302 ASSIGN 02.xIsxHome Insert Draw Page Layout Formulas Data Review View Automate Tell me X Calibri (Body) 16 A A ab Wrap Text v General Paste B A Merge & Center v $ ~ % 9 Conditional Format I Formatting as Table C26 X V fx C D E G H M N 0 Q S U V 1.0000% 1 2 3 6 10 11 12 14 U computes =PV ($162.8368) 20 20 20 20 20 20 20 20 20 20 20 20 20 20 100 computes =RATE 4.9219% 1 2 3 4 5 6 9 11 12 13 14 ($250.00) 20 20 20 20 20 20 20 20 20 20 20 20 20 20 100 computes =IRR 22.0176% 0 1 2 3 5 6 8 9 10 11 12 13 14 ($250.00) 20 20 20 20 100 100 100 100 200 200 200 20 20 20 1.0000% 1 3 5 6 8 9 10 11 12 13 14 ($2,500.00) 20 253 214 523 200 200 200 200 200 200 200 200 20 100 computes =NPV $53.31 11.0000% 1 2 3 5 9 11 12 13 14 ($162.8368) 20 20 20 20 20 20 20 20 20 20 20 20 20 20 100 computes =pmt 20 11.0000% 1 2 3 5 7 10 11 12 13 14 ($162.8368) 20 20 20 20 20 20 20 20 20 20 20 20 20 14 100 computes =nper 11.0000% 1 2 3 5 1 9 10 11 12 13 14 ($162.8368) 20 20 20 20 20 20 20 20 20 20 20 20 20 20 computes =fv 100 D ASSIGN SCHEDULE PSA165 DCF in XL +Tell me Home Insert Draw Page Layout Formulas Data Review View Automate Insert v X Calibri (Body) 16 VA A ab Wrap Text General nx Delete v Merge & Center v $ ~ % 9 Conditional Format Cell Paste BI UV A Formatting as lable Styles Format v J8 X V fx M N B D 9.000% POOL$ 100,000 PSA 165 INPUT WA 9.500% WAM 360 PASS_THROUGH RATE Estimated Principal Total Principal Total Cash Flow Pool Month Beginning Mortgage PMT Interest$ paid Scheduled to Investors Pre-PMT to Investors Balance CPR% SMM% Expected Principal PMT paid to Investors Fees Number 1 $100,000 10 7 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32