Upload your bank's Question $1$ balance sheet, the bank capital under each scenario in Question $2,$ and your bank's modified Question $3$ balance sheet to Moodle for credit. If you use Excel, copy everything into a Word document and upload that.

As the board of directors of a commercial bank, it is your job to make sure the bank passes the Federal Reserve's stress test. The goal is to make sure that your bank can avoid catastrophic failure if the economy goes to you$-$know$-$where in a handbasket. Good luck!

Decide whether the following are assets or liabilities and enter them in the appropriate columns in the "Bank balancesheet.xlsx$"$ spreadsheet. Remember that assets must equal the sum of liabilities and the bank's net worth. NOTE: loan interest should only be accounted for once it has been paid. In this question, it has not been paid.

$\backslash$table$[[$Name$,$Value $($thousands$)],[$Deposit: Widows and Orphans Charitable Trust,$100],[$Deposit: Customers $1-99,270],[$Deposit: Customers $100-199,280],[$Deposit: Bayou Speculators' Assoc.,$50],[$Deposit: Customers $200-299,300],[$Cash Reserves,$150],[$Loan AAA,$500],[$Loan ABB,$90],[$Loan IDK,$260],[$U$.$S$.$ Treasury Bonds,$170],[$AAA loan interest $($not paid until question $4),10],[$ABB loan interest $($not paid until question $4),30],[$IDK loan interest $($not paid until question $4),50]]$

Remember, if you get nervous about the economy, you can affect your balance sheet by trading U$.$S$.$ Treasury Bonds for reserve cash $($in case customers want to make a withdrawal$),$ and you can sell outstanding loans if you're afraid someone will be unable to repay them.