Create a spreadsheet showing an amortization schedule for the payments
(showing principal and interest separately) scheduled to be received each month
for months 1 through 360 from a pool of $100,000,000 in identical 30 year fixed
rate level-payment mortgages with a 5% APR interest rate. Show the total cash
flows coming into this pool assuming a 100% PSA prepayment rate. Make your
spreadsheet flexible enough to use different prepayment rates.
Hint: Put the % of PSA in only one cell, and have all cells that need the PSA speed
link to that cell.
Another hint: Remember that the PSA prepayment rate model calls for an annualized
Conditional Prepayment Rate (CPR) for months 1 through 30 as (t/30)*6.0% and
6.0% thereafter. 200% PSA would mean that the CPR is (t/30)*12% for months 1
through 30 and 12.0% thereafter.
The CPR can be converted to the Single Month Mortality (SMM) as follows:
(1-SMM)12 = (1-CPR)

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.