Question: 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

\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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

\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...

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...

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

Hi There, I need someone to help me with the attached finance worksheet. There are 3 problems in this excel file - one problem on each individual tab. I am attaching a couple of additional files as...

Dear Dr Fids, Can you please help these questions? It is about MBS cash flow. R Generating MBS cash flows can be messy so we are going to write some functions in R that allows us to generate the cash...

~~~~~Income Statement~~~~~ You only need to finish IS tab. Actually the IS almost done, just need finish earnings per share part at the bottom under IS tab. Do 11 Steps for 2014, each Step in...

I need help on a written assignment for my Government and Not-for-Profit Accounting Course. I've attached a word document with the assignment details and grading rubrix along with a pdf of a...

Jones - Financial Statement Case Assignment Start Assignment Due Sunday by 11:59pm Points 20 Submitting a file upload File Types doc, pdf, docx, xls, and xlsx Available Jun 27 at 12am - Jul 3 at...

hi could you help with this assignment? i am hard time finding the fraud thanks Student Handout 1. Tallahassee BeanCounters organizational chart Franklin Kennedy Owner Phil Ackers President $95,000...

QUESTIONS and PROBLEMS GROUP MULTIPLE CHOICE QUESTIONS LO 2.1 LO 2.1 LO 2.1 LO 2.1 1. The definition of gross income in the tax law is: a. All items specifically listed as income in the tax law b....

Let G be a graph with n vertices, m edges, and k components. Show that 1 n k m = (n k) (n k + 1).

solve the following initial value problems. a) y"+ 4y' + 8y = 40cos(2x), y(0) = 8, y'(0) = 0 b) y" + 6y' + 13y = 12e -3x sin(2x), y(0) = 0, y'(0) = 0 Find a general solution of each of the following...

A restructuring refers to a change in the original terms of a debt agreement that is motivated by the financial difficulties of the borrower.

A cooling water stream leaves the condenser in the formalin 37/3 process at a temperature of 450C and a flowrate of 12kg/s. It is sent to a cooling tower to be cooled down to 160C for recycling back....

2. Suppose that the pen-making industry is perfectly competitive. Also suppose that each current firm and any potential firms that might enter the industry all have identical cost curves, with...

LO12.4 Explain how a pure monopoly sets its profitmaximizing output and price.

3. Suppose that as the output of mobile phones increases, the cost of touch screens and other component parts decreases. If the mobile phone industry features pure competition, we would expect the...