Please Respond to the following FIN 100 EXCEL SPREADSHEET Week 2
Please Respond to the following FIN 100 EXCEL SPREADSHEET Week 2
I NEED THIS ON EXCEL SPREADSHEET SIR THANK YOU THE NUMBER: THE SHEET HOME WORK WEEK 2
Chapter 4 Exercise 2
2. As the head of a thrift bank you will only have so much money on hand. It is very important to make sure that it is possible to have access to the funds that you need. When something like interest rates being low happens, it is important to make sure that there is a process of allowing supply to be there. What that means is that when there is a demand for money sometimes there is a need to make sure that the supply is available to be able to keep up with the demand. What that means is that there needs to be a borrowing from a central bank. It would be the necessary to make sure that there was going to be the help of a central bank to meet the needs. That means that the owner of the bank would need to reach out to ensure that there was going to be enough money.
Chapter 5 P1, P6
Balance Sheet
Assets
Initial Deposit 1,000,0001/9/17
Cash (1,000,000*.20=200,000)200,000 Cash
Accounts Receivable (AR)
Total Assets
Liabilities
Accounts Payable (AP)
Debt
Total Liabilities
Shareholder’s Equity
Common Stock and Additional Paid in Capital (APIC)
Total Shareholders’ Equity
To calculate the initial amount of cash it is important to figure 20% of 1000,000=1000,000*.2=200,000
P6. Assume a financial system has a monetary base of $25 million. The required reserves ratio is 1- percent, and there are no leakages in the system.
a.What is the size of the money multiplier? 1/2,500,000=.0000004
b.What will be in the system’s money supply? 25,000,000*.10=2,500,000 is the supply
References
Adrian, Tobias, and Hyun Song Shin. “Financial intermediary balance sheet management.” A Flow-of-Funds Perspective on the Financial Crisis. Palgrave Macmillan UK, 2014. 177-202.
Breuer, Peter. “Measuring off-balance-sheet leverage.” Journal of banking & finance 26.2 (2002): 223-242.