FIG Modeling Test and have some questions

Hello all,
I am currently interviewing for an ER position covering Financial Insitutions. They recently gave me a modeling test, and it is much more detailed than any other model I have worked on (probably not unusual considering that banks typically are more difficult to value and forecast than a tech or consumer company). I am not sure if I am overthinking it, and that they don't expect it to be completed perfectly but would rather get a feel for how I approach a model and my thought process.
Does anyone have any resources or tips for FIG modeling? I have found some basic websites and tips online, but would love any additional help because I feel a bit stumped to be honest.
How do I forecast LLR and charge-offs? How do I forecast loan growth without a deep analysis of various loan types (Municipals, Leasing, Construction etc.) and their macro drivers? How do I forecast Average other earnings assets? I tried it by myself and have determined an absurdly high EPS estimate, which I have attributed directly to my LLR estimate. Whenever I am having trouble I am typically just throwing a historical average in there (when appropriate).
Let me know if yall have any thoughts or answers. I would additionally love to take a peek at older FIG models if peeps out there have them and are open to sending them my way. Any advice on how to forecast the effects of COVID on banks would also be appreciated.

Comments (3)

 
Aug 5, 2020 - 6:11pm

Forecast allowance for loan losses (balance sheet item) as a % of average loans
Forecast charge-offs as a % of average loans

Beg allowance for loan losses
+ LLR (P&L item) - this is a plug and what goes on the income statement
- charge-offs
= Ending allowance for loan losses (this is the number you forecasted in the first step)

For loan growth, if you want to keep it high level, start with historical growth by loan type and adjust based off of trends, macro drivers etc. (e.g., restaurants, hospitality, travel, C&R are highly impacted by covid). Lots of different approaches here up to you how much detail to go into.
Banks themselves will likely preform regression analysis based off drivers at a micro product level.

DB (Matt O'Connor) has a really good banks primer - if you have access to research, look for a report called "Banking 101". Latest version may have been from 2017

Array
Start Discussion

Popular Content See all

Biggest Regret in Undergrad
+52IBby Prospective Monkey in Investment Banking - Mergers and Acquisitions">Prospect in IB-M&A
The lighter side of IB! (Hopefully)
+33IBby 1st Year Analyst in Investment Banking - Mergers and Acquisitions">Analyst 1 in IB-M&A
Making the first move as a woman?
+11OFFby Intern in Investment Banking - Generalist">Intern in IB - Gen
JPM vs. CS offer decision
+7IBby Intern in Investment Banking - Generalist">Intern in IB - Gen

Total Avg Compensation

October 2020 Investment Banking

  • Director/MD (17) $704
  • Vice President (49) $326
  • Associates (265) $228
  • 3rd+ Year Analyst (36) $168
  • 2nd Year Analyst (147) $159
  • Intern/Summer Associate (137) $141
  • 1st Year Analyst (583) $129
  • Intern/Summer Analyst (558) $82

Leaderboard See all

1
LonLonMilk's picture
LonLonMilk
98.4
2
Jamoldo's picture
Jamoldo
98.3
3
Secyh62's picture
Secyh62
98.2
4
CompBanker's picture
CompBanker
97.9
5
redever's picture
redever
97.7
6
Addinator's picture
Addinator
97.6
7
frgna's picture
frgna
97.5
8
bolo up's picture
bolo up
97.5
9
NuckFuts's picture
NuckFuts
97.5
10
Edifice's picture
Edifice
97.3