Spreadsheet: 629525d1561393917-help-with-a-string-of-if-statements-sample
Sheet: Customer onboarding

New Proposal – Information Requirements Checklist
Prepared by: |  | [NAME]
Reviewed by: |  | [NAME]
 |  |  | Y | N | N/a
1.      Proposal:
 | (a)    Sources & Uses table showing:
 |  | i. Settlement amount / purchase price. | Y
 |  | ii. [NAME]. | Y
 |  | iii. Equity to be provided. | Y
 |  | iv. Costs etc. | Y
 | (b) Source of any equity explained |  | Y
 | (c) Is the deal proposed to Finance Ireland contingent on another deal closing. |  |  | N
 | (d)   Name of Borrowers solicitor provided. |  | Y
 | (e) Where proposal involves a refinance of debt:
 |  | i. Has a deal been agreed with the Loan Servicer. | Y
 |  | ii. Terms of settlement disclosed (e.g. level of settlement, closing date, equity contribution). | Y
 |  | iii. Copy of settlement deed provided. | Y
 |  | iv. Any deferred tax liability arising from benefit of partial debt forgiveness. |  | N
 |  | v. Confirmation required from Tax Advisor. |  | N
2.      Ownership structure:
 | (a) Will the Property be held in an SPV. |  | Y
 | (b) Will the Property be retained by the current owner, if not what are the implications |  |  | N
 | (c) Applicable tax rate to include details of losses forward, capital allowances provided. |  | Y
 | (d) CGT base cost provided. |  | Y
3.      The Property:
 | (a) Lease schedule provided to include rents, lease terms, square footage etc, |  | Y
 | (b) Has borrower any previous links to the property. |  | Y
 | (c) Are any of the tenants linked to the borrower. |  |  | N
 | (d) Basis for estimated valuations povided / any previous valuations available? |  | Y
 | (e) Does the Property have any attaching Judgements. |  |  | N
 | (f) Is the Property a PDH. |  |  | N
 | (g) Is there a management company in place? If so, what are the details & control of same? |  | Y
 | (h) Confirmation provided as to who holds the title deeds / leases for the Property – readily available. |  | Y
 | (i) Is the planning for the Property compliant? Confirmation available? |  | Y
4.      Guarantors / Personal Borrowers / Promoters:
 | (a)  Name, phone number, email and home address of borrowers / guarantors provided |  | Y
 | (b)  What is the Borrower profile and experience |  | Y
 | (c)  Global debt position / income position (to include an SOA & Income statement, loan statements), and including any connected debts within companies, SPVs etc |  | Y
 | (d) Have any / all dealings with financial institutions been consensual |  | Y
 | (e) Are there any judgements or pending litigation – all relevant details are to be provided. Searches are required early in the process. |  | Y
 | (f)  ICB completed. |  | Y
 | (g) Experian search to check if any of the parties are banned as acting as Directors |  | Y
 | (h)  Borrower meeting required early in diligence process & property site visit |  | Y
 | (i) Sworn statement of affairs signed by Borrower / Guarantor, possibly in front of Commissioner for oaths “as required” |  | Y
 | (j) SOA to include income details and debt servicing obligations |  | Y
 | (k) Has Borrower / Guarantor or connected parties had any previous dealings with Finance Ireland employees |  |  | N
 | (l) Brief synopsis on Borrower, Guarantor and / or any promoters’ previous history |  | Y
 | (j) Google search on Guarantors / Personal Borrowers / Promoter to identify any adverse media. |  | Y
 | (k) Guarantors / Personal Borrowers / Promoter is known to CRE team or wider Finance Ireland staff |  |  | N
5.      Corporate Borrowers:
 | (a)  Details of any shareholders provided. |  | Y
 | (b) Disclosure of any Beneficial Interests standing behind the shareholders |  | Y
 | (c) Any charges registered against the company |  |  | N
 | (d) Accounts to be provided |  | Y
 | (e)  Projections to be provided |  | Y
 | (f) Creditors up to date |  | Y
 | (g)  Revenue – up to date? Any Revenue audits in past 5 years? Outcome? |  | Y
6.      Experian:
 | (a) Names and d.o.b. of any directors & shareholders |  | Y
 | (b) Any charges against Limited company |  | Y
7.     Sources of funds / AML:
 | (a) Source of funds understood and noted |  | Y
 | (b) Beneficial owners (25%) understood with appropriate ID&V |  | Y
 | (c) Written confirmation on beneficial ownership from promoter/ solicitor/ other source |  |  | N
8.      Legal Process:
 | (a) [NAME] / Promoter advised to request their solicitor to source title deeds, original leases, ‘legal pack’ etc to expedite this aspect of the transaction. Recent transactions have been significantly delayed (and legal fees escalated) if Borrower’s solicitor doesn’t provide a complete, adequate and timely suite of required documentation. |  | Y
 | Note: The above table is based on Customer Onboarding Check Sheet Version 2.1