Okay, I'm having some trouble with this question, any help from any of the finance guys on here would be greatly appreciated.
Assume that a bank will institute a micro hedge against a portfolio of three proposed loans financed by a combination of pure discount 2-year and 5-year CDs. The loans are given by the table below.
1-year discount loan...........................$10,000
3-year 10% loan; semi-annual pmts......$25,000
5-year 10% loan; annual pmts..............$50,000
Determine the funding allocation between the 2-year and 5-year CDs.
I'm thinking I need to use this formula:
Where DG is the duration gap, DA is the average duration of the assets, MVL is the market value of liabilities, MVA is the market value of the assets, and DL is the average duration of the liabilities.
For the CDs and the discount loan, the durations equal the maturities. For the 3-year loan I figured the duration to be 2.66 years? And for the 5-year, I figured it to be 4.17 years?
I'm assuming I need to set DG to zero but I don't know how to find the weighted averages for for the assets (loans) or the liabilities (CDs). Is MVA just going to be $10,000? So I'm going to be solving for MVL but once I get a number for it how am I going to divide it up between the two different CDs?
Keep in mind I need to show the calculations for this so anybody trying to help should write out the steps involved. I'm hoping somebody who knows this stuff can fly through it and help me out, it would definitely be appreciated. Thanks guys