Deposit / NII / NIX / Off Balance Sheet Asset models
Prescio Consulting was retained to develop time series models to forecast Deposit Balances, Non-Interest Income (NII), Non-Interest Expenses (NIX), and Off Balance Sheet Assets for a major U.S. bank. The models were developed in SAS using extensive in-depth statistical analysis and industry standard tools. We worked closely with personnel at the bank to ensure that the models were both statistically sound and yielded predictions that were in line with business expectations. The modeling process incorporated exploratory data analysis, data cleansing, segmentation, variable selection (using statistical and qualitative methods), forecasting, back testing, and sensitivity analysis. These models were incorporated into the mid-year and annual CCAR stress testing exercises for the bank.
Latest posts by Prakash Kayastha (see all)
- Prescio Consulting is a SAS Partner - May 2, 2016
- Prescio Launches New Website – Prescio.com - February 10, 2015
Related Work
-
Automated Valuation Model (AVM) Validation for a major US bank
FeaturedRisk Management -
SBSS Based Credit Scoring Model Development Documentation
FeaturedRisk Management -
Prescio Loan Quality Forecast System (PLQFS)
ApplicationsRisk ManagementSoftware Development -
Pre-Provision Net Revenue Model Validation (PPNR)
FeaturedFinancial Modeling -
Debt Security Risk Model Validation (SRM Debt)
FeaturedFinancial Modeling -
Commercial and Industrial Validation (C&I)
FeaturedFinancial Modeling -
Commercial and Industrial Asset-Based Lending Credit Risk Model Validation (ABL)
FeaturedFinancial Modeling -
Loss Given Default Credit Risk Model Validation (LGD)
FeaturedFinancial Modeling -
Probability of Default Credit Risk Model Validation (PD)
FeaturedFinancial Modeling -
Acquisition, Development and Construction Risk Model Validation (ADC)
FeaturedFinancial Modeling -
Equity Security Risk Model Validation (SRM Equity)
FeaturedFinancial Modeling -
Vendor Risk Gap Analysis (VRGA)
ApplicationsRisk ManagementSoftware Development -
Value at Risk (VaR) Application
ApplicationsRisk Management -
Liquidity Coverage Ratio (LCR) Model Validation
FeaturedFinancial Modeling -
CD Rate and CD Early Withdrawal Model Validation
FeaturedFinancial Modeling -
Loan Loss Mitigation Modeling
FeaturedFinancial Modeling -
Mortgage Portfolio PD, LGD, EAD and Expected Loss Model Review
FeaturedFinancial Modeling -
Commercial PD/LGD/EAD
FeaturedFinancial Modeling -
CCAR Stress Testing for a major U.S. bank
FeaturedRisk Management -
Operational Risk economic capital model
FeaturedRisk Management -
Operational Risk Copula model
FeaturedRisk Management -
Retail Loan Loss Forecasting model
FeaturedRisk Management -
LIFO to FIFO financial statements conversion for major international bank
FeaturedRisk Management -
Mortgage loan loss mitigation model development for a major Canadian bank
FeaturedRisk Management -
Validation of advanced measurement approaches theory – Operational Risk Model
FeaturedRisk Management -
Construction real estate loan disbursement process proposal for auto manufacturer
FeaturedRisk Management -
Risk management methodologies of Basel II Accord applied for major European Bank
FeaturedRisk Management -
Loss and credit quality migration analysis for commercial and consumer loans
FeaturedRisk Management -
LAN based application software and asset quality forecasting model for global banking institution
FeaturedRisk ManagementSystems Administration & IT -
Analysis of historical weather data for US energy and weather institution
FeaturedRisk Management -
Commercial portfolio credit migration model and application software upgrade
FeaturedFinancial TechnologyRisk Management -
Comprehensive study of B2B commerce in Asian for a major Asian transportation company
FeaturedRisk Management -
Customized loan portfolio valuation model and application for regional bank
FeaturedRisk Management -
Validation of advanced electricity pricing models for major US utility company
FeaturedRisk Management -
Comprehensive research study on the feasibility of call centers for Asian conglomerate
FeaturedRisk Management -
Load profiling model and application for aggregating present and future customers
FeaturedRisk Management -
Customized derivatives pricing software developed for major electric utility company
FeaturedRisk Management -
Primary Source Breakeven Analysis (PSBE)
ApplicationsRisk Management -
Retail Lending Loan Forecasting Model (RLLF)
ApplicationsRisk Management -
Operational Risk Model Application (OpRisk)
ApplicationsRisk Management -
Probability of Default Model (PD Model)
ApplicationsRisk Management -
Loss Given Default Application (LGD)
ApplicationsRisk Management -
Loss Equivalent Quotient Model Application (LEQ)
ApplicationsRisk Management -
Loan Migration Model Application (LMM)
ApplicationsRisk Management -
Loan Loss Mitigation Model (PLLM)
ApplicationsRisk Management -
Asset Quality Forecast Model Application (AQF)
ApplicationsRisk Management -
USAT Excel Application With Moody’s Risk Analytics (LIFO to FIFO)
ApplicationsRisk Management -
Retail business restructuring and deregulation analysis for a major utility company
FeaturedRisk Management -
Using generalized flexible time series model to analyze returns at a major trading company
Risk Management -
Quantitative analysis to support new energy trading operations at major financial trading firm
Risk Management -
Model Update, Redevelopment, and Sensitivity Analysis of PPNR for US Bank
FeaturedFinancial Modeling -
Interactive Voice Response (IVR) software utility for automated support
Data AdministrationFeatured -
Custom loan portfolio valuation model and software application for regional US bank
FeaturedFinancial Modeling