Excel Bulk Upload System

Welcome to the AST Defeasance excel bulk upload system. You may use this system to upload an excel spreadsheet with multiple sets of data inputs and get mass calculations. To use it, simply format an excel spreadsheet using the format shown below. Or download the Excel Upload Template. Some columns require specific values as shown. Default values are shown in bold for you.

Example Required Excel Format

Company Email Property Loan Type Purpose Loan Servicer Original
Principal
Amount
Interest
Rate
Interest
Calculation
First
Payment
Date
Loan
Term
Amort
Period
Int
Only
Term
Defeasance
Date
Text ?@?.? Text Amortizing
Interest Only
Partial IO
Other
Purchase
Refinance
Sale
Bank of America
Bank of New York
Berkadia (Formerly CapMark)
CWCapital
GEMSA Loan Services
KeyBank
Midland Loan Services
NCB
Orix
Other
Pacific Life
Principal
Prudential
Wachovia
Wells Fargo
1000000 5.123 Actual/360
30/360
mm/dd/yyyy 180 360 60 mm/dd/yyyy