Modeling and Analytics
  • CMBS Pricing & Hedging Models
  • NPL Portfolio Valuation Models
  • Fund Modeling
  • B-Piece Analysis Systems
  • Underwriting Templates
  • Land Valuation Models
  • Investor Reporting
  • Servicing Valuation Models
  • Model Review for Accuracy
  • Financial Analytics
Transactional Activities
  • Debt Placement
  • Commercial Mortgage Brokerage
  • Whole Loan Sales
  • Real Estate Capital Raising
  • Transaction Oversight
LatestNews
  • 07-26-2012 New Analytic Training Seminars Quantinal is pleased to offer 1/2 day or full day analytic training seminars to teach your analysts the proper way to design, structure and create an Excel model
  • 06-01-2012 CREFC Conference Quantinal will be attending the CREFC conference in DC on June 11th to 13th
Quantinal Capital Advisors
Ron Kaminker
1901 Ave of the Stars, #1020
Los Angeles, CA 90067
(310) 272-1390
info@qntnl.com
Formerly Known as C_nd_r Capital Advisors
 
 
 
 
 
The Quantinal NPL Portfolio Valuation Process

Initial Stages

  • Convert database into useable Excel format;
  • "Scrub" the data by standardizing data within fields, checking for errors, and creating calculations (e.g. Balance / Foot);
  • Create detailed stratifications on all relevant fields;
  • Select loans to underwrite;
  • Customize underwriting template (UWT), if needed, to fit requirements of assets in the portfolio;
  • Create UWT's by automatically downloading as much data as possible from the data tape provided.

During Underwriting

  • Review partially and fully completed UWT's to review for accuracy, completeness,  and logical conclusions;
  • Roll up completed UWT's to get sense of values: in total, by underwriter, property type, performance status,...;
  • Update data changes as they come in. If needed write a macro to automatically update the data in the UWT's.

Final Pricing

  • Roll up all UWT's;
  • Extrapolate cash flows on non underwritten assets;
  • Run cash flows through any debt structures, equity waterfalls, FDIC splits after deducting asset management, servicing, disposition fees to calculate net IRR and price;
  • Create price/yield tables;
  • Run sensitivities based on timing and amount of cash flows.
Powered by Adrecom CMS suite and website design by LADezign.com