Can anyone point me to a resource that shows/walks through a CCAR/PPNR financial model? So far, i have seen powerpoint decks & documents discussing CCAR/PPNR but have not found any model that actually does that. Is that even done in excel? or is that something implemented in Python/SQL code that continuously updates a realtime dashboard, like stock tickers? Any inputs on this topic are appreciated. I am having a hard time understanding how this concept is implemented in practice without looking at anything concrete. Thanks in advance!

I know this is late and probably of little use to now, but maybe I can still help. I spent a summer at a BB doing this in a Finance/Treasury role. For the first question, it is very hard to find models since a lot of the models seem to be proprietary and are created by quantitative analytics teams. Many institutions seem to have their own models and some banks will hire consultants to aid with the model implementation process. Generally, financial institutions who are new to FRB stress testing will do this so they can follow in the footsteps of banks who have succeeded in passing the test.

CCAR/PPNR Modeling Help

Can anyone point me to a resource that shows/walks through a CCAR/PPNR financial model? So far, i have seen powerpoint decks & documents discussing CCAR/PPNR but have not found any model that actually does that.
Is that even done in excel? or is that something implemented in Python/SQL code that continuously updates a realtime dashboard, like stock tickers?

Any inputs on this topic are appreciated. I am having a hard time understanding how this concept is implemented in practice without looking at anything concrete.

Thanks in advance!

297 WSO Academy Sales & Trading Session Reviews: 4.86/5

Class of '28 Apr 2026 Cohort

5.00/5

Sales & Trading Mock Interview

“My mock session with Joyce was genuinely useful and very targeted. Rather than generic advice, she caught specific delivery habits I need to fix before my Superday. First, she pointed out how often I lean on filler words like "like" and "emm", and gave me a clear fix: pause instead of filling the silence. Second, she told me to slow down my pace overall, which should make my answers sound more confident and easier to follow. Third, she flagged that my opening warm-up came across as a bit stiff, and coached me to be warmer and more personable in the first few minutes so I build rapport before the technical part starts. All three points are things I can practice immediately, which is exactly what I needed at this stage of prep. The session felt focused and honest about what needs work, and I came out with a clear practice list. I would happily book with Joyce again for another round closer to the Superday.”

Thompson Rivers University

Class of '29 Nov 2026 Cohort

4.56/5

Sales & Trading Career Roadmap (optional)

“I had a great experience speaking with him and genuinely appreciated the time he took to share his insights and experiences. He was extremely knowledgeable about the Sales & Trading industry and did a great job explaining different aspects of the role, the industry, and what it takes to build a career in this space. He communicated exceptionally well, was approachable and kind throughout the conversation, and made it very easy to ask questions and engage in a meaningful discussion. I particularly appreciated that he provided actionable advice and practical takeaways that I can apply as I continue exploring opportunities in Sales & Trading and preparing for internship recruiting. He was also very accommodating when it came to scheduling the conversation. Overall, it was a very valuable networking experience, and I am grateful for his willingness to share his knowledge and offer guidance to someone early in their finance career.”

See All 11,551 WSO Academy Reviews

2 Comments

MBA_Junkie

CF

10y

bump..

Reply

Quote

Report

Other

Authored by: Certified Corporate Finance Professional - 2nd Year AssociateCertified Corporate Finance Pro

deepvalue94

ER

10y

Best Response

Praesentium deleniti reiciendis ea est quo at cum non. Nostrum aspernatur aut similique omnis vitae blanditiis cumque quis. Et sit voluptatem ut adipisci.

Odio cum porro dolor. Aut veniam eveniet quia cumque quae vel. Rerum nam est est saepe odit quia. Voluptas dignissimos assumenda minus praesentium. Praesentium voluptates explicabo eius cupiditate eveniet odit fuga.

Reply

Quote

Report

Other

+18	EM trading – looking for some insights	3	1d
+9	Global Markets: What Does the Day-to-Day Look Like Across Different Roles?	1	6d
+9	S&T at an IB or Product Owner at Revolut?	1	3d
+9	Best Banks to Work in Global Markets in Portugal - Compensation and Career Prospects	0	6d
+5	GS vs MS vs JPM S&T SA 2027	3	1d
+4	London SnT 2027 Grad Recruiting	16	15h
+4	SIG Capital Markets Assessment	1	4d

1	redever	99.2
2	kanon	99.0
3	BankonBanking	99.0
4	Secyh62	99.0
5	GameTheory	98.9
6	Betsy Massar	98.9
7	CompBanker	98.9
8	dosk17	98.9
9	DrApeman	98.9
10	Mimbs	98.8

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

CCAR/PPNR Modeling Help

Score Breakdown

Feedback

Score Breakdown

Feedback

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

CCAR/PPNR Modeling Help

See All Comments - 100% Free

Trending Content - Sales and Trading Forum