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.
Company | 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 |