computing and interpreting duration of a portfolio

Project Description:

part 1: please compute the duration on a 7-year, 5% annual bond that currently sells for \$1060.02. you should use a spreadsheet for this calculation. please show your equations in the spreadsheet for full points.

part 2: blue sunday bank has a portfolio of loans and securities as well as deposits and money market borrowings that are expected to produce the following cash inflows and outflows for the bank in the coming five years. cash inflows are denoted with a “+” and cash outflows are denoted with a “-“.

expected cash flow (in %bodyamp;rsquo;s)

timing of cash flow

+ 1.9 million

1 year from today

- 1.4 million

1 year from today

+ 750,000

2 years from today

- 830,000

2 years from today

+ 350,000

3 years from today

- 400,000

3 years from today

+ 65,000

4 years from today

- 45,000

4 years from today

+ 10,000

5 years from today

- 40,000

5 years from today

assume the current discount rate that applies to these cash flows is 4.5%. on a spreadsheet, compute the duration of the total cash inflows as well as the duration of total cash outflows and then compute the duration gap of this bank.
what kind of hedging should the bank use to reduce its risk? be specific about the hedging transaction and discuss its expected effect. again, enter this answer in a cell within your spreadsheet.
now assume that the bank has total assets of \$30 billion and total liabilities of \$25 billion and all asset and liability cash flows are proportional to the cash flows given in this problem. how much would the value of the bank change if interest rates rise from 4.5% to 5.0%? what about if interest rates changed from 4.5% to 4.2%? assume that total assets and total liabilities have the same duration profile as the cash flows given in this problem. show your calculations on the spreadsheet.
Skills Required:
Project Stats:

Price Type: Fixed

Project Budget: \$0 to \$10
Completed
Total Proposals: 2
1 Current viewersl
234 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
• 4.9
367 Jobs 233 Reviews
\$20 in 1 Day
• 4.8
39 Jobs 23 Reviews
\$20 in 1 Day