Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Blue Sunday Bank has a portfolio of loans and securities, as well as deposits and money market borrowings, which are expected to produce the following

Blue Sunday Bank has a portfolio of loans and securities, as well as deposits and money market borrowings, which are expected to produce the following cash inflows and outflows for the bank in the coming 5 years. Explain the danger of the banks position. What kind of hedging should the bank use to reduce its risk and what's the expected effect?

Duration of Total Cash Inflows
Expected Cash Flow Cash Flow Timeline Current Year Present Value (4.5%) Present Value Weight Duration
1900000 1 Year 1 0.956937799 1818181.818 0.63258399 0.63258399
750000 2 Years 2 0.915729951 686797.4634 0.238951394 0.477902788
350000 3 Years 3 0.876296604 306703.8114 0.106708756 0.320126269
65000 4 Years 4 0.838561344 54506.48733 0.018963962 0.075855849
10000 5 Years 5 0.802451047 8024.510465 0.002791897 0.013959486
2874214.091 1.520428382
Duration is 1.520428 Years
Duration of Total Cash Outflows
Expected Cash Flow Cash Flow Timeline Current Year Present Value (4.5%) Present Value Weight Duration
-1400000 1 Year 1 0.956937799 -1339712.919 0.531606644 0.531606644
-830000 2 Years 2 0.915729951 -760055.8595 0.30159502 0.60319004
-400000 3 Years 3 0.876296604 -350518.6416 0.139088036 0.417264108
-45000 4 Years 4 0.838561344 -37735.26046 0.014973592 0.05989437
-40000 5 Years 5 0.802451047 -32098.04186 0.012736708 0.06368354
-2520120.722 1.675638701
Duration is 1.675639 Years

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions

Question

What is the formula to calculate the mth Fibonacci number?

Answered: 1 week ago