Question: Create a stress testing Model in Excel to simulate each steps of the stress testing process that a bank should go through in order to

Create a stress testing Model in Excel to simulate each steps of the stress testing process that a bank should go through in order to pass or not the FED Stress testing process. Number, Indicate, Narrate each step, highlight the key inputs (that should be extracted from internet sources and indicate them in cell comment) and key formulas in the excel (no hardcoding of formulas, formulas must use either inputs or other formula cells, indicate source in cell comment as well). Use Bank of America and Llyods bank to illustrate in Excel and compare with stress testing results published for both of these banks.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!