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.