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