|
Distribution Date: |
11/18/22 |
BANK 2017-BNK5 |
|
Determination Date: |
11/14/22 |
|
|
Next Distribution Date: |
12/16/22 |
|
|
Record Date: |
10/31/22 |
Commercial Mortgage Pass-Through Certificates |
|
|
|
Series 2017-BNK5 |
|
Table of Contents |
|
|
Contacts |
|
|
|
Section |
Pages |
Role |
Party and Contact Information |
|
|
|
Certificate Distribution Detail |
2 |
Depositor |
Morgan Stanley Capital I Inc. |
|
|
|
Certificate Factor Detail |
3 |
|
General Information Number |
(212) 761-4000 |
cmbs_notices@morganstanley.com |
|
Certificate Interest Reconciliation Detail |
4 |
|
1585 Broadway | New York, NY 10036 | United States |
|
|
|
|
|
General Master Servicer |
Wells Fargo Bank, National Association |
|
|
|
Additional Information |
5 |
|
|
|
|
|
|
|
|
Investor Relations |
|
REAM_InvestorRelations@wellsfargo.com |
|
Bond / Collateral Reconciliation - Cash Flows |
6 |
|
|
|
|
|
|
|
|
Three Wells Fargo, MAC D1050-084, 401 S. Tryon Street, 8th Floor | Charlotte, NC 28202 | United States |
||
|
Bond / Collateral Reconciliation - Balances |
7 |
Master & Special Servicer |
National Cooperative Bank, N.A. |
|
|
|
Current Mortgage Loan and Property Stratification |
8-12 |
|
Kathleen Luzik |
(703) 302-1902 |
|
|
Mortgage Loan Detail (Part 1) |
13-15 |
|
2011 Crystal Drive, Suite 800 | Arlington, VA 22202 | United States |
|
|
|
Mortgage Loan Detail (Part 2) |
16-18 |
General Special Servicer |
LNR Partners, LLC |
|
|
|
Principal Prepayment Detail |
19 |
|
Heather Bennett and Job Warshaw |
|
lnr.cmbs.notices@lnrproperty.com |
|
Historical Detail |
20 |
|
2340 Collins Avenue, Suite 700 | Miami Beach, FL 33139 | United States |
|
|
|
Delinquency Loan Detail |
21 |
Operating Advisor & Asset |
Park Bridge Lender Services LLC |
|
|
|
|
|
Representations Reviewer |
|
|
|
|
Collateral Stratification and Historical Detail |
22 |
|
David Rodgers |
(212) 230-9025 |
|
|
Specially Serviced Loan Detail - Part 1 |
23 |
|
600 Third Avenue, 40th Floor | New York, NY 10016 | United States |
|
|
|
Specially Serviced Loan Detail - Part 2 |
24 |
Certificate Administrator |
Computershare Trust Company, N.A. as agent for Wells Fargo |
|
|
|
|
|
|
Bank, N.A. |
|
|
|
Modified Loan Detail |
25 |
|
Corporate Trust Services (CMBS) |
|
cts.cmbs.bond.admin@wellsfargo.com; |
|
Historical Liquidated Loan Detail |
26 |
|
|
|
trustadministrationgroup@wellsfargo.com |
|
|
|
|
9062 Old Annapolis Road | Columbia, MD 21045 | United States |
|
|
|
Historical Bond / Collateral Loss Reconciliation Detail |
27 |
|
|
|
|
|
|
|
Trustee |
Wilmington Trust, National Association |
|
|
|
Interest Shortfall Detail - Collateral Level |
28 |
|
|
|
|
|
|
|
|
Attention: CMBS Trustee |
(302) 636-4140 |
CMBSTrustee@wilmingtontrust.com |
|
Supplemental Notes |
29 |
|
|
|
|
|
|
|
|
1100 North Market Street | Wilmington, DE 19890 | United States |
|
|
This report is compiled by Computershare Trust Company, N.A. from information provided by third parties. Computershare Trust Company, N.A. has not independently confirmed the accuracy of the information.
Please visit www.ctslink.com for additional information and if applicable, any special notices and any credit risk retention notices. In addition, certificate holders may register online for email notification when special notices are posted. For information or assistance please call 866-846-4526.
|
© 2021 Computershare. All rights reserved. Confidential. |
Page 1 of 29 |
|
|
|
|
|
Certificate Distribution Detail |
|
|
|
|
|
|||
|
|
||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
Current |
Original |
|
|
|
Pass-Through |
|
|
Principal |
Interest |
Prepayment |
|
|
|
Credit |
Credit |
|
Class |
CUSIP |
Rate (2) |
Original Balance Beginning Balance |
Distribution |
Distribution |
Penalties |
Realized Losses Total Distribution Ending Balance |
Support¹ Support¹ |
||||
|
|
||||||||||||
|
A-1 |
06541WAS1 |
1.909000% |
37,200,000.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00% |
30.00% |
|
A-2 |
06541WAT9 |
2.987000% |
98,300,000.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00% |
30.00% |
|
A-SB |
06541WAU6 |
3.179000% |
52,700,000.00 |
49,012,429.42 |
867,670.05 |
129,842.09 |
0.00 |
0.00 |
997,512.14 |
48,144,759.37 |
34.25% |
30.00% |
|
A-3 |
06541WAV4 |
3.020000% |
52,700,000.00 |
47,550,793.73 |
0.00 |
119,669.50 |
0.00 |
0.00 |
119,669.50 |
47,550,793.73 |
34.25% |
30.00% |
|
A-4 |
06541WAW2 |
3.131000% |
270,000,000.00 |
270,000,000.00 |
0.00 |
704,475.00 |
0.00 |
0.00 |
704,475.00 |
270,000,000.00 |
34.25% |
30.00% |
|
A-5 |
06541WAX0 |
3.390000% |
307,906,000.00 |
307,906,000.00 |
0.00 |
869,834.45 |
0.00 |
0.00 |
869,834.45 |
307,906,000.00 |
34.25% |
30.00% |
|
A-S |
06541WBA9 |
3.624000% |
140,367,000.00 |
140,367,000.00 |
0.00 |
423,908.34 |
0.00 |
0.00 |
423,908.34 |
140,367,000.00 |
20.55% |
18.00% |
|
B |
06541WBB7 |
3.896000% |
55,562,000.00 |
55,562,000.00 |
0.00 |
180,391.29 |
0.00 |
0.00 |
180,391.29 |
55,562,000.00 |
15.13% |
13.25% |
|
C |
06541WBC5 |
4.330770% |
40,940,000.00 |
40,940,000.00 |
0.00 |
147,751.42 |
0.00 |
0.00 |
147,751.42 |
40,940,000.00 |
11.13% |
9.75% |
|
D |
06541WAC6 |
3.078000% |
42,403,000.00 |
42,403,000.00 |
0.00 |
108,763.69 |
0.00 |
0.00 |
108,763.69 |
42,403,000.00 |
6.99% |
6.13% |
|
E |
06541WAE2 |
4.330770% |
24,856,000.00 |
24,856,000.00 |
0.00 |
89,704.67 |
0.00 |
0.00 |
89,704.67 |
24,856,000.00 |
4.57% |
4.00% |
|
F |
06541WAG7 |
4.330770% |
11,698,000.00 |
11,698,000.00 |
0.00 |
42,217.79 |
0.00 |
0.00 |
42,217.79 |
11,698,000.00 |
3.43% |
3.00% |
|
G |
06541WAJ1 |
4.330770% |
14,621,000.00 |
14,621,000.00 |
0.00 |
52,766.82 |
0.00 |
0.00 |
52,766.82 |
14,621,000.00 |
2.00% |
1.75% |
|
H* |
06541WAL6 |
4.330770% |
20,470,946.00 |
20,470,946.00 |
0.00 |
73,879.13 |
0.00 |
0.00 |
73,879.13 |
20,470,946.00 |
0.00% |
0.00% |
|
RR Interest |
BCC2DPUK9 |
4.330770% |
61,564,418.24 |
53,967,745.77 |
45,666.84 |
194,768.23 |
0.00 |
0.00 |
240,435.07 |
53,922,078.93 |
0.00% |
0.00% |
|
V |
06541WAP7 |
0.000000% |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00% |
0.00% |
|
R |
06541WAQ5 |
0.000000% |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00% |
0.00% |
|
Regular SubTotal |
|
1,231,288,364.24 |
1,079,354,914.92 |
913,336.89 |
3,137,972.42 |
0.00 |
0.00 |
4,051,309.31 |
1,078,441,578.03 |
|
|
|
|
|
||||||||||||
|
|
||||||||||||
|
X-A |
06541WAY8 |
1.085869% |
818,806,000.00 |
674,469,223.15 |
0.00 |
610,321.28 |
0.00 |
0.00 |
610,321.28 |
673,601,553.10 |
|
|
|
X-B |
06541WAZ5 |
0.520810% |
236,869,000.00 |
236,869,000.00 |
0.00 |
102,803.16 |
0.00 |
0.00 |
102,803.16 |
236,869,000.00 |
|
|
|
X-D |
06541WAA0 |
1.252770% |
42,403,000.00 |
42,403,000.00 |
0.00 |
44,267.66 |
0.00 |
0.00 |
44,267.66 |
42,403,000.00 |
|
|
|
Notional SubTotal |
|
1,098,078,000.00 |
953,741,223.15 |
0.00 |
757,392.10 |
0.00 |
0.00 |
757,392.10 |
952,873,553.10 |
|
|
|
|
|
||||||||||||
|
Deal Distribution Total |
|
|
|
913,336.89 |
3,895,364.52 |
0.00 |
0.00 |
4,808,701.41 |
|
|
|
|
|
|
||||||||||||
|
* |
Denotes the Controlling Class (if required) |
|
|
|
|
|
|
|
|
|
|
|
|
(1) |
Calculated by taking (A) the sum of the ending certificate balance of all classes in a series less (B) the sum of (i) the ending certificate balance of the designated class and (ii) the ending certificate balance of all classes which are not subordinate to the designated class and |
|||||||||||
|
|
dividing the result by (A). |
|
|
|
|
|
|
|
|
|
|
|
|
(2) |
Pass-Through Rates with respect to any Class of Certificates on next month’s Payment Date is expected to be the same as the current respective Pass-Through Rate, subject to any modifications on the underlying loans, any change in certificate or pool balance, any change in |
|||||||||||
|
|
the underlying index (if and as applicable), and any other matters provided in the governing documents. |
|
|
|
|
|
|
|
|
|||
|
|
||||||||||||
|
|
||||||||||||
|
|
||||||||||||
|
|
||||||||||||
|
© 2021 Computershare. All rights reserved. Confidential. |
|
|
|
|
|
|
|
Page 2 of 29 |
||||
|
|
|
|
|
Certificate Factor Detail |
|
|
|
|||
|
|
|
|
|
|
|
Cumulative |
|
|
|
|
|
|
|
|
|
|
Interest Shortfalls |
Interest |
|
|
|
|
|
Class |
CUSIP |
Beginning Balance |
Principal Distribution |
Interest Distribution |
/ (Paybacks) |
Shortfalls |
Prepayment Penalties |
Losses |
Total Distribution |
Ending Balance |
|
Regular Certificates |
|
|
|
|
|
|
|
|
|
|
|
A-1 |
06541WAS1 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
|
A-2 |
06541WAT9 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
|
A-SB |
06541WAU6 |
930.02712372 |
16.46432732 |
2.46379677 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
18.92812410 |
913.56279639 |
|
A-3 |
06541WAV4 |
902.29210114 |
0.00000000 |
2.27076850 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
2.27076850 |
902.29210114 |
|
A-4 |
06541WAW2 |
1,000.00000000 |
0.00000000 |
2.60916667 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
2.60916667 |
1,000.00000000 |
|
A-5 |
06541WAX0 |
1,000.00000000 |
0.00000000 |
2.82500000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
2.82500000 |
1,000.00000000 |
|
A-S |
06541WBA9 |
1,000.00000000 |
0.00000000 |
3.02000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
3.02000000 |
1,000.00000000 |
|
B |
06541WBB7 |
1,000.00000000 |
0.00000000 |
3.24666661 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
3.24666661 |
1,000.00000000 |
|
C |
06541WBC5 |
1,000.00000000 |
0.00000000 |
3.60897460 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
3.60897460 |
1,000.00000000 |
|
D |
06541WAC6 |
1,000.00000000 |
0.00000000 |
2.56499988 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
2.56499988 |
1,000.00000000 |
|
E |
06541WAE2 |
1,000.00000000 |
0.00000000 |
3.60897449 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
3.60897449 |
1,000.00000000 |
|
F |
06541WAG7 |
1,000.00000000 |
0.00000000 |
3.60897504 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
3.60897504 |
1,000.00000000 |
|
G |
06541WAJ1 |
1,000.00000000 |
0.00000000 |
3.60897476 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
3.60897476 |
1,000.00000000 |
|
H |
06541WAL6 |
1,000.00000000 |
0.00000000 |
3.60897489 |
0.00000000 |
0.34432752 |
0.00000000 |
0.00000000 |
3.60897489 |
1,000.00000000 |
|
RR Interest |
BCC2DPUK9 |
876.60611946 |
0.74177327 |
3.16364932 |
0.00000000 |
0.00602588 |
0.00000000 |
0.00000000 |
3.90542259 |
875.86434618 |
|
V |
06541WAP7 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
|
R |
06541WAQ5 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
|
|
||||||||||
|
Notional Certificates |
|
|
|
|
|
|
|
|
|
|
|
X-A |
06541WAY8 |
823.72286372 |
0.00000000 |
0.74537959 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.74537959 |
822.66318652 |
|
X-B |
06541WAZ5 |
1,000.00000000 |
0.00000000 |
0.43400850 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
0.43400850 |
1,000.00000000 |
|
X-D |
06541WAA0 |
1,000.00000000 |
0.00000000 |
1.04397472 |
0.00000000 |
0.00000000 |
0.00000000 |
0.00000000 |
1.04397472 |
1,000.00000000 |
|
|
||||||||||
|
|
||||||||||
|
|
||||||||||
|
|
||||||||||
|
© 2021 Computershare. All rights reserved. Confidential. |
|
|
|
|
|
|
Page 3 of 29 |
|||
|
|
|
|
|
Certificate Interest Reconciliation Detail |
|
|
|
|
||||
|
|
||||||||||||
|
|
|
|
|
|
|
|
|
|
Additional |
|
|
|
|
|
|
|
|
Accrued |
Net Aggregate |
Distributable |
Interest |
|
Interest |
|
|
|
|
|
|
Accrual |
Prior Interest |
Certificate |
Prepayment |
Certificate |
Shortfalls / |
Payback of Prior |
Distribution |
Interest |
Cumulative |
|
|
Class |
Accrual Period |
Days |
Shortfalls |
Interest |
Interest Shortfall |
Interest |
(Paybacks) |
Realized Losses |
Amount |
Distribution |
Interest Shortfalls |
|
|
A-1 |
N/A |
N/A |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
|
A-2 |
N/A |
N/A |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
|
A-SB |
10/01/22 - 10/30/22 |
30 |
0.00 |
129,842.09 |
0.00 |
129,842.09 |
0.00 |
0.00 |
0.00 |
129,842.09 |
0.00 |
|
|
A-3 |
10/01/22 - 10/30/22 |
30 |
0.00 |
119,669.50 |
0.00 |
119,669.50 |
0.00 |
0.00 |
0.00 |
119,669.50 |
0.00 |
|
|
A-4 |
10/01/22 - 10/30/22 |
30 |
0.00 |
704,475.00 |
0.00 |
704,475.00 |
0.00 |
0.00 |
0.00 |
704,475.00 |
0.00 |
|
|
A-5 |
10/01/22 - 10/30/22 |
30 |
0.00 |
869,834.45 |
0.00 |
869,834.45 |
0.00 |
0.00 |
0.00 |
869,834.45 |
0.00 |
|
|
X-A |
10/01/22 - 10/30/22 |
30 |
0.00 |
610,321.28 |
0.00 |
610,321.28 |
0.00 |
0.00 |
0.00 |
610,321.28 |
0.00 |
|
|
X-B |
10/01/22 - 10/30/22 |
30 |
0.00 |
102,803.16 |
0.00 |
102,803.16 |
0.00 |
0.00 |
0.00 |
102,803.16 |
0.00 |
|
|
A-S |
10/01/22 - 10/30/22 |
30 |
0.00 |
423,908.34 |
0.00 |
423,908.34 |
0.00 |
0.00 |
0.00 |
423,908.34 |
0.00 |
|
|
X-D |
10/01/22 - 10/30/22 |
30 |
0.00 |
44,267.66 |
0.00 |
44,267.66 |
0.00 |
0.00 |
0.00 |
44,267.66 |
0.00 |
|
|
B |
10/01/22 - 10/30/22 |
30 |
0.00 |
180,391.29 |
0.00 |
180,391.29 |
0.00 |
0.00 |
0.00 |
180,391.29 |
0.00 |
|
|
C |
10/01/22 - 10/30/22 |
30 |
0.00 |
147,751.42 |
0.00 |
147,751.42 |
0.00 |
0.00 |
0.00 |
147,751.42 |
0.00 |
|
|
D |
10/01/22 - 10/30/22 |
30 |
0.00 |
108,763.69 |
0.00 |
108,763.69 |
0.00 |
0.00 |
0.00 |
108,763.69 |
0.00 |
|
|
E |
10/01/22 - 10/30/22 |
30 |
0.00 |
89,704.67 |
0.00 |
89,704.67 |
0.00 |
0.00 |
0.00 |
89,704.67 |
0.00 |
|
|
F |
10/01/22 - 10/30/22 |
30 |
0.00 |
42,217.79 |
0.00 |
42,217.79 |
0.00 |
0.00 |
0.00 |
42,217.79 |
0.00 |
|
|
G |
10/01/22 - 10/30/22 |
30 |
0.00 |
52,766.82 |
0.00 |
52,766.82 |
0.00 |
0.00 |
0.00 |
52,766.82 |
0.00 |
|
|
H |
10/01/22 - 10/30/22 |
30 |
7,023.37 |
73,879.12 |
0.00 |
73,879.12 |
0.00 |
0.00 |
0.00 |
73,879.13 |
7,048.71 |
|
|
RR Interest |
10/01/22 - 10/30/22 |
30 |
369.65 |
194,768.23 |
0.00 |
194,768.23 |
0.00 |
0.00 |
0.00 |
194,768.23 |
370.98 |
|
|
V |
N/A |
N/A |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
|
Totals |
|
|
7,393.02 |
3,895,364.51 |
0.00 |
3,895,364.51 |
0.00 |
0.00 |
0.00 |
3,895,364.52 |
7,419.69 |
|
|
|
||||||||||||
|
|
||||||||||||
|
|
||||||||||||
|
|
||||||||||||
|
© 2021 Computershare. All rights reserved. Confidential. |
|
|
|
|
|
|
|
Page 4 of 29 |
||||
|
|
Additional Information |
|
|
Total Available Distribution Amount (1) |
4,808,701.41 |
|
|
(1) The Available Distribution Amount includes any Prepayment Premiums. |
|
|
|
|
||
|
|
||
|
|
||
|
|
||
|
© 2021 Computershare. All rights reserved. Confidential. |
|
Page 5 of 29 |
|
Bond / Collateral Reconciliation - Cash Flows |
|
||
|
|
|||
|
Total Funds Collected |
|
Total Funds Distributed |
|
|
Interest |
|
Fees |
|
|
Interest Paid or Advanced |
3,914,247.18 |
Master Servicing Fee |
11,496.23 |
|
Interest Reductions due to Nonrecoverability Determination |
0.00 |
Certificate Administrator Fee |
4,998.54 |
|
Interest Adjustments |
0.00 |
Trustee Fee |
290.00 |
|
Deferred Interest |
0.00 |
CREFC® Intellectual Property Royalty License Fee |
464.72 |
|
ARD Interest |
0.00 |
Operating Advisor Fee |
1,410.10 |
|
Net Prepayment Interest Excess / (Shortfall) |
0.00 |
Asset Representations Reviewer Fee |
223.07 |
|
Extension Interest |
0.00 |
|
|
|
Interest Reserve Withdrawal |
0.00 |
|
|
|
Total Interest Collected |
3,914,247.18 |
Total Fees |
18,882.66 |
|
|
|||
|
Principal |
|
Expenses/Reimbursements |
|
|
Scheduled Principal |
913,336.89 |
Reimbursement for Interest on Advances |
0.00 |
|
Unscheduled Principal Collections |
|
ASER Amount |
0.00 |
|
Principal Prepayments |
0.00 |
Special Servicing Fees (Monthly) |
0.00 |
|
Collection of Principal after Maturity Date |
0.00 |
Special Servicing Fees (Liquidation) |
0.00 |
|
Recoveries From Liquidations and Insurance Proceeds |
0.00 |
Special Servicing Fees (Work Out) |
0.00 |
|
Excess of Prior Principal Amounts Paid |
0.00 |
Legal Fees |
0.00 |
|
Curtailments |
0.00 |
Rating Agency Expenses |
0.00 |
|
Principal Adjustments |
0.00 |
Taxes Imposed on Trust Fund |
0.00 |
|
|
|
Non-Recoverable Advances |
0.00 |
|
|
|
Workout Delayed Reimbursement Amounts |
0.00 |
|
|
|
Other Expenses |
0.00 |
|
Total Principal Collected |
913,336.89 |
Total Expenses/Reimbursements |
0.00 |
|
|
|||
|
|
|
Interest Reserve Deposit |
0.00 |
|
|
|||
|
Other |
|
Payments to Certificateholders and Others |
|
|
Prepayment Penalties / Yield Maintenance |
0.00 |
Interest Distribution |
3,895,364.52 |
|
Gain on Sale / Excess Liquidation Proceeds |
0.00 |
Principal Distribution |
913,336.89 |
|
Borrower Option Extension Fees |
0.00 |
Prepayment Penalties / Yield Maintenance |
0.00 |
|
Net SWAP Counterparty Payments Received |
0.00 |
Borrower Option Extension Fees |
0.00 |
|
|
|
Net SWAP Counterparty Payments Paid |
0.00 |
|
Total Other Collected |
0.00 |
Total Payments to Certificateholders and Others |
4,808,701.41 |
|
Total Funds Collected |
4,827,584.07 |
Total Funds Distributed |
4,827,584.07 |
|
|
|||
|
© 2021 Computershare. All rights reserved. Confidential. |
|
|
Page 6 of 29 |
|
|
|
Bond / Collateral Reconciliation - Balances |
|
||
|
|
|||||
|
|
|
Collateral Reconciliation |
|
Certificate Reconciliation |
|
|
|
|
|
Total |
|
Total |
|
Beginning Scheduled Collateral Balance |
1,079,354,915.52 |
1,079,354,915.52 |
Beginning Certificate Balance |
1,079,354,914.92 |
|
|
(-) Scheduled Principal Collections |
913,336.89 |
913,336.89 |
(-) Principal Distributions |
913,336.89 |
|
|
(-) Unscheduled Principal Collections |
0.00 |
0.00 |
(-) Realized Losses |
0.00 |
|
|
(-) Principal Adjustments (Cash) |
0.00 |
0.00 |
Realized Loss and Realized Loss Adjustments on Collateral |
0.00 |
|
|
(-) Principal Adjustments (Non-Cash) |
0.00 |
0.00 |
Current Period NRA¹ |
0.00 |
|
|
(-) Realized Losses from Collateral |
0.00 |
0.00 |
Current Period WODRA¹ |
0.00 |
|
|
(-) Other Adjustments² |
0.00 |
0.00 |
Principal Used to Pay Interest |
0.00 |
|
|
|
|
|
|
Non-Cash Principal Adjustments |
0.00 |
|
Ending Scheduled Collateral Balance |
1,078,441,578.63 |
1,078,441,578.63 |
Certificate Other Adjustments** |
0.00 |
|
|
Beginning Actual Collateral Balance |
1,079,354,915.52 |
1,079,354,915.52 |
Ending Certificate Balance |
1,078,441,578.03 |
|
|
Ending Actual Collateral Balance |
1,078,441,578.63 |
1,078,441,578.63 |
|
|
|
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|
NRA/WODRA Reconciliation |
|
Under / Over Collateralization Reconciliation |
|
|
|
|
Non-Recoverable Advances (NRA) from |
Workout Delayed Reimbursement of Advances |
|
|
|
|
|
Principal |
(WODRA) from Principal |
Beginning UC / (OC) |
(0.60) |
|
Beginning Cumulative Advances |
0.00 |
0.00 |
UC / (OC) Change |
0.00 |
|
|
Current Period Advances |
0.00 |
0.00 |
Ending UC / (OC) |
(0.60) |
|
|
Ending Cumulative Advances |
0.00 |
0.00 |
Net WAC Rate |
4.33% |
|
|
|
|
|
|
UC / (OC) Interest |
0.00 |
|
(1) |
Current Period NRA and WODRA displayed will represent the portion applied as Realized Losses to the bonds. |
|
|
|
|
|
(2) |
Other Adjustments value will represent miscellaneous items that may impact the Scheduled Balance of the collateral. |
|
|
|
|
|
** |
A negative value for Certificate Other Adjustments represents the payback of prior Principal Shortfalls, if any. |
|
|
|
|
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
© 2021 Computershare. All rights reserved. Confidential. |
|
|
Page 7 of 29 |
||
|
|
|
|
|
Current Mortgage Loan and Property Stratification |
|
|
|
|
||||||
|
|
||||||||||||||
|
|
||||||||||||||
|
|
||||||||||||||
|
|
|
|
Scheduled Balance |
|
|
|
|
|
Debt Service Coverage Ratio¹ |
|
|
|
||
|
|
Scheduled |
# Of |
Scheduled |
% Of |
|
|
Weighted Avg |
Debt Service Coverage |
# Of |
Scheduled |
% Of |
|
|
Weighted Avg |
|
|
|
|
|
|
WAM² |
WAC |
|
|
|
|
|
WAM² |
WAC |
|
|
|
Balance |
Loans |
Balance |
Agg. Bal. |
|
|
DSCR¹ |
Ratio |
Loans |
Balance |
Agg. Bal. |
|
|
DSCR¹ |
|
|
Defeased |
4 |
17,248,788.47 |
1.60% |
53 |
4.4498 |
NAP |
Defeased |
4 |
17,248,788.47 |
1.60% |
53 |
4.4498 |
NAP |
|
|
5,000,000 or less |
34 |
95,209,342.84 |
8.83% |
53 |
4.3069 |
1.814101 |
1.30 or less |
20 |
149,127,950.35 |
13.83% |
53 |
4.4541 |
0.705745 |
|
5,000,001 to 10,000,000 |
15 |
110,244,605.71 |
10.22% |
54 |
4.4241 |
2.413887 |
1.31 to 1.40 |
4 |
99,420,165.67 |
9.22% |
55 |
4.2056 |
1.383054 |
|
|
10,000,001 to 15,000,000 |
6 |
76,603,744.80 |
7.10% |
49 |
4.3312 |
2.166032 |
1.41 to 1.50 |
2 |
33,263,376.86 |
3.08% |
53 |
4.4942 |
1.444712 |
|
|
15,000,001 to 20,000,000 |
7 |
116,205,019.50 |
10.78% |
53 |
4.5258 |
1.798892 |
1.51 to 1.60 |
4 |
37,636,737.39 |
3.49% |
54 |
4.4024 |
1.565304 |
|
|
20,000,001 to 35,000,000 |
7 |
166,353,779.42 |
15.43% |
54 |
4.3834 |
1.772436 |
1.61 to 1.80 |
7 |
137,768,228.01 |
12.77% |
55 |
4.2947 |
1.709106 |
|
|
35,000,001 to 50,000,000 |
6 |
249,752,490.50 |
23.16% |
48 |
3.8312 |
2.781667 |
1.81 to 2.00 |
8 |
96,631,841.41 |
8.96% |
50 |
4.4298 |
1.890686 |
|
|
|
50,000,001 or greater |
4 |
246,823,807.39 |
22.89% |
55 |
4.1457 |
1.750230 |
2.01 to 2.25 |
10 |
166,718,962.49 |
15.46% |
54 |
4.2215 |
2.087542 |
|
|
Totals |
83 |
1,078,441,578.63 |
100.00% |
52 |
4.2112 |
2.117076 |
2.26 to 2.50 |
4 |
63,799,825.22 |
5.92% |
54 |
4.0396 |
2.279199 |
|
|
|
|
|
|
|
|
|
2.51 or greater |
20 |
276,825,702.76 |
25.67% |
49 |
3.9231 |
3.518665 |
|
|
|
|
|
|
|
|
|
Totals |
83 |
1,078,441,578.63 |
100.00% |
52 |
4.2112 |
2.117076 |
|
(1) |
Debt Service Coverage Ratios are updated periodically as new NOI figures become available from borrowers on an asset level. In all cases the most current DSCR provided by the Servicer is used. To the extent that no DSCR is provided by the Servicer, information from the offering document is |
|||||||||||||
|
|
used. The debt service coverage ratio information was provided to the Certificate Administrator by the Master Servicer and the Certificate Administrator has not independently confirmed the accuracy of such information. |
|
|
|
|
|||||||||
|
(2) |
Anticipated Remaining Term and WAM are each calculated based upon the term from the current month to the earlier of the Anticipated Repayment Date, if applicable, and the Maturity Date. |
|
|
|
|
|
||||||||
|
(3) |
Data in this table was calculated by allocating pro-rata the current loan information to the properties based upon the Cut Off Date Balance of each property as disclosed in the offering document. The Scheduled Balance Totals reflect the aggregate balances of all pooled loans as reported in the |
|||||||||||||
|
|
CREFC Loan Periodic Update File. To the extent that the Scheduled Balance Total figure for the "State" and "Property" stratification tables is not equal to the sum of the scheduled balance figures for each state or property, the difference is explained by loans that have been modified into a split |
|||||||||||||
|
|
loan structure. The "State" and "Property" stratification tables do not include the balance of the subordinate note (sometimes called the B-piece or a "hope note") of a loan that has been modified into a split-loan structure. Rather, the scheduled balance for each state or property only reflects the |
|||||||||||||
|
|
balance of the senior note (sometimes called the A-piece) of a loan that has been modified into a split-loan structure. |
|
|
|
|
|
|
|
|
|||||
|
|
||||||||||||||
|
|
||||||||||||||
|
|
||||||||||||||
|
|
||||||||||||||
|
© 2021 Computershare. All rights reserved. Confidential. |
|
|
|
|
|
|
|
|
|
Page 8 of 29 |
||||
|
|
|
|
Current Mortgage Loan and Property Stratification |
|
|
|
|
||||||
|
|
|||||||||||||
|
|
|||||||||||||
|
|
|||||||||||||
|
|
|||||||||||||
|
|
|
|
State³ |
|
|
|
|
|
State³ |
|
|
|
|
|
|
# Of |
Scheduled |
% Of |
|
|
Weighted Avg |
|
# Of |
Scheduled |
% Of |
|
|
Weighted Avg |
|
State |
|
|
|
WAM² |
WAC |
|
State |
|
|
|
WAM² |
WAC |
|
|
|
Properties |
Balance |
Agg. Bal. |
|
|
DSCR¹ |
|
Properties |
Balance |
Agg. Bal. |
|
|
DSCR¹ |
|
Defeased |
4 |
17,248,788.47 |
1.60% |
53 |
4.4498 |
NAP |
Pennsylvania |
4 |
3,087,602.06 |
0.29% |
47 |
4.2774 |
2.112024 |
|
Alabama |
3 |
19,519,786.37 |
1.81% |
51 |
4.3340 |
1.569946 |
South Carolina |
3 |
6,963,773.44 |
0.65% |
51 |
4.6071 |
1.672150 |
|
Arizona |
3 |
8,470,755.05 |
0.79% |
43 |
4.4841 |
3.193015 |
Tennessee |
4 |
14,765,030.12 |
1.37% |
54 |
4.3400 |
2.552700 |
|
Arkansas |
1 |
261,987.65 |
0.02% |
55 |
4.4860 |
1.657400 |
Texas |
36 |
191,544,113.49 |
17.76% |
53 |
4.2083 |
1.975028 |
|
California |
34 |
361,505,391.24 |
33.52% |
53 |
4.1359 |
2.790465 |
Utah |
2 |
16,783,487.57 |
1.56% |
54 |
4.1444 |
1.725547 |
|
Colorado |
3 |
14,320,800.00 |
1.33% |
54 |
4.0024 |
2.987906 |
Virginia |
5 |
27,519,901.25 |
2.55% |
51 |
4.4172 |
1.347311 |
|
Connecticut |
3 |
24,581,618.53 |
2.28% |
50 |
4.0486 |
1.701467 |
Washington |
3 |
11,917,302.57 |
1.11% |
54 |
4.0221 |
1.965658 |
|
Florida |
4 |
2,212,141.49 |
0.21% |
19 |
3.5628 |
3.669000 |
Wisconsin |
5 |
4,085,779.35 |
0.38% |
31 |
3.7544 |
3.065420 |
|
Georgia |
2 |
6,078,348.88 |
0.56% |
52 |
4.7972 |
1.944542 |
Wyoming |
1 |
771,963.18 |
0.07% |
55 |
4.4860 |
1.657400 |
|
Illinois |
5 |
15,661,859.29 |
1.45% |
53 |
4.6964 |
1.860648 |
Totals |
203 |
1,078,441,578.63 |
100.00% |
52 |
4.2112 |
2.117076 |
|
Indiana |
7 |
11,377,982.18 |
1.06% |
35 |
3.9773 |
2.765901 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Property Type³ |
|
|
|
|
|
Iowa |
1 |
378,585.09 |
0.04% |
19 |
3.5628 |
3.669000 |
|
|
|
|
|
|
|
|
Kentucky |
1 |
1,355,041.79 |
0.13% |
55 |
4.4860 |
1.657400 |
|
# Of |
Scheduled |
% Of |
|
|
Weighted Avg |
|
|
|
|
|
|
|
|
Property Type |
|
|
|
WAM² |
WAC |
|
|
Louisiana |
1 |
312,332.70 |
0.03% |
19 |
3.5628 |
3.669000 |
|
Properties |
Balance |
Agg. Bal. |
|
|
DSCR¹ |
|
Maryland |
4 |
12,849,615.69 |
1.19% |
44 |
4.4760 |
2.498618 |
Defeased |
4 |
17,248,788.47 |
1.60% |
53 |
4.4498 |
NAP |
|
Michigan |
7 |
14,994,739.41 |
1.39% |
43 |
3.8949 |
2.499325 |
Industrial |
28 |
42,664,659.99 |
3.96% |
29 |
3.8784 |
3.225801 |
|
Minnesota |
6 |
23,885,851.25 |
2.21% |
49 |
4.7642 |
0.839586 |
Lodging |
68 |
137,995,772.46 |
12.80% |
54 |
4.6190 |
1.181864 |
|
Missouri |
5 |
31,004,538.83 |
2.87% |
52 |
4.4799 |
2.259640 |
Mixed Use |
2 |
65,279,997.72 |
6.05% |
53 |
4.0870 |
2.138249 |
|
Nevada |
1 |
424,187.38 |
0.04% |
19 |
3.5628 |
3.669000 |
Multi-Family |
26 |
92,946,158.11 |
8.62% |
54 |
4.1314 |
1.451562 |
|
New Jersey |
1 |
1,330,404.70 |
0.12% |
55 |
4.4860 |
1.657400 |
Office |
22 |
170,437,466.40 |
15.80% |
52 |
4.1954 |
1.622893 |
|
New York |
28 |
228,339,536.03 |
21.17% |
54 |
4.0218 |
1.688392 |
Other |
12 |
45,400,000.00 |
4.21% |
53 |
3.7950 |
2.116600 |
|
North Carolina |
5 |
50,353,670.34 |
4.67% |
53 |
4.7335 |
0.434213 |
Retail |
21 |
446,507,624.49 |
41.40% |
54 |
4.1466 |
2.302962 |
|
Ohio |
6 |
6,364,782.25 |
0.59% |
49 |
4.3400 |
2.235262 |
Self Storage |
20 |
117,738,888.76 |
10.92% |
54 |
4.3174 |
3.344036 |
|
Oklahoma |
4 |
4,288,759.12 |
0.40% |
53 |
4.5601 |
1.827946 |
Totals |
203 |
1,078,441,578.63 |
100.00% |
52 |
4.2112 |
2.117076 |
|
Oregon |
1 |
1,658,899.64 |
0.15% |
55 |
4.4860 |
1.657400 |
|
|
|
|
|
|
|
|
|
|||||||||||||
|
Note: Please refer to footnotes on the next page of the report. |
|
|
|
|
|
|
|
|
|
|
|
||
|
|
|||||||||||||
|
|
|||||||||||||
|
|
|||||||||||||
|
|
|||||||||||||
|
© 2021 Computershare. All rights reserved. Confidential. |
|
|
|
|
|
|
|
|
|
Page 9 of 29 |
|||
|
|
|
|
|
Current Mortgage Loan and Property Stratification |
|
|
|
|
||||||
|
|
||||||||||||||
|
|
||||||||||||||
|
|
||||||||||||||
|
|
|
|
Note Rate |
|
|
|
|
|
Seasoning |
|
|
|
||
|
|
|
# Of |
Scheduled |
% Of |
|
|
Weighted Avg |
|
# Of |
Scheduled |
% Of |
|
|
Weighted Avg |
|
|
Note Rate |
|
|
|
WAM² |
WAC |
|
Seasoning |
|
|
|
WAM² |
WAC |
|
|
|
|
Loans |
Balance |
Agg. Bal. |
|
|
DSCR¹ |
|
Loans |
Balance |
Agg. Bal. |
|
|
DSCR¹ |
|
|
Defeased |
4 |
17,248,788.47 |
1.60% |
53 |
4.4498 |
NAP |
Defeased |
4 |
17,248,788.47 |
1.60% |
53 |
4.4498 |
NAP |
|
|
4.00000% or less |
29 |
365,586,490.82 |
33.90% |
50 |
3.8039 |
2.514655 |
12 months or less |
0 |
0.00 |
0.00% |
0 |
0.0000 |
0.000000 |
|
|
4.00001% to 4.50000% |
26 |
476,149,060.57 |
44.15% |
55 |
4.2502 |
2.113541 |
13 months to 24 months |
0 |
0.00 |
0.00% |
0 |
0.0000 |
0.000000 |
|
|
4.5000% to 5.00000% |
22 |
210,537,633.32 |
19.52% |
51 |
4.7716 |
1.393966 |
25 months to 36 months |
0 |
0.00 |
0.00% |
0 |
0.0000 |
0.000000 |
|
|
5.00001% or greater |
2 |
8,919,605.45 |
0.83% |
53 |
5.1398 |
1.817944 |
37 months to 48 months |
0 |
0.00 |
0.00% |
0 |
0.0000 |
0.000000 |
|
|
Totals |
83 |
1,078,441,578.63 |
100.00% |
52 |
4.2112 |
2.117076 |
49 months or greater |
79 |
1,061,192,790.16 |
98.40% |
52 |
4.2073 |
2.106480 |
|
|
|
|
|
|
|
|
|
Totals |
83 |
1,078,441,578.63 |
100.00% |
52 |
4.2112 |
2.117076 |
|
(1) |
Debt Service Coverage Ratios are updated periodically as new NOI figures become available from borrowers on an asset level. In all cases the most current DSCR provided by the Servicer is used. To the extent that no DSCR is provided by the Servicer, information from the offering document |
|||||||||||||
|
|
is used. The debt service coverage ratio information was provided to the Certificate Administrator by the Master Servicer and the Certificate Administrator has not independently confirmed the accuracy of such information. |
|
|
|
|
|||||||||
|
(2) |
Anticipated Remaining Term and WAM are each calculated based upon the term from the current month to the earlier of the Anticipated Repayment Date, if applicable, and the Maturity Date. |
|
|
|
|
|
||||||||
|
(3) |
Data in this table was calculated by allocating pro-rata the current loan information to the properties based upon the Cut Off Date Balance of each property as disclosed in the offering document. The Scheduled Balance Totals reflect the aggregate balances of all pooled loans as reported in the |
|||||||||||||
|
|
CREFC Loan Periodic Update File. To the extent that the Scheduled Balance Total figure for the "State" and "Property" stratification tables is not equal to the sum of the scheduled balance figures for each state or property, the difference is explained by loans that have been modified into a split |
|||||||||||||
|
|
loan structure. The "State" and "Property" stratification tables do not include the balance of the subordinate note (sometimes called the B-piece or a "hope note") of a loan that has been modified into a split-loan structure. Rather, the scheduled balance for each state or property only reflects the |
|||||||||||||
|
|
balance of the senior note (sometimes called the A-piece) of a loan that has been modified into a split-loan structure. |
|
|
|
|
|
|
|
|
|||||
|
|
||||||||||||||
|
|
||||||||||||||
|
|
||||||||||||||
|
|
||||||||||||||
|
© 2021 Computershare. All rights reserved. Confidential. |
|
|
|
|
|
|
|
|
|
Page 10 of 29 |
||||
|
|
|
|
|
Current Mortgage Loan and Property Stratification |
|
|
|
|
||||||
|
|
||||||||||||||
|
|
||||||||||||||
|
|
||||||||||||||
|
|
|
Anticipated Remaining Term (ARD and Balloon Loans) |
|
|
|
Remaining Amortization Term (ARD and Balloon Loans) |
|
|
||||||
|
|
Anticipated |
# Of |
Scheduled |
% Of |
|
|
Weighted Avg |
Remaining |
# Of |
Scheduled |
% Of |
|
|
Weighted Avg |
|
|
|
|
|
|
WAM² |
WAC |
|
|
|
|
|
WAM² |
WAC |
|
|
|
Remaining Term |
Loans |
Balance |
Agg. Bal. |
|
|
DSCR¹ |
Amortization Term |
Loans |
Balance |
Agg. Bal. |
|
|
DSCR¹ |
|
|
Defeased |
4 |
17,248,788.47 |
1.60% |
53 |
4.4498 |
NAP |
Defeased |
4 |
17,248,788.47 |
1.60% |
53 |
4.4498 |
NAP |
|
|
60 months or less |
79 |
1,061,192,790.16 |
98.40% |
52 |
4.2073 |
2.106480 |
Interest Only |
20 |
511,085,000.00 |
47.39% |
51 |
4.0146 |
2.723134 |
|
61 months to 84 months |
0 |
0.00 |
0.00% |
0 |
0.0000 |
0.000000 |
300 months or less |
51 |
527,106,396.82 |
48.88% |
53 |
4.4069 |
1.535406 |
|
|
85 months to 116 months |
0 |
0.00 |
0.00% |
0 |
0.0000 |
0.000000 |
301 months or greater |
8 |
23,001,393.34 |
2.13% |
54 |
3.9171 |
1.491490 |
|
|
|
117 months or greater |
0 |
0.00 |
0.00% |
0 |
0.0000 |
0.000000 |
Totals |
83 |
1,078,441,578.63 |
100.00% |
52 |
4.2112 |
2.117076 |
|
|
Totals |
83 |
1,078,441,578.63 |
100.00% |
52 |
4.2112 |
2.117076 |
|
|
|
|
|
|
|
|
(1) |
Debt Service Coverage Ratios are updated periodically as new NOI figures become available from borrowers on an asset level. In all cases the most current DSCR provided by the Servicer is used. To the extent that no DSCR is provided by the Servicer, information from the offering document |
|||||||||||||
|
|
is used. The debt service coverage ratio information was provided to the Certificate Administrator by the Master Servicer and the Certificate Administrator has not independently confirmed the accuracy of such information. |
|
|
|
|
|||||||||
|
(2) |
Anticipated Remaining Term and WAM are each calculated based upon the term from the current month to the earlier of the Anticipated Repayment Date, if applicable, and the Maturity Date. |
|
|
|
|
|
||||||||
|
(3) |
Data in this table was calculated by allocating pro-rata the current loan information to the properties based upon the Cut Off Date Balance of each property as disclosed in the offering document. The Scheduled Balance Totals reflect the aggregate balances of all pooled loans as reported in the |
|||||||||||||
|
|
CREFC Loan Periodic Update File. To the extent that the Scheduled Balance Total figure for the "State" and "Property" stratification tables is not equal to the sum of the scheduled balance figures for each state or property, the difference is explained by loans that have been modified into a split |
|||||||||||||
|
|
loan structure. The "State" and "Property" stratification tables do not include the balance of the subordinate note (sometimes called the B-piece or a "hope note") of a loan that has been modified into a split-loan structure. Rather, the scheduled balance for each state or property only reflects the |
|||||||||||||
|
|
balance of the senior note (sometimes called the A-piece) of a loan that has been modified into a split-loan structure. |
|
|
|
|
|
|
|
|
|||||
|
|
||||||||||||||
|
|
||||||||||||||
|
|
||||||||||||||
|
|
||||||||||||||
|
© 2021 Computershare. All rights reserved. Confidential. |
|
|
|
|
|
|
|
|
|
Page 11 of 29 |
||||
|
|
|
|
|
Current Mortgage Loan and Property Stratification |
|
|
||||||
|
|
||||||||||||
|
|
||||||||||||
|
|
||||||||||||
|
|
|
|
Age of Most Recent NOI |
|
|
|
|
Remaining Stated Term (Fully Amortizing Loans) |
|
|||
|
|
Age of Most |
# Of |
Scheduled |
% Of |
|
|
Weighted Avg |
Age of Most |
# Of |
Scheduled |
% Of |
Weighted Avg |
|
|
|
|
|
|
WAM² |
WAC |
|
|
|
|
WAM² |
WAC |
|
|
Recent NOI |
Loans |
Balance |
Agg. Bal. |
|
|
DSCR¹ |
Recent NOI |
Loans |
Balance |
Agg. Bal. |
DSCR¹ |
|
|
Defeased |
4 |
17,248,788.47 |
1.60% |
53 |
4.4498 |
NAP |
|
|
|
None |
|
|
Underwriter's Information |
4 |
75,679,000.00 |
7.02% |
55 |
3.7846 |
2.953499 |
|
|
|
|
|
|
|
|
1 year or less |
64 |
962,678,761.02 |
89.27% |
52 |
4.2472 |
2.050810 |
|
|
|
|
|
|
|
1 year to 2 years |
11 |
22,835,029.14 |
2.12% |
54 |
3.9268 |
1.646262 |
|
|
|
|
|
|
|
2 years or greater |
0 |
0.00 |
0.00% |
0 |
0.0000 |
0.000000 |
|
|
|
|
|
|
|
Totals |
83 |
1,078,441,578.63 |
100.00% |
52 |
4.2112 |
2.117076 |
|
|
|
|
|
|
(1) |
Debt Service Coverage Ratios are updated periodically as new NOI figures become available from borrowers on an asset level. In all cases the most current DSCR provided by the Servicer is used. To the extent that no DSCR is provided by the Servicer, information from the offering document |
|||||||||||
|
|
is used. The debt service coverage ratio information was provided to the Certificate Administrator by the Master Servicer and the Certificate Administrator has not independently confirmed the accuracy of such information. |
|
||||||||||
|
(2) |
Anticipated Remaining Term and WAM are each calculated based upon the term from the current month to the earlier of the Anticipated Repayment Date, if applicable, and the Maturity Date. |
|
|
|
||||||||
|
(3) |
Data in this table was calculated by allocating pro-rata the current loan information to the properties based upon the Cut Off Date Balance of each property as disclosed in the offering document. The Scheduled Balance Totals reflect the aggregate balances of all pooled loans as reported in the |
|||||||||||
|
|
CREFC Loan Periodic Update File. To the extent that the Scheduled Balance Total figure for the "State" and "Property" stratification tables is not equal to the sum of the scheduled balance figures for each state or property, the difference is explained by loans that have been modified into a split |
|||||||||||
|
|
loan structure. The "State" and "Property" stratification tables do not include the balance of the subordinate note (sometimes called the B-piece or a "hope note") of a loan that has been modified into a split-loan structure. Rather, the scheduled balance for each state or property only reflects the |
|||||||||||
|
|
balance of the senior note (sometimes called the A-piece) of a loan that has been modified into a split-loan structure. |
|
|
|
|
|
|
|||||
|
|
||||||||||||
|
|
||||||||||||
|
|
||||||||||||
|
|
||||||||||||
|
© 2021 Computershare. All rights reserved. Confidential. |
|
|
|
|
|
|
|
Page 12 of 29 |
||||
|
|
|
|
|
|
Mortgage Loan Detail (Part 1) |
|
|
|
|
|
|
|||||
|
|
||||||||||||||||
|
|
|
Prop |
|
|
|
|
|
|
|
|
Original Adjusted |
Beginning |
Ending |
Paid |
|
|
|
|
|
Type |
|
|
Interest |
|
Scheduled |
Scheduled |
Principal |
Anticipated Maturity Maturity |
Scheduled |
Scheduled |
Through |
|
||
|
Pros ID |
Loan ID |
(1) |
City |
State Accrual Type Gross Rate |
Interest |
Principal |
Adjustments Repay Date Date |
Date |
Balance |
Balance |
Date |
|
||||
|
1 |
310941125 |
RT |
Torrance |
CA |
Actual/360 |
3.658% |
115,968.25 |
0.00 |
0.00 |
N/A |
06/01/27 |
-- |
36,821,000.00 |
36,821,000.00 |
11/01/22 |
|
|
1A |
307980001 |
|
|
|
Actual/360 |
3.658% |
115,968.25 |
0.00 |
0.00 |
N/A |
06/01/27 |
-- |
36,821,000.00 |
36,821,000.00 |
11/01/22 |
|
|
1B |
307980101 |
|
|
|
Actual/360 |
3.658% |
25,759.87 |
0.00 |
0.00 |
N/A |
06/01/27 |
-- |
8,179,000.00 |
8,179,000.00 |
11/01/22 |
|
|
1C |
310941339 |
|
|
|
Actual/360 |
3.658% |
25,759.87 |
0.00 |
0.00 |
N/A |
06/01/27 |
-- |
8,179,000.00 |
8,179,000.00 |
11/01/22 |
|
|
2 |
307980002 |
LO |
Various |
Various |
Actual/360 |
4.486% |
280,063.47 |
0.00 |
0.00 |
N/A |
06/01/27 |
-- |
72,500,000.00 |
72,500,000.00 |
11/01/22 |
|
|
3 |
1749473 |
OF |
White Plains |
NY |
Actual/360 |
4.076% |
227,743.66 |
97,476.18 |
0.00 |
N/A |
07/01/27 |
-- |
64,886,288.27 |
64,788,812.09 |
11/01/22 |
|
|
4 |
310939172 |
RT |
The Woodlands |
TX |
Actual/360 |
4.085% |
149,499.65 |
0.00 |
0.00 |
N/A |
06/01/27 |
-- |
42,500,000.00 |
42,500,000.00 |
11/01/22 |
|
|
4A |
307980004 |
|
|
|
Actual/360 |
4.085% |
79,146.88 |
0.00 |
0.00 |
N/A |
06/01/27 |
-- |
22,500,000.00 |
22,500,000.00 |
11/01/22 |
|
|
5 |
307980005 |
MU |
New York |
NY |
Actual/360 |
3.954% |
190,668.13 |
0.00 |
0.00 |
N/A |
05/06/27 |
-- |
56,000,000.00 |
56,000,000.00 |
11/06/22 |
|
|
6 |
310939983 |
RT |
San Jose |
CA |
Actual/360 |
3.970% |
183,299.37 |
83,085.56 |
0.00 |
05/11/27 |
05/11/29 |
-- |
53,618,080.86 |
53,534,995.30 |
11/11/22 |
|
|
8 |
307980008 |
98 |
Various |
Various |
Actual/360 |
3.795% |
148,363.42 |
0.00 |
0.00 |
04/06/27 |
04/06/28 |
-- |
45,400,000.00 |
45,400,000.00 |
11/06/22 |
|
|
9 |
307980009 |
Various Various |
Various |
Actual/360 |
3.563% |
138,059.66 |
0.00 |
0.00 |
N/A |
06/05/24 |
-- |
45,000,000.00 |
45,000,000.00 |
11/05/22 |
|
|
|
10 |
310940170 |
OF |
Anaheim |
CA |
Actual/360 |
4.195% |
156,295.27 |
56,300.27 |
0.00 |
N/A |
06/11/27 |
-- |
43,266,790.77 |
43,210,490.50 |
11/11/22 |
|
|
11 |
310939637 |
SS |
Various |
CA |
Actual/360 |
4.100% |
117,390.97 |
0.00 |
0.00 |
N/A |
05/01/27 |
-- |
33,250,000.00 |
33,250,000.00 |
11/01/22 |
|
|
12 |
310939161 |
LO |
Glen Allen |
VA |
Actual/360 |
4.490% |
88,471.08 |
40,076.11 |
0.00 |
N/A |
04/11/27 |
-- |
22,882,095.71 |
22,842,019.60 |
11/11/22 |
|
|
13 |
600939206 |
LO |
Charlotte |
NC |
Actual/360 |
4.900% |
96,187.81 |
36,493.87 |
0.00 |
N/A |
04/11/27 |
-- |
22,796,322.16 |
22,759,828.29 |
11/11/22 |
|
|
14 |
300801608 |
RT |
New York |
NY |
Actual/360 |
4.420% |
87,540.56 |
0.00 |
0.00 |
N/A |
05/01/27 |
-- |
23,000,000.00 |
23,000,000.00 |
11/01/22 |
|
|
15 |
600938902 |
OF |
Raleigh |
NC |
Actual/360 |
4.680% |
87,692.83 |
31,317.54 |
0.00 |
N/A |
05/11/27 |
-- |
21,760,007.37 |
21,728,689.83 |
11/11/22 |
|
|
16 |
1749067 |
RT |
Shelton |
CT |
Actual/360 |
4.120% |
72,055.96 |
36,924.88 |
0.00 |
N/A |
06/01/27 |
-- |
20,310,166.58 |
20,273,241.70 |
11/01/22 |
|
|
17 |
310938721 |
LO |
Brooklyn Park |
MN |
Actual/360 |
4.930% |
84,590.68 |
31,905.00 |
0.00 |
N/A |
03/11/27 |
-- |
19,925,829.58 |
19,893,924.58 |
11/11/22 |
|
|
19 |
310939178 |
OF |
Birmingham |
AL |
Actual/360 |
4.390% |
68,889.75 |
26,142.62 |
0.00 |
N/A |
04/11/27 |
-- |
18,223,462.45 |
18,197,319.83 |
11/11/22 |
|
|
21 |
1546629 |
MF |
Platte City |
MO |
Actual/360 |
4.700% |
67,585.10 |
19,546.05 |
0.00 |
N/A |
05/01/27 |
-- |
16,699,132.68 |
16,679,586.63 |
11/01/22 |
|
|
22 |
310940007 |
RT |
San Antonio |
TX |
Actual/360 |
4.620% |
60,038.29 |
25,259.20 |
0.00 |
N/A |
05/11/27 |
-- |
15,091,316.23 |
15,066,057.03 |
11/11/22 |
|
|
23 |
410938214 |
SS |
Various |
TN |
Actual/360 |
4.340% |
55,277.44 |
26,018.52 |
0.00 |
N/A |
05/11/27 |
-- |
14,791,048.65 |
14,765,030.13 |
11/11/22 |
|
|
24 |
310939400 |
RT |
New York |
NY |
Actual/360 |
3.990% |
54,973.33 |
0.00 |
0.00 |
N/A |
04/11/27 |
-- |
16,000,000.00 |
16,000,000.00 |
11/11/22 |
|
|
25 |
300801605 |
RT |
Plano |
TX |
Actual/360 |
4.425% |
58,307.64 |
19,037.13 |
0.00 |
N/A |
05/01/27 |
-- |
15,302,168.56 |
15,283,131.43 |
11/01/22 |
|
|
26 |
310938213 |
RT |
Lawndale |
CA |
Actual/360 |
4.540% |
58,973.97 |
0.00 |
0.00 |
N/A |
03/11/27 |
-- |
15,085,000.00 |
15,085,000.00 |
11/11/22 |
|
|
27 |
300801609 |
SS |
Los Angeles |
CA |
Actual/360 |
4.165% |
53,797.92 |
0.00 |
0.00 |
N/A |
05/01/27 |
-- |
15,000,000.00 |
15,000,000.00 |
11/01/22 |
|
|
|
||||||||||||||||
|
|
||||||||||||||||
|
|
||||||||||||||||
|
|
||||||||||||||||
|
© 2021 Computershare. All rights reserved. Confidential. |
|
|
|
|
|
|
|
|
|
|
Page 13 of 29 |
|||||
|
|
|
|
|
|
Mortgage Loan Detail (Part 1) |
|
|
|
|
|
|
|||||
|
|
||||||||||||||||
|
|
|
Prop |
|
|
|
|
|
|
|
|
Original Adjusted |
Beginning |
Ending |
Paid |
|
|
|
|
|
Type |
|
|
Interest |
|
Scheduled |
Scheduled |
Principal |
Anticipated Maturity Maturity |
Scheduled |
Scheduled |
Through |
|
||
|
Pros ID |
Loan ID |
(1) |
City |
State Accrual Type Gross Rate |
Interest |
Principal |
Adjustments Repay Date Date |
Date |
Balance |
Balance |
Date |
|
||||
|
29 |
470103450 |
MF |
New York |
NY |
Actual/360 |
3.810% |
39,348.33 |
33,088.03 |
0.00 |
N/A |
04/01/27 |
-- |
11,993,396.45 |
11,960,308.42 |
11/01/22 |
|
|
30 |
310939849 |
RT |
Vacaville |
CA |
Actual/360 |
4.700% |
47,155.67 |
28,429.76 |
0.00 |
N/A |
05/11/27 |
-- |
11,651,365.45 |
11,622,935.69 |
11/11/22 |
|
|
31 |
1749254 |
RT |
Manchester |
MO |
Actual/360 |
4.320% |
46,500.00 |
0.00 |
0.00 |
N/A |
06/01/27 |
-- |
12,500,000.00 |
12,500,000.00 |
11/01/22 |
|
|
32 |
300801607 |
RT |
Corona |
CA |
Actual/360 |
4.745% |
44,001.09 |
13,346.97 |
0.00 |
N/A |
05/01/24 |
-- |
10,768,817.53 |
10,755,470.56 |
11/01/22 |
|
|
33 |
1749214 |
SS |
Van Nuys |
CA |
Actual/360 |
4.490% |
36,885.73 |
16,253.86 |
0.00 |
N/A |
06/01/27 |
-- |
9,540,097.77 |
9,523,843.91 |
11/01/22 |
|
|
34 |
610936527 |
MU |
Santa Cruz |
CA |
Actual/360 |
4.890% |
39,140.51 |
15,196.69 |
0.00 |
N/A |
01/11/27 |
-- |
9,295,194.41 |
9,279,997.72 |
11/11/22 |
|
|
35 |
600938789 |
RT |
Chicago |
IL |
Actual/360 |
4.700% |
37,145.89 |
15,236.53 |
0.00 |
N/A |
04/11/27 |
-- |
9,178,118.77 |
9,162,882.24 |
11/11/22 |
|
|
36 |
310939631 |
SS |
Various |
CA |
Actual/360 |
4.100% |
34,422.92 |
0.00 |
0.00 |
N/A |
05/01/27 |
-- |
9,750,000.00 |
9,750,000.00 |
11/01/22 |
|
|
37 |
470103760 |
MF |
Bayside |
NY |
Actual/360 |
3.880% |
28,279.21 |
8,666.36 |
0.00 |
N/A |
05/01/27 |
-- |
8,464,012.32 |
8,455,345.96 |
11/01/22 |
|
|
38 |
470102980 |
MF |
Annapolis |
MD |
Actual/360 |
4.960% |
33,007.50 |
12,235.99 |
0.00 |
N/A |
04/01/27 |
-- |
7,728,083.53 |
7,715,847.54 |
11/01/22 |
|
|
39 |
300801606 |
RT |
Easley |
SC |
Actual/360 |
4.690% |
26,099.54 |
10,681.08 |
0.00 |
N/A |
05/01/27 |
-- |
6,462,504.23 |
6,451,823.15 |
11/01/22 |
|
|
40 |
300801611 |
SS |
Oceanside |
CA |
Actual/360 |
4.768% |
25,509.20 |
7,161.60 |
0.00 |
N/A |
05/01/27 |
-- |
6,213,001.57 |
6,205,839.97 |
11/01/22 |
|
|
41 |
1748780 |
RT |
Magna |
UT |
Actual/360 |
4.820% |
23,781.22 |
8,560.09 |
0.00 |
N/A |
06/01/27 |
-- |
5,729,647.66 |
5,721,087.57 |
11/01/22 |
|
|
42 |
300801629 |
SS |
League City |
TX |
Actual/360 |
4.639% |
21,905.32 |
9,096.34 |
0.00 |
N/A |
06/01/27 |
-- |
5,483,604.41 |
5,474,508.07 |
11/01/22 |
|
|
43 |
300801604 |
SS |
Grand Junction |
CO |
Actual/360 |
4.065% |
21,002.50 |
0.00 |
0.00 |
N/A |
||||||