ProBanker Exercise 2 (Regional Bank) This assignment will demonstrate the sensitivity of loans and deposits to changes in interest rates (price elasticity of demand) and its impact on discount window...

ProBanker Exercise 2 (Regional Bank)

This assignment will demonstrate the sensitivity of loans and deposits to changes in interest rates (price elasticity of demand) and its impact on discount window advances. The basic bank in ProBanker has the following features.

1. 
   

   Demand for loans will increase if interest rates are reduced (some customers will remain loyal, but others will take the opportunity of the lower rates).

   
   


2. 
   

   Supply of deposits will increase if interest rates are increased (some customers will remain loyal, but others will take the opportunity of the higher rates).

   
   


3. 
   

   If loan demand exceeds available funds (from deposits, CDs and equity), the program will force banks to borrow from the central bank through the discount window advances at a penalty rate.

   
   


4. 
   

   Federal funds are short term loans between banks. Participants can borrow federal funds as non-depository source of funds. If there are excess funds at the end of the quarter, ProBanker will sell them to other banks as federal funds sold.

   
   

Please note that in Autosim you are playing solo against the computer. The outcomes will be different in a competitive game because demand and supply are affected by the decisions of your competitors.

Assignment 2:

1. 
   

   Create a personal Autosim.
   
   
   

   
   




1. 
   

   Click on Games.

   
   


2. 
   

   Click on New Autosim game.

   
   


3. 
   

   Select Assignments Regional Bank template in using template.
   
   Note: Make sure NOT to choose Sample Regional Bank template.

   
   


4. 
   

   Type a name for the new Autosim in New game’s name

   
   


5. 
   

   Example “John Roger’s Assignment 2”

   
   


6. 
   

   Click on Create Game

   
   


7. 
   

   You can create as many Autosims as you wish.

   
   

2. 
   

   Input decisions to your new Autosim. There are five categories of decisions – Bank Treasury, Asset-other, Asset-loans, Liabilities-deposits, Bank-general.

   
   

We will reduce interest rates of all our loans by 0.3% to increase the demand for loans. To fund this expected increase in loan demand, we will increase the interest rates offered on all our deposits by 1%. We then simulate the game and observe the changes from quarter 0 to quarter 1.

Click on Autosim Games (on left, in blue) or Games on top (in red)

1. 
   

   Select your newly created Autosim.

   
   


2. 
   

   Click on Play bank.

   
   


3. 
   

   Input and update Decisions.

   
   


4. 
   

   Remember to click Save before you go to the next set of inputs.

   
   

1. 
   

   Bank Treasury – change the following:

   
   

1. 
   

   Federal Funds Purchased (not Sold)= $50,000.

   
   


2. 
   

   360 Days CDs to Issue= $50,000.

   
   


3. 
   

   The remaining boxes should all be zeroes.
   
   

   
   

2. 
   

   Asset-other – change the following:

   
   

4. 
   

   Planned required reserves= $25,000.

   
   


5. 
   

   New Bonds to Purchase= $15,000.

   
   


6. 
   

   New provision for loan losses = $500.

   
   

3. 
   

   Asset-loans – change the following: reduce all loan rates by 0.3%.

   
   




1. 
   

   Fixed-rate loans: Reduce loan rate to 9 and keep corporate standards as normal (0).

   
   


2. 
   

   Floating-rate loans: Reduce loan spread to 3.7 and keep corporate standards as normal (0).

   
   


3. 
   

   Installment Loans: Reduce loan rate to 10.7 and keep advertising at 150.

   
   


4. 
   

   Mortgage loans: Reduce loan rate to 8.7 and keep advertising at 80.

   
   

4. 
   

   Liabilities-deposits – change the following: Increase all deposit rates by 1%

   
   




1. 
   

   Corporate demand deposit: Keep as is (0,580,100).

   
   


2. 
   

   Retail demand deposit: Keep as is (0,410,100).

   
   


3. 
   

   Retail savings: Increase deposit rate to 6 and keep advertising as 140.

   
   


4. 
   

   Retail CDs: Increase CD rate to 7 and keep advertising at 290.

   
   


5. 
   

   Long-term retail deposits: Increase deposit rate to 8.5 and keep advertising at 60.

   
   

5. 
   

   Bank-general – change the following:

   
   

Keep as is (0, 0)

6. 
   

   Simulate next period (on left side of the screen). After a few seconds, you will notice a flicker and it should say End of Period 1. You are ready to review the results.

   
   

Answer the following questions.

Download the Excel file in Reports to answer the questions. Also consult the student manual available in the Help folder (top right)

1. 
   

   Rates on fixed, floating, installment and mortgage loans were reduced by 0.3 percent (from 9.3% to 9.0% etc.). Which loans, in percent change, were impacted the most and which the least?

   
   

2. 
   

   Rates on savings deposits, retail CDs and long-term retail deposits were increased by 1%. Which deposits, in percent change, were impacted the most and which the least?

   
   

3. 
   

   You put in $25,000 for reserve requirements. Why is the reserve requirement showing a different number? Explain.

   
   

4. 
   

   Explain the numbers under "excess reserves" and "discount window advances."

   
   

5. 
   

   There are no interest rates for retail and corporate demand deposits. What likely factors can explain the change in volume of deposits?

   
   

Assignment 2 (Continued)

7. 
   

   Input decisions for quarter 2 as given below:

   
   

3. 
   

   Bank Treasury – change the following:

   
   

1. 
   

   Federal Funds Purchased (not Sold)= $50,000.

   
   


2. 
   

   360 Days CDs to Issue= $50,000.

   
   


3. 
   

   The remaining boxes should all be zeroes.

   
   

4. 
   

   Asset-other – change the following:

   
   

4. 
   

   Planned required reserves= $25,000

   
   


5. 
   

   New Bonds to Purchase= $15,000

   
   


6. 
   

   New provision for loan losses = $500

   
   

8. 
   

   Asset-loans – Keep interest rates, corporate loan standards and advertising the same.

   
   




1. 
   

   Fixed-rate loans: Keep loan rate at 9 and standards as normal (0).

   
   


2. 
   

   Floating-rate loans: Keep loan spread at 3.7 and standards as normal (0).

   
   


3. 
   

   Installment Loans: Keep loan rate at 10.7 and advertising at 150.

   
   


4. 
   

   Mortgage loans: Keep loan rate at 8.7 and advertising at 80.

   
   

9. 
   

   Liabilities-deposits – change the following: Increase all deposits (except demand deposits) rates by an additional 1%

   
   




1. 
   

   Corporate demand deposit, keep as is (0,580,100).

   
   


2. 
   

   Retail demand deposit, keep as is (0,410,100).

   
   


3. 
   

   Retail savings: Increase deposit rate to 7 and keep advertising as 140.

   
   


4. 
   

   Retail CDs: Increase CD rate to 8 and keep advertising at 290.

   
   


5. 
   

   Long-term retail deposits: Increase deposit rate to 9.5 and keep advertising at 60.

   
   

10. 
    

    Bank-general – change the following:

    
    

Keep as is (0, 0)

11. 
    

    Simulate next period (on left side of the screen). After a few seconds, you will notice a flicker and it should say End of Period 2.

    
    

Answer the following questions.

1. 
   

   Rates on fixed, floating, installment and mortgage loans remained the same. Which loans, in percent, were impacted the most and which the least?

   
   

2. 
   

   Rates on retail savings deposits, retail CDs and long-term retail deposits were increased by 1%. Which deposits, in percent, were impacted the most and which the least?

   
   

3. 
   

   Explain the numbers under “Reserve requirements,” "Excess reserves" and "Discount window advances."