Question: Please show formulas if using excel Complete the following table (in dollars) assuming a prepayment rate of 450 PSA for the following MBS pass-through: Original

Please show formulas if using excel

Complete the following table (in dollars) assuming a prepayment rate of 450 PSA for the following MBS pass-through: Original balance: $ 10,000,000 WAC: 7% (APR) WAM: 360 months No fee Mortgage Interest Scheduled Prepaid Total SMM Payment Payment Principal Principal Principal Payment Payment Payment Cash Flow Outstanding Month Principal at beg. of month 36 37 38 39 40

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!

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

Question3: MBS Part (a). Complete the following table assuming a prepayment rate of 140 PSA: (3 marks) Original balance: $150,000,000 Pass through rate: 7% WAM: 360 months interest month outstanding...

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

I need help with my part 1 and part 2.can you finished ,thank u FINA 415-15S PART 2 (VBA) # Worksheet Name 1 A 2 B Description Programing user defined function (30 marks) Subroutine to generate after...

CableTech Bell Corporation (CTB) operates in the telecommunications industry. CTB has two divisions: the Phone Division and the Cable Service Division. The Phone Division manufactures telephones in...

Part Two Instructions Using a spreadsheet and based on the information provided in the next section, complete the following requirements: 1. Determine the predetermined overhead rate. 2. Determine...

can i have help on this issue thank you :) sorry about that is this good information if not please let me know so i can provide :) i am hoping just with starting this im not sure how to fix the...

Assignment ? MBS pass-throughs, IO and PO pass-throughs, and CMO sequential tranches and accrual tranches The file ?Data? has 4 sheets ? one for an MBS pass-through, one for an MBS divided into IO...

Please show formulas and use the same cells as me. Sullivan Ranch Corporation has purchased a new tractor and has provided you with the information related to the purchase. The Controller has asked...

In Round Two of the simulation, you begin to diversify the composition of your assets, choosing among types of loans with varying levels of risk and return. You can also grow your assets further by...

Fourteen applicants for a city of Providence, Rhode Island, police academy training class each received from the city a letter stating that it was a conditional offer of employment subject to...

What do we mean by an unbiased estimator? Why is this important?

_________ is different from the Decrease Decimal button (or Increase Decimal button) because it eliminates all values to the right of the decimal places specified. Question 7 options: RATE AMORTIZE...

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

The city in which you go to school needs a new administration building. One location being considered for the building site is a public park in the downtown area. If this park area is used, many...

Technology. You are a customer service representative for the Trax Computer Corporation. The companys office is located in San Mateo, California, but your customers represent all areas of the United...

Star Electric has provided electricity to the area for many years. Recently, Star upgraded all of its wiring to fiber optics and is expanding into digital cable services. As marketing manager for...