AS you see you only need to answer 2 litle question by the end and show how i can do by calculation and Excel.

Suppose that National Bank of Guerneville has $30 million in checkable deposits, Commonwealth Bank has $46 million in checkable deposits, and the required reserve ratio for checkable deposits is 10%. If National Bank of Guerneville has $4 million in reserves and Commonwealth has $5 million in reserves, how much in excess reserves does each bank have? (Enter your answers rounded to one decimal place.)

The National Bank of Guerneville is required to hold 10% of its checkable deposits as reserves. Thus, its required reserves on $30 million in checkable deposits is $3 Million.(30*10% = 3)

So, the National Bank of Guerneville has in excess reserves the difference between its total reserves and its required reserves, which equals is $1 Million.($4 M. -$3 M. = $1 M.)

Commonwealth Bank is likewise required to hold 10% of its checkable deposits as reserves. So, its required reserver on

$46 million in checkable deposits is $ 4.6 Million. (46*10% =4.6)

Given both its required and total reserves, Commonwealth Bank has excess reserves equal to $0.4 Million.

($5 M. - $4.6 M. = $ 0.4 M.)

Now suppose that a customer of National Bank of Guerneville writes a check for $ 2 million to a real estate broker who deposits the check at Commonwealth. After the check clears, how much in excess reserves does each bank have?

After the check clears, National Bank of Guerneville has $28 million in checkable deposits and reserves of

$2 million, So, National Bank of Guerneville has in excess reserves $ __Million.

Commonwealth Bank has in Excess reserves $ ___ Million.