19 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.
You spend most of the day reading balance sheets, income statements and cash-flow reports to assess credit risk for borrowers. That means opening client files, running financial ratios in Excel, and checking credit histories in SQL or SAS databases.
You’ll also talk to relationship managers, pull extra documents from legal or accounting, and send or read emails in Outlook about credit issues, payment delinquencies, or requests to set or change credit limits.
Expect heavy Excel use for ratio models and scenario tables, plus Word for formal credit memos. SQL Server (using SQL) or SAS holds client credit histories and transaction data you query.
Larger shops add Python for automation and SAP for accounting data. Outlook is the daily communications hub. Learn Excel, basic SQL queries, and one scripting tool like Python or SAS to do this job well.
Use AI to automate repetitive tasks: run Excel macros, generate first-draft ratios, or clean datasets with Python or SQL. Always treat AI outputs as drafts — verify numbers against source documents and your own calculations.
Never rely on AI for final credit decisions. Keep an audit trail (saved Excel files, SQL queries, and Word memos) so you can show how you checked the model and why you recommended a credit limit.
You’ll calculate cash flow coverage, debt-to-equity, and current ratio — usually in Excel. Typical coverage targets vary: banks often want interest coverage above 2.0 or debt-service coverage above 1.2, but rules change by firm and industry.
When setting new customer credit limits, you combine ratio results with payment history and policy guidelines. The final dollar limit depends on the borrower size, collateral, and internal risk tiers.
All three matter, but start with Excel and financial modelling because you’ll build ratio sheets, stress tests and credit memos there every day. Learn VLOOKUP/XLOOKUP, pivot tables, and basic macros.
Next, learn SQL to pull history and transactional data from Microsoft SQL Server. Financial modelling links the two — run scenarios in Excel using data pulled by SQL to produce credit recommendations.