PLEASE HELP I ONLY HAVE 1 HOUR

B (1) From the Sources and Uses of Funds Statement in exhibit 1, calculate the estimated changes in loans and deposits from month-to-month, as well as estimated liquidity needs. (i) Given the information in Exhibit 11.2, calculate the bank's ratio of estimated liquidity sources to liquidity needs. Is there a possibility that the bank will have a liquidity problem at some time in the coming months? Exhibit 1 Sources and Uses of Funds Statement Estimated Total Loans Estimated Total Deposits End of Month / June July August September October November December 1 $190,000 180,000 190,000 200,000 210,000 200,000 190,000 $180,000 190,000 210,000 240,000 200,000 180,000 170,000 1 End of Month / June July August September October November December Exhibit 2 Estimated Sources of Liquidity Estimated Estimated Asset Liquidity Sources of Liabilities $3,000 $5,000 4,000 10,000 4,000 5,000 3,000 3,000 2,000 5,000 3,000 10,000 4,000 10,000 B (1) From the Sources and Uses of Funds Statement in exhibit 1, calculate the estimated changes in loans and deposits from month-to-month, as well as estimated liquidity needs. (i) Given the information in Exhibit 11.2, calculate the bank's ratio of estimated liquidity sources to liquidity needs. Is there a possibility that the bank will have a liquidity problem at some time in the coming months? Exhibit 1 Sources and Uses of Funds Statement Estimated Total Loans Estimated Total Deposits End of Month / June July August September October November December 1 $190,000 180,000 190,000 200,000 210,000 200,000 190,000 $180,000 190,000 210,000 240,000 200,000 180,000 170,000 1 End of Month / June July August September October November December Exhibit 2 Estimated Sources of Liquidity Estimated Estimated Asset Liquidity Sources of Liabilities $3,000 $5,000 4,000 10,000 4,000 5,000 3,000 3,000 2,000 5,000 3,000 10,000 4,000 10,000