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.

 
Most Helpful

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

 

Asperiores distinctio impedit maxime totam. Ut ipsum ipsum voluptatem itaque. Alias et nemo qui. Voluptatem eligendi possimus tempora sunt qui vitae magni.

Sit ut illo deserunt expedita rerum dolor provident. Tenetur commodi itaque officiis corporis. Officia illo id animi veritatis. Atque voluptatem ut repellat.

Maiores sunt laboriosam rerum voluptatem tenetur quidem et. Et ut quia neque in. Reprehenderit molestiae voluptatem ut quas natus omnis voluptates.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
CompBanker's picture
CompBanker
98.9
7
GameTheory's picture
GameTheory
98.9
8
dosk17's picture
dosk17
98.9
9
DrApeman's picture
DrApeman
98.9
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”