Question: Using excel spreadsheet: A DI has the following assets in its portfolio: $20 million in cash reserves with the Fed, $20 million in T-bills, and

Using excel spreadsheet:

A DI has the following assets in its portfolio: $20 million in cash reserves with the Fed, $20 million in T-bills, and $50 million in mortgage loans. If it needs to dispose of its assets at short notice, it will receive only 99 percent of the fair market value of the T-bills and 90 percent of the fair market value of its mortgage loans. If the DI waits one month to liquidate these assets, it would receive the full fair market value for each security. Calculate the one-month liquidity index using the previous information.

please show formulas in excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

A Financial Institution has assets of $10,000 invested in a 20-year, 9% annual coupon Treasury bond selling at par. The duration of this bond has been estimated at 8 years. The assets are financed...

Question 1 A Financial Institution has assets of $10,000 invested in a 20-year, 9% annual coupon Treasury bond selling at par. The duration of this bond has been estimated at 8 years. The assets are...

A DI has the following assets in its portfolio: $20 million in cash reserves with the Fed, $20 million in T-bills, and $50 million in mortgage loans. If the assets need to be liquidated at short...

2. A DI has the following assets in its portfolio: $20 million in cash reserves with the Fed, $42 million in T-bills, and $50 million in mortgage loans. If the assets need to be liquidated at short...

A DI has the following assets in its portfolio: $20 million in cash reserves with the Fed, $20 million in T-bills, and $50 million in mortgage loans. If it needs to dispose of its assets at short...

A DI has the following assets in its portfolio: $20 million in cash reserves with the Fed, $45 million in T-bills, $85 million in mortgage loans. If the DI has to liquidate the assets today, it will...

A DI has the following assets in its portfolio: $20 million in cash reserves with the Fed, $20 million in T-bills, and $50 million in mortgage loans. If it needs to dispose of its assets at short...

A Financial Institution has assets of $10,000 invested in a 20-year, 9% annual coupon Treasury bond selling at par. The duration of this bond has been estimated at 8 years. The assets are financed...

The U.S. Government Accountability Office recently indicated the price of college textbooks has been rising an average of 6% annually since the late 1980s. The report estimated that the average cost...

A letter in the December 1995 issue of Dell Champion Variety Puzzles stated: Ive noticed over the last several issues there have been no winners from the South in your contests. You always say that...

Which of the following is NOT a function of finance? a ) Budgeting b ) Auditing c ) Investing d ) Financing

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...