Your classmates from the University of Chicago are planning to go to Miami for spring break, and you are undecided about whether you should go with them. The round-trip airfare is $600, but you have a frequent-flyer coupon worth $500 that you could use to pay part of the airfare. All other costs for the vacation are exactly $900. The most you would be willing to pay for the trip is $1,400. Your only alternative use for your frequent-flyer coupon is for your trip to Atlanta two weeks after the break to attend your sister's graduation, which your parents are forcing you to attend. The Chicago-Atlanta round-trip airfare is $450. If the Chicago-Atlanta round-trip air fare were $350, should you use the coupon to go to Miami?

Variable rate cd’s = $90 treasury bills = $150 discount loans = $20 treasury notes = $100 fixed rate cds = $160 money market deposit accts. = $140 savings deposits = $90 fed funds borrowing = $40 variable rate mortgage loans $140 demand deposits = $40 primary reserves = $50 fixed rate loans = $210 fed funds lending = $50 equity capital = $120 a. develop a balance sheet from the above data. be sure to divide your balance sheet into rate-sensitive assets and liabilities as we did in class and in the examples. b. perform a standard gap analysis and a duration analysis using the above data if you have a 1.15% decrease in interest rates and an average duration of assets of 5.4 years and an average duration of liabilities of 3.8 years. c. indicate if this bank will remain solvent after the valuation changes. if so, indicate the new level of equity capital after the valuation changes. if not, indicate the amount of the shortage in equity capital.