Home

User Manual SOLAR Application

Contents

1. Wildcards can be used in searches if not all characters are known The percentage sign is the Wildcard sign Example Execute a search for the name Johnson without knowing the correct notation Type John in the search field Click the lt F8 gt key to collect all names Results are e john e johnson e Johnsons The percentage sign can also be placed in front of the search option Example 0hn A search is executed after names wherein the combination ohn occurs Results are e Bohnen Bohnke Central Wohnungsbau John Johnson Johnsons Mohnen Tailor John Up John Searching is context sensitive pt ppt If the search operation returns empty the status bar displays the message Query caused no records to be retrieved Re enter The first character may be replaced by the percentage sign lt gt in case of p uncertainty whether it is written in capital letters 2 7 2 Range Searches In SOLAR one may search on ranges With the lt Less Than gt lt sign and the lt Greater Than gt gt sign a search can be executed Example only Loans with principal amount larger than EUR 5 000 000 are requested Type gt 5000000 in the Principal Amount field and click the lt F8 gt key or the lt Execute Query gt button User Manual SOLAR v3 4 Page 16 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 2 8 Save and Add Functionality Click the lt OK gt button to save the changes made Saved data can
2. terest income 49 43 Fee ncome 0 i 0 Cash mmagemert ncome 0 I Derwstes FX income 0 B Other incorna OANE 1 a Totalin EUR PT 49 Margon Ramais Vaste marge bij relatie 95 bps Ease Rale Remarks Rente obv Euribor Fee Renerks EUR 500 adm kst Corporate Frontsheet window Earnings Tab Value Description Oblig atory Earnings last 12 months in Euros and next 12 months in Euros two tables Interest Manual Realised margin on interest amounts in Euros Income Input Fee Income Manual Commission amount in Euros Input Cash Manual Cash managed earnings in Euros Manageme Input nt Income User Manual SOLAR v3 4 Page 87 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Corporate Frontsheet window Earnings Tab Value Description Oblig atory Derivates Manual Earnings from pre settlement activities Treasury FX Income Input products In Euros Manual Other earnings In Euros Input Sum of all earnings This sum is aggregated automatically and can not be changed manuall Remarks on Earnings Remarks Input commission or the interest base Remarks Input et a N Remarks Input 4 1 3 Corporate Frontsheet Window Covers Tab General Facilites Earnings i Covenants Orei Transfer Courtry Facilly Nuther Descrintion Cover Value Perc Cover Value sPerc Cover Obliger Obligar Status Biocked 1 ank hypotheek ex EUR 998 jn p I z 7 Ta 3h56 Pank hypotheek EUR 6 000 o femi
3. BAA E Published 55 Term Sheet On the Acceptance Term Sheet window select the lt Accepted gt Approved option On the Maintain Funds Management window the lt Approve gt button can be clicked Pie coe Accepted to complete the loan details 70 Documents The term Sheet with status 70 must be completed with all Prepared and necessary documents Created Disbursement Funding Agreement is signed disbursement request from the Ordered and client received Treasury receives summary and draft funding Checked fora agreement The Loan disbursement has been prepared Loan SOLAR gt Term Sheet gt Maintain Disbursement Order PA gt Maintain Disbursement Order by PA window delete the disbursement order and enter the disbursement in SOLAR gt Term Sheet gt Disbursement Order Loan Rejected Rejected 130 Application Proposal De activated 140 Term Sheet Accepted but Expired 3 1 Preparatory Tasks before Entering an Application Application for a Loan Client posts Loan application Tasks to do before the application can be registered in SOLAR 1 Contact Details in the Grid for existing clients a SOLAR ID number is available The client must always be registered in GRID within the Credit Risk Management portal Type all contact details data after a click on the ING Real Estate data link Next check the Cross References checkbox External and click the Add Cross Reference hyperlink This opens the National ID Kamer van Koophandel field to
4. Client Check A click on the Clt button opens the Maintain Client window can also be reached by using the shortcut key ALT 1 Appraiser Check A click on the App button opens the Appraisers window Creditor Check A click on the Crd button or using the shortcut key ALT C opens the Maintain Creditors window Guarantee Check A click on the G Ind button opens the Maintain Lender Guarantee Lender window or by using the ALT G shortcut ke Bank Name Automa This field is filled by a click on the Bank Accounts tic button which opens the Maintaining Bank Details window where all bank details can be added Domicile Automa Filled from Maintain Bank Details window Yes Country tic Domicile Faa Filled from Maintain Bank Details window Yes tic Swift Code Automa Filled from Maintain Bank Details window Swift codes Yes tic can be found on the Swift Bic Website Bank Code ma Filled from Maintain Bank Details window tic Bank Automa Number of bank account Account tic Abroad Number of Giro account User Manual SOLAR v3 4 Page 114 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Person Company Details Window Core Values Description Obligatory The Details window of for example the lt I ntermediary gt checkbox contains the same functionality as in the before described Company Person Details window See to obtaining first all necessary data for filling out the required fields A click on the lt
5. Every proposal that has been submitted regarding a particular application must be approved before a term sheet can be prepared At the time of approval the system checks whether the user is authorized to implement a proposal approval If so the fields relating to the authoriser will be filled with the user details the system date is displayed in the date field and the authorising field is filled The authorising body is determined by reference to an approvals matrix in SOLAR The determinants in this matrix are e Quality Check Debtor Property e Approval or Rejection from the Credit Committee e Cancellation from client e Client Type If the proposal is to be approved the Approved LOV option must be selected after which the user can press the lt OK gt button The status of the proposal changes from Status 30 to Status 40 Proposal Approved making the item ready for drawing up the term sheet It is possible to enter a comment related to the approval A rejected or retained proposal leads to abandoning the Proposal Three options are available 1 SOLAR gt Term Sheet gt Deactivate Application gt Deactivate Application window 2 SOLAR gt Term Sheet gt Reactivate Application gt Reactivate Application window 3 SOLAR gt Term Sheet gt Approve gt Approval Proposal window Between the Proposal and the Term Sheet the Maintain Status Description per Application and or Term Sheet window serves to provide an overview of the available applicat
6. ING REAL ESTATE User Manual SOLAR Application Date 06 29 2007 Version 34 Status Draft Author ING Real Estate Finance User Manual SOLAR v3 4 Page 1 of 135 2007 ING REF All Rights Reserved 06 29 2007 Internal Use Only Revision History Version Description comments Author Date 1 00 Initial version Timmo Joosten 31 03 2003 2 00 Properties module revised Securities Escrows Iris de Rover 15 12 2003 Prolongations added to publication 2 01 Additional information Properties Properties Michael Thiel 01 09 2004 module 2 1 Securities Securities Module 2 03 Interests phase II Ratings phase I and Funding version 1 0 2 02 Translation in English R L Piek 18 05 2005 2 03 Review and completion of English version Eric Labordus 12 08 2005 3 0 Renewed English Version draft Francien van der 22 05 2007 Velden 3 1 Changes added Corporate Frontsheet Follow Francien van der 05 25 2007 the Process Insight Velden 3 2 Transfer Corp Frontsheets add info to Deposit Francien van der 04 06 2007 Request PRE Velden 3 3 Process changes reported by Mila Adamson Francien van der 06 29 2007 and Hein Mijland Velden Filename A0932022 Org REF Operations I T Functioneel System Management Systemen Solar Handleidingen User Manual SOLAR Lastsaved 06 29 2007 User Manual SOLAR v3 4 Page 2 of 135 2007 ING REF All Rights Reserved 06 29
7. Term sheet date 7 04 2007 Valid until 4 03 2007 Periodicity i Portfolio tacilty nr 1st roll over dete Margin ee C Currency Eur uro Economic term Principal amount T5000 Expiry date 042012 Registration 3 173 000 Clean up oO Initial increese COo E Subrogation fi Increase Extended O Funding E Approved o o gn00e0 Lean to value percentage 70 Loan File name Curr Outst Frinc Art General_ PPP en Eur text Loan Costsiescrow Securities Document ClientProp Other text Salutation The additional fields on this window are Maintain Term Sheet window Field Values__ Description Obligatory User Manual SOLAR v3 4 Page 48 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Term Sheet window Field _ Values _ Description _ Obligatory Term Automatic Filled from the Maintain Term Sheet sub N A window Loan Acceptance Date Date of agreement with client Yes Margin Automatic 1 or 2 of the principal amount already N A decided in the Maintain Application sub window Interest Periodicity Automatic Deduced from Maintain Term Sheet sub N A window Loan 1 Roll Over Date Manual Date to revaluate loan provisions No Input Economic Term Manual Duration of the loan differs from expiry Input date Expiry Date Manual Date on which the interest contract Input agreements expire Not to be confused with the end date or roll over date Maintain Term S
8. Client Number__ LOV__ Select from Find Contact window _ No_ Name LOV_ Deduced from Client Number__ No_ Client Type Automat Filled with the selection from Clients ic Properties window field Capacit On the File Contact Details window Direct Displays all involvement of the client with outstanding loan Involved applications ry __ Application Automatic Filled oy soraR_ NA staus fidem idem NA Currency fidem idem fna amount fidem idem fna MTemsneet fidem idem NA loan fidem idem fna FileName idem idem fna Outstanding Jidem idem NA Arrears idem idem na User Manual SOLAR v3 4 Page 42 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Application Window Buttons Indirect Refer to Direct Involved button for explanation of the fields Involved Client Opens the Maintain Client Obligations window where the Obligation outstanding balance and the name of the lender can be seen s e ry ME N Provider D icine E matic L Amount of client obligations __ Maturity Date _ End term of obligation Total Group Auto Total amount of Group Exposure N A Exposure matic Other Exposure Total amount of other exposure matic On the Maintain Client Obligations window Company Person Add or change details of the client N A al Details Addresses Opens Addresses window to add or change address details of the client Default Periods Opens the Con
9. Enter Cancellation Window Obligatory available on the Maintain Loan window Property Address PC Yes Cit Domicile of the propert Yes Status LOV Select the applicable status Cancellation of Property Foreign Automatic Filled by the system if applicable N A Address Land Registry Automatic Market Value Automatic Old Market Value Manual Input Change Market Value Manual Input New Gross Rental Automatic Value Old Gross Rental Manual Input Value Change Gross Rental Manual Input Value New Filled by the system Filled by the system Status LOV Select the status or leave empty Cancellation Transaction Automatic Filled upon selecting a Status Cancellation N A Date option Market Value Manual Input Rental Value _ Manualinput SSS P repayment Filled with the PPP number that is issued for payment If checked the loan is divided on more than N A one participant Section Part Code of the section part Status LOV Select the status Cancellation Date the Status Cancellation is selected Date Market Value Manual Input Type the market value Rental Value Manual Input Type the rental value User Manual SOLAR v3 4 Page 132 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only g gt o jo n nw Enter Cancellation Window C T Obligatory E he security umber _ ___MA_ na The Cancel Mortgage request is recorded in SOLAR gt Cancel Mortgage gt Enter Cancellat
10. User Manual SOLAR v3 4 Page 60 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only N Maintain loan Apatestion 2007 01 0716 Term sheet seq number 3 Status Fp saes sd Lasn fommna ING Bark eetas T Apalcstion date 19 01 2007 Client peor pueros Gosterbeck B V Product type PM iargagetoan File neme QUEROS OOSTERBEEK B V Product cade po lonker s mortgage Rotationahip mor pie P G 3 Kuipers CS Paley Peper pm onstruction Finance Policy Department fat FilKanmeorArmhem Loan purpose pov ake over r e from Vor Accourt Manager Far z A J G Westra Nijkamp Exposure type fr Etres Centre po NG Reol Estate Finanec H V LOO exposure ponar ot Uweg htercomo Ctr E D Boo fae pof Uweg Role NG al LOO par BO o Portfoio facity m sd S Closing date _ Currency pur Euo o O Disbursement tale o Pancia amcurt manana Interest ot dete pt o42007 Regctotion onoo Loan to value 80 0000 Short LTFund F Subrogation gt Econortic tern P yt cn Typa straignt tin Mia g Expiry cate 042009 mth Stotement dete ak Fie tansiered po Legalierm a yr Spec funded oO Checked Loan Compl jm hes e moth Bark account tits Bark account sbr aooo Gencral PPP Loan Securities l zilentProperty Salutation oon interest aroud fields are displayed Maintain Loan Window Description al poe Generated pe SOLAR NA A a Term Autom During e application process the Term Sheet may be Sheet changed
11. the version number reflects the changes Sequence Number Loan Autom Generated by SOLAR if Term Sheet is accepted in N A Number atic Acceptance Term Sheet window The following ING Bank Manual Bank account number of ING head office Interface Input Borrower applying for the loan atic p Manager application t Manager manager User Manual SOLAR v3 4 2007 ING REF All Rights Reserved Page 61 of 135 06 29 2007 Internal Use Only Maintain Loan Window Value Description s Centre number of the group business unit which is lending ING REF money Select the intercompany centre Centre L Intercomp any Centre Role ING OV LOV OV L Select the ING role from the list of values Default role for ING Real Estate Finance is bilateral because often there is a one to one relation with the client Autom atic Portfolio If the loan is part of a portfolio facility the number is entered by SOLAR LOV Currency of the loan Jy Autom Sum requested for the client A atic Registratio Autom Amount generated by SOLAR N A n atic Short Autom Indicator whether the money is short term or long term LTFund atic financed money Short term money is money lent after the expiry date of the fixed rate period long term money is money lent during the legal term or fixed rate period Statement Autom Filled automatic on statement date A Date atic Specifically Check Checked if the
12. 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 2 14 1 Calculation Methods Select the required calculation method below on the window by clicking on the corresponding button Straightline PY int loss Comb rate 2 14 2 Annual Installments Annuity Calc Losn amt 10 618 799 64 Annuity 153 793449 Res value 60 000 00 fixed ort 837 00 Escr amt 20 000 00 Annuity amount J 154 631 49 Click the lt Calc gt button to execute 2 14 3 Straight Line Summary Straightline Calc Loan amt 10 618 799 64 Repayment amount 87 823 33 Res value 60 000 00 fixed amt 837 00 Escr amt 20 000 00 Click the lt Calc gt button to execute 2 14 4 Lease Term Summary Lease Lease amt pem Depreciation Res value OOo O Initial cosi Escr ant i Effective Estimeted RR 250000000 PY periods Growth p Y Calc IRR input WITT Click the lt Calc gt button to execute Attention Growth Per Year may not be a required field User Manual SOLAR v3 4 Page 23 of 135 2007 ING REF All Rights Reserved 06 29 2007 Internal Use Only 2 14 5 Present Value Interest Loss Present vale interest Joss Cale Expiry date Remaining pericds BE inv untl 1 01 2007 Precerd value cenount 10 550 794 04 Market int 70000 Freseni value asmoa Min PY 30000 Minimum present raue 316 763 04 Max amt w0 PPP w FPP amount zno Atmourn at interest 50000 00 30 ro Number of
13. 325 Corret S E 328 Prepare Deea o E 330 Deed Prepared S 340 Accepted by Client_ E 350 lt Determined by ING REF 351 Confirmed by REF 360 Non Acceptance S E 370 Maximum Interest Applied 385 Loan Finished 393 f Definitive Determined by REF User Manual SOLAR v3 4 Page 104 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only User Manual SOLAR v3 4 Page 105 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 6 1 8 Letters to Generate for Extensions The Prepare Announcements Prepare Extension Letters Prepare Letters to Request Total Repayment Prepare Extension Reminder Letters Prepare Confirmation Letters Prepare Guarantor Letters 6 1 9 Approve Special Extensions Approve Special Extensions Window i Description Obligatory 6 1 10 Enter Acceptance Extensions The same window appears as the User Manual SOLAR v3 4 Page 106 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Enter Extension Details window Missing are details on Interest repayment and invoicing issues Next to this the Properties Euribor and Letters buttons are missing For accepted extensions are following conditions e Interest rate and annual installment Multiple loans for the same client No interest percentage for the period offered Extensions with diverging interest rate Interest payment in advance Ending government backed loan 6 1 11 Put Back Accepte
14. Assign File PA FA All documents prepared arrive in the To Do list of the employee who is authorised to proceed with the Loan This employee must review all documents prepared and if necessary comment upon them User Manual SOLAR v3 4 Page 70 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 3 19 Prepare Order to Disburse Loan Using this feature the user can prepare an order to disburse monies after establishment of a loan or a loan increase It is possible to prepare disbursement orders for temporary loans if the documents concerning settlement have already been prepared and sent with status 60 or 70 under the condition that there are no proposal documents that are blocking the process It is not possible to prepare a disbursement order for a loan application which has been deactivated of course Use the already entered information found in SOLAR to prepare a disbursement order Use the lt View gt option to retrieve all relevant information regarding the disbursement order 3 19 1 Prepare Disbursement Loan Amounts Window aaar ae aa aiet rua ox Pie ENS lew SOLTRAIN Loan io00003259 PRIEHENOORD VASTGOED B 1 TS siat fro Poc prep Application nr 2005 12 2390 fi Appl dete 8 12 2006 Client parsa frienenoord Yastgoed B Y Product type pi Mortgage loan Relatonship mer js RGM Moons Product code pi Panker s mortgage Department pis HL Regio Kantoor Rotterdani ING branch ae Sea Int
15. Close Pe 2 ENa Uijetra SOLFB Cliert pote Aor van OS Name funds provider Group exposure Other Maturity a E Sub Window with own __ Window title COO C fP Total E D Company pers details Address Links e Different window title The title of the new window differentiates from the main screen This window is dependent on the Maintain Proposal window but the window has its own title And the static data from the main screen is available on this screen This window needs to be closed first to be able to return to the previous main screen by a click on the lt Close gt button 2 6 1 The Status Bar Enter a query press F8 to execute Ctrl q to cancel Record 1 1 Enter Query List of Yalues kOSC gt lt DBG gt i The status bar is at the bottom of the SOLAR window The SOLAR status bar consists of two rows and on the first row the tip text containing for example the meaning of a command or a referral to the content of a field is described Errors are displayed here with Oracle and or SOLAR descriptions Other SOLAR messages appear as a message on the window 2 6 2 Print Functionality Any open screen in SOLAR can be printed directly as screen image The screen is printed on the printer using standard set up On the File menu click the Print menu option to create a screen image SOLAR gt File menu gt Print 2 6 2 1 Printing Reports and Summaries A print preview window precedes all repo
16. Escrow And the lt Terminated gt button serves to end the complete Escrow Use this module to debit existing escrows After a debit the escrow receives the status 220 Completed Only an escrow with a zero balance can be considered Completed Use the lt Components gt button to consult the sub parts that have been entered into the system and the lt Terminated gt button to finish an escrow 5 6 Enter Payment Requests SOLAR gt Escrow gt Enter Payment Request gt Enter Payment Request window Create a payment request for escrow funds wit this menu option If the funds are to be escrowed over more than one bank account then it will be necessary to first split the payment into segments Only payment requests that meet all ING Real Estate Finance standards and criteria will be registered When creating a payment request the user must first determine for which escrow sub part the payment must be made as more than one invoice can be registered less than one payment request Upon registration the invoice amount is reserved Click the User Manual SOLAR v3 4 Page 95 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only SOLAR gt Escrow gt Enter Payment Request gt Enter Payment Request window to make a payment request this is done by Financial Administration zio Losn posse Escrow fos Fie name hery a2 Inttis simone 103 762 75 Currency EuR po oo Asbnee St Poatie fs Paerow ooo Reserved a Frogu
17. Euro 29 329 329 Totall PS W for thes application Euro a C y U Total for this application Euro 0 TotalotherL PS W Euro y e 9 Total other S Euro 38 429 Total Legal one Obligor L PS W Euro fo fo 0 Total Legal one obligor Euro 329 3 329 Total Legal one Obligor Corporate Frontsheet window Facilities Tab Value Description Oblig atory Facility Automati Facility ID number is generated by SOLAR but can be l c changed by the user Facilities are numbered ascending by date This field can be manually changed an asterisk will appear behind the field Cur LOV Select from Currency list This field can be manually Yes Code changed an asterisk will appear behind the field Manual manually adjusted The amount is displayed in thousands Existin Automati Displays the principal of all existing and approved facilities g c and The amount is generated from the LOO window but can be Input Manual manually adjusted The amount is displayed in thousands Input Propos Automati The intended new principal for the loan If existing facilities ed c and are not changed repeat here the principal This sum can be User Manual SOLAR v3 4 Page 82 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Corporate Frontsheet window Facilities Tab Value Description 070 fe atory Outsta Automati Balance of debts per facility loan Type the amount in Yes nding cand thou
18. Legal c Other S these three fields contain the counted values of the One Existing Proposed and Outstanding sums Sums are Obligor displayed in thousands Totals are automatically counted and S cannot be adjusted in this field Total Automati For facilities with risk code Total LOO L PS W and Total Legal c LOO S these three fields contain the counted values of the Existing Proposed and Outstanding amounts Sums are One Obligor displayed in thousands Totals are automatically counted and cannot be adjusted in this field Below the window is explained Detail Button A click on this button opens the Corporate Frontsheet Facility Details window Refer to explanation below User Manual SOLAR v3 4 Page 84 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 4 1 1 1 Corporate Frontsheet Facility Details The Facility Details window is part of the Corporate Frontsheet window SOLAR gt General gt Corporate Frontsheet gt Corporate Frontsheet gt Corporate Frontsheet Facility tab gt Details button k Facit id Facilly Description poaza Facility amounts Interest Fees Repayment neresseOrcrease BIR a Minimum Margin Poo Installment 100 Proposed ELR to hlerexi Rete Base cor merr Per Period Every 3months gt Afterwar gt Outstanding ELR hiterest Period f0yearsfieed Fret Reduction Deste pir203 00 Muti Currancy T CommtwetFee e Frnoletuny ote sn2 2028 Other Fes M Tence Basyer SCS Country
19. Letters Values Description Announcement LOV Select document to prepare an Letter announcement letter Announcement Manual Description of the letter Text Input Prepared Manual Date the letter has been prepared Input Document Deed LOV Select the document to prepare an extension letter Prepared l Date l Preparation date of the deed l No about the deed Reminder Document 2 LOV Select the document to send a second No Reminder reminder Date Reminder Type the date of the remind letter Date 2 Reminder Type the date of the second remind letter Letter to Date Preparation date of the guarantor Guarantors document 6 1 2 Prepare Letters Request for Financials Obligatory For loans qualified for extension or renewal letters requesting financial information are sent Letters are sent from SOLAR gt Extension gt Prepare Letters to Request Information on Financials The SOLAR gt Extension gt Prepare letters to Remind on the Request for Financials serves to remind the client to send information 6 1 3 The Prepare Extensions Functionality SOLAR gt Extensions gt Prepare Extensions gt Prepare Extensions window allows the authorised employee to start a batch procedure to automatically generate Extensions 6 1 4 Enter Received Finacials and Assess Debtors The Financials Received check box on the Enter Extension Details is checked if all financial data is available The Debtors OK checkbox is checked if the debtors are suffic
20. Mark gt button and click the lt Clock gt button El Additional fields are Maintain Agenda Window Obligatory The Risk manager assesses loans to be extended or renewed Go to SOLAR gt Extensions gt Enter Extension Details gt Enter Extension Details window to prepare the loan User Manual SOLAR v3 4 Page 99 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 6 1 Enter Extension Details 7N Enter extension details SOLTRAIN Loan number fos poor AARD 109427 Expiry date Currency Fur fer o Intarest rol over Depariment fro fac Regio Kantoor Amsterdam Ns Lasn type Straight line Principal smourt 30 756 04 Loo f 2298 f ransportbedrijf Boogaard Residue amourt E09 2056 fransportbedi ijf Boogaard Remanng 34 487 71 Extend Yes Finsncisk received oO Dettors OK m Ramaning tarm e 4 yt Anth Stes Fenson prepausa Rating z5 3 fir 02 2006 Interest calculstion method ose i Review daste 30 06 2007 Repayment nyvoicing freq P Per year Source fano Intarest Invoicing en p Per year GCREF appy E Commissionisdmiistralion costs Typa Commission x Total Pereertage hterm Andusiny Percentage General Properties Euribor PPP Escrow Letters Loan interest g oup Enter Extension Details Window Field Values___ Description Obligatory Loan Number LOV Select the loan number that requires N A extension or renewal Expiry Date Automatic Filled by the system upon
21. OV Way to round the amount Margin anua Percentage to add up to Euribor rc zl r Input 1 roll over Manua First date to review the interest date Inout Interest Roll LOV Frequency of interest revision Over Frequency ae p Free text field to comment upon the escrow Input Blocking Code Select block code reason Opens the Change Escrow Components window User Manual SOLAR v3 4 Page 93 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 5 2 1 Change Escrow Components I Change escrow components Descrplion trier Ertra Escrow Descrpibn For enlarging the building I E Amourt 0 00 YATING F Paynert 5 0000 VAT disbursement F SOLAR ID 22045 Name fs Gravenhof Vastgoed B V Ciy Bark accourt 565996559 Bark neme Reg Sank Change Escrow Components Window Description Description Manual Free text field to describe the escrow brief Input Description Manual Free text field to characterize the escrow Input Amount Total amount of this component Yes tic VAT ING nt Input must be gt 0 Disbursement behalf of the customer tic number of the client tic the client tic ee tic account number of the client il stl e E tic the bank R S p tic of the bank Obligatory ii User Manual SOLAR v3 4 Page 94 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only conge Escrow Components Window C CS Obligatory 5 3 Escrow Approval
22. Pay out date of the loan ent Date atic Interest Autom Generated by SOLAR Start Date atic Loan to Manual The portion of the amount borrowed compared to the Yes Value Input cost or value of the property purchased Economic Manual Term loan in years and months Term Input Expiry Manual Date the loan expires terminates Date Input Legal Manual Final date of the acknowledged deed Term Input N A Check_ Notvalid CSN Bank Manual Bank account number of the client if it is not a domestic Account Input bank account Abroad ry Yes EE a a gt a a Ww gt v v 7 On closing the window a check is carried out to ensure that the expiry date is not lt gt later than the starting date and the legal term of the loan User Manual SOLAR v3 4 Page 63 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 3 17 1 The Maintain Loan Sub Window PPP A click on the lt PPP gt button PrePaymentPenalty opens a window with the fields Maintain loan SOLTRAIN carly repayment Pen free init princ arnt intial princ arnt Minimum PY Amount PPP tree l Max amourt at nterest rate Nurrber of months interest Prepayment clause rs Upfront fee Total Total Total amount J 288 25 IntermeciaryiIG branch Amount X wHGbranch S Admin coste ti COCOC zCq Portfolio commission E K a E a a Maintain Loan Sub Window PPP Value Description Obli
23. SOLAR gt Escrow gt Approve Escrows gt Approve Escrows window The Approve Escrows window enables the authenticated user to issue approval for registered escrows this changes the status of the escrow into status 210 Definite Escrow approval must take place before final approval can be issued for a loan It is possible to create an escrow for a loan already in existence for example the disbursement of insurance funds in the form of an escrow A summary of approved escrows can be reviewed by clicking on the lt Approve gt button 5 4 Change Running Escrows An escrow can be sub divided into parts One component is standard and is prepared and checked by the system automatically if a minimum of one component has not been prepared then it is not possible to pay an invoice Of course the sum of all components must be equal to the total payable amount of the loan escrow Invoices and components are coupled and invoices are generally paid excluding tax unless another agreement has been reached in which case the client is required to reimburse the tax amount to ING Real Estate Finance after it has been refunded Under certain circumstances it is also possible to use an escrow to cover tax fees as well 5 5 Ending Escrow Click the SOLAR gt Escrow gt Ending Escrow menu option to open the Ending Escrow window On this window all escrow details are gathered for the specific loan The lt Components gt button allows to partly ending the
24. Self filling This field is filled by a click on the Bank Yes Entry accounts button which opens the Maintaining Bank Details window where you add all bank details The Maintain Application window contains buttons The buttons open windows to new functionality described below Maintain Application Window Buttons Cop Opens the Copy window to copy the record General The Maintain Applications Main window greyed out when active Requested Opens the Maintain Application sub window Requested Loan Loan Value Description Oblig atory Requested Economic Term Manual Type the requested Yes Input economic term E Interest Fixing Type the number of years User Manual SOLAR v3 4 Page 40 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Application Window Buttons Po Input minimum is one year minimumisoneyear Input client is willing to pay Portfolio Facility Nr Automa If the loan is part of a N A i a portfolio facility the number is entered by SOLAR tic window tic window Ultimate date of submission Date Input of Term Sheet Input closing mortgage deed Free text field to state Input reason of the deviating lead time Opens the Maintain Application sub window Distribution Channel at least one distribution channel is compulsory Aii atory aie a e Select ING Branch from Find Contact window ING Branch checkbox has been checked ee Select Intermediary from Find Contact win
25. before this period expires SOLAR gt Term Sheet gt Remind Issued Term Sheets User Manual SOLAR v3 4 Page 75 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 50102060 Remind issued term sheets i E A miles on cose fale gt SOLTRAIN Selection Others Reminder date 1 03 2007 C C Save selection Reminder Raro ooo Humber of copies Term shect o Destination e Destination name E i Restart frequency E When restart Export Status Start v Process on 0 03 2007 16 19 16 19 Number 3 25 Payment Order Approved e Add and Approve ESCROW e Insert Recurrent Invoice Data e Approve Loan User Manual SOLAR v3 4 Page 76 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 4 Corporate Frontsheets Se The purpose of the Corporate Frontsheets is to provide a summary of the gt whole of the financing that we offer to a single Legal One Obligor and to determine the risk All data is assembled from the SOLAR application Corporate Frontsheets are meant to provide an overview on the total amount of funding ING Real Estate has out on a Legal One Obligor With this Corporate Frontsheet credit risk estimations can be made Credit assessment and approval occurs through these statements The Corporate Frontsheets window opens in search mode pP To adjust the Corporate Frontsheets does not change the data in SOLAR SOLAR gt General gt Corporate F
26. could be from a company or a person After selecting either the Person Details window or the Company Details window opens Individual persons and companies can be linked For example the managing director being as a person head of a particular business has a Person Details record The company from which this person is the managing director has a Company Details record On these windows a button is available to connect the director to his business or vice versa The lt Links gt button opens the Contact Links Details window where the connection can be made On the Details window a table is present to display all relation options If an option is checked the relation belongs to that variety A saved Client details record cannot be deleted If a client number is no longer in use it can be blocked however The information can still be viewed but the record can no longer be used for new processing For Search options on the Find a Contact window refer to the Search and Query Functionality in a previous chapter User Manual SOLAR v3 4 Page 111 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 7 6 Updating Personal Details Files The Find a Contact window opens either the Contact Numbers Result window listing all contacts similar to the search or an Information Message window with the There are no records that meet this selection message Next the searched for record is selected and the Details window opens enabling the
27. detaits RAROC detalle Other Risk Country Rating fc J pm Raroc C Role ING CLC CNN Courtry Provision Perc Grose EVA _z Risk Progran Net EVA Ey Booking Otice oOo O Severty Rating DAB Soency zz Corporate Frontsheet Facility Details window Value Description 070 fe atory ee ID Ge The ee ees ID number is automatically derived from the W A ee Ate ae tab window Facility Automa The Facility Description is automatically derived from the Facility Description is automatically derived from the a A Description _ tic Facilities tab Facility Amounts Increase De_ Automa Increase or decrease of the facility in EUR In case of a crease EUR _ tic decrease type the amount between brackets Proposed Automa The proposed new loan principal in EUR If existing EUR i facilities do not change repeat here the outstanding amounts per facility Sums are displayed in thousands This field can be manually changed an asterisk will appear behind the field Outstanding Automa Current amount per facility loan in EUR Sums are EUR tic displayed in thousands Please Note The difference with the Existing amount indicates an for example arrearage prepayment or an already validated but not yet booked line Multi Check Check in case of a multi currency loan Default is Yes Currency unchecked Interest Fees Minimum Manual Type here the realised effective margin in basic points Margin Input for existing faciliti
28. example if in the case of correspondence the correspondence address is not known an address of another address type will be selected automatically The set order for the SOLAR searching sequence is 1 Invoice address 2 Correspondence address 3 Domicile address In case of a Dutch address if the postal code and house number is typed this automatically causes SOLAR to generate the corresponding street and city However the fields can also be entered manually if for example a postal code is not listed in the table Once an address has been entered the address is visible on the Company Person Details window Use the lt Links gt button to navigate directly to the Contact Links Details window Address details can be deleted by typing and saving a new address on the Address gt window but atleast one valid address must remain in the system at all times 7 6 4 The Maintain Properties Window The SOLAR gt General gt Properties gt Maintain Properties window gt Valuation Request tab allows requesting a valuation request for a certain property Maintain properties Add Ok Close Sort SOLTRAIN Property number prove 9190 Address Ubbeschoterweg 2 Description Farm o oS RE type poz Poricaturot other Currency Fur Fuo Aiccking code T i wrt SY Tewary p 3927C RENSWOUDE Hiii Rental details Valuation request Location details Properly specifics Dutch land register det Agpreiser 563 00 ou
29. field is based on the Input commencement of the loan and the economic tenor This field can be manually changed an asterisk will appear behind the field Country Details Rating nual Input Country Provision Input Percentage RAROC Details lees I oclei l Input Type the gross Economic Value Added EVA Sums are EVA Input displayed in thousands Lai alla il Input displayed in thousands il ll seat A ill Rating User Manual SOLAR v3 4 Page 86 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Manual E The ISO code of the country and the risk rating of the country where the client has been legally founded The required percentage Refer to the CCRM Country Rating List Yes Corporate Frontsheet Facility Details window Value Description 070 fe atory DNB Manual Do not enter text here A Solvenc Input Role ING LOV Select the ING role from the list of values Default role for ING Real Estate Finance is bilateral because often there is a one on one relation with the client Risk Manual Default Not Applicable Program Input Booking Manual Only type data in this field if the facility is booked by Office Input another office than the ING business unit All else is Not Applicable 4 1 2 Corporate Frontsheet Window Earnings Tab General Fatilibes Earnings Covers Covenants Earnings last 12 Earnings mext 12 months EURO monthe EUR
30. for more information on the subject 3 6 The Maintain Application Window The employee with the matching rights opens SOLAR to enter data from the client into SOLAR gt Term Sheet gt Application gt Maintain Application window 3S Maintain applicatio Asnvrasgrr Poe7 05 1003 Status fo fcastercd Cent a an der Vorm Vastgoed B V Aaplcsbon deta p2 o5 2007 File name AN DER VORMA VASTGOED BV Irtis opel dete RSM hss feJvandertoan Ol i PeReg E Depswtment pis L Regio Kantoor Rotterdam Product typa Mo Prortgacetoan Code nective Reactivated p Block DEZ Urgart p Product cde po Panker s mortgage Lomnpurpose ABP Purenasoomeunapropary TT Surogtin f Bank dient Princigal smourt R 20 000 000 00 Exposure type st Biategic Increase IR Group exposure as Chancse S0 p ECO fuss ran der vorm vastgoed B Y Roe ING p pitera ooo LOO exposwe pms an der Vorm Vastgoed B Y Cran up B LOO net Sa Loen Fie rame Cur Outstencing principal amourt TE EE Te ee E Gereral Requested Loan Dietrch CientsPropertiee Filectient cussnee Assumed is in this case the client already exists in the GRID and is available in the Find Contact window Click the lt Cancel gt button on the Maintain Application window to open a new record the following fields are open for data User Manual SOLAR v3 4 Page 38 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Application window Values
31. for the Problem Loan Statement Problem Loans that are generated automatically by the Create Problem Loan Statement window at the time of the monthly close always have a Reason for Problem Loan Statement like Arrears More Than 90 Days the starting date is the starting date of the active default period In case of problem loans with only an active Reason for Problem Loan Statement saying Arrears More Than 90 Days that are no longer on the default list because of the payment arrears the end date is retrieved from the default list A new Reason for Problem Loan Statement is created with the code EAH End of Arrears reassessment by CRES and the starting date is the same as the end date of the line saying Arrears More Than 90 Days Based on the active Reason Risk Report the Recovery or Restructuring checkbox is checked In case of more than one active reason the Recovery checkbox precedes the Restructuring checkbox 9 1 3 Maintain Risk Details CRES Window Operational Risk Tab Maintain Risk Details CRES Window Operational Risk Tab Field __ Values _ Description Obligatory User Manual SOLAR v3 4 Page 129 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Risk Details CRES Window Operational Risk Tab Field ___ Values __ Description Obligatory If an item is transferred to Credit Restructuring the transferring branch creates a credit Proposal provided with a rating and a note o
32. i a description Euribor Round off__ LOV__ Select the round off procedure applicable__ Yes _ Round off To LOV__ Select the required round off decimal Yes _ Euribor Term LOV__ Select the complete Euribor duration No Interest Type _ LOV__ Select interest type applicable No Interest Cap Manual Difference between original Euribor Input interest and revised new Euribor interest fj lt T gt Yes ith User Manual SOLAR v3 4 Page 51 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Cost Escrow Maintain Term Sheet sub window Cost Escrow Value Description 070 fe atory Displays the information about the commission of the loan and the Escrow available escrow Total Manual Amount or Percentage of the commission Yes Input Yes Intermediary ING Select Amount or percentage of the principle charged to the client and credited to the Intermediary ING Branch Admin Costs Manual Amount the client is charged to cover all Input costs ING made for closing the loan Free text field Specification of the commission and costs Input ma Escrow Details Details information of escrow Escrow Type Code Product Type and Code of the escrow Amount held on escrow This amount must Input Payment Manual Input be less than or equal to the principle Maximum payable amount of the escrow Periodic
33. lt Page Up gt Previous Record lt Shift gt lt ArrowUp gt si iess lt OW Return lt ENTER gt Right Right Arrow gt ss s ssSSSSS Scroll Down lt Page Down gt Scroll Up lt Page Up gt Show Keys lt Ctrl F1 gt Up lt Arrow Up gt Up lt Ctrl p gt To thumb through a selection of records use the arrow icons in the button bar below the menu bar User Manual SOLAR v3 4 Page 13 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 2 5 Main Menu The SOLAR application offers the user all functionality through the Menu bar A click on the selected menu name opens the menu options list containing all functionality belonging to this menu 28 Solar Euro SOLFB MO1E682 F A van Leeuwen van der elden File General Termsheet Extension Escrow Invoice Debtor Creditor FinAffairs Cancelmortgage Guarantee Mgmt Table System Window Depending on the level of authorisation the lists below the menu are visible A user may be authorised to change and add data or a user is allowed to only search and read 2 6 Window Differences All SOLAR windows essentially contain the same functionality Sub windows are windows that have a dependency to the main screen and can be accessed through the buttons on the main window Example 5 marntarn proposal eee aisem ria ok cose QA EE Oi Etra z SOLFB Apolication nr Seq number Status appl J Client Appi date
34. of VAT code due VAT Financing Check Check if the VAT is financed too Included VAT Paid by ING Check if the VAT is paid by ING Check ifthe VAT is paid by ING _ _ VAT on Lease Check Check if the VAT is included in the lease term No Payment Residual Automa Amount remaining after retirement of a loan Value Amount tic Euribor tariffs RoundTo _ Lov__ Select the level to round off no Input ial alii Ll Input e idle lll Input Select the correct tariff No Input window but can be altered Frequenc Input window but can be altered Input window but can be altered c i I ite Variation Frequenc Input window but can be altered i Manual Initially transferred from Maintain Term Sheet Repayment Ann_ Input window but can be altered BLGEL Yes Yes Yes Yes ulment EE g gt n User Manual SOLAR v3 4 Page 66 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Loan Sub Window Loan Button Description ry Amount Manual Initially transferred from Maintain Term Sheet Yes Input window but can be altered Interest Rate Manual Initially transferred from Maintain Term Sheet Yes Input window but can be altered Condition Calculation N A na A novaa o o f Transferred from Maintain Term Sheet window c Rating Date Transferred from Maintain Term Sheet window c 3 17 3 The Maintain Loan Sub Window Securities 58 Maintain loan Securi
35. order ox cose pale Ee p fera SOLTRAIN Spec Art fc oan principal amount mutation 16 400 000 00 p Payment tye Disbursement new loan Mutation principal amount escrow 3 260 000 00 orront tee 33 008 00 Cost spec Lan oan principal amount mutation O r Description pan principal arnount e O f Loen fiosoeoss27 TEST SOLAR TRAINING OCE E Excr sd E pe Eect cong E D nwoice EE DE Nn Cost cat 7 Ledger amt ZO fussenrek hyp ug curo Amcurt eur i 16 500 000 00 E EUR 16 508 000 08 Deicte line Disb order A click on the lt Disbursement Order gt button returns to the Maintain Disbursement Order Details window 3 23 Maintain Disbursement Order by PA This screen displays a list of all disbursement orders that have been prepared but not yet processed and can still be deleted It is possible to enter changes for any order that has not yet been processed as well 3 24 Audit Loan Payment At the time the offer is issued prepare an agenda item in Solar in which to update a record of when the offer must be received back Refer to SOLAR gt Term Sheet gt Agenda Functionality Check the authorization period Set at 2 months Check the period regarding the interest agreement that has been made by reference to what is shown in the offer already prepared If no response has been received before the expiry of the validity date the client must be reminded at least a day
36. previously made proposal or can be a completely new application It is important to keep in mind however that when an additional proposal is entered the previous one must already have been completed The new proposal receives a serial number in sequence with that of the previous The previous proposals can no longer be altered in User Manual SOLAR v3 4 Page 46 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only the system once the newer is registered A reason for entering a new proposal could be for example that new information regarding the clients finances is available which may have new bearing on the application loan A proposal is always associated with an already existing application Enter a new proposal by quitting the query mode and a click on the Question Mark lt gt button next select status 10 20 or 45 The status of the application becomes 20 meaning the application is Being Processed Up until the moment that an issued proposal goes up for authorization it is still possible to make changes to it The Proposal must now be offered for approval to authorized employees The Ready option box on the Maintain Proposal window is checked and the Produced on Field contains the date the Proposal became ready SOLAR distributes the Proposal to the validated employee for approval After validation the Proposal can be called forward with Status Number 40 on the Maintain Term Sheet window 3 10 Proposal Ready
37. selection of the N loan number Currency Lov select the currenc e Interest Roll Over Automatic Filled by the system upon selection of the N A loan number Department Select the department accountable Yes Select the loan t Yess Loo Automatic Filled upon selection Residual Amount Manual Type the residual amount Ye Input N Principal Amount Automatic Displays the principal of the loan NA Remaining Calculated by the system NA pe Select whether the loan is extendable or ot User Manual SOLAR v3 4 Page 100 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only A S Filled upon selection Calculated by the system N A S Enter Extension Details Window Field _ Values __ Description _ Obligatory Financials Check Checked if the reports are available A Received Debtors OK aa Checked if all debtors are sufficient and N A valid gt Deduced from initial loan Status Automatic _ Filled by the system Assigned by the Risk Manager A Interest LOV Select the right interest calculation method Yes Calculation Method Review Date Text Date field filled by the Risk Manager Repayment Manual Frequency of invoices Yes Invoicing Input Frequenc Source LOV_ i Select the origin of the loan Interest Invoicing Manual Frequency of invoices Ye Frequenc Input GC REF Appl Inactive Commission Administration Costs p Select the type Yes Select Amo
38. the Account Input parent company Manager User Manual SOLAR v3 4 Page 80 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Corporate Frontsheet window General Tab Value Description Oblig atory PAM Office Manual Office name of the parent company Input Local Manual Insert Application number from Term Sheet menu Application Input option leave out hyphens Number Regional Manual Input Application Number number Number Input Input GRID ID Manual The GRID number of the parent company No Input el Manual Copied from Risk Rater refer to the CCRM portal for Input more information on the rating procedure Parent Standalone Rating Parent Influenced Rating Input more information on the rating procedure Parent Risk Country Manual Copied from Risk Rater refer to the CCRM portal for TTA Manual Risk rating of the country the parent company exerts its Input major activities Rating changed an asterisk will appear behind the field Standalone Manual Rating codes from Risk Rater This field can be manually Input changed an asterisk will appear behind the field Industry Select the correct industry code from the Branch LOV Code Borrowers Borrowers may be manually added and or deleted if the status of the Frontsheet has been status To be Finalised Type here the name of the borrower according the ru
39. the status awarded to regular term sheets in this phase The primary term sheet is now ready for official use Go to the SOLAR gt Term Sheet gt Maintain Funds gt Maintain Funds Management window to retrieve the primary term sheet and approve the total extended credit amount by pressing User Manual SOLAR v3 4 Page 53 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only the lt Approve gt button The status of the term sheet becomes status 55 Term Sheet Approved and from this time on sub divisions in the form of new loans can be prepared Use the Maintain Funds to ensure that no amount exceeds the maximum credit limit This functionality also provides a summary of all loan sub divisions extended in connection with the primary term sheet 3 13 The Maintain Funds Management Window If a loan is being supplied in separate monetary portions a term sheet is generated using a different preparatory process of acquiring a loan in SOLAR for simplification purposes Such a loan can be prepared using Funds Management Certain conditions must be met when preparing a subdivided loan e Product specification sub divided loan must occur in the application phase SOLAR determines automatically which processes must be followed in order to secure the loan e The loan concerns a private loan agreement not a mortgage loan agreement e Loan interest is based on Euribor tariff e Escrow allowances are not possible The techni
40. type the intended KvK User Manual SOLAR v3 4 Page 28 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only number Finally click the lt Submit gt button Refer to the GRID SOLAR procedure on the intranet for more information on the subject Risk Rater Error Reference source not found Client Risk Qualification Property Registration 3 2 Maintain Economic One Obligor Search SOLAR for the existence of an obligor number in the Maintain Economic One Obligor window that connects the client SOLAR gt Term Sheet gt Maintain Economic One Obligor This enables the SOLAR user to manage and update the EOO and the LOO exposure as well as corresponding client information Initially all EOO interests are displayed on the SOLAR gt Term Sheet gt Maintain Economic One Obligor gt Maintain Economic One Obligor window Ore NY TN Maintain Economic One Obligor SOLTRAIN BOO number Description Being deal wehby Employes CA Blocked FS S E i E SchouenWVantuicwinkel ja p ee E ns an Kerkhof JHM m eet gt bee p SS S r SS g a jalenbeeke VOF mall eee aA f eoeraan a n l Se eas fis Piecntonw ca pf po hoe g Loo On the Maintain Economic One Obligor window click the lt Add gt button On the empty row type the new EOO click the lt OK gt button to save the EOO The system attaches an EOO number to the EOO Description Click the lt LOO gt button to coupl
41. user to consult modify and expand Personal or Company Details files This details window comprises four supplementing windows 1 Person or Company Details window 2 Addresses window 3 Contact Links Details window 4 Maintaining Bank Details window 7 6 1 Adding a New Client File To add a client be it a company or a person to the SOLAR database first select in the Contact Type field of the Find a Contact window the right selection either Person or Company next click the lt Add gt button to open the Details window where the details can be added A SOLAR ID number is generated at the time a new client is added to the database This number is unique non modifiable and cannot be assigned to another person or company The summary table given below indicates which fields must be completed when adding a new file It is advisable to register as much information as possible The following fields are available in the Details window Person Company Details Window Field __ Values Description Obligatory SOLAR ID Automa Unique Contact Details identification number which is N A Number tic assigned when a new record is stored GRID ID Link A contact is introduced into the coordinating Static Yes Number Data database of the ING Bank NV the GRID application Refer to GRID documentation for more information File Name Manual Collective name specifically intended for searching for Yes Input contact details Always UPPERCASE Last N
42. with different extensions for example an Excel sheet or a Calculation sheet 2 14 Calculation Menu SOLAR gt General Menu gt Calculation Menu gt Calculation Menu window The calculations made in this menu option have no bearing on the administrative processing of loan information within SOLAR The user can select several different calculation methods After doing calculations in the toolbar the lt Print gt button enables the user to print the completed summary that can be helpful when discussing further financial details with a client User Manual SOLAR v3 4 Page 21 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only The Calculation menu has two parts 1 Top section to type new variable information used to make the calculations 2 Bottom section to display the calculation results LT ols Add OK Close 2 Print SOLFB Appl 1007 70 01 34 Seq p Loan jroo 959 Curr FUR ro Client Park Exploitatie B W Lean am 10 618 799 64 perc p y 4 185000 Res value 60 000 00 hyoice frey 4 Term po y E Months calc meth fact 1365 7 In acdv afieny jin advance x First payment dale 1 01 2003 Escrow 20 000 00 Loan type Straight line 7 Straighitise Calc Losn amt 10 610 799 64 Repaymert amourt a Res value 60 000 00 fixed amt 837 00 Escr amt 20 000 00 Annuity Straightline Common examples of information Calculation Menu Window Explanation User Manual SOLAR v3 4 Page 22 of
43. 00 00 Princ amount Already prepared disbursed term sheets Teen sheet Lean Flens Outstanding principal smout 07 05 0924 ONMM PNT COMBINATIE OVERHOFKS CU 435 124000 00 Tota outst principal ert 4 124 300 00 Undrawn emourt 117 075 200 00 Additional fields in this screen are Maintain Funds Management Window T_T Already prepared disbursed Term Sheets A subdivision loan can be prepared by retrieving the primary term sheet using SOLAR nA gt Term Sheet gt Maintain Funds Management window and entering the application number searching for the application via the lt gt option Upon entering the subdivision loan amount in the Principal Amount field and click the lt Approve gt button we Ensure that an Euribor offer has been prepared for all other purposes enter the amount of 0 00 for repayment on the primary term sheet User Manual SOLAR v3 4 Page 55 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only The Term Sheet receives status 45 at the moment the term sheet is approved for and the user clicks the lt OK gt button After actually drawing up the term sheet document the status toggles into status 50 3 14 Publish Term Sheet Together with the Corporate Frontsheets the Generate Document tab SOLAR gt Term Sheet gt Maintain Term Sheet gt click the lt Document gt button to open the Maintain Term Sheet sub window Generate Document allows to publish the Term S
44. 007 05 1007 Seq number fu Slats appl Ro Pearwen sis Client frag QUAL Partners Invest B V Appl date Pe neme PouGiceLDERKOOL sid Producttype et Plortgageloan Acecurbngr pa FT Mewe Scheting Product coje fo Janker e mortgage RSMiice Mgr a FP Houtkoop S S amp Policy Paper C ig ao Decariment fo IL Regio Kantoor Amsterdam Subrogation a Porttolo taciity CS o a Loan curcose fan tur chase existing property Exposure type fr Braegic Principal amount EUR 6340 00 00 Group exposure TELI Increase SSS Rok NG Mar Pitera sd Chances 50 N BOO pa je Jong Groep Wan Gelder cs Reay m LOO exposure poar je Jong Van Gelder Van der Kooij Produced on OTT LOS pari ris Approved tog niet goedgekeurd Recommencation Conclusion ee ee E Loan File name Currency Outstanding principal amount ee d E Generat Loan _ interest omer ClientProperty Client obligations Gus antes Only fields not described in the Maintain Application window are mentioned here Maintain Proposal Window Values Description 0 ei Te atory Select from the Employee LOV the right AM RSM Acc Mgr LOV Select from Find Contact Employee window Yes option list Portfolio Facility Nr Automatic Number of portfolio of this Client filled only when applicable Ready Check Check the Ready option box if the Proposal is Uncheck ready status of proposal is heightened from Status 20 to Status 30 Approved LOV Authorised employee sele
45. 04 06 TEST SOLAR TRAINING Poymeritypos Disbursement new toan x Escr d req aa Eser EE FT Ecer comp sis E Amou ___ sa amp 247 000 00 Already paid 0 00 Peym date fAve220er Incoming invoice sd Invoice fs ee Lean fioeoenss25 0 fTESTSOLARTRAMING Peymerd ta 1953 fest Solar Training CourseSAS Att Se eee Adcrecs a rue de ta Victoire Paymul detalis Cty Cty PARIS FRANCE Atrond F Uet p Accoun number E Bank ace abrosd ps seso s006 ooo Journal Banik cade 30 Cartre pos NG Real Estate Finance H V Swit code NGBFRZAXXX IC centre ia E Cry FR Fae Curr EUR fuo oo Paym descr s teeth of payment Fte aym sts YS BN number fi Reason retussl r Dee a er _ _Seeatication_ The fields that can still be altered are Char Description of the disbursement order Payment Type Select how the money is to be disbursed Payment Date Journal Select from the LOV the journal Method of Payment Is decided after selecting the journal Reason Refusal Select the reason to refuse disbursement Use the lt Ready gt button to mark the disbursement order as ready for review and approval User Manual SOLAR v3 4 Page 74 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 3 22 2 Consult Specification Click the lt Specification gt button to request a specification of disbursement elements that together form the total payable amount TN Maintain disbursement
46. 2007 Internal Use Only TABLE OF CONTENTS 1 Introduction to the SOLAR Application 7 LI NOTATION IN THIS DOCUMENT 7 n n U l Preconditions for SOLAR 8 2 Getting Started with SOLAR 9 2 1 USER AUTHORISATION 9 22 CHANGE PASSWORD 9 23 NAVIGATE THROUGH THE SOLAR WINDOW 10 2 4 BUTTONS AND SHORTCUT KEYS 12 2 5 MAIN MENU 14 2 6 WINDOW DIFFERENCES 14 2 6 1 The Status Bar 15 210 2 Print Functionality 15 2 1 SEARCH AND QUERY FUNCTIONALITY 15 2il Wildcards Searches 16 212 Range Searches 16 2 8 SAVE AND ADD FUNCTIONALITY 17 2 9 LIST OF VALUES 18 2 10 ABOUT SOLAR 18 2 11 REPORTS AND OVERVIEWS 19 2 12 AGENDA FUNCTIONALITY 20 2 13 SHOW FILES FUNCTIONALITY 21 2 14 CALCULATION MENU 21 2 14 1 Calculation Methods 23 2 14 2 Annual Installments 23 2 14 3 Straight Line Summary 23 2 14 4 Lease Term Summary 23 214 5 Present Value Interest Loss 24 2 14 6 Present Value Future Value Reference Date 24 2 14 7 Percentage Comparison 24 2 14 8 Mixed Interest Rates 25 2 14 9 RCS 25 3 The Loan Process 27 3L PREPARATORY TASKS BEFORE ENTERING AN APPLICATION 28 3 2 MAINTAIN ECONOMIC ONE OBLIGOR 29 3 24 Retrieve EOO LOO Information 30 2 3 CLIENT RISK QUALIFICATION 30 3 4 IPRE RATING PROCEDURE 30 3 4 1 The Ratings Button 32 3 4 2 The Prepare Rating Button 34 3 4 3 The Pro Forma Rating Button 37 3 5 MAINTAIN PROPERTIES WINDOW 38 3 6 THE MAINTAIN APPLICATION WINDOW 38 User Manual SOLAR v3 4 Page 3 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Us
47. 5 TE 0 12 2006 aa 3 726 ses 4028 pe122006 mi na as a r 11 1 The Maintain Euribor I nterest Percentages Window Maintain Euribor I nterest Percentages Window Description Click the lt Add gt button to insert a new interest rate for the selected Euribor Rate Type Be aware this functionality is connected with authorisation rules After inserting the new interest rates go to SOLAR gt General gt Euribor gt Approve Euribor Roll Over gt Approve Euribor Loan Escrow Roll Over window to set the parameters for the new interest rate concerning the selected loans After the roll over Euribor renewal notices must be prepared SOLAR gt Euribor gt Prepare Letters Euribor Roll Over User Manual SOLAR v3 4 Page 134 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Concluding the Euribor Roll Over Process go to SOLAR gt General gt Process Euribor Roll Over gt Process Euribor Loan Escrow Roll Over window 11 2 The Maintain Funding Rates Window SOLAR gt General gt Interest Rates gt Maintain Funding Rates gt Maintain Funding Rates window 1 yest 2 yee 3 year 4 yest 6 yest Tyee a year S yest 10 year Date 5 yest 2 05 2007 4406000 4 550000 4571000 4591000 4615000 4650000 4 600000 4745000 4741000 4760000 106 2007 4 492000 4 656000 4577000 l 4594000 4 616000 4 6510090 4 691000 4715000 4743000 4 762000 bo us 2007 4 465000 4523000 4
48. 558000 4570000 4602000 4639000 7664000 01000 arsooue 4 743000 9 05 2007 AWB 4523000 4550000 4579008 4602000 4639000 4219000 4739000 4 743000 8 05 2007 asnon 452000 4550000 4573000 4en2000 acaso aesan 4714000 4739000 4743000 7 06 2007 4 467000 4 635000 14547000 4 572000 4 696000 4 630000 4 650000 4695000 4722000 4 741000 feasa aao aaueuen as1s000 assoeue ases00u acusv00 aesa000 asrzo00 areseoe 722000 5 05 2007 4430000 4493000 4516000 4542008 4570000 4509000 arawa 4709000 4729000 405 2007 4414000 4 496000 4480000 4513000 4541000 44578000 4 610000 4f644000 4874000 4695000 3 05 2007 4 402000 4 397000 gazono 4 420000 4 416000 4 462000 4513000 4545000 4578000 4 598000 fausa amano aso7u00 aoro L12000 aeon a200 s1300 aswouo asraeue asusv00 1 05 2007 4402000 4397000 4407000 4 929000 4 496000 4402000 4513000 4540008 4570000 4598000 0 05 2007 44127000 4 446000 4465000 4 469000 4508000 4544000 4 575000 4609000 4030000 4 656000 3 05 2007 4405000 4 492000 4156000 4 979000 4 487000 4 631000 4562000 4596000 4625000 4 615000 Bsasamr amooo aaviueo aasco0e aavwoe aon assa000 asus0e0 asereuo aszseu0 aevo000 Maintain Funding Rates Window Field___ Values__ Description 1Year____ Automatic __ Dispi 2Year____ Automatic __ Year Automatic id NA 8 Year Automatic id NA 9Year_ Automat
49. Corporate Frontsheet per Legal One Obligor can have Status LOV The authorised employees change the status of the Frontsheet from To Be Finalized into Final Only one status Final Version Autom Version number is automatically determined by SOLAR Y atic previous version 1 Refreshed Autom Displays the date the lt Refresh Data gt button was atic clicked Corporate Frontsheet Buttons T Refresh Data Button Gathers all source data available in SOLAR eliminates all previously entered data except the data on the Covenants tab and inserts the new data The Prepared By field is also adjusted to the user who clicks the button User Manual SOLAR v3 4 Page 78 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Corporate Frontsheet Buttons Field_ Description Initially all fields must contain data incomplete Corporate Frontsheets are sent back by the requested credit committees User Manual SOLAR v3 4 Page 79 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Corporate Frontsheet Window General Tab l Facilites Earnings Covers Covenants Initiating Otice fiL Kantoor amS Loca Apolicetion Mo Prepsred By P A hubertus Regional Agpiizetion Mo Risk Management erra oo Exposes No j Liimet Approval Authority vA Parent Name ti CWTCOC Ing Execute E Gidd a Naxt Review Date fie05 2007 Paart St
50. DNB A standard report is available for this If a subsidiary relationship is not recorded in SOLAR the DNB will be provided with incorrect information By moving the horizontal scroll bar to the right you can add comments to the 1 coupled files 7 6 6 Updating Client Obligations When entering the Client type in the Contact Details section it is possible to record the clients external obligations Examples of such obligations are a mortgage currently running at another bank or financial institution Click the lt Obligations gt button on the Maintain Client window this opens the Maintain Client Obligations window SS Maintain client obligations me i Ty Client Bas fiwento BV Nome funds provider Group exposure Onher Moure Hardeman Groep 123 456 000 00 pa 02 2007 Company pers details Address Links Maintain Client Obligations Window Field ___ Values __ Description Obligatory Name and address type to which the obligations are being assigned Name Funds Enter Name of the external lender Provider Group Enter Total amount of the participation in the external Exposure lender Other financial exposure to an external lender Maturit Enter Expiration date external obligation Buttons Enter Company Pe Button Opens the Company Person Details window rson Details Maturity Automatic Total amount N A N A Address Button Opens the Address window to add information NA Links Open
51. Description Obligat ory Application Number Automatic Assigned by SOLAR NA Sequence Number Automatic Serial number assigned by SOLAR NA Client LOV Select the Client from the Find Contact Yes window File Name Automatic Collective name specifically intended for Yes searching for contact details Always UPPERCASE RSM LOV Select from Find Contact Employee Yes window option list Filled by selecting the RSM Code Inactive LOV Code indicating the reason of the inactive status of the application for authorised employees only Reactivated Check RSM charged with the application receives the application on the To Do list if the authorising manager applies code inactive to the application but leaves the Block checkbox unchecked Block Check Authorising employee checks the block code if s he deems it necessary This stops the application Urgent Check RSM checks this checkbox in case of a great urgenc Loan Purpose OV From the Financing Reasons option list select the right reason O Select the clients bank from the Bank Clients option list Select Exposure Type from option list V Manual Enter the amount that indicates the group Y input exposure in millions V L Bank Client L Exposure Type LOV Group Exposure m li Kikki m O O Deduced from selected LOO Exposure field Y e e Select from EOO LOO option list the right Ye LOO e LOO Part Y save the application Date of realis
52. Displays the address information These options can also be manually Address adjusted if it is a new property Postal Code Automa Filled upon creating the property tic House Automa Filled upon creating the property Number tic Filled upon creating the property tic Filled upon creating the property tic Foreign Automa Free text field can be filled in case of a foreign property N A Address tic User Manual SOLAR v3 4 Page 118 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Properties Window Property Specifics Tab Value Description Oblig atory Legal Owner ee C Filled upon creating the property m rr a A O s Yes or No from List Of Values O eck a means the lease lasts forever with T to T Maturity Date ame Ee a a Type the end date of the loan parte lee Bought Off Bought Off Check Checked empties this option the Ground Rent Year field Checked empties this option the Ground Rent Year field Yes oe Oe Type the year in which to revise the loan aise rw Number of Type the number of parking places Parking Places Net ea ame Type the o amount ea pp ame Construction Manual Type nied construction or renovation year Renovation Input Year Select the appropriate form Operating Manual Type the operating costs amount Costs Input Gross Rental Manual Type the gross rental income amount Income Input Net Rental Manual Type the n
53. File rame Product type l Accountmor Product code RSMlAce Mor Policy Paper Depsrtment co r Subrogstion O Portfolio tacilty e D Loan purpose 2 Exposure typs a Principal amount LT Grow exposure Increase Ee Chances S0 pjm Ready O Produced on Approved Conclusion d z Loan File name Currency Outstanding principal amount e Reccmmendetion owm General Loan imerest other CllentProperty Client obligations Giiarantee This is the main window of the menu option Proposal Accessible through Solar gt Term Sheet gt Proposal gt Maintain Proposal The General button is unavailable because the window that belongs to this button is the current window After clicking one of the following buttons the options are e Same window title The title of the new window remains unchanged only supplementing fields are displayed The static data of the main window is displayed too The upper part of the window remains unchanged On this new dependent window the button that was clicked is unavailable If the sub window is active and the lt Close gt button in the toolbar is clicked this may either close the complete Maintain Proposal window functionality or close only the sub window and allow changes on the main window User Manual SOLAR v3 4 Page 14 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only ai x Add OK
54. Maintain last button on the Maintain Loan window the Loan Interest Group is inactive 3 17 6 Prepare Documents Before the Term Sheet is send to the employee authorised to process loans the employee must draw up certain documents necessary for initiating a loan such as e Prepare a letter of instruction for the notary public e Set up a mortgage deed file a copy for Real Estate Finance e Draw up a loan agreement in duplicate e Make the contract of pledge in duplicate with the interest receivable e Draw up the general conditions in duplicate e Make the authorisation form for repayment and prepayment penalties e Set up different contracts on guarantees User Manual SOLAR v3 4 Page 69 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only D Prepare documents ae mf afea u SOLTRAIN Loan number fisoocoss06 karokra By Sialus Pocuments preparea Apolicetion nr 2007 01 0002 Seq number E Application dete p2 01 2007 ciem pa Karioka Bv Producttype Mortgage loan Notary fossa Baker McKenzie Product code Panker s mortgage Relationship mer bso Faber Closirg date 5 01 2007 Department fio JIL Regio Kantoor Amsterdam Loan Agr Ex Date z Reg amount 2 850 000 00 Stard doc Descrpton Document ID Fre Na Remind Document Sert Reminder pare after date date Bla fonasedeed hero ww fl fae E BTs 000 ikte van Hoofdelijke Medeschul f3SToon747 M M 2 04 2007 Vv z sT69 Pepotakte algemeen verhuu
55. OK gt button and the lt Close gt button saves the record and returns to the Main window Ifa company or organization is a subsidiary of a foreign company lt gt information on a loan that has been made must be passed to De Nederlandsche Bank DNB A standard report is available for this If a subsidiary relationship is not recorded in SOLAR the DNB will be provided with incorrect information It is always necessary to enter details pertaining to the particular ING office that mediated in extending a loan to a client This information is necessary for correct correspondence and disbursing of loan monies and provisions Which department for example the Corporate client department assumes responsibility for a particular client is listed in the client file Which department the client is assigned to determines the various authorizations necessary throughout the loan administration process 7 6 2 Maintain Client Obligations SOLAR gt General gt Contact Details gt Clients gt Maintain Clients Details window This window displays all details regarding a client Eight buttons are available at the bottom of the window to allow for changes 1 The Company Personal Details window to add data in the contact details field 2 The Address Details window to add or change address information the lt Links gt button on this window is similar to the next window 3 The Contact Links Details window offers the opportunity to add relati
56. Product Type i ic Escrow Code utoma Product Code that is offered for the Yes ic Escrow Interest Automa Value represents the difference with the Yes Differential tic loan interest Escrow Amount Automa Percentage or amount of the total closing tic fee Interest Type Interest type of the escrow tic Round Automa Specifies the rounding of the escrow tic compensation at an interest roll over Round To LOV Specifies the accuracy of the rounding of the calculated escrow compensation at an interest roll over Margin Automa tic 1 Roll Over Automa First Euribor roll over date of the escrow Date tic Periodicity of the Euribor interest roll over al tic 3 16 1 Rejection Tab Acceptance Term Sheet User Manual SOLAR v3 4 Page 59 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Default this tab is inactive select the lt Not Accepted gt option in the Acceptance field to activate this tab Acceptance Hot accepted z Term sheat Escrow Accepted term sheet Rejection Clarification rejection nitistor E D Block code E Reason L LOSS O O Subreason L Acceptance Term Sheet Window Rejection Tab Value Description 070 fe atory On the SOLAR gt Term Sheet gt Maintain Term Sheet gt Maintain Term Sheet window click the lt OK gt button to save the accepted term sheet This save action invokes the system to generate a temporary loan This temporary loan needs further adjustment
57. Properties bv fm yO 2 ank hypotheek cx EUR 1 702 0 wa mo f We 4 ank hypotheek FUR 730 o wa mo f r 4 Bank hypotheek EUR 1 426 0 wa i 7 rd Corporate Frontsheet window Covers Tab Value Description 070 fe atory Facility Manual Refers to the Facilities from the previous Corporate Yes Number Input Frontsheet Window Facilities Tab If a security is coupled to a number of loans then you also have to enter several loan numbers Be aware The accuracy of the referrals is not forced upon by SOLAR This field can be manually changed an asterisk will appear behind the field Description Manual A short description of the security This field can be Input manually changed an asterisk will appear behind the field Credit Cover Manual Type the investment value in an active currency Value Input User Manual SOLAR v3 4 Page 88 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Corporate Frontsheet window Covers Tab Value Description 070 fe atory Perc Manual Investment value divided by the Pro Rata of the Input principal Transfer Manual Hardly ever applicable when in doubt ask superiors No Cover Value Input Hardly ever applicable when in doubt ask superiors Input Cover Obligor Manual The name of the legal entity or person providing the Yes Input security or a reference to the borrower s on the General Tab Country where the underwriter is a sta
58. R v3 4 Page 122 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only or directly through the menu SOLAR gt General gt Contact Details gt Guarantee Lenders gt Maintain Guarantee Lenders window Maintain Guarantee Lenders Window Description Obligatory User Manual SOLAR v3 4 Page 123 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 8 Review Outstanding Loan and Rerating Monthly task to print out the review lists with Business Objects SOLAR ENG 001 All clients due to be reviewed are listed This allows the RSM to change the loan details by e Enter the CCRM Portal e Go to the GRID e Select an organization e A popup screen appears In the right column the customer type is visible e Click the customer type e Search for the correct customer type and select it e A change proposal screen appears e Fill all the mandatory fields in the change proposal and press submit Review in SOLAR e The Loan File SOLAR gt General gt Consult Functions gt Consult Loan Details window e LOO file SOLAR gt General gt Consult Functions gt Consult EOO LOO gt Consult EOO LOO window Outside SOLAR in the CCRM portal the Customer Due Diligence report must be edited refer to the CDD Manual for more information on the subject After the CDD has been prepared the client is classified in the appropriate risk level group On the Maintain LOO window SOLAR gt Term Sheet gt Maintain Econ
59. R v3 4 Page 57 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Additional fields are atory Date Input Input Input install ol llamo Input Select either Accepted or Not Accepted Acceptance Term Sheet Window Term Sheet Tab Value Description Oblig T_T Term Automa Filled by SOLAR tic Interest Rate Filled by SOLAR tic Annual Automa Yes Repayment tic Amount Selection Manual el Input tic 1 Roll Over Automa Filled by SOLAR Date tic al Repayment Automa Filled by SOLAR Amount tic Selection crek JN Acceptance Term Sheet Window Escrow Tab D ed aa atory tic tic Escrow Differential tic loan interest User Manual SOLAR v3 4 Page 58 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Acceptance Term Sheet Window Escrow Tab Value Description Oblig atory Escrow Amount Manual Percentage or amount of the total closing Input fee Interest Type Interest type of the escrow ian tic Round Automa Specifies the rounding of the escrow tic compensation at an interest roll over Round To LOV Specifies the accuracy of the rounding of the calculated escrow compensation at an interest roll over Margin Automa tic 1 Roll Over Automa First Euribor roll over date of the escrow Date tic Periodicity of the Euribor interest roll over al tic Acceptance Term Sheet Window Accepted Term Sheet Tab Value Description 0 ei Te atory Escrow Type
60. after the user has entered the above information In the Acceptance field at the bottom of the screen select the lt Accepted gt option The Term Sheet receives the status 60 indicating the official Term Sheet acceptance A temporary loan number is generated and added to the term sheet the system will notify the user automatically This feature enables ING to record the receipt and acceptance of a Term Sheet after the client has added his signature It is necessary to add some additional information yet to the Term Sheet oT ia Aia ox cose Pl Ele Ulema SOLTRAIN Application nr 2007 010059 Seq number p Status fo spo CS Client fizs ooo Post amp VecntBv o Application cate fo o1 2007 File rame POsTavECHTBY impp JEP Purchase existing propery Accountmer 3 fa fa van Welsenes Term shee date f 1 01 2007 F p Faber Valid until f 8 01 2007 Depertment fto HL Regio Kantoor Amsterdam Receipt date Relationship mor ING Bank Signing daie Intermediary Loan to value percertaye 00 0000 Centre pos NG Real Estate Finance H V Economic tenm po E yt Currency fur pro o O ty ate prorzno Principal arnourt emoon Quote ID pee Registration 1 680 000 00 Approved Margin 000000 Acceptance Term sheet Escrow Accaptadtarm sheet EE Term Interest rate AnnwJrepsym ameunt Selection Margin istrollover de review renawsl Repaymert amourt Selecton 1 000 p1 04 2007 Every 3 months A User Manual SOLA
61. al Escrow Manual Months Input Branch compared to the total If the percentage is reached the system reports this and blocks further payments Number of months for which cash is placed on escrow Only in combination with an cash escrow Difference between the interest rate to be paid and the escrow payment This field is only used for printing out the Term Sheet Manual Input Interest Differential Euribor Escrow details Margin Manual Margin percentage of the Euribor escrow Input First Rollover Date Type the first rollover date Input At this stage the escrow cannot yet be subdivided this is only possible when the loan has become definite Such a subdivision is performed by Financial Administration If the loan is drawn up using Euribor you cannot offer a fixed rate escrow TA User Manual SOLAR v3 4 Page 52 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Securities Collateral Add general comments regarding securities collateral using this window Maintain Term Sheet sub window Securities Value Description og atory Add general comments regarding securities collateral using this window Securities Securities Tet comment upon closed securtes Text Comment upon closed securities co ae P security type and description licable sen Security Type eee a ee ee from selection in Security field l ee oe Name is derived from s
62. ame Manual Full name Yes or Company Input Name Name Manual Trade name or abbreviation of the official company Input name Legal Form LO Select from option list only in Company Details Yes window Registered Manual Only in Company Details window Yes Branch In Input First Initials only in Person Details window e i Input User Manual SOLAR v3 4 Page 112 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Person Company Details Window Field ___ Values Description _ Obligatory Input Details window Input Statutory LOV Select from option list only in Company Details Domicile window Country Date Manual Format is dd mm yyyy only in Company Details Registration Input window Document City Centre Manual Place of Centre of Commerce only in Company of Input Details window Commerce CoC Registration Manual Enter number only in Company Details window Nr CoC Input Date Manual Format is dd mm yyyy only in Company Details Registration Input window of CoC VAT Number Manual Number assigned from Tax and Customs Input Administration only in Company Details window Place of Manual Place of birth Check or Uncheck only in Person Birth Input Details window Date of Birth Manual Only in Person Details window Input m Only in Person Details window Communal Check Indicates whether the person is married in community Free Property or of property Only
63. anda one Retng GlobeltCorcarete Ciert r Perert hihenced R ng ssi Perert Accourt Meneger ii Parert Risk Country Rating PAM Ollke es Borrowers Report Stand neu cry Industry hi Beevoveer dione enced res Cndld code Blocked Manua a Rt Holding B v psms femm O D _ re a a ee Zz CJJ LUIL IL JE m z CICIO TITL u m LI CI LIC JC _Je a Corporate Frontsheet window General Tab Value Description Oblig atory Purpose Manual Text field containing reason for Frontsheet Reasons Input are e Initial credit proposal e Review proposal e Renewal proposal e Credit modification Initiating B The office that submitted the request This field can be Office manually changed an asterisk will appear behind the field tic active employee Risk Manual Default ING REF CA But can be changed This field can Management Input be manually changed an asterisk will appear behind the field Ultimate LOV Select the highest authorising authority Approval Authorit ING Manual Type the name of the involved councilor in case of a Executive Input Global or a Corporate client Next Review Manual Type the proposed next review date according the Date Input review policy Global Corpo Check Default this box stays unchecked Check this option if Yes rate Client the debtor or the mother of the debtor are on the ratified list of Global or Corporate Clients list Parent Manual Name of the assigned relationship manager for
64. anged agreement Example is an annuit Percentage Field market value of the properties Financing Fee Amount fixed by contract which has to be paid at ending of mortgage Interest SOLAR gt Term Sheet gt Proposal gt Maintain Proposal window gt Click the lt Interest gt button and add data in the Maintain Proposal sub window Interest The additional fields on this window are Maintain Proposal Window Interest Field _ Values __ Description Obligatory Interest Fixing Enter Indication of what interest fixing periods Years are being offered If they have been entered these periods are copied in the proposal Rating Automatic Rating Date Automatic Selecting the Rating format automatically N A leads to the date in this field Interest Manual Proposed interest condition of the Yes Input financing agreement Repayment Manual The proposed principal amount for the Yes Input registration of the mortgage This need not be the same as the actual principal amount User Manual SOLAR v3 4 Page 45 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Proposal Window Interest Field __ Values _ Description __ Obligatory Interest Condon Other Four text fields are available to add information with regards to e Escrow Agreements e Special Clauses e Securities e Details Leasing Client Property The Client and property information can be registered on this wi
65. applicable if married Only in Person Unchec Details window k Art 88 Check Only in Person Details window if checked all Contact Applicable or Details of person married to must be added Unchec k Profession Manual Occupation only in Person Details window Input Telephone Manual General Phone number of the Company or Person Input General Fax number of the Company or Person Input User Manual SOLAR v3 4 Page 113 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Yes oO n Person Company Details Window Field ___ Values Description __ Obligatory Mobile Manual Mobile Phone number of the Company or Person Phone Input aa ee E mail address of the Company or Person Input Language _ LOV__ Select from Lov Blocking LOV Select the block reason If EMPTY the record is not Code blocked Checked Check If the record is complete by a click on the lt OK gt N A button the checkbox is checked ING Branch Check _ To define the relation from the Company with ING only in case of Company Details Intermediary Check A click on the Imd button or using shortcut key ALT I opens the Intermediaries window to define the relation Employee Check A click on the Emp button or using shortcut key ALT m opens the Employees window to describe the relation Notary Check The Maintain Notary window opens after a click on the Ntr button also possible by using the shortcut key ALT t
66. aring and managing documents Preparation of a temporary loan Disbursement of loan monies Reminders Reports A status is associated with every step of the loan process and when the specific step has been completed then the status will be mutated accordingly In this way it is impossible to miss a vital step in the application sequence By associating a status with each step the user can also work more methodically and can easily keep track of how far an application is in completing the process The following table summarizes the various statuses along THE LOAN PROCESS STAT DESCRIPTION FUNCTION US with their description User Manual SOLAR v3 4 Page 27 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only THE LOAN PROCESS US The risk manager checks on the quality and credit risk of the Approved proposal The quality being the proposal Basel compliant and the credit risk being acceptable for ING REF Deactivate An application or proposal with status from 5 to 45 can be de Application activated SOLAR gt Term Sheet gt De Activate Application gt Deactivate Application window The status of the application or Term Sheet after de activation will change into status 130 Term Sheet Approval from the manager leads to the drawing up of the Registered Term Sheet All previously entered data for the application is available on the SOLAR gt Term Sheet gt Term Sheet gt Maintain Term Sheet window
67. ata is entered prompts a SOLAR message Do you want to save the changes you have made Selecting the lt Yes gt button saves all data Selecting the lt No gt button closes the window without saving any data The Add functionality is available after closing the active query The lt Shift F4 gt command is useful if you want to leave an opened window No data is saved upon this action 2 8 1 1 Change Functionality The status of a record and user authorisations denominate the chance to alter the data To close the window after a change will prompt the system with the message Do you want to save the changes you have made Confirming this with a click on the lt Yes gt button writes the changes if they pass the checks to the database Refusing this by a click on the lt No gt button closes the window without saving the changes This is also valid for the execution of a query The system asks if the changes must be saved A click on the lt OK gt button saves the changed data But the window is not closed and stays active User Manual SOLAR v3 4 Page 17 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 2 9 List of Values A click on the lt Question Mark gt button or a click on the lt F9 gt key opens the List of Values LOV for the field concerned The List of Values window consists of a set of similar values from which the correct value must be selected The List of Values allows paging thr
68. ate LOV Select from Rating Scale the rating number and next type the date KFC Exposure User Manual SOLAR v3 4 Page 31 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Clients window Value Description atory Customer LOV Select from the Customer Segment window the Yes Section appropriate segment O S K Customer LOV Select from the LOV compiled by the CCRM Department Yes pe GRID the appropriate segment Block Check Check if the client needs to be rated before continuation N A Buttons All Client Details can be reached through the buttons Company Per Button Opens the Company Person Details window son Detail Address Button Opens the Addresses window to add or change address N A Details details WEE gt N A Links Button Opens the Contact Links Details window to add or delete a coupling Obligations Button Opens the Maintain Client Obligations window to add or N A change an obligation Periods date and maturity date settings Rating Pro Forma Opens the Pro Forma Rating IPRE Client window N Rating 3 4 1 The Ratings Button N N N A oA A A D Mamtain rating SOLAR ID Ciert risk quaif Stertng dete Resting mode Rating owner Stendaione Influenced Adctional n omaan Employee 3 4 van Lecuveen v d Velden Authorizing Branch pas z J Steenhoven Approval dete po 06 2007 Blocked m User Manua
69. ation of the application Format is dd mm Initial Application Date Historic date of initial application Preliminary Check or Uncheck in case of progress Registration Uncheck Product Type LOV Select correct Product Type from Product Yes Type option list LOO Exposure LO S S S S Yes Application Date Yes User Manual SOLAR v3 4 Page 39 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Application window Values Description Obligat ory Product Code LOV Select the Code from the Product Types Yes and Codes option list Policy Paper LOV Select Policy Paper from Policy Paper Yes option list Subrogation Check or Check in case of urgency Yes Uncheck Principal Amount Manual Select Currency from Currency Codes Yes input option list and type the requested principal amount Increase Automatic If the application is an increase request to a former loan Chances gt 50 Check or Uncheck Role ING LOV Select role that is applicable for this record from the Role ING option list Clean Up Check or Check in case of erroneous data data is Uncheck deleted Loan LOV Click the lt gt button to open the Find a Loan window and select the appropriate loan e ace Filled by SOLAR if the client has existing e loans Currency Automatic Filled by SOLAR if the client has existing loans Outstanding Principal Automatic Filled by SOLAR if the client has existing Amount loans remaining amount Bank Name
70. b summarizes the quality of the real estate On the RCS Tab all data from previous tab is assessed and a click on the lt Caculate RCS gt button calculates the RCS code N Calculate ict Add OK Close P 2 eim SOLPR2 EUR Calculsted by i ae D Delete Catoulsted on Copy Solvability Repayment capacity Quality info Rea estate Res Velue Ports Somsbity 55 5 35 Age of yeanutbes 10 Repayment capercily 0 36 40 Qually nto Real estate iv l 60 Total 125 Calculate RCS ROS code l 5 User Manual SOLAR v3 4 Page 26 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 3 The Loan Process This chapter intends to provide the user with a description of all the data entry processes involved in the loan process starting from a client request all the way to the final step the actual disbursement of a loan to the client Assumed is that the following step has already been taken e Anti Money Laundering check on the client In SOLAR not only is it possible to register standard financing but non standard financing for example an underwriting to a loan as well The process of registering an underwriting to a loan differs a bit however and will be covered in a separate section of the manual Generally speaking the following steps are involved e Registration of a financing request Contact Details Risk Assessment Risk Involved Authorization Registration and processing of Term Sheets Prep
71. be consulted and edited However SOLAR is build in such a way that data modification depend on the current status of the requested information or record for example the interest rate following a loan approval or term sheet number after a term sheet has been issued Making data modifications of course also depends on the personal authorization of the user to do so If a screen is closed after a modification has been made the system will display the following request Do you want to save the changes you have made By answering lt Yes gt assuming the system permits the mutations the changes are recorded in the database By a click on the lt No gt button the function shall close The above also holds valid for booting up certain procedures such as starting a query In that case the system shall ask if the user wishes to save the changes By entering the lt OK gt button the modifications made are saved but the window does not close automatically The screen closes only when the user clicks the lt Close gt button Activating the lt Add gt button or the lt F6 gt key opens the required window in the Add mode A new record can be created Executing the lt Shift F4 gt command clears all fields from input No data is saved this way This command is convenient to cancel the new record without typing all mandatory fields Click the lt OK gt button to save all new data or press the lt F1O gt key To close the window before all d
72. ber Start he Default the Process On field carries the current date and hour A click on the lt OK gt button starts the generation of the overview 2 12 Agenda Functionality The Agenda functionality can be reached in three ways 1 SOLAR gt General gt Agenda gt the Maintain Agenda window displays an overview of all reports requesting action 2 Click the Agenda amp button in the toolbar on the Maintain Company Person Details window to open the Maintain Agenda window 3 An employee has entered an agenda issue for you after the SOLAR application starts your agenda is opened immediately N Maintain agenda aisa sa o coo ja EG Delete Report Show defaut Vv Concemng Desorption hlended io Entered by Action coje Stetus Concerning Decerpiion hterded tor Entered by Action code Ststus Concerning Descrpion htended tor Entered by Actoncode Status Loan feal fiononass20 PULLAART fremeneet z poora lovin mvestor User Manual SOLAR v3 4 2007 ING REF All Rights Reserved Manual a Starling dale 7 03 2007 Mariy date Pi 03 2007 Not ste pa as 2007 Stetus dete 7 03 2007 Manual va Storting date fi6 03 2007 Maturity date b3 03 2007 Not Oste p3 03 2007 Ststus deta fis 03 2007 Manual E Starting cate i Matury dete Not Deste Ststus dete Page 20 of 135 m 10 SOLTRAIN Acdbona intormsbon rs i Addtons intormetion i Additional informetio
73. cal make up of a sub divided loan is as follows The feature Maintain Funds enables the user to prepare new loans in the form of sub division loans without having to complete the entire loan application process of acquiring a loan normally required in SOLAR Approved proposal is already entered for the entire allowance A sub division loan will be prepared based on the primary term sheet and will therefore receive the same application number followed by sequence number 01 Each ensuing sub division loan will be awarded the next number in the sequence 02 03 etc Access the term sheet using the SOLAR gt Term Sheet menu option gt Maintain Term Sheet window gt button Loan The prepared term sheet will receive the status 50 and it is not possible to add any changes to the term sheet It is then possible to enter the sub division term sheet into the system in the same manner required for entering a regular term sheet Adjust the repayment amount in the Maintain Funds Management window User Manual SOLAR v3 4 Page 54 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only PE CoS ENS fea SOLPR Term sh stalus TS appr Appl Gale 0 04 2007 Product type po Product code po Frea mortgage Loon purpose GR Purchase land Loen to vahe 80 00 Term shest cate fo 05 2007 Yaidurti 4 05 2007 Economic term reer months Currency UR Furo Exgiry date 0 05 2045 Oete approval 005 2007 Crec limit 159 200 0
74. ct cove pe Stallings escrove Escrow undrawn a a 71 Part ht omourt Brence Reserver Lhiawn amourt Payment VAT dish stalingedopot 103 762 75 6 00 0 00 0 08 100 0000 FF i Payment request can be more than one SOLAR D 054 Ea wey o Amourt disbursement Cty fearrsrooRT CS S SCSC CS CTOYAXT TOUT Bank account bsza ooo Requested parent dote fiz C C S Foreign bank accourt e Status ho foun Bank name pac Bank H Y Regist Branch Banik iijkes k nvore Neme Date rmouni W T inc YAT amount fprit 93 iro Hopstaken pr 04 1998 l 40 731 90 a faprit 1393 iro Hopstaken ph na rs989 3 093693 ES sD CO In the payment request portion of the screen enter invoices per creditor or per client name Please be careful to ensure that the invoices entered are properly coupled with the activated portion of the selected loan Use the arrows to page through the various payment requests displayed on the screen Place the cursor in the SOLAR ID field number and then click on the lt Add gt button to register a payment request tas h Do not make changes to the information contained within the escrow space at time of registration The invoice amount will be reserved for each invoice registered in the system in other words the escrow space is diminished 5 7 Approve Request for Payment Use this feature to approve a payment request This window is similar to the Enter Payme
75. ctionality of SOLAR is divided between employees safeguarding the employee from fraud and wrongdoing The 4 eyes principle sees to every employee carrying out his her responsibilities without breaking the rules 2 2 Change Password To prevent unauthorised persons from working with the SOLAR application a username and password are necessary After creating the user account a frequent change of password is also needed File General Termsheet Exter Baki Batch records mi Change password The password can be altered in two manners o User Request User can decide to change the password o System Request the system warns the user It is time to change your password N Change password User pan E682 Leer nene F a van Leeuwen v d Velden Enter the old password type the new password then retype it again After a click on the OK button the new password is active Changing password for MOIE6B2 x Old Password New Password Retype New Password User Manual SOLAR v3 4 Page 9 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 2 3 Navigate Through the SOLAR Window Below an image of the SOLAR window is available This image helps in understanding the functionality in the application Menu Bar The SOLAR Menu Bar provides access to the complete loan functionality A click on the General menu option opens all functionality necessary to insert and maintain Contact Details also known as S
76. cts the option applicable from LOV Recommendation Free Text Approver can add information on the loan Field proposal Conclusion Free Text Definition on the lt Go gt or lt No Go gt status of Field the loan proposal The Maintain Proposal window calls for the previous application document All records from the Maintain Application window must be complemented with information from the following buttons e Loan e Interest e Other User Manual SOLAR v3 4 Page 44 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only e Client Property e Client Obligation s e Guarantee Loan SOLAR gt Term Sheet gt Proposal gt Maintain Proposal window gt Click the lt Loan gt button and add data in the Maintain Proposal sub window Loan Use this feature to enter or alter loan information By default the loan information is automatically transferred from the application when entered but in this screen the transferred data can still be changed The additional fields on this window are Maintain Proposal Window Loan Field _ Values _ Description _ Obligatory Loan Starting Date _ Enter__ The expected start date of the loan ves Currency Lov Select from Currency option list_ ves exchange LOVEE Mortgage Automatic The proposed principal amount for the Yes Subscription registration of the mortgage This does not need to be the same as the actual principal amount general screen and cannot be ch
77. d Extensions The status of accepted extensions can be put back in case of deviations from the expected Check the Put Back checkbox behind the loan line to postpone User Manual SOLAR v3 4 Page 107 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 6 1 12 Settle Unextendible Loans Sometimes an expiring loan must be extended according certain interest conditions 6 1 13 Definitely Process Extensions This menu option opens the Definitely Process Extensions window to select a loan and print out the extension proposal 6 1 14 Maintain Ending Loans Upon selecting the department the Maintain Ending Loans window is automatically filled by the expiring loans The Term field and the Interest Rate field are the only fields to update For the Term field select the term and type the interest rate in the Interest Rate field 6 1 15 Process Ending Loans Check the Process checkbox on the SOLAR gt Extension gt Process Ending Loans gt Implement Expiring Loan Agreements window to proceed with the loan 6 1 16 Reports Notify Extensions Report Get Interest and Calculate Annuity Extensions Report Open Extensions Extensions Changes Report Ending Loans Report User Manual SOLAR v3 4 Page 108 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 7 Contract Amendments Loan contacts need to be maintained Contract Amendments is the flow where changes are added Subjects are e Consult Loan Funct
78. d a number of tab sheets for the rest of the details Client has been assessed by CRES as a problem loan Following Business Objects SOLAR 006 Arrears Overview Go to SOLAR gt Debtor gt Maintain Risk Details CRES gt Maintain Risk Details CRES window User Manual SOLAR v3 4 Page 126 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only T Maintain tick detaile CRES o we a Ejo ifm D Risk period poo Laan number fieneis Eamsaean Gert psss Peastar Group avy SS S Rating Fx 20 Accourtmsneget CRES fo ps3 HJ van Woerkens Currency pa American Dollar sid Recovery m Sutim dete Rec zz Recovery LOO Restructuring F Risk type Continue financing Source Jautomatic Status Active i Reason nisk report Operational isk Calculation current nish amount Defirile risk semoun previous period Interest simoun of change Amaunt pad Open market value Dete J Liquid value Other nvokes Celculates amcurt of change Tote amot of charge Defirile rick amount current period Redetirition riek Loss Cakugonin EUR Calcuebon in 0 00 0 00 l 439 782 00 127 040 41 Maintain Risk Details CRES Window Field ___ Values__ Description _ Obligatory Loan Number Automatic Loan number and name Ye OV Select the loan number Risk Period Current active period N A s IPRE rating or STARPRO Account a Number and name of the Credit Manager CRES Restructuring staff member which
79. ddresses 116 7 6 4 The Maintain Properties Window 117 7 6 5 To Link Contact Details 120 7 6 6 Updating Client Obligations 121 7 6 7 Updating Creditors 122 7 6 8 Updating Appraisers 122 7 6 9 Updating Guarantors 122 8 Review Outstanding Loan and Rerating 124 9 Transfer to Credit Restructuring 126 9 1 MAINTAIN RISK DETAILS CRES 126 9 1 1 Maintain Risk Details CRES Window Provision Tab 128 9 1 2 Maintain Risk Details CRES Window Reason Risk Report Tab 129 9 1 3 Maintain Risk Details CRES Window Operational Risk Tab 129 10 Repayment and Cancellation 131 11 Interest Condition 134 User Manual SOLAR v3 4 Page 5 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 11 1 THE MAINTAIN EURIBOR INTEREST PERCENTAGES WINDOW 134 11 2 THE MAINTAIN FUNDING RATES WINDOW 135 User Manual SOLAR v3 4 Page 6 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 1 Introduction to the SOLAR Application This manual is intended for those whose daily work activities require the use of the SOLAR software Therefore it pertains primarily to the product administration aspects of SOLAR and does not extend descriptions and explanations regarding specific functions and activities surrounding Financial Administration Furthermore it is important to note that this manual describes all SOLAR functionality options also the functionality that is only available for the employee who is authorized to access a specific SOLAR functi
80. dow Intermediary checkbox has been checked e al Select Initiator from Find Contact window client checkbox has been checked LO a Select Account Manager from Find Contact window employee checkbox has been checked LO Select Regional Manager from Find Others involved Lov Select Other Involved from Find No User Manual SOLAR v3 4 Page 41 of 135 06 29 2007 V V V V Relationship V Select Relationship Manager from Find Manager Contact window employee checkbox V V Contact window employee checkbox V 2007 ING REF All Rights Reserved Internal Use Only HAUT Distributio n Channel B _ has been checked Regional Manager has been checked Maintain Application Window Buttons M e has been checked ING Branch Select ING Branch from Find Contact window ING Branch checkbox has been checked Intermediary Select Intermediary from Find Contact window Intermediary checkbox has been checked Initiator Select Initiator from Find Contact window client checkbox has been checked Clients Pr On this window the relations with clients and properties are operties displayed Client Automatic Deduced from number ee P eee the correct relation from the a nen Po ie eee ee a E Deduced from Block in a eee the ee from Find Pree D ee Description LOV___ Deduced from Property Number S Client Opens the File Contact Details window links to other clients a al atory __
81. e war fe SS ES SS A E L SS ES ES Pe EEE ee ees ee Objenion Property number Desorption Merket volje Prop exposure Csts Type Cty Cty Merhetobity Stoe of REM Financa resorting locking pam penne Seana tee et fees eet f es tr PE eS SS ee eee A LC SS T M o n Mame BHO Enddaterent Gusty Blocking indicator Fu O a oa T segini o onoo voeon articuler i ao Prate O O C T mag Maintain Rating PRE Client window Value Description 0 o fe atory Number Autom System number assigned by a click on the Prepare N A atic Rating button Rating Autom Calculated rating value N A atic Appealed Manua If no rating value is known appeal a rating number here Rating Input Client Autom Filled from the Maintain Client window N A atic Purpose of Text Type here the rating purpose Yes Rating Additional Text Free text field for additional information Information Rating Date Autom Commencing date of current rating Yes atic External Manua Value ING interest outside ING Real Estate Finance Yes Exposure Input Morality of LOV Either Good or Bad Bad is leeway gt 250 and or 60 Payment days over the past two years User Manual SOLAR v3 4 Page 34 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Rating PRE Client window Value Description 0 oife Ye Button _ i m Source pe eee TATA this button to collect the data f
82. e Only 37 GATHER AND ANALYSE CLIENT DATA 43 3 8 MAINTAIN PROPOSAL WINDOW 43 3 9 PROPOSAL MADE 46 3 10 PROPOSAL READY 47 3 11 TERM SHEET REGISTERED 47 3 11 1 Maintain Term Sheet 48 3 12 LOAN TOGGLES INTO FUND 53 3 13 THE MAINTAIN FUNDS MANAGEMENT WINDOW 54 3 14 PUBLISH TERM SHEET 56 3 14 1 Clients Response 56 3 15 REVISE TERM SHEET 56 3 16 APPROVE TERM SHEET 57 3 16 1 Rejection Tab Acceptance Term Sheet 59 3 17 DOCUMENTS PREPARED AND APPROVAL RECEIVED 60 3 17 1 The Maintain Loan Sub Window PPP 64 3 17 2 The Maintain Loan Sub Window Loan 65 3 17 3 The Maintain Loan Sub Window Securities 67 3 17 4 The Maintain Loan Sub Window Client Property 68 3 17 5 The Maintain Loan Sub Window Other Text and Salutation 69 3 17 6 Prepare Documents 69 3 17 7 Receive Documents 70 3 18 ASSIGN FILE PA FA 70 3 19 PREPARE ORDER TO DISBURSE LOAN 71 3 19 1 Prepare Disbursement Loan Amounts Window 71 3 20 REGISTRATION OF DOCUMENTS RECEIVED 72 3 21 MAINTAIN DISBURSEMENT ORDERS 73 3 22 ORDER PREPARATION FOR LOAN MONEY DISBURSEMENT 73 3 22 1 To Update the Disbursement Order 74 3 22 2 Consult Specification 75 3 23 MAINTAIN DISBURSEMENT ORDER BY PA 75 3 24 AUDIT LOAN PAYMENT 75 3 25 PAYMENT ORDER APPROVED 76 4 Corporate Frontsheets 77 4 1 1 Corporate Frontsheet Window Facilities Tab 82 4 1 2 Corporate Frontsheet Window Earnings Tab 87 4 1 3 Corporate Frontsheet Window Covers Tab 88 4 1 4 Corporate Frontsheet Window Covenants Tab 89 5 Deposit Request 91 5 1 Escro
83. e the EOO to a Legal One Obligor on the Maintain LOO window Maintain LOO Window User Manual SOLAR v3 4 Page 29 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain LOO Window Field Values _ Description Obligatory Lov Select the appropriate risk level No 3 2 1 Retrieve EOO LOO I nformation Use this function to consult information about the EOO and the belonging LOO SOLAR gt General gt Consult functions gt Consult EOO LOO N Consult EOD LOD ox cose Pjan ES femme store SOLTRAIN lonique H B V Show aitoane x LOO exposure Loannr hterest fixed Loan nr Fie rame cur Initislsmourt Quiet Prine Amt Year Month Gurr Srobover Reason tock E 22 SS SS SS 5 000 000 00 700 3 3 Client Risk Qualification In the CCRM portal the Contact Details of a client are registered and estimation is made upon the financial trustworthiness of the client in the Risk Rater To rate a client in SOLAR go to SOLAR gt General gt Contact Details gt Clients gt Maintain Clients window A The procedure described below is only valid for clients with risk qualification code SL IPRE 3 4 I PRE Rating Procedure In SOLAR a client is available this client requests a loan To estimate possible risks ING Real Estate Finance might run with this customer a rating procedure has been developed Go to SOLAR gt General gt Contact Details gt Clients gt Maintain Clien
84. election in Fee ee Fee ee Currency Automa Currency is derived from selection in tic Security field Initial Automa Only filled if difference occurs with initial tic securit Actual Automa Only filled if difference occurs with initial tic securit Details Button Opens the Maintain Mortgages Non Solar Facilities window to maintain a security When all term sheet data has been entered the term sheet document can be generated as an MS Word document Use the lt Document gt button on the Maintain Term Sheet window Drawing up this document is crucial to the continuance of the loan completion as well as a mutated SOLAR status of the application making the acceptance of the client possible A client can only accept a term sheet for which a term sheet document has been prepared The term sheet then results in a temporary loan and this is recognisable by a generated status number 3 12 Loan Toggles into Fund A Term Sheet is complete and by a click on the lt Document gt button a temporary loan is prepared This Loan product is entered as Fund The credit maximum of the client is established here too The SOLAR system recognizes the product code signifies a fund loan and assigns the number OO to the term sheet This will be the primary term sheet to which all sub divisions of the loan are linked later The primary term sheet document must be generated after which the term sheet document receives the status 50 corresponds with
85. eminder A Facity type z Porttolo facity re htaignapal source 17107 500 00 Nealdeeat deed Source Per Gur m CtherSecutys oF GC REF apply z T TE SOLTRAIN Term sheet 2007 01 0057 Status po S disb Contre pos ING RE Finance UK BV Currency fer Prien pounds Account Manager pes 28 F Bordelmeser Accom Manager esf ING Bark branch BHG code z Closing date P 04 2007 Qoshg ote F 04 2007 Disbursemeni dete prore Eriry debe Expiry dete 5 16 2011 tralurity date hen Stetus ext Losn purpose per Purchase existing property Loan to value percentage 50 0800 Fle trenetarred Steterrert cate aa Spes ind T Appraised liquidation valie Dascrbticn of progeny Currency In foreign currency in BUR Hootaweg 59 te Amsterdam Fur sue arson rene five wenera Corantanetrast rte Ametordam fn semo senoufo fo Wetnoriande Appealea Year Proparty country User Manual SOLAR v3 4 2007 ING REF All Rights Reserved Page 97 of 135 06 29 2007 Internal Use Only 5 9 Preparing Reports and Alerts Several standard summaries are defined for Reporting Each report begins with a screen that allows the user to specify selection parameters e Escrow Notification Report gt Prepare Notification Report Escrows i c w Repayments window e Construction Documents Notification Report gt Prepare Notification Report Construction Documents window e Escrow Notifications gt Escrow Notifications e Payme
86. ermediary fo Disbureoment order Beneficiery Client 7 ING branch Contact detalis pa734 Brienenoord Vastgoed B V Vaue daie 1 04 2007 Bank accourt Bank acc abroad Charge costs against escrow Print camenission anc administration costs on disbursemert za Standard document ALSG jitbetaling hypotheekgelden voor REL Prepare Prepare standard document adm costs on aisi The Loan Number transfers all detail information from Maintain Disbursement Order by PA window into the Prepare Disbursement Loan Amounts window Review the data thoroughly and add or change data if necessary e Beneficiary select Client Notary or ING Branch Contact Details field is filled after the selection e Value Date type the date the money is disbursed e Bank Account the bank account field can not be empty e Charge Costs against Escrow type whether the costs for example the commission fee are to be paid from the Escrow Default the costs are automatically deducted from the amount to be processed User Manual SOLAR v3 4 Page 71 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only e Print Commission and Administration Costs on Disbursement check the option box e Standard Document Select the appropriate letter Disbursement Order Buttons e Click the lt Prepare gt button a click on this button prepares the disbursement order The status of the order rises from status 70 to 80 Changes are not allowed e Click the lt Pre
87. ernal Use Only 9 Transfer to Credit Restructuring Every month a batch procedure is carried out to create a list of loans that have an arrearage This list constitutes the basis for the Credit Restructuring Procedure This chapter deals with the way problem loans are handled In SOLAR The problem loan management is partly defined by the payment behaviour of a client SOLAR saves and records the dates a loan must be paid This enables the course of the payment behaviour of a client to be charted in detail If a client is in arrears by more than 90 days in respect of a payment obligation the client goes into default The default period ends if the client has fulfilled all his payment obligations and is no longer under problem loan management In this context all the loans of the client are evaluated Problem loan management in Solar is also based on the 90 day principle The monthly problem loan statement records clients who are 90 days in arrears 9 1 Maintain Risk Details CRES In this window the problem loan details can be maintained for each loan The problem loan details are closely linked to the default list Changes in this window can reflect in the default list Changes can be made to existing problem loans and new problem loans can be created The problem loan can also be generated automatically by means of the Create Problem Loan Statement The upper part of the window contains the general details of the problem loan Below are include
88. es Use this value as minimal proposed effective margin for new facilities User Manual SOLAR v3 4 Page 85 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Corporate Frontsheet Facility Details window Oblig atory LOV Select the base on which the margin is calculated Choose from COF Euribor and Libor Interest fixed period in years and months This field can be manually changed an asterisk will appear behind the field Commitment Manual If applicable type commitment fee in base points Yes Fee Input Other Fee Other Fees in base points Yes Input Repayment Installment Yes Interest Rate Base Interest Manual Input The amount of the periodical repayment If this is a flexible amount type here flexible This field can be manually changed an asterisk will appear behind the field Input Number of times the installment amount is paid per year Options are 1 2 4 and 12 This field can be manually changed an asterisk will appear behind the Per Period Manual Input field Period options can be In Advance or Afterwards First Manual First repayment date This field can be manually Reduction Input changed an asterisk will appear behind the field Date Final Manual End date of the loan This field can be manually Maturity Input changed an asterisk will appear behind the field Date Tenor Manual Term of the loan in years This
89. et rental income amount Income Input Appraisal Automa The date to which the value applies N A Date tic Filled with number and name of the appraiser tic Market Value Type the market value of the property Input User Manual SOLAR v3 4 Page 119 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Properties Window Property Specifics Tab Value Description 070 fe atory 7 6 5 To Link Contact Details Companies and or persons can be linked or coupled with each other For each coupling it is necessary to indicate the relationship between the two files N Contact links details Coupling can be carried out bipartitely For example when an individual person is connected to a particular company by being its managing director the files are coupled Person to Company However SOLAR then automatically couples the Company to the Person as well Both the Coupling and the Contact Details number are obligatory It is possible to retrieve the Contact Details number using the lt Find Contact gt button A coupling cannot be deleted once made but it can only be blocked User Manual SOLAR v3 4 Page 120 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only A click on the lt Addresses gt button opens the Addresses window amp Ifa company or organization is a subsidiary of a foreign company information on a gt loan that has been made must be passed to De Nederlandsche Bank
90. ga tory User Manual SOLAR v3 4 Page 64 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Loan Sub Window PPP Value Description Obliga tory 3 17 2 The Maintain Loan Sub Window Loan A click on the lt Loan gt button opens the Maintain Loan sub window loan with the fields N Maintain loan ok cose Piel eG Olena SOLTRAIN leasing Euribor Depreciation VAT financing included pm nterest type L a Ownership iF nll VAT pald by ING fl Rond OoOo H Property type g YAT on lease payment j Roundto LO E Margin VAT code 2E DEE Review dete review renewa Residual valus amourt rtsrest ibing POT dotorcat Start fiz 01 2007 interest rate 5 000000 Invoiche Trequency 4 Fer year terest condition l Afterwards 7 1st payment js 2007 nterest caculation act 1366 Cost of iund Nia ri Interest variation P Rating H 43 Invacing frequency 4 Per year Retingdste 5 08 2006 1st repaym ann fis 01 2007 Amount 0 00 _Gonerai Ppp toon _Securitioe CliontProperty Othortoxt__ Salutation Loon intorost aroun User Manual SOLAR v3 4 Page 65 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Loan Sub Window Loan Button moo pe Header for leasing fields pe ee eee Input charged to the client each year Input by ING Property Type Select if the property is new or existing VAT Code Select the level
91. has been responsible for the problem loan Currency Automatic ___ The currency of theloan Na Recovery Check __ Checked the loan is an active problem loan_ N A S Client tomatic Number and name of the client linked to N A the loan as borrower A Starting Date Starting date of a problem loan N A Recover Recovery Manual Input_ Type the maturity date of the loan NA Restructuring Automatic Checked if the loan is an active N A restructuring loan Source LOV Select Manual or Automatic Manual if the N A problem loan is typed Automatic if created through create problem loan statement User Manual SOLAR v3 4 2007 ING REF All Rights Reserved Page 127 of 135 06 29 2007 Internal Use Only Maintain Risk Details CRES Window Cor ee Description Obligatory Risk Type Select the risk type for dealing with the m7 loan Status LOV Select the appropriate status Automatic If in SOLAR the Loan is no longer a problem loan SOLAR sets the status to Cancelled If a loan rating is modified the Rating field will be adjusted too fp app Based on the active Reasons for Problem Loan Statement the Recovery or the Restructuring checkbox is checked In the case of more than one active reason the Recovery checkbox precedes the Restructuring checkbox 9 1 1 Maintain Risk Details CRES Window Provision Tab On this tab sheet provisions against the problem loan are typed Maintain Risk Details CRES Window Provisi
92. heet Buttons Opens the Copy window to copy the record The Maintain Term Sheet window greyed out when active Values Description Oblig atory PPP Euribor Prepay N A The prepayment clause in the mortgage N A allows the unpaid principal to be retired by the owner with a 1 penalt HE i Euribor Free text field to reason Euribor changes N Euribor being the money market reference rates for the Euro Loan sd Opens the Maintain Term Sheet sub window Loan with three tabs see below Costs Escrow _ Opens the Maintain Term Sheet sub window Costs Escrow see below Securities Opens the Maintain Term Sheet sub window Securities see below Document Opens the Maintain Text Blocks per Term Sheet window to draw up a letter properties and relations connected to the Term Sheet Other Text Opens the Maintain Term Sheet sub window Other Text to add text in to defined text fields 1 Special Clauses text field 2 Flexible Clauses text field Salutation Opens the Maintain Term Sheet sub window Salutation where could be added three salutation texts 1 Description Borrower 2 Description J oint and Several Debtors 3 Description Guarantors Loan User Manual SOLAR v3 4 Page 49 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Refer to information on lt Loan gt button to Maintain Application window and Maintain Proposals window T Maintain term sheet SOLTRAIN Rating kc m Ratinadate panon Quote D Repa
93. heet to acquire approval from the client The status of the Term Sheet is raised to 50 The original Term Sheet is printed out in duplicate and copy is signed by ING Real Estate Finance File the copy Both Term Sheets are sent to the client Create an agenda item for when the Term Sheet must be returned Refer to Agenda Functionality 3 14 1 Clients Response A client responds to the Term Sheet e Accepts the Term Sheet without changes proceed Approve Term Sheet e Accepts the Term Sheet but with changes return to Maintain Term Sheet refer to Revise Term Sheet e Rejects the Term Sheet click the Not Accepted field on the Acceptance Term Sheet window refer to Rejection Tab Acceptance Term Sheet 3 15 Revise Term Sheet Once the documents have been prepared the status can be reversed for basic changes but all the prepared documents are then cancelled The changes to the Term Sheet approved by the competent employee in question must always be confirmed to the client in writing by means of a letter If there are many changes to the Term Sheet the client must be notified that no rights can any longer be derived from the first Term Sheet These changes must of course again be agreed by the manager The Revised Term Sheet is again published for approval Open the SOLAR gt Term Sheet gt Put Back Term Sheet gt Put Back Term Sheet window SS Put back term sheet Add Term sheet Povr 03s 0095 for Loan number foomo Loantype Straightli
94. heking ndcstor Kruideat l 500 000 00 09 02 2044 eooa 7 E eegstand moona vaconey m articuler 23 000 00 Private z m l Em g atic Rating button atic atic V A Purpose of Text Free text Rating Rating Date Commencing date of current rating External Manua Value ING interest outside ING Real Estate Finance Exposure Input Enter Source Button Refer to The Prepare Rating Button Details Calculate Risk Refer to The Prepare Rating Button p Driver User Manual SOLAR v3 4 Page 37 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Exposure Manua Enter data if client is Guarantor or Surety GG BS Input N A Pro Forma Rating PRE Client window Value Description 0 oI Te atory Rating Butto Source Data Tab PA Facilities Refer to The Prepare Rating Button __ 3 5 Maintain Properties Window In SOLAR a large number of real estate units are registered The applicant wants the loan for a property that may or may not be available in the system SOLAR gt General gt Properties gt Maintain Properties window After a click on the lt Question Mark gt button the Find Properties window opens Enter a search term and click the lt Find Property gt button Select the desired property and add the new details The lt Add gt button on the Maintain Properties window can also be used in case of a new property Refer to The Maintain Properties Window
95. ic fid NA 10Year Automatic id na User Manual SOLAR v3 4 Page 135 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only
96. ient and authenticated Then the Risk manager judges the loan on the financials the securities the properties and the guarantors A loan can be manually approved in the SOLAR gt Extensions gt Manual Approving of Extensions gt Manual Approving of Extensions window Check the Approve check box and save the changes to manually approve a loan 6 1 5 Approve Repayment Amounts User Manual SOLAR v3 4 Page 103 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only The Approve Repayment Amounts window processes the loans of which the repayment is lt 0 00 A click on the lt Approve gt check box behind the loan line approves the loan 6 1 6 Get Interest and Calculate Annuity The authorised employee uses the batch procedure to apply interest rates and annuity changes from SOLAR for the extension of loans 6 1 7 Change Status Extension TE 15 x wo ox cose PiS Ell etre o SOLPR2 Loan faitis300 Pen ooo Expiry loar 1 05 2007 Currency fe 1 Interest roll over Lasn typa trasont lin Nia ry Eend vex i Financisk receNed pm Principal emoun DETT Dectars OK eA Residual smourt Rating E Remanng 7 425 12 Stalus 320 Rerainingterm gt 9 yr Jmrth 6 1 7 1 Status Description 300 Extension Prepared S 310 Extension Entered 0 311 Letter Requesting Repayment 3i5_ Endingtoan S 316 Ending Loan Changed S E 320 Extension Approved S E 321 Check Repayment Amount__ 323 incorrect S
97. ion gt Enter Cancellation window o Next prepare the covering letter SOLAR gt General gt Other Document gt Standard Document gt Standard Document gt Generate Word Documents window Select on this window the Standard Document that is appropriate and type the loan number and select the Word Processor option Word o Check the interest rates for the P repayment SOLAR gt General gt Euribor gt Euribor Interest Rates gt Maintain Euribor Interest Percentages window o Next click the lt Generate gt button to generate a letter o On repayment of the loan in full the LOO file with the EOO LOO number is filed separately All repaid loan files and all security documents are recorded by loan number o The LOO file is recorded by EOO LOO number User Manual SOLAR v3 4 Page 133 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 11 Interest Condition Interest changes take place on the SOLAR gt General gt Euribor gt Euribor Interest Rates gt Maintain Euribor Interest Percentages window Estio rete type rocked pwr Flonsortion variabele rente a Interest percentages 1 month 2 months 3 months BS rme 12 months 244 2007 aa aef goa A pra at 3675 3 757 Le ij foorzour f serf seesf sras aeas a063 3 01 2007 3616 3665 3 742 3 878 ua 8 01 2007 3620 3665 Sama 7 04 2007 3 625 3 663 3 736 3864 a 5 44 2007 3 625 3 663 3 735 as 4 04 2007 z 5 04 2007 3 726 a 4 04 2007 w 3 725 3 853 112 2006 3 72
98. ions Consult Economic One Obligor Legal One Obligor Corporate Frontsheets Contract Details Sureties Debtors Financials e Securities To ascertain that changes can be applied to the loan go to the SOLAR gt General gt Consult Functions gt Consult Loan Details window Also go to the SOLAR gt General gt Consult Functions gt Consult EOO LOO gt Consult EOO LOO window After this returns satisfactorily manage the changes in an new application Refer to The Loan Process 7 1 Change Loan Details By PA FA Window A client requests a change to be made to an existing contract Now the actions undertaken are Register the request Open SOLAR gt General gt Change Loan Details gt Change Loan Details by PA or FA Window 3 Change loan detaile by PA IDI x Loan 00020 Fie name Proerema s 100020 SSS Ciert 0007 Apatestion LoS fas oo Term sheet seg number 7 LOO part i oi ING Bark intertace rr fssssoans Role NG po Fo Arrangr Rel mor pz fama aeyn Department pao HL Regio Kantoor Eindhoven Aco mgr free po fi vanBoom RIG bwanch 013 15 Product tyre fr PMorigageloan i htermediary fsan NG Bank veenendaal Product cade fo fea mortgage Notary e PolcyPeper of Ss Centra pos NG Real Estate Finance HU Cleeng date pis 12 1804 E certre E Disbursement dete pr t0 1997 Loan purpose hlerexi stating date prizas Exposure tye fT Ptrategie O00000 Lasn to value Sa Laqal teen a rmt Parttoio facikty ne BA E Eso
99. ions waiting for approval Documents sent in for approval e Front Sheets Prepared Proposal Appraisal Document Risk Rater Document Customer Due Diligence Document Property Overview derived from Maintain LOO window 3 11 Term Sheet Registered Based on the GMA General Material Approval form the application in Solar is authorised and goes from status 20 to status 30 Proposal Produced complete the Term Sheet fields in accordance with the Solar manual and generate the offer in Word The conditions set out in the GMA form must be included in the application Every Term Sheet that deviates from the User Manual SOLAR v3 4 Page 47 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only standard application must be physically printed out and the manager must sign the relevant sections of it 3 11 1 Maintain Term Sheet T Maintain term sheet Close Z SOLTRAIN Apolication nr 2007 01 0005 Seq number pa Term sheet status fo ace Client R foxes Duttaart Appl date File rame ULLAART Procuct type Accountner pio van Lokven Procuct code Relationship mar p29 N Hodeclmane Lean purpose Depsrtment J21 FL Kantoor Arnhem Term Centre code pos JUG Real Estate Finance V Acceptance date 17 01 2007 Exposure type fr fuaege ss ntcrest percentage 5 158000 Group exposure ans Repayment percentage 3000000 Foo pe PullaartenBoth SCS Chanc2s gt s0 fa LOO exposure fsz PuaartenBon Role ING p pitera oo LOO part tr
100. ip Type of note to help the user apply techniques and procedures to p enhance the user friendliness of Solar Short Section Summary Provide the user with a summary of the important information contained in a chapter 1 1 1 Preconditions for SOLAR To be able to register a loan in the SOLAR application some prerequisites must be fulfilled in some CCRM applications This is to cover the risks ING runs for outstanding loans Furthermore to prevent redundancy in the Contact Details database and to have the Static Data only once in the ING database The applications to first register a client are The GRID Create a New Organisation here if the client is not yet part of the GRIDS Contact Details The Risk Rater Use this application to gather a risk nomination for the client if the client exists already in SOLAR the rating from SOLAR is inserted The Customer Due Diligence report must be made to establish the financial status of a client Refer to the CCRM Portal for more information on the subject User Manual SOLAR v3 4 Page 8 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 2 Getting Started with SOLAR This chapter deals with the basics and primary functions of the SOLAR application After reading this chapter you are familiar with User Profile Navigation through SOLAR Shortcut Keys and Buttons Window differences Search and Query Save and Add Report and List of Values 2 1 User Authorisation The fun
101. ished 5 2 To Enter or Change an Escrow The initial escrow transaction is prepared automatically at the time a temporary loan is drawn up However it will be necessary to enter the specific escrow information in the system At such time the escrow will have been awarded the status 200 meaning Prepared When choosing the escrow form the product model will help determine which screen fields are mandatory as well as which default values the user must enter Each escrow comprises of at least one sub part Sub parts can generally be split but it is important to keep in mind that the sum of all the parts must equal the total escrow amount Escrows are always registered in the currency in which they are paid User Manual SOLAR v3 4 Page 91 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only The moment a written disbursement request from the client is received the following procedure must be obeyed SOLAR gt General gt Consult Functions gt Loan The disbursement request must be compared to the loan conditions Conditions in the loan must be met with the disbursement request Approval must be obtained SOLAR gt Escrow gt Enter Payment Request gt Enter Payment Request window After the approval regarding the disbursement request from the authorised employee has been received draw up the payment request on the Enter Payment Request window Lown 4002437 Escrow a Ple nare AVEHHOF VASTGOED l Currency F
102. l SOLAR v3 4 Page 32 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Rating window Value Description 0 o fe atory Pe ID aa rae a PTN Risk A D a a a from Maintain Clients window al Ea aL Date dd mm yyyy ia ie Select the applicable rating code with this code the employee assigns a mark to identify the branch to which the client belongs Rating Owner LOV Select from Rating Owner LOY mim scale scale Gla Filled by the two previous actions re atic GRID Check _ Checked ifimportedintheGRID na Information Text atic Branch atic Blocked Checked if input is erroneous User Manual SOLAR v3 4 Page 33 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 3 4 2 The Prepare Rating Button A monthly batch run used to generate a new rating for all IPRE clients with a rating older than twelve months This new rating proposal must be manually approved of IN Mamtain rating IPRE chent a joj Add oK Close SOLTRAIN Number 23502 Railing 149 Appesied reling bntcr sourne aas Chent pisss Fabricii Ros B V Addtioralinftormstion Purpasa of rating F Gacwate nek dniuer Rotngiete fi2 03 2007 External exposure MoresHly of Paymert x Exposure GGBS Rating report Risk drwers Lowi number Application number File neme Outstanding lean Outstanding escrow Outstanding coretruction CF FC Borrowers Y Brocking fearsome ane LARS mv enone a
103. le all accompanying gt tasks are delegated to Financial Administration Refer to the CCRM Glossary for more information on the subject After reading this chapter the user will be familiar with the processes that surround the preparation and management of money escrows and will be able to conduct and enter changes relating to an escrow A deposit request is an agreement between two or more parties providing that certain property be placed with a third party for safekeeping pending the fulfillment or performance of certain actions An escrow is a particular kind of line of credit account with certain limitations One such limitation is that such an account is generally used for the temporary storing of monetary funds that have been paid out on loan Escrows are always coupled together with a temporary loan When the temporary loan is being drawn up the escrow will be prepared automatically in one part Escrows can have different forms Presently ING Real Estate Finance recognizes the following kinds of escrows new building coverage rental maintenance and storage escrows Described here are the following Escrow processes 1 Dutch Process Deposit Request 2 Deposit Request Cancellation of Securities 3 Deposit Request Construction Lease 4 Spanish Process Construction Disbursement Request 5 1 Escrow Records ESCROW RECORDS STATUS DESCRIPTION FUNCTION 2 Escrow oo E Eea aa 210 Escrow approved E Escrow fin
104. les Influenced Manual Rating codes from Risk Rater rating can be influenced Input by the rating of another entity this is influenced rating This field can be manually changed an asterisk will appear behind the field Blocked Check If checked the line is not included when printing the Yes Frontsheet Report ID Reference to the borrower the report gets an ID of the Global Data Standard Abbreviations per line in the Country where the debtor exerts its major activities User Manual SOLAR v3 4 Page 81 of 135 06 29 2007 alphabetical character This field can be manually Borrower Manual Input correct Grid name and correct legal form GRID ID Manual Type the GRID Number of the debtor Input 2007 ING REF All Rights Reserved Internal Use Only Corporate Frontsheet window General Tab Value Description 070 fe atory Checked if the borrower details are manually added 4 1 1 Corporate Frontsheet Window Facilities Tab iN Corporate frontsheet a Joj Add oK Cose Pa SOLTRAIN LOD rumber foss SC PMroangse seee Status To be finalized gt Refresh Data versin p Prit fi onsin BOO rumter au IM Holding B Y Refreshed 406 2007 Delete General Faciities Eamings Covers Covenants Fecity 9 Cur c Fisk Ig coje Existing Prowosed Outstanding u at Facility Decerption Biocked Manual re 9 39 zo eHe spore o a an E Detail EE u a Dj i e ae Eim i SC e BLEH oE SF i a A SS ee
105. loan is specifically funded A Funded Bank Autom Filled by the system the bank account number at the N A Account atic domestic bank Subrogatio Check Checked if the bank seeks to recover an amount of loss N A from another party who is legally liable for it N A Check File Check Acknowledgement date of the deed Facility Number Currenc Principal Amount je eae i i Z ziz gt gt Lin E lt gt gt 72 Transferre d Checked Loan Complianc e Check Checked if the loan has been reviewed by Loan Compliance Autom Status of the loan at this point is status 60 A atic Application Autom Filled by the system after saving the application for the N A Date atic first time Product LOV Select correct Product Type from Product Type option Yes Type list User Manual SOLAR v3 4 Page 62 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Loan Window ee fe s Product LOV Select the Code from the Product Types and Codes Yes Code option list Loan Reason to apply for the loan Purpose oe Select Exposure Type from option list Typ LOO LOV Select from EOO LOO list of values appropriate LOO Exposure EOO Autom Filled by the system from the application form atic LOO Part Autom Filled by the system from the application form atic Closing Manual Date of acknowledgement at the notary public Date Input Disbursem Autom
106. lt F10 gt Cancel lt Esc gt Clear Block lt Shift F5 gt Clear Field Item lt Ctrl U gt Clear Form lt Shift F7 gt Clear Record lt Shift F4 gt Close Window lt Alt F4 gt Count Matching lt Shift F2 gt Records Debug Mode P lt Ctrl gt Delete Backward lt DELETE gt sss User Manual SOLAR v3 4 Page 12 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Delete Backward lt Backspace gt sss lt lt i lt C Delete Record lt Shift F6 gt Display Error lt Shift F1 gt Down lt Ctrl gt Down lt Down Arrow gt Duplicate Field Item lt F3 gt Duplicate Record lt F4 gt Edit lt Ctri e gt Enter Application lt Ctrl F6 gt Parameters Enter Menu lt Ctril F5 gt Parameters Enter Query lt F7 gt Execute Query lt F8 gt Exit lt Ctri e gt Help lt F1 gt Left lt Arrow Left gt eee List of Values lt F9 gt New Record lt F6 gt Next Block lt Ctrl gt lt Page Down gt ss sss lt s s lt lt lt lt i i iw Next Field lt TAB gt Next Record lt Page Down gt Next Record lt Shift gt lt Down gt Previous Block lt Ctrl gt lt Page Up gt i t lt lt lt lt lt lt i lt i lt i lt i lt OO Previous Field Item lt Shift gt lt TAB gt Previous Field Item lt Shift gt lt Ctrl gt lt TAB gt Previous Menu lt Ctrl gt lt ENTER gt Previous Record
107. months charged 3 Total comp 323 041 34 Regular repayment 4 200 00 More detailed information is necessary for this particular calculation Enter the variable data in the left hand column of the calculation sheet After doing so click the lt Calc gt button to execute 2 14 6 Present Value Future Value Reference Date Future VabPres Val ref date Cale Rei de of periods 42 Stert date 01 2004 PY on siarting date 9 425 661 46 Date 12 02 2007 PY on ref dote 11 962 970 05 Also in this case more detailed information is needed in order to arrive at a correct calculation and typing the reference and effective dates is mandatory The reference date is needed to calculate the amount of money a client presents in order to receive a given value back at date of commencement The date effective is needed to determine the amount of money a client will receive back per given reference date L 2 14 7 Percentage Comparison comparison Calc Input Export Input period Az Rate eifective 4000 Purchase 60 000 Outpt perica ke Margin ee Rate PPA 0 PIN Margin PPA Rate PPY 4 000 3 970 Margin PPY ame Purchase eck 4 089 Clear screen This method serves to calculate an interest comparison between interest paid per period in arrear and interest per period in advance ad User Manual SOLAR v3 4 Page 24 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 2 14 8 Mixed Interest Rates Calc
108. n 06 29 2007 Internal Use Only Maintain Agenda Window Create an Agenda Entry Go to SOLAR gt General menu gt Agenda gt Maintain Agenda window From the Concerning LOV select the agenda type similar to the record that must be listed Next type value for example the loan number If unknown values can be retrieved using the question mark lt gt button Enter necessary information in the remaining fields of the agenda entry Press the lt Enter gt button before adding new information if there are already three agenda entries or more displayed on the screen Click the lt OK gt button to store the agenda entry The lt Delete gt button allows to delete an item from the Maintain Agenda window The lt Report gt button opens the Report Open Agenda Actions window to edit a report Delete an Agenda Entry Click the lt Delete gt button 4 Click the lt OK gt button to store the changes made Alter an Agenda Entry Position the cursor in the required fields and alter the dates u Click the lt OK gt button to store the changes made Consult Agenda Entries of a Selected User Position the cursor in the Intended For field of any agenda entry 7 p Click on lt F7 gt or press u Enter the employee code or click the lt gt button to select a user u Click on lt F8 gt or res 2 13 Show Files Functionality The Show Files ul button serves to attach a file to a record It is possible to attach files
109. n the state of affairs User Manual SOLAR v3 4 Page 130 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 10 Repayment and Cancellation The client requests a repayment and or cancellation offer If the client wants to prepay part of the loan or wants to pay off the loan Repayments options are Pro Forma Repayment in Full Partial Repayment Additional Repayment Repayment Release without Payment e Payment with Security Deposit Create an agenda item in SOLAR gt General gt Agenda gt Maintain Agenda window to record the repayment or cancellation request Refer to Agenda Functionality Depending on the status of the loan the request can be forwarded for approval or kept in the pending issues maintenance mode seis Ea Leane Mortgage gt Enter Cancellation gt Enter Cancellation window Securty 2960 prn Ponk mortgage Starling cate 01 2007 Pirepsym Loan nr 000009350 Moturky dete Property Address Pe Cty Stelus cancelation oi property 03622 Forain sdorecs a Land Regstry Od Change Market value 4 100 080 90 lt Gross rema value 1060 00 Section Status cancellstion Transaction date Market value Rertal value Pyrepeym Shared Section Psat Sistue camelstion Tras cale Market value Rental vaus Pyrepaym E EE LL CE Enter Cancellation Window Field Values __ Description Obligatory User Manual SOLAR v3 4 Page 131 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only
110. n to the Real Yes Input Estate market Financial LOV Reporting frequency Yes Reporting Blocking Check JA Display of all matching tenants Name Autom Name of tenant N A atic BHO Manua Gross rental income Yes Input End Date Date Letting expiry date Rent Valuation of the lease Blocking Indicator atic determined atic atic atic atic Part Part atic atic User Manual SOLAR v3 4 Page 36 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 3 4 3 The Pro Forma Rating Button iN Pro Forme lating PRE chent T Joj Ada OK Close P f E SOLTRAIN Number F 3503 Rating 149 Enter source details Chert phass Gabricita Ras B V Purposs of r amp ng Calculate risk driver Roingiae fie 05 2007 External exposure Morslty of Payment z Exposure GGBS Rating report Risk drwers Loan number Apalcstion number Fik neme Quistandng loan Outstanding escrow Outstanding construction CF FC Borroyrers Y Bocking fienonessa2 Pon 03 000am GABRIELLA RAS BY 5 000 000 00 0 00 smp r os df SS Ea a Tae Eg Propertios Property number Desorption Merket volje Prop exposure Cats Tye Cty Cty Merhetobity Staic of REM Finaned recoring Bockng poussms Minkcipand Haarie 7 000 000 00 1 000000 15 Retail gt ewe fl Good gt 10 Very trequent gt E E E ya SS SE E a N a ee ee L SS SS E CC E T Huap Tenants Mame BHO Enddaterenk Cuaky B
111. namnic iem 25 yr tinreth Currency Er fo Expiry dale pri 108 2008 Princkia amount AART Maturity Gate Regictstion hia Mh etor oOo Bark accourt i Bark ace abroed Assess the changes User Manual SOLAR v3 4 2007 ING REF All Rights Reserved Specticaly funded o hecked Loan Comp p Page 109 of 135 06 29 2007 Internal Use Only 7 2 Consult EOO LOO Window Next review on the SOLAR gt General gt Consult Functions gt Consult EOO LOO gt Consult EOO LOO window LIT i i pjat Stan qs tow allloans x Losn rr nee ier free same arp e ore E A e oe EE EEE nn A Le ann EF aS oe OE Sa aes 2 es eS a es ee ee ae eet E ee Se ee ee ee a E EE a a az es eens eee EE a a 2 EEE EEE E 2 ee eee eee a E E eS A a a a n es CCU U C Toia 90 756 04 90 756 04 7 3 Expenses Draw up a new proposal if necessary Otherwise create a Credit Modification Package to seek approval from management Use the Agenda Functionality to set response dates Evaluate if the legal documents need to be adjusted Do not forget to calculate administration costs On the SOLAR gt Consult Functions gt Consult Loan Details window click the Costs Income button to open the Consult Loan Details sub window Costs Proceeds Type the calculated amount and select the Expenses option from the LOV The Credit Modification Package remains under construction If the proposal is approved send it for a
112. ndow By default information regarding both is copied from the original application but they can be altered here Client Obligations Client obligations are described on the Maintain Clients window after a click on the lt Obligations gt button the Maintain Clients Obligations window opens where to add and or change relations Guarantee All contact details happen through the GRID refer to the GRID manual for more information on the subject Guarantees are given normally by ING Real Estate Finance A client of the ING Real Estate Finance can also guarantee for another client All these actions usually happen in the GRID but in case of incidents they may still be done in SOLAR Guarantees are put into SOLAR on the General menu gt Contact Details gt Contact gt Find Contact window gt Company Person Details window gt Click the lt G Ind gt button gt Maintain Guarantee Lender window to add a Guarantee Lender On the Maintain Application window select the Product Type Provided Guarantees and next select an applicable product code On the Guarantee menu option Guarantees can be maintained 3 9 Proposal Made The Relationship Manager processes all data into the Proposal Using this feature the relationship manager enters her his proposal regarding a loan into the system A proposal consists of a background and a conclusion It is possible to register more than one proposal for a given application these can be additional to a
113. ne E File rame jng DUTCH RETAIL FUND D HV Status fo ffermeheet accepted Cliert pisse o IHG Dutch Retail Fund D H V Reltonship mer per pHiddemo SS Depertment pa HL Kantoor Arnhem Product type pr Mortgage loan Product code fo anker s mortgage Term sheet date 17 01 2007 _ Term eheet etatus reset to 45 e Select the Term Sheet number to reset OK Close B S V Extra User Manual SOLAR v3 4 Page 56 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only e Click the Execute Query e gt button e Click the lt Term Sheet Status Reset to 45 gt button e SOLAR requests to confirm status reset by an Information Message Status is put back e Click the lt OK gt button to confirm Click the lt OK gt button in the toolbar to save the changes The SOLAR gt Term Sheet gt Term Sheet gt Maintain Term Sheet window allows changing the demoted Term Sheet 3 16 Approve Term Sheet For the acceptance of a term sheet the date of receipt and date of signature must be entered The accepted choice must also be marked and the Interest commencement date completed The interest and capital payment dates and the invoice statement frequency can be altered The feature consists of four tab sheets In the first enter the loan option in the second view any escrow details read only Depending on the choice entered in the 3 tab sheet it is possible to view a summary The final Acceptance procedure begins
114. nt Request window but for the lt Approve gt button After approval it is possible to create a payment order but this aspect of payment processing lies solely with Financial Administration and is therefore not covered any further in this manual User Manual SOLAR v3 4 Page 96 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 5 8 N Put back status escrow payment request Loan i 1004104 IRMA DE BRANDING Eac mna Aporaved escrow payment regue sts Eac comp Beretcary Put Back Status Request for Payment z SOLTRAIN 52 HERRERO The Put Back Checkbox allows toggling escrow components Putting back disbursement forms enforces a renewed approval procedure 5 8 1 For a written disbursement request from the Consult Loan Details Window client open the SOLAR gt General gt Consult Functions gt Loan gt Consult Loan Details window Consult loan details general Los 000003353 RP LANDESBANK RHEINLAND aah r htermediary lt De Rebrlionship Mansger fis freama SS Degariment par p United Kingdom 58 PUT boo fo F LOO Exposures LCO part pirss f fuer neey Property Unit Trust vehicle Product type ft Moroso SoS Product cada fo fixed mortgage Chert risk ouclit pa oak o ooo Exposure type Er prasme Sector ID E Legal Ore Obigo 47 000 Bark acccurt Atareti cotiecton f Fisk nurber a Penaky mth 4 000 Code hit hew oan gt Payrmert r
115. nt Requests Report gt Prepare Report Payment Requests window e Invoices Per Escrow Component Report gt Report Invoices for Escrow Component User Manual SOLAR v3 4 Page 98 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 6 Interest Rate Renewal and Extension In SOLAR the expiry date of a loan calls for a renewed decision on the loan In introducing a loan into SOLAR the Maintain Agenda option can be used to list this date After the risk manager decides the loan qualifies for renewal or extension the loan is processed in SOLAR In SOLAR gt General gt Agenda gt Maintain Agenda gt Maintain Agenda window all loans with an expiry date lt today stand in line to be revised Steps to perform for a renewed or extended loan are 1 Risk evaluation 2 Client behavior 3 Loan History Refer to SOLAR gt General gt Consult Functions gt Loan gt Consult Loan Details window general Risk Manager Go or No Go Go Click the SOLAR gt Extensions gt Enter Extensions Details gt Enter Extensions Details window Or go to SOLAR gt Agenda gt Maintain Agenda gt Maintain Agenda window to find the extendable loans Look in Solar for the associated loan number if not yet known and create an agenda entry in Solar for recording purposes SOLAR gt General gt Consult Functions gt Loan gt Consult Loan Details window Type here the loan number or one of the associated loan numbers click the lt Question
116. ntain counted value for the Existing Proposed and W for Outstanding sums Amounts are in thousands Totals are this automatically counted and cannot be adjusted in this field Applica tion User Manual SOLAR v3 4 Page 83 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Corporate Frontsheet window Facilities Tab fee Value Description i Total S For facilities with risk code S these fields contain the c for this counted values of the Existing Proposed and Outstanding Manual For other facilities with risk code L PS U or W these Input three fields contain the counted values of the Existing Proposed and Outstanding sums Sums are displayed in Applica sums Totals are automatically counted and cannot be thousands tion adjusted in this field Sums are displayed in thousands 7 Manual For other facilities from outside Real Estate Finance with risk Input code S these three fields contain the counted values of the Existing Proposed and Outstanding sums Sums are displayed in thousands Total Automati For this application with risk code L PS W and Total Other Legal c L PS W these three fields contain the counted values of One the Existing Proposed and Outstanding sums Sums are Obligor displayed in thousands Totals are automatically counted and L PS cannot be adjusted in this field W Total Automati For this application with risk code S and facilities with Total No
117. omic One Obligor gt Click the lt LOO gt button gt Maintain LOO window check the appropriate checkboxes and if necessary change the CDD Date SOLTRAIN Eo number LOO number Deserplion Revisie datum CDO COO date COD risk level Blocked firas s32 Man Kooten Computer Services B V pt 04 2003 F praso normar 7 O Maintain LOO Field Values__ Description Obligatory E00 Number Automatic _ Economic One Obligor number __ N CDD Risk Level__ LOV___ Select the appropriate risk level___ Yes OO le Check data in GRID en Solar with loan file including dates of interest renewal loan expiry object valuation and tenant contracts within the coming 12 months For GRID instructions refer to the GRID manual Determine which rating model should be used for rating this customer type CL SME SBF or IPRE Refer to CCRM Portal Rating Exposure User Manual SOLAR v3 4 Page 124 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Prepare 1 Frontsheets refer to Corporate Frontsheets 2 List the loan on the Agenda Functionality in SOLAR 3 BO Loan Control Report 4 Real Estate tables refer to Business Objects to generate the ST 059 Overview Real Estate Table Exposure Overview Result e An approved Customer Review Credit Proposal with GMA e Updated Loan file in SOLAR e Updated LOO file in SOLAR User Manual SOLAR v3 4 Page 125 of 135 06 29 2007 2007 ING REF All Rights Reserved Int
118. on Tab Field Values___ Description Obligatory Calculation Current Risk Amount Amount previous period Previous Period Interest Automatic Amount Amount of Change Amount Paid pert autona S poe ae ePIC Automatic Automatically filled by the system ime b Lil system Some sowe sed a Demre WE Date Liquid e Input Type the E e S date in the first field Value type in the second the liquidation price for the property Other Invoices Calculated Automatic Sum of the Interest Amount of Change Amount of field the Amount Paid field the Liquid Change Value field and the Other Invoices field Please Note The Open Market Value field does not count eooo Amount Manual cata ee with the amounts from two columns of eee Definite Risk ame Input E Amount Current Period ee prom cal Los sid menu Input User Manual SOLAR v3 4 Page 128 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only The Open market Value field is only completed if there is an amount gt 0 00 in the Definite Risk Amount Previous Period field and the Definite Risk Amount Current Period field ash If the Loss field is completed the Operational risk tab sheet will become active TI 9 1 2 Maintain Risk Details CRES Window Reason Risk Report Tab Maintain Risk Details CRES Window Reason Risk Report Tab Field _ Values _ Description Obligatory A problem loan must include at least one Reason
119. onality Financial Manage ment Contact Details Static Data For your convenience the general manual layout is provided below e An introduction to SOLAR in this chapter an explanation on how the manual has been developed and the notation in this document e Getting Started with SOLAR details information on your User Profile how to navigate through SOLAR the available functionality such as Print Search Save Add and the existence of Lists of Values Next seven chapters explain the Loan Administration Deposit Request Interest Rate Renewal and Extension Contract Amendments Review Outstanding Loan and Rerating Transfer to Credit Restructuring Repayment and Cancellation Interest Condition 1 1 Notation in this Document error Message window message is between the 4 number sign lt keyboard Keyboard button For example lt enter gt or lt F5 gt button gt lt button gt Software button visible on the window for example _Find contact LOV Option list a click on the arrow next to the list box opens the list of values from where to select an option Window Name F User Manual SOLAR v3 4 Page 7 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Entity Element of Solar for example Term Sheet Loan or Client Field Data input box these boxes have access rules to prevent unauthorized alterations or updates Fieldname Title of a field R Mind Pay attention to what is written here a T
120. ons of other companies and or Persons to the Client 4 The Maintain Client Obligations window allows for fund providers or ING Branches to be added with their amount of participation or with their amount of Client Obligations with the Maturity Date 5 The Consult Default Periods window displays the Start Date and Maturity Date of a Problem Loan User Manual SOLAR v3 4 Page 115 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 6 The Maintain Rating window enables to add and or change Rating information on the Client 7 The Maintain Rating IPRE Client window can also be reached at the SOLAR gt General gt IPRE Rating gt Maintain Rating IPRE Client window This window serves to rate a client with all information already entered into SOLAR The three buttons are there to manage the rating process a Click the Enter Source Details button to organize all information on various places available in the Solar The Source Data tab displays all Facilities of the client all Properties of the client and all Tenants of the client b The Calculate Risk Driver button displays all part that influence the risk rating process c The Rating Report button produces a report on the rating to be printed 8 The Pro Forma Rating IPRE Client window also serves to rate a client but in this window additional data for example securities can be added to achieve a more accurate rate 7 6 3 Updating Addresses By clicking the lt Add
121. ording anticipation Functional Management wants to know the program number and the version number of the active software 2 11 Reports and Overviews A report in SOLAR is always preceded by a Print Definition Format window On this window all conditions and parameters that make up the report are set N 5010208 epaie rep mim i OK cose la w z7 SOLPR2 Selection Others Department __ E Save setection E Centre Humber of copics Produet tpe E Destination RIHTER Currency a Destination name 096 Voluc date Period Balanec in escrow onby 7 Loan number from E SS Export Report total 7 n _ A Print Definition Format window consists of three parts 1 Selection This part defines the parameters for the report The subject of the overview determines the number of selection options D In general it is possible to set multiple parameters 2 Export Reports may have different export options For example both a financial and an industrial overview can be exported Set the export option to Y to prepare the selected overviews 3 Others Set the follow up for the overview on this part of the window After setting all preconditions for the report and a click on the lt OK gt button the Process window opens to determine the production date and hour User Manual SOLAR v3 4 Page 19 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Process on 31 01 2007 13 16 Status Num
122. ough and after a value is selected a click on the lt OK gt button or a click on the lt Enter gt key transports the value to the field on the calling window Application number x 1007700134 1104942008 1105130008 1705224900 1705242000 1770011300 1997040028 1997050037 1997060170 1997070204 1997070308 1997080011 Find 18 05 1999 22 03 2000 02 08 2000 30 01 2001 03 08 2000 30 09 1997 30 09 1997 30 09 1997 10 07 1997 08 07 1997 30 09 1997 HHTC HOLDING BRANDJES NUCLEON SOPHIA BLY VASTGOED HEZELSTRAAT 14 16 WERFF VERHOEVE BEHEER A Y WENTGES ROOBOL UEY BERLO DHR ING F H VAN OPPENHEIM EURIMA INMOGRO BY POUW EV o Cancel If a List of Values is very large in the Find D functionality a search query can be typed To execute the search click the lt Find gt button The lt Enter gt key or the lt OK gt button serves to transport the selected value to the calling window p To close a List of Values next to the lt Cancel gt button the lt Esc gt key may also be used 2 10 About SOLAR zi Copyright ING Real Estate 1995 User PAOTEGS2 Date 30 01 2007 13 14 Station SPHL TERSO004 aa 1176976 Program 0162080 Version 2 46 User Manual SOLAR v3 4 2007 ING REF All Rights Reserved Page 18 of 135 06 29 2007 Internal Use Only A click the lt Question Mark gt button gt on the System menu bar opens the About Solar window If the SOLAR application works not acc
123. pare Standard Document gt button to generate a standard money disbursement letter e Click the lt Administration Costs on Disbursement gt button to open the Maintain Disbursement Order window where to adjust the administration costs Click the lt Specification gt button to open the Maintain Disbursement Order Specification window to review the administration costs selected SS Maintain disbursement order ox cose 9jaj7 Eje loj SOLTRAIN Dish order feats Ready E Cher flix burs loan 2007 01 0057 01 LRP LANDESBANK RHEIN Payrnent type Disbursement new loon Eso a req A Ezcr z le r Eac comp hws Ge Amourt 17 161 718 75 Abeady paid eea Paym date 04 2007 heaming noce ae hake Ee DEDA Lasn foononsisi ERP LANDESBANK RHEINLAND Paymert to pss peoe Ait E Address rosse Bleishes4 00 0 Paymu detals chy Cry MAINZ GERMANY GERMANY Abroag ff Wom amp Accourt number ana Berk occ abroad Bazas oo Journal DAO a Berk code eee Centre pos NG RE Finance UK BY Swift cade peresa Ke cartre Ea P Giry pa Englnd O Curr psr British pounde Paym descr 4 Meth of payment Fie paul l EM number C Reason refusal a Dete Keady spegmieation 3 20 Registration of documents received This feature enables the user to register receipt of returned documents Documents which have been registered will not be displayed on the Reminder list Register a document by entering a datum of receipt a
124. r z fs9sTo00st1 Vv 2 04 2007 F fi etre eldleningsovereenkomst linea fostom Vv A E 2 04 2007 Vy ere Gcidicningsoverecnkomatlinca mef if mf Bre Howrsbier i poron ae oe fife me P Jf Ee CT Cle Cds Prepare To successfully draw up documents you must enter as much relevant information as possible in SOLAR Document composition is the sole product of the information already collected in the SOLAR system It is possible to draw up and print a document more than once as soon as these documents are sent per post they are considered definitive Upon generating the first document the status of the loan becomes status 70 meaning that documents relevant to the loan are being drawn up It is not possible to draw up documents if the loan request becomes deactivated during the process After selecting the appropriate loan number retrieve the documents using lt F9 gt Use the lt Prepare gt button to prepare the checked documents and place them in the defined directory The reminder date can be set on the Reminder Date column If this date passes and the documents still have not been returned then they will be printed on the Reminder list 3 17 7 Receive Documents After the documents are prepared and the lt Prepare gt button is clicked the documents can be reviewed in the SOLAR gt Term Sheet gt Received Documents gt Maintain Reception of Documents window The lt View gt button is available to evaluate the documents 3 18
125. redraft to the legal advisor 7 3 1 Term Sheet Draw up the changed loan documentation in the original Term Sheet SOLAR gt Term Sheet gt Maintain Term Sheet gt click the Loan button A new Loan letter must be prepared After the legal document is prepared and the Loan documentation is ready send in the documents for approval After approval by management itemize the documents in SOLAR through the Agenda Functionality and send the documents for signatures to the legal advisor of the client If the documents return from the client file them in SOLAR User Manual SOLAR v3 4 Page 110 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 7 4 Maintain Contact Details Maintain Contact Details To maintain e ING Branches e Intermediaries e Notaries e Clients e Appraisers e Creditors e Guarantee Lenders 7 5 Maintain Clients Clients are registered in the GRID application Refer to the CCRM intranet site to register the client in GRID Next submit the client contact details to SOLAR and from there continue in SOLAR If the GRID application is unavailable type the contact details in SOLAR as is described below But do not forget to establish the connection with the GRID as soon as possible SOLAR gt General Menu gt Contact Details gt Contact Details Select the Contact Type and click the lt Add gt button Before an application form can be administered the contact details must be entered Client details
126. resses gt button addresses can be recorded in both personal details and company details files HN Adresses ol x mapa inset ox close QA ENSA Etra 7 SOLPR4 Address type v f omicile address Cio oO Att Country code IL fe Netherlands Postal code inland abroad p2steEv Delete House number fio l Street e Rede City PRONTEN Blocking code l l Links Addresses are subdivided into types On the Address type field one of the address type options can be selected using the Question Mark lt gt button Only one address of a particular type can be added for a person or company The following address types can be selected e C Postal address e F Invoice address e V Domicile address More than one address can be recorded on the Addresses window To record more than one address it is necessary to make entries according to address type and click the lt OK gt button before starting on the next address record For correspondence at least one unblocked address is obligatory for each Client record If this is not the case the system reports this in situations where the address has to be used SOLAR applies a searching sequence in recalling listed addresses for a particular client If a particular address type is not present in the record SOLAR pages through to the next one User Manual SOLAR v3 4 Page 116 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only according to set sequence For
127. rom the Maintain m ae ae window data is displayed on the Source Data tab Calculate Button After the Enter Source Details button has been clicked inal Risk Driver the next activity can be a click on the Calculate Risk aon ater button Data At tect kre buton tes ee ced on the Risk pares tab Ru E button can be clicked to A a rating report Sore bas AE L Taran Ce ERE loan and AA EEE EEE tables are eee ee eS Number atic atic Loan atic Escrow atic Construction atic is unchecked has signed the loan a R E Nr Input Blocking Checked if the loan is a problem loan Property Display of all property data belonging to the matching loan and application data Property Autom Filled with property number Number atic Description Autom atic Market Value Manua Type here the open market value Input Property Manua Pro rata exposure per property loan combination Yes Exposure Input User Manual SOLAR v3 4 Page 35 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Cru ue Enter data if client is Guarantor or a ese es CE EL an Maintain Rating PRE Client window Value Description Oblig atory atic Select suitable property characteristic City Autom Location of the property N A atic Cty LOV Select code of the country where the property is Yes situated l Marketability l LOV l Select applicable characteristic Yes State of REM Manua Current value of the property in relatio
128. rontsheet gt Corporate Frontsheet window The only search option is for an existing Legal One Obligor Use the lt F8 gt keyboard button or the Question Mark lt gt menu button If no Frontsheet was created for the selected LOO SOLAR generates a Frontsheet The newly created Frontsheet receives version number 1 and the version will remain nr 1 until the status of the Frontsheet is changed from Status To Be Finalized into Status Final then the version number increases If more Corporate Frontsheets for one Legal One Obligor are available in the system the Frontsheet of the latest version is displayed first The lt Page Up gt and lt Page Down gt arrow buttons allow for paging through the records The lt Refresh Data gt button collects all data The status of any new requested Corporate Frontsheet opens with status To be Finalised The Corporate Frontsheet menu option allows changes to the data if an asterisk is placed behind the modifiable field Changes are not validated by the system they are confined to the Corporate Frontsheet window When a Corporate Frontsheet is ready the authorised employee can toggle the status from To be Finalised into Final Once the status is Final no changes are allowed to the Corporate Frontsheet A fallback option is only available for as long as there is no other Frontsheet from the same Legal One Obligor with status To Be Finalised A blocked Legal One Obligor prevents generating Corporate Frontsheets for
129. rts and summaries for printing The conditions and parameters associated with the chosen list can be entered on this window 2 7 Search and Query Functionality To search find and display data the SOLAR application offers Search or Query functionality Query functionality is activated by a click on the lt Query gt cA button or by a click on the lt F7 gt key This renders the window in the lt Enter Query gt mode Features are On the Search window no data in the fields User Manual SOLAR v3 4 Page 15 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only The lt Add gt and lt OK gt buttons in the button bar are unavailable Also the lt Arrow gt buttons are grayed out The lt Close gt button toggles into the lt Cancel gt button The status bar displays the following text Enter a query press F8 to execute lt Ctrl q gt to cancel Searches can be done in the Query mode a click on the lt F8 gt key or a click on the lt Execute Query gt P button collects the searched for records A Search can be done based on more fields in the same window k Be aware various windows open in Query mode at startup Queries can be started at once by executing a search option in one of the fields Execution of the query occurs by a click on the lt F8 gt key or the lt Execute Query gt K button To interrupt a query click the lt Cancel gt button Or use the lt Ctrl q gt command 2 7 1 Wildcards Searches
130. s shown below User Manual SOLAR v3 4 Page 72 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain reception of documents Loan nr fiovos2 VEENENDAAL 100052 Status Appication rr Seq number l Application date Client foe13 pie heer T van Veenendaal Closing dale fi2 01 1984 Notary l Product type pm Mortgage loan Relaicnshp mar jage Product code po Fired mortgage Departmert p26 IL CC Lease NG branch nr foror HG Bank H Y Heemskerk Stonderd doc Description Docunert Remind Docunert Reminder Remincer Receipt FETOP reerdereafechriten pos pomor p amp a es eee E G ee ee ee ee ae i SSS Seid A R SS A E A E E a ey 6 ee es 1 S S E aS OR FD He e a Ces A G eee G A ee 3 21 Maintain Disbursement Orders This feature consists of three screens e Summary of disbursement orders e Update disbursement order e Consult specification 3 22 Order Preparation for Loan Money Disbursement SOLAR gt Term Sheet Maintain Disbursement Order gt Select the loan that needs updating and click the lt Change gt button This opens the Maintain Disbursement Order Details window User Manual SOLAR v3 4 Page 73 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 3 22 1 To Update the Disbursement Order t Maintain disbursement order 7 awe ja Ee Dish arder fist Ready r mew Dixburs loan 2007 02 00
131. s the Contact Link Details window to add a link User Manual SOLAR v3 4 Page 121 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 7 6 7 Updating Creditors This feature allows the user to couple a Contact Details creditor record and is accessible using the lt Crd gt button found in the Personal Company details window or directly through the menu SOLAR gt General gt Contact Details gt Contact Details gt Maintain Creditors window Creditor information is vital for carrying out all payments of monies not directly related to loans in SOLAR through payment records 7 6 8 Updating Appraisers Using this feature a Company Person Details record can be coupled with Valuer records and is accessible using the lt App gt button on the Personal Company Details window or directly through the menu SOLAR gt General gt Contact Details gt Appraisers gt Appraisers window Appraiser information is used in assessing and appraisal of property aaa OK Close z SOLAR ID f323862 Es Schocman Aperasertype independent 3 NO eperaser Branch boas Fchocman feonendaal Work wea SISTING HOUSES Specialization ia residential housing Blochng code Companyipers details Address details 7 6 9 Updating Guarantors Using this screen a Contact Details record can be coupled with an Guarantors record and it can be accessed by a click on the lt G Ind gt button on the Person Company Details window User Manual SOLA
132. sands The difference with the Proposed field points at Manual the arrearage prepayment situation or a not yet booked but C U Input are part of an already validated line Fill out C meaning Committed or U in case of Uncommitted Only internal validation orders are uncommitted Default LOV value is C LOV Risk Risk Categories differ between Cat L Lending S Settlement PS Pre Settlement W Warehouse l Issuer U Underwriting O Other Basically all Real Estate Finance activities are part of the Lending category IT Issuer Proprietary Trading Risk for reference only is not part of the Legal One Obligor group exposure Facility Manual Type here the standardised name of the facility next type Descrip Input the character of the debtor concerned for example A or A tion B Standardised names are Term Loan Operational Financial Lease Current Account Construction Finance Sell Off in Smaller Lots Facility Bridge Loan swing loan for short period made in anticipation for a long term loan used for financing VAT for example If Facilities are in standby mode type s b behind the notation Blocke Check Default checkbox remains unchecked Blocking a line leads d to omitting the line on the print overview Adjust the logical referrals manually Automatically checked if facility details are added manually Yes Total Automati Facilities with risk code L PS U or W these three fields L PS ic co
133. sult Default Periods window to review Starting Date and Maturity Date of a loan Guarantee Inactive refer to Guarantee menu option Links Opens Contact Links Details window to see the relations of client with other clients After all details are inserted save the Maintain Application window and present the file to the employee authorised to validate the application After validation of the file the Application reappears in the Relation Ship Managers To Do list If items for the application are unclear the Deactivate Application window serves to place the application on hold After clearing the issues the Reactivate Application window serves to activate the application 3 7 Gather and Analyse Client Data The Proposal for a loan is processed through the Maintain Proposal window In this stage of the process the information needs to be gathered for the future Term Sheet All information on the intended client needs to be processed Update Client information on the Company Person Details window The property for which the loan is requested needs an update too on the Maintain Properties window And the interest rates to fund the loan must be deduced from the Maintain Funding Rates window 3 8 Maintain Proposal Window User Manual SOLAR v3 4 Page 43 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 15 x N Maintain proposal afem a ox cos ja Eel fi SOLPR Application m 2
134. tatic Data Title Bar The name of the subject the specific window is supposed to cover Toolbar Contains all general button functionality refer to User Manual SOLAR v3 4 Page 10 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Buttons and Shortcut Keys for more information on the subject Scroll Bar To the left and at the bottom of a window a scroll bar might be present this is only if the information in the window does not fit the display monitor Use the mouse to drag the slide control up or down or click the Up or Down arrow to page through the window Status Bar SOLAR Oracle information is displayed on the data on the current window l x ancel mortgage Guarantee N Solar Euro SOLTRAIN MO1E682 F A van Leeuwen van der elden Fie General Termsheet Extension Escrow Invoice Debto j i Mgmt Table System Window Title Bar N Maintain term sheet Application nr Seq number Term sheet status C Client i o ean Appl date E File name Product type Accountmgr Product code Relationship mgr Loap ammanan AAN 7 Scroll Bar epartmel er Centre code Acceptance date E Exposure type Interest percentage a Group exposure Repayment percentage E EQO Chances 50 oO LOO exposure Role ING E LOO part Margin E Term sheet date sd Valid until E Periodicity E Portfolio facility nr 1st roll over date i an d User Man
135. this LOO User Manual SOLAR v3 4 Page 77 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only N Corporate frontsheet ad OK Close 9 z SOLTRAIN LOO number pas AmM vanleeuwwen SiS Sj Status To be finalized Refresh Data Version f Print fronsheet EOO number pos AmM vanleeuwen S i Sy Refreshed p 06 2007 Delete General Facilities Earnings Covers Covenants Purpose a a Initiating Office fi Kantoor EIN Local Application No E Prepared By F A van Leeuwen v d Velden Regional Application No Risk Management JUGREFCA sis Exposee No Ultimate Approval Authority E Parent Name A Ing Executive E Grid Id a Next Review Date 2 01 2020 Parent Standalone Rating Global Corporate Client oO Parent Influenced Rating Parent Account Manager EOSO o y y Parent Risk Country Rating m PAM Office N Borrowers Report Stand Influ Ctry Industry Id Borrower alone enced res Grid Id code Blocked Manual a 4 M van Leeuwen fonts fl pezars f31300 O a LJ CLI CC J CJ8 L_ LJ LJ LJ DJL 6 JL CIC j e Ci CI CC JC je Functionality on this window Corporate Frontsheet window Upper Part Value Description Oblig atory LOO Number Select from EOO LOO window the correct LOO Number _ Yes_ Autom LOO description Yes atic Autom EOO number retrieved from selecting a particular LOO Yes atic Autom EOO description Yes atic Yes es EOO Number
136. ts window On this window the ratings are selected And after setting the qualifications three buttons are available to actually carry out the rating procedure User Manual SOLAR v3 4 Page 30 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 20 Maintain clients R Add OK Close 2 a Y 2 3 M Extra SOLAR ID fis155 fx van Leeuwen EN Industrie NAICS 31300 Activities Related to Real Est Debtor number ING Intercompany centre r Prime client Internal REF entity O Contact type fon Forentty S Client risk qualif SME Corporate Small and Medium Sized E Rating model kso Korporates Large Converted Rating Date 13 s o3 2004 KFC exposure O Customer section RVRF Private Individuals Real Estat Customer type GRID ov fndividual S Block a Comppers detail Address details Links Obligations Defaultperiods Prepare rating Pro forma rating Maintain Clients window p E ry SOLARID Lov Select from Find Contact window Yes SOLARID LOV Fo ll E Number ING Centre atic raised Check if the client is a prime client Internal REF Check if the client is an internal REF Entity Entit Client Risk LOV Select the client risk qualification code from the LOV Qualification this is the first indication of a possible risk Rating Model LOV Select the applicable rating code with this code the Yes employee assigns a mark to identify the branch to which the client belongs Rating D
137. tutory occupant Obligor Select the status of the security Blocked Check This checkbox blocks the data from the checked rule in Yes a printing mission All existing referrals must be tested manually 4 1 4 Corporate Frontsheet Window Covenants Tab General Facilites Earnings Covers Covenants Facility Humber Description Status Compliance Blocked fie frerpanding huurpenningen Existing and complied weith x l E E E pu Corporate Frontsheet window Covenants Tab Value Description 070 fe atory Facility Manual Refers to the Facility from the previous Corporate Number Input Frontsheet Window Facilities Tab If a security is coupled to a number of loans then you also have to enter several loan numbers Be aware The accuracy of the referrals is not forced upon by SOLAR A short description of the security Yes Input Indicates the status of the condition User Manual SOLAR v3 4 Page 89 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Corporate Frontsheet window Covenants Tab Value Description 0 o I Te atory User Manual SOLAR v3 4 Page 90 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 5 Deposit Request This chapter describes the features that are available in SOLAR which aid in preparation and management of money escrows necessary after a loan has been drawn up Escrow information must be registered in the Escrow modu
138. ty Security type Provider Currency Initial Actual Block Lt SS ES O a E a aA a SS es es ee ee a ES ES a E E a E Lf CC a Detail Hew security Maintain Loan Sub Window Securities Button Description Header for leasing fields Security Type Generated when selecting the security tic Provider Automa Generated by SOLAR rA tic tic User Manual SOLAR v3 4 Page 67 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Loan Sub Window Securities Button Value Description Obli gato Le lh a Lal SOLTRAIN Client psw e o oy NG Bank branch ani PE nternedary rs ee Notery l Rela ionshp manager 446 Kiteantae Departmert A United Kingdom Contact Clent Capacity Bock aa E f z gt ss E ae gt es lz rs ae Da OL ILIE Property nr Description Black a A E a Cd a CC JIE General PPP Loan Securitice Client Property Other text Salutation Loan interest aroup Maintain Loan Sub Window Loan Button Value Description Oblig atory User Manual SOLAR v3 4 Page 68 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Loan Sub Window Loan Button Value Description Oblig atory 3 17 5 The Maintain Loan Sub Window Other Text and Salutation The Maintain Loan sub window Other Text and the Maintain Loan sub window Salutation offer free text fields to adjust the Loan letter The
139. ual SOLAR v3 4 Page 11 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Buttons and Shortcut Keys Button Shortcut Function IOE lt F6 gt The Add command opens a new window with no data to allow for filing a new record On a multiple records window a new line is created to file the new data OK lt F10 gt Save the filed data and stay in the same window Cancel lt Ctrl q gt Abort adding data without saving Abort a query Close lt Alt F4 gt Close the active window If no windows are active SOLAR is closed E o Click the lt Query gt EA button to open the active form ener in query mode Type the query and click the lt Execute Query gt D button If the result is larger than zero the result is displayed otherwise the Status bar displays a message Query caused no records to be retrieved Re enter To page through a search result h E lt F9 gt A click on this lt Question Mark gt button opens the List of Values from which an option can be selected B The lt Maintain Memo gt button opens a window with text field to create a memo Click the lt OK gt button to save the memo and click the lt Close gt button to return to original window The lt Maintain Memo gt icon is now colored red A click on the lt Maintain Agenda gt button opens the Maintain Agenda window to file changes window to attach some files to the company To Todoths this Shortcut Key Accept Commit
140. ulate mixed interest x case Pl Ee 0 Date pat new Interest trie wer i ia noun new term months a En a et loj Loan numer Remaining Ads Ren nv Inv F Mixed Med Mixed Mixed Sz E SS ee A E a E E ss ell a nn es ee ee E ee es es ee es ee O sf Amou Increace New interest e SS eed ee a a ee New tern Neve principal amount Mixed rete Clear screen Calculate mixed rate Print 2 14 9 RCS ma o cooo PAP z enm SOLPR2 2 e Caubtedsy T Iaa Delete Caoulstedon LE Cony Sobvahility Repaymenicapacily QualityinfoReslesiate RCS Specwicatian ladle copier Coveciioas Nable capita Stock csptal secost other sesats Minnceny others hterceemmany General ago end law reserve RE board Joint Profit Reserve nvectnant pramium Corrections 0 00 reserve potential tax Sient reserved real estate Balanos total Lishe captal 0 00 Somaknty Age of yeernumbers Recent digues C 1624 morthre Cc Aber To calculate a Risk Classification System code go to SOLAR gt General gt Calculation Menu gt Calculation Menu gt click the RCS button With this functionality an RCS code can be aqcuired On the Solvability tab the holdings are given The Repayment Capacity Tab User Manual SOLAR v3 4 Page 25 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only surveys the numbers acquiring the repayment capacity The Quality info Real Estate Ta
141. unt or Percentage Yes Intermediary Indu LOV Select Amount or Percentage Yes str General Button Click this button to return to the default window Refer to Maintain Properties Window Euribor Button Refer to The Maintain Loan Sub Window Loan PPP Escrow Refer to The Maintain Loan Sub Window a PPP Letters Button _ Seebelow gt Z zZ gt gt i g gt n my gt 2 User Manual SOLAR v3 4 Page 101 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 6 1 1 Letters Button N Enter exbension details SOLTRAIN Loan nutier mi4 ALK 101074 Expiry date 1 07 2007 Qurrency UR uro Merast rol over Letter data Request for financials F Ramin request for financial E Prepared Dote renner Letier sert E Number of reminders J Announcement through Invoice Y Letter request tor total repayment Announcement letier Anrnuncement text Preserad Documert deed JveRLsz Prenared pa 03 2007 Remind F Decumert reminder JWeRLs7 Document 2nd reminder WERL36 Dete reminder fe 03 2007 Date 2nd reminder si Letter to querantore A click on the lt Letters gt button opens the Enter Extension Details sub window Letters Additional fields are Enter Extension Details Sub Window Letters CoC 0 ee Description Obligatory User Manual SOLAR v3 4 Page 102 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Enter Extension Details Sub Window
142. ur po Burbs rete type FSSC CO Escrow statue pno Prepared Esnwanom Ty Product tyre ps Emon OO Sr 20000 Product cade fin scrow term sheet classy Dteerce zao Starling date 04 2003 Nat const ct o Maury cate 07 2000 Eurbor interest tyae Round oft Round otf to 4 1st ral over date Margn CSSS Interest rollover ireguency LO B Condtons Bicchng code Enter Change Escrows Window S User Manual SOLAR v3 4 Page 92 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Enter Change Escrows Window S Escrow Status Tu Assigned upon the creation of the Escrow e atic Product Type Select product type from Product Models list No E Product Code Filled automatically after selecting a Product Type atic Manua Type the interest differential for non Euribor Compensation Input escrows Leave empty for Euribor escrows Difference Manua Type the percentage of the difference between the No Input escrow and the principal Starting Date Type here the Application Date Input Notification Check Check this option box if the documents must be N A Construction notified Documents Maturity Date Type here the Loan End Date Input Escrow Amount Manua Type here the amount open for deposit Yes Input Overview of data regarding Euribor Interest Type Select interest type from Euribor Rate Types list Round Off OV Way to round the amount Round Off To
143. w RECORDS 91 5 2 TO ENTER OR CHANGE AN ESCROW 91 52l Change Escrow Components 94 5 3 ESCROW APPROVAL 95 5 4 CHANGE RUNNING ESCROWS 95 5 5 ENDING ESCROW 95 User Manual SOLAR v3 4 Page 4 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only 5 6 ENTER PAYMENT REQUESTS 95 5 7 APPROVE REQUEST FOR PAYMENT 96 5 8 PUT BACK STATUS REQUEST FOR PAYMENT 97 5 8 1 Consult Loan Details Window 97 5 9 PREPARING REPORTS AND ALERTS 98 6 Interest Rate Renewal and Extension 99 6 1 ENTER EXTENSION DETAILS 100 6 1 1 Letters Button 102 6 1 2 Prepare Letters Request for Financials 103 6 1 3 The Prepare Extensions Functionality 103 6 1 4 Enter Received Finacials and Assess Debtors 103 6 1 5 Approve Repayment Amounts 103 6 1 6 Get Interest and Calculate Annuity 104 6 1 7 Change Status Extension 104 6 1 8 Letters to Generate for Extensions 106 6 1 9 Approve Special Extensions 106 6 1 10 Enter Acceptance Extensions 106 6 1 11 Put Back Accepted Extensions 107 6 1 12 Settle Unextendible Loans 108 6 1 13 Definitely Process Extensions 108 6 1 14 Maintain Ending Loans 108 6 1 15 Process Ending Loans 108 6 1 16 Reports 108 7 Contract Amendments 109 Jl CHANGE LOAN DETAILS By PA FA WINDOW 109 7 2 CONSULT EOO LOO WINDow 110 3 EXPENSES 110 Fal Term Sheet 110 7 4 MAINTAIN CONTACT DETAILS 111 15 MAINTAIN CLIENTS 111 7 6 UPDATING PERSONAL DETAILS FILES 112 76 1 Adding a New Client File 112 70 2 Maintain Client Obligations 115 1 6 3 Updating A
144. wer Het Grocne Hues Print daste Request consens existing Aperasal moby Purchase x LOO i oo focuwentankvot Destinstion Agriculture Appraisal Applicant Client RSM SAM io fiat tonhof S Cher Acpicart panet Pivento nw Branch Fangene rt a Telephone TU 3 9502 Telephone A Fax Mohie phone Location Peal Estate CRM Ownership titie Ownership ves New development Furchsse price 123 456 000 00 hyestment cosis WOI vaue 60 233 000 00 Land costs Transfer dete 20 02 2007 Construction coats AcdBons into Print User Manual SOLAR v3 4 Page 117 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Properties Window Value Description Oblig atory Property LOV Select the property number from the Properties List Of Yes Number Values Description Manual A short description of the property This field can be Yes Input manually changed an asterisk appears behind the field RE Type Select the real estate type that matches the property C A sl Select the appropriate currency coe EE reasons o A aa Selecting a property fills the Address field tic Temporary Check Checked as long as no loan has been agreed upon Checked as long as no loan has been agreed upon Yes Maintain Properties Window Location Details Tab Value Description 070 fe atory Location Displays all information on the property Details Select NL from Country list Dutch
145. yment clause BE Y Straight line Annuity interest group Euribor Interest condtion Afterwards x Interest calc sorso z Repaymert amount Repaym frequency 1st Int due cate ist repaym due dete T 4 2 3 Funcing Closed rate Offer 1 C D5 Offer 2 C ss otte 3 sd ae Otter sd Ci Offe 5 C i i General PPP en Eur text Loan Costsiescrow Securities Document ClientProp Other text Salutation The lt Loan gt button is greyed out meaning this is the active window Three tab options are available on the Maintain Term Sheet sub window Loan Straight line Annuity interest group Euribor Maintain Term Sheet sub window Loan E Tab cas level of revenues over the E of the loan User Manual SOLAR v3 4 Page 50 of 135 06 29 2007 2007 ING REF All Rights Reserved Internal Use Only Maintain Term Sheet sub window Loan Value Description 070 fe Amount tic Frequenc Input Date Input sequence is dd mm yyyy Due Date Input Date Input Condition Calculation of the interest ab and including 5 Annuity A series of equal payments each payment occurring at the end of each interest group equally spaced period Additional fields not yet discussed before Residual Automa After deducting the necessary payments a Amount tic residual amount may be calculated by SOLAR Frequenc Input Ea Tab Display of Euribor values connected to the loan selected R

Download Pdf Manuals

Related Search

Related Contents

Daily Physical Activity  Manuel d`utilisation GV 210  カラー監視カメラ LC-S24J（38 万画素） 取扱説明書  Luxor EC111-B  FBTB-16 FPKB-16  JVC KD G521 User's Manual  Manual  König CMP-USB2HUB55      

Copyright © All rights reserved. Failed to retrieve file