Excel@CFO

Excel Solutions and Spreadsheets for the Financial Analyst & CFO

Month: April 2018

HEL (Home Equity Prepayment)

By Don Pistulka
04/28/201809/07/2018UncategorizedLeave a Comment on HEL (Home Equity Prepayment)

HEL (Home Equity Prepayment) is similar to the PSA prepayment model in that it starts a 2% CPR in the first month and increasing at 2% CPR until month 10. It then remains at 20% CPR for the remaining life of the pool. Increases or decreases to the standard 100 HEL are made the same […]

Continue Reading

MHP (Prepayment Rate for Manufactured-Housing)

By Don Pistulka
04/26/201809/07/2018UncategorizedLeave a Comment on MHP (Prepayment Rate for Manufactured-Housing)

I have to admit that I have never purchased or sold manufactured housing loan pools, but am aware that those that do own or trade these pools, have different assumptions when applying prepayment rates. The MHP calculation is very close the PSA ramp, except that the first month starts with a 3.7 CPR, and each […]

Continue Reading

Change to “Calculate Historic CPR and PSA”

By Don Pistulka
04/25/201809/07/2018Uncategorized2 Comments on Change to “Calculate Historic CPR and PSA”

In the previous spreadsheet used to calculate historic CPR and PSA, I used a separate sheet in the workbook to run an iteration on an amortization schedule in order to calculate PSA. An iteration is only necessary if the loan pools are 29 months old or less. I have replaced the amortization sheet with a […]

Continue Reading

CMO-Inverse Interest Only (Inverse IO)

By Don Pistulka
04/15/201809/07/2018UncategorizedLeave a Comment on CMO-Inverse Interest Only (Inverse IO)

A reader asked if I had an example of a CMO Inverse IO, and I did not. Although I have not had access to a Bloomberg to check my assumption, I thought I would give it a try. Actual IO’s may vary from my example, but I think I have captured the essences of an […]

Continue Reading

CMO -IO/PO PAIR

By Don Pistulka
04/09/201809/07/2018UncategorizedLeave a Comment on CMO -IO/PO PAIR

This is my fourth free CMO Excel spreadsheet. This post is going to be very short. You can find a lot of information online, so I am not going to add much. After entering the information on the “Inputs” sheet (yellow cells only), go to the “IO_PO” sheet where you will find ways of analyzing […]

Continue Reading

CMO – PAC

By Don Pistulka
04/08/201809/07/2018Uncategorized1 Comment on CMO – PAC

I have posted two other examples (and Excel workbooks) of CMO structures in the past.  Floater & Inverse-Floater CMO and Sequential Pay CMO. Now, we are going to look at a CMO PAC (Planned Amortization Class). It is a simple example, with only two tranches, the PAC and Companion (or sometimes called Support) bonds. The PAC […]

Continue Reading

Subscribe to my posts



Created by Webfish.
April 2018
M T W T F S S
« Mar   May »
 1
2345678
9101112131415
16171819202122
23242526272829
30  

Archives

  • February 2021 (1)
  • January 2021 (3)
  • December 2020 (2)
  • November 2020 (1)
  • September 2020 (1)
  • May 2020 (1)
  • April 2020 (1)
  • August 2019 (1)
  • June 2019 (2)
  • May 2019 (2)
  • April 2019 (1)
  • March 2019 (4)
  • February 2019 (4)
  • January 2019 (1)
  • December 2018 (2)
  • November 2018 (1)
  • October 2018 (1)
  • September 2018 (4)
  • August 2018 (3)
  • July 2018 (2)
  • June 2018 (1)
  • May 2018 (1)
  • April 2018 (6)
  • March 2018 (1)
  • February 2018 (3)
  • August 2017 (1)
  • July 2017 (2)
  • June 2017 (1)
  • May 2017 (3)
  • March 2017 (1)
  • February 2017 (1)
  • December 2016 (1)
  • November 2016 (1)
  • October 2016 (1)
  • September 2016 (4)
  • August 2016 (2)
  • June 2016 (1)
  • May 2016 (3)
  • April 2016 (3)
  • March 2016 (1)
  • February 2016 (1)
  • January 2016 (1)
  • December 2015 (2)
  • November 2015 (3)
  • October 2015 (4)
  • September 2015 (5)
  • August 2015 (7)
  • July 2015 (8)
  • June 2015 (5)
  • May 2015 (6)
  • April 2015 (6)
  • March 2015 (5)
  • February 2015 (5)
  • January 2015 (8)
  • December 2014 (8)
  • November 2014 (10)
  • October 2014 (4)
  • September 2014 (14)
  • August 2014 (7)

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
© Copyright 2021 Excel@CFO. Powered by WordPress.
  • 구글 크롬 전체 다운로드
  • 공부의 왕도 다운로드
  • 플레이스테이션 넷플릭스 다운로드
  • 한컴 오피스 교육 기관용 다운로드
  • 퀘이크 3 다운로드
  • 태양은 없다 다운로드
  • 마이크로소프트 오피스 2016 무료 다운로드
  • 대항해시대 4 다운로드
  • 남아공 월드컵 다운로드
  • 리빌드 3 다운로드
  • 바로가기 다운로드
  • 점프게임 다운로드
  • 초능력자 다운로드
  • 장덕철 지각 다운로드
  • 위대한쇼맨 ost 다운로드
  • 갤럭시노트2 펌웨어 다운로드
  • old town road 다운로드
  • labview 8 5 다운로드
  • gta5 타노스 모드 다운로드
  • alftp 다운로드