Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Modeling CMBS Deals

No description
by

Ajay Bhandaram

on 28 October 2013

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Modeling CMBS Deals

Modeling CMBS Deals
1. Issuer emails modeling package to CMBS team
Annex
Loan, bond, deal CFs
Summary
Term Sheet
Other email updates


2. Convert the files to .xls
Asset Setup
Bond Setup
Create a java waterfall

3. MODEL Deal using
CONQUEST

4. Tie out cashflows
Save files to P: Drive
Rolling
1. Download files from
Trustees (IRP)
Factors
Ginnie files
2. Scrub
Remove characters
Insert headers
3. Convert all files to IRP
4. Commentaries and supplemental files go to CMBS staging database
4. Autoroll deals using
CONQUEST
QC PASS
QC FAIL
Manual intervention
SHIP
Deal Update
CONQUEST DATABASE
CMBS Staging database
CMO SUN 1 - CONQUEST
Multiple COMDBs
get updated with collateral Data
LDES
CMB
CRE
BLNR
LRP
...

Conquest (Prod)
SYT
CFT
MTCS
SPA
Python Waterfall Engine
API for Conquest loan flows
YT NEW
Conquest System
Full transcript