finance – master level

Get perfect grades by consistently using www.college-experts.com. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

Hi this is an assignment about finance/accounting. We calculate Period GAP, Cumulative GAP, GAP ratio, Cumulative GAP-to Earning. This assignment need a tutor who know about bank and understand the balance sheet. I have attached 2 files.

finance – master level
You are expected to use the Excel file Assignment 2_Interest and Liquidity Risk Analysis by performing and reporting the required computations in the spaces provided.  The cells of the different tabs are color-coded to better indicate where the computations must be performed and the results reported.  Yellow cells include input data and questions.  Green cells delineate spaces where the computations must be performed and answers must be provided. Section 1 – Static GAP Analysis (30 points)Perform the computation and answer the questions listed in the tab (Rate Sensitivity Report) by using the reported information. In order to complete the data in the balance sheet, you can make the following assumptions: The balance sheet and rate sensitivity report is based on a forecasted increase in both the prime and federal fund rates over the next two weeks and then constant rates for the foreseeable future. Money market investments include $7.2 million of corporate securities with adjustable rates pegged to the prime rate.  The remaining balance includes fixed rate commercial paper securities maturing in 4 months ($6.3 million) and in 8 months ($15.2 million) Federal funds sold and reverse repos include overnight lending for $8.3 million and the remaining balance of $8 million include lending with evenly distributed maturities from 2 months to 5 months. Real estate installment loans with fixed rates include $180 million in exposure to residential real estate mortgages.  Half of the mortgages are amortized loans with monthly constant principal payments, an average APR of 4.7%, and an average maturity of 10 years.  The other half of the mortgages include fixed payments amortized loans with an average APR of 5.1% and an average maturity of 15 years. The bank borrows $5.2 million in the federal fund market with overnight maturityComplete the balance sheet using for aforementioned assumptions and then for each “time bucket” listed compute the listed measures: Period GAP  Cumulative GAP  GAP ratio  Cumulative GAP-to-Earning Assets ratio

Writerbay.net

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper