Question: Using the MBS collateral Excel program, create an Excel table for the following agency MBS. Mortgage collateral = $50,000,000 WAC = 7%

Using the MBS collateral Excel program, create an Excel table for the following agency MBS.

Mortgage collateral = $50,000,000

WAC = 7%

PT rate = 6.5

WAM = 350

Seasoning = 10

PSA = 75%

Note: In your table, you may want to hide many of the rows and some of the columns. Do keep columns for period, balance, interest, scheduled principal, prepaid principal, and cash flow.

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 Understanding Management Questions!

Given the following mortgage collateral and PAC: Mortgage collateral = $100,000,000 Weighted average coupon rate (WAC) = 7% Weighted average maturity (WAM) = 350 months Seasoning = 10 months...

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

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

For the exclusive use of X. Ye, 2017. ARVIND KRISHNAMURTHY AND TAFT FOSTER KEL782 Quantitative Easing in the Great Recession On October 29, 2008, the Federal Open Market Committee (FOMC) concluded...

Hi, I am doing a project for derivatives class and I have some questions about a regression and Monte Carlo simulation that I need to come up with. So the goal is to hedge against CDS instruments by...

Hello. Can you help with this four question problem? Case PRIVATE EQUITY CASE: MERGER CONSOLIDATION The questions below COMBINE the Ohio & Maryland PT acquisitions as if they are a single c Learning...

Hi. I need Chapter 11 part 1-4 Let me know. Thanks! (it wont letme add more than $8, but I will give $12+ tip) Personal Finance, Fifth Edition by Jeff Madura BUILDING YOUR OWN FINANCIAL PLAN WORKBOOK...

Calculate Nike, Inc.s working capital on May 31, 2015 and 2014 Calculate Nike, Inc.s Current Ratio on May 31, 2015 and 2014. numbers and per share amounts presented reflect the stock split NIKE, Inc....

I need Chapter 2 & 3 finished. Chapter 4 & 5, Chapter 6 & 7, & Chapter 8. Some of this is completed, but it isn't 100% finished. Let me know if you can get to it. Personal Finance, Fifth Edition by...

Excel Assessment Attached is the excel assessment workbook. Each sheet represents a vendor and the jobs that we expect to complete in a particular year. Most jobs have a program name, item...

Why does it make sense to choose the absolute value here Are we looking for gender composition being male-female dominant OR the magnitude of differences in gender composition. Explain?

A steady-flow Carnot refrigeration cycle uses refrigerant- 134a as the working fluid. The refrigerant changes from saturated vapor to saturated liquid at 30C in the condenser as it rejects heat. The...

The question should state, "The subscription price during a rights offering is normally _________ than the rights-on price and _________ than the ex-rights price

In Exercises find the interval of convergence of the power series. (Be sure to include a check for convergence at the endpoints of the interval.) n=0 (-1) xn+1 2n + 1

Final discussion. What did you learn about cultures and norms? How can it be helpful to make the implicit explicit? (510 mins.) Optional method: Small groups develop their own group graffiti and...

Go ahead and use the documents to the companys benefit but make clear to your boss that you do not want him passing confidential information to you in the future. If he threatens to fire you,...

Confront your boss privately and let him know you are uncomfortable with how the documents were obtained and what this says about the companys culture. In addition to the question of the legality of...

The Laura Company has the following errors on its books as of December 31, 2020. The books for 2020 have not yet been closed. a. In 2020, fully depreciated equipment (with no residual value) that...

Moving to another question will save this response. estion 6 1 points On October 1, a corporation had 200,000 shares of 54 par value common stock, and $1,000,000 of retained earnings. The corporation...

When Google Glass experienced a significant decline in sales for its product line, the company temporarily reduced its advertising and sales expenditures for the products in an attempt to improve...