Changes in Monetary Policy Assignment for Macro-Economics

Prepare a 2-3 page analysis by answering the questions below. Be sure to cite your references using APA format.

Assume that the Bank of Ecoville has the following balance sheet and the Fed has a 10% reserve requirement in place:

Required:

Now assume that the Fed lowers the reserve requirement to 8%.

1. What is the maximum amount of new loans that this bank can make?
2. Assume that the bank makes these loans. What will the new balance sheet look like?
3. By how much has the money supply increased or decreased?
4. If the money multiplier is 5, how much money will ultimately be created by this event?
5. If the Fed wanted to implement a contractionary monetary policy using reserve requirement, how would that work?

Deliverables:

Address the questions above, showing your calculations.  Develop your analysis in Microsoft Excel format. Enter non-numerical responses in the same worksheet using textboxes.

ASSIGNMENT TO BE DONE IN EXCEL SHOWING ALL CALCULATIONS AND HOW YOU ARRIVED AT THEM, INCLUDE TEXT BOXES FOR NON-NUMERIC RESPONSES IN THE SAME WORKSHEET. 

REFERENCES MUST BE IN APA AT THE BOTTOM AND IN TEXT IF APPLICABLE.