Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Authentication
digital resources
195x Filetype XLSX File size 0.03 MB Source: www.eba.europa.eu
ID Sheet Formula If value missing (but table Narrative explanation / error message
prerequisites met)
1 3 {3.047} + {3.048} + {3.049} = {3.050} treat as zero/empty string Sum of Fixed Assets + Current Assets + Cash and Cash Equavalents = Total Assets
2 3 {3.050} - {3.051} = {3.052} treat as zero/empty string Total Assets - Net Assets = Total Liabilities
3 7 {7.037}+{7.038} = {7.034} treat as zero/empty string Current Interest Base Rate + Current Interest Margin = Current Interest Rate
4 7 {7.031}+{7.032} = {7.028} treat as zero/empty string Original Interest Base Rate + Original Interest Margin = Original Interest Rate
5 7 {7.017} + {7.018 } + {7.019} = {7.020} treat as zero/empty string Principal balance + Accrued Interest Balance (On book) + Other Balances = Total Balance
6 7 {7.020} + {7.021} = {7.021} treat as zero/empty string Total Balance + Accrued Interest Balance (Off book) = Legal Balance
7 3 {3.006} <= {1.000} Date of Birth is before Cut-off date
8 3 {3.022} <= {1.000} Date of Verification for Personal Details is before Cut-off date
9 3 {3.031} <= {1.000} Date of Incorporation is before Cut-off date
10 3 {3.042} <= {1.000} Date of Financial Statements is before Cut-off date
11 3 {3.059} <= {1.000} Date of Last Contact is before Cut-off date
12 3 {3.069} >= 0 Deposit with Lender is larger than zero
13 3 {3.083} <= {1.000} Date of Internal Demand Issuance is before Cut-off date
14 3 {3.084} <= {1.000} Date of External Demand Issuance is before Cut-off date
15 3 {3.085} <= {1.000} Date When Reservation of Rights Letter Was Issued is before Cut-off Date
16 3 {3.088} <= {1.000} Date of Obtaining Order for Possession is before Cut-off date
17 3 {3.089} <= {1.000} Eviction Date is before cut-off date
18 3 {3.09} <= {1.000} Sheriff / Bailiff Date is before Cut-off date
19 7 {7.004} <= {1.000} Date of Origination is before Cut-off date
20 7 {7.04} <= {1.000} Start Date of Interest Only Period before Cut-off date
21 7 {7.042} <= {1.000} Start Date of Current Fixed Interest Period is before Cut-off date
22 7 {7.053} <= {1.000} Last Interest Reset Date is before Cut-off date
23 7 {7.054} >= {1.000} Next Interest Reset Date is after Cut-off date
24 7 {7.058} <= {1.000} Last Payment Date Before the Cut-off date
25 7 {7.062} >= {1.000} Next Principal Scheduled Repayment Date is after Cut-off date
26 7 {7.063} >= {1.000} Next Interest Scheduled Repayment Date is after Cut-off date
27 7 {7.077} <= {1.000} Non-Performing Date is before Cut-off date
28 7 {7.078} <= {1.000} Charge-off Date is before Cut-off date
29 7 {7.088} <= {1.000} Last Covenant Test Date is before Cut-off date
30 7 {7.1} <= {1.000} Start Date of Subsidy is before Cut-off date
31 9 {9.006} <= {1.000} Date Sent to Agent is before Cut-off date
32 9 {9.007} <= {1.000} Date Returned From Agent is before Cut-off date
33 1 {10.004} <= {1.000} Date of First Forbearance is before Cut-off date
34 1 {11.032} <= {1.000} Date of Initial Valuation is before Cut-off date
35 1 {11.038} <= {1.000} Date of Latest Valuation is before Cut-off date
36 1 {13.004} <= {1.000} Start Date of Lease is before Cut-off date
37 1 {13.013} <= {1.000} Last Rent Review Date is before Cut-off date
38 1 {13.014} >= {1.000} Next Rent Review Date is after Cut-off date
39 1 {11.032} <= {1.000} Date of Initial Valuation is before Cut-off date
40 1 {11.038} <= {1.000} Date of Latest Valuation is before Cut-off date
41 1 {16.017} <= {1.000} Prepare Property for Sale Date is before Cut-off date
42 1 {16.018} <= {1.000} Property on Market Date is before Cut-off date
43 1 {16.019} <= {1.000} On Market offer Date is before Cut off date
44 1 {16.02} <= {1.000} Sale Agreed Date is before Cut-off date
45 1 {16.021} <= {1.000} Contracted Date is before Cut-off date
46 1 {16.022} <= {1.000} Sold Date is before Cut-off date
47 1 {16.025} >= {1.000} Next Auction Date is after Cut-off date
48 1 {16.027} <= {1.000} Last Auction Date is before Cut-off date
49 1 {16.034} <= {1.000} Date of Receiver Appointment is before Cut-off date
50 1 {16.04} >= {1.000} Date Next Insurance Payment Is Due is after Cut-off date
51 1 {14.022} <= {1.000} Year of Registration is before Cut-off date
52 1 {14.027} <= {1.000} Year of Manufacture is before Cut-off date
53 1 {17.003} <= {1.000} Start Date of Swap is before Cut-off date
54 3 {3.047} >= 0 Fixed Assets; is larger or equal to zero
55 3 {3.048} >= 0 Current Assets; is larger or equal to zero
56 3 {3.049} >= 0 Cash and Cash Equivalent Items; is larger or equal to zero
57 3 {3.05} >= 0 Total Assets; is larger or equal to zero
58 3 {3.052} >= 0 Total Liabilities; is larger or equal to zero
59 3 {3.053} >= 0 Total Debt; is larger or equal to zero
60 3 {3.054} >= 0 Market Capitalisation; is larger or equal to zero
61 3 {3.058} >= 0 Number of FTE; is larger or equal to zero
62 3 {3.081} >= 0 Number of Current Judgements; is larger or equal to zero
63 3 {3.082} >= 0 Number of Discharged Judgements; is larger or equal to zero
64 3 {3.091} >= 0 Legal Fees Accrued; is larger or equal to zero
65 7 {7.012} >= 0 Final Bullet Repayment; is larger or equal to zero
66 7 {7.016} >= 0 Origination Amount; is larger or equal to zero
67 7 {7.017} >= 0 Principal Balance; is larger or equal to zero
68 7 {7.018} >= 0 Accrued Interest Balance (On book); is larger or equal to zero
69 7 {7.019} >= 0 Other Balances; is larger or equal to zero
70 7 {7.02} >= 0 Total Balance; is larger or equal to zero
71 7 {7.021} >= 0 Accrued Interest Balance (Off book); is larger or equal to zero
72 7 {7.022} >= 0 Legal Balance; is larger or equal to zero
73 7 {7.023} >= 0 Carrying Amount; is larger or equal to zero
74 7 {7.024} >= 0 Write-off Amount; is larger or equal to zero
75 7 {7.025} >= 0 Provision Amount; is larger or equal to zero
76 7 {7.027} >= 0 Legal Balance at Charge-off Date; is larger or equal to zero
77 7 {7.027} >= 0 Loan Commitment; is larger or equal to zero
78 7 {7.052} >= 0 Interest Reset Interval; is larger or equal to zero
79 7 {7.059} >= 0 Last Payment Amount; is larger or equal to zero
80 7 {7.06} >= 0 Next Principal Scheduled Repayment Amount; is larger or equal to zero
81 7 {7.061} >= 0 Next Interest Scheduled Repayment Amount; is larger or equal to zero
82 7 {7.066} >= 0 Past-Due Principal Amount; is larger or equal to zero
83 7 {7.067} >= 0 Past-Due Interest Amount; is larger or equal to zero
84 7 {7.068} >= 0 Other Past-Due Amounts; is larger or equal to zero
85 7 {7.069} >= 0 Total Past-Due Amount; is larger or equal to zero
86 7 {7.07} >= 0 Capitalised Past-Due Amount; is larger or equal to zero
87 7 {7.071} >= 0 Days in Past-Due; is larger or equal to zero
88 7 {7.072} >= 0 Time in Past-Due; is larger or equal to zero
89 7 {7.073} >= 0 Number of Past-Due Events; is larger or equal to zero
90 7 {7.102} >= 0 Subsidy Amount; is larger or equal to zero
91 8 {8.002} >= 0 Total Repayment Schedule; is larger or equal to zero
92 8 {8.003} >= 0 Principal Repayment Schedule; is larger or equal to zero
93 8 {8.004} >= 0 Interest Repayment Schedule; is larger or equal to zero
94 8 {8.005} >= 0 History of Legal Unpaid Balances; is larger or equal to zero
95 8 {8.006} >= 0 History of Past-Due Balances; is larger or equal to zero
96 8 {8.007} >= 0 History of Total Repayments; is larger or equal to zero
97 8 {8.008} >= 0 History of Repayments - Not From Asset Sales; is larger or equal to zero
98 8 {8.009} >= 0 History of Repayments - From Asset Sales; is larger or equal to zero
99 8 {8.01} >= 0 History of Outstanding Balances Since Charge-off; is larger or equal to zero
100 8 {8.011} >= 0 History of Charges/Interest Since Charge-off; is larger or equal to zero
101 8 {8.012} >= 0 History of Payments Since Charge-off; is larger or equal to zero
102 8 {8.013} >= 0 History of Write-off Since Charge-off; is larger or equal to zero
103 9 {9.01} >= 0 Cash Recoveries; is larger or equal to zero
104 9 {9.011} >= 0 Costs Accrued; is larger or equal to zero
105 9 {9.012} >= 0 Principal Forgiveness; is larger or equal to zero
106 10 {10.005} >= 0 Number of Historical Forbearance; is larger or equal to zero
107 10 {10.01} >= 0 Repayment Amount Under Forbearance; is larger or equal to zero
108 10 {10.012} >= 0 Date of Repayment Step Up; is larger or equal to zero
109 10 {10.013} >= 0 Amount of Repayment Step Up; is larger or equal to zero
110 11 {11.016} >= 0 Year of Construction; is larger or equal to zero
111 11 {11.017} >= 0 Year of Refurbishment; is larger or equal to zero
112 11 {11.019} >= 0 Remaining Term of Leasehold; is larger or equal to zero
113 11 {11.02} >= 0 Number of Bedrooms; is larger or equal to zero
114 11 {11.021} >= 0 Number of Rooms; is larger or equal to zero
115 11 {11.022} >= 0 Building Area (M2); is larger or equal to zero
116 11 {11.023} >= 0 Building Area (M2) Lettable; is larger or equal to zero
117 11 {11.024} >= 0 Building Area (M2) Occupied; is larger or equal to zero
118 11 {11.025} >= 0 Number of Lettable Units; is larger or equal to zero
119 11 {11.026} >= 0 Number of Units Vacant; is larger or equal to zero
120 11 {11.027} >= 0 Number of Units Occupied; is larger or equal to zero
121 11 {11.028} >= 0 Land Area (M2) ; is larger or equal to zero
122 11 {11.029} >= 0 Number of Car Parking Spaces; is larger or equal to zero
123 11 {11.031} >= 0 Initial Valuation Amount; is larger or equal to zero
124 11 {11.036} >= 0 Initial Estimated Rental Value; is larger or equal to zero
125 11 {11.037} >= 0 Latest Valuation Amount; is larger or equal to zero
126 11 {11.042} >= 0 Latest Estimated Rental Value; is larger or equal to zero
127 11 {11.043} >= 0 Current Annual Passing Rent; is larger or equal to zero
128 11 {11.044} >= 0 Current Opex And Overheads; is larger or equal to zero
129 11 {11.045} >= 0 Planned Capex next 12m; is larger or equal to zero
130 11 {11.046} >= 0 Current Net Operating Income; is larger or equal to zero
131 11 {11.047} >= 0 Estimated Rental Void; is larger or equal to zero
132 11 {11.048} >= 0 Estimated Annual Void Cost; is larger or equal to zero
133 11 {11.051} >= 0 Amount of VAT Payable; is larger or equal to zero
134 12 {12.003} >= 0 Mortgage amount; is larger or equal to zero
135 12 {12.004} >= 0 Lien Position; is larger or equal to zero
136 12 {12.005} >= 0 Higher Ranking Loan; is larger or equal to zero
137 13 {13.002} >= 0 Rent Coverage Ratio; is larger or equal to zero
138 13 {13.011} >= 0 Rent in Past-Due; is larger or equal to zero
139 13 {13.016} >= 0 Rent Review Interval; is larger or equal to zero
140 13 {13.017} >= 0 Deposit Amount; is larger or equal to zero
141 14 {14.007} >= 0 Guarantee Amount; is larger or equal to zero
142 14 {14.010} >= 0 Date of Initial Valuation; is larger or equal to zero
143 14 {14.012} >= 0 Initial Residual Value; is larger or equal to zero
144 14 {14.013} >= 0 Initial Residual Valuation Date; is larger or equal to zero
145 14 {14.014} >= 0 Date of Latest Valuation; is larger or equal to zero
146 14 {14.017} >= 0 Latest Residual Value; is larger or equal to zero
147 14 {14.019} >= 0 Current Opex And Overheads; is larger or equal to zero
148 14 {14.021} >= 0 Option to Buy Price; is larger or equal to zero
149 14 {14.022} >= 0 Year of Registration; is larger or equal to zero
150 14 {14.026} >= 0 Estimated Useful Life; is larger or equal to zero
151 14 {14.027} >= 0 Year of Manufacture; is larger or equal to zero
152 14 {14.03} >= 0 Engine Size; is larger or equal to zero
153 14 {14.034} >= 0 Collateral Insurance Provider; is larger or equal to zero
154 15 {15.002} >= 0 Lien Position; is larger or equal to zero
155 15 {15.003} >= 0 Higher Ranking Loan; is larger or equal to zero
156 16 {16.007} >= 0 Court Appraisal Amount; is larger or equal to zero
157 16 {16.01} >= 0 On Market Price; is larger or equal to zero
158 16 {16.011} >= 0 Offer Price; is larger or equal to zero
159 16 {16.012} >= 0 Sale Agreed Price; is larger or equal to zero
160 16 {16.013} >= 0 Gross Sale Proceeds; is larger or equal to zero
161 16 {16.014} >= 0 Costs at End of Sale; is larger or equal to zero
162 16 {16.015} >= 0 Net Sale Proceeds; is larger or equal to zero
163 16 {16.016} >= 0 Costs Accrued to Buyer; is larger or equal to zero
164 16 {16.024} >= 0 Court Auction Reserve Price for First Auction; is larger or equal to zero
165 16 {16.026} >= 0 Court Auction Reserve Price for Next Auction; is larger or equal to zero
166 16 {16.028} >= 0 Court Auction Reserve Price for Last Auction; is larger or equal to zero
167 16 {16.029} >= 0 Number of Failed Auctions; is larger or equal to zero
168 16 {16.035} >= 0 Fees of Receivership; is larger or equal to zero
169 16 {16.038} >= 0 Insurance Coverage Amount; is larger or equal to zero
170 16 {16.039} >= 0 Annual Insurance Payment; is larger or equal to zero
171 16 {16.041} >= 0 Amount of Outstanding Liabilities; is larger or equal to zero
172 16 {16.042} >= 0 Other ongoing enforcement proceedings; is larger or equal to zero
173 17 {17.006} >= 0 Current Notional; is larger or equal to zero
no reviews yet
Please Login to review.
