Part 1 is shown, i just need part 2 and the rest, please help me this is my final assignment for this course!

1. As an intern with the Bank of Milan, Tennessee, you have observed that this bank makes two types of loans, agriculture loans and consumer loans, and offers two types of deposits, demand deposits and time deposits. You have determined that your bank is not an asset management bank but is a liability management bank, where core deposits plus capital are less than demand for loans. Thus, your bank needs to acquire money market funds in the Eurodollar or Federal Funds markets at a cost of 3.15 percent. If your bank were an asset management bank, you would invest your excess funds in treasury securities that yield an annual rate of 3.00 percent. Your bank has $2,000 in capital. Using the Economics of Banking Handouts for this class. Part 1 of this problem, already worked for you, shows that, using Demand/Supply functions to formulate this bank's pro-forma Balance Sheet, that this bank cannot operate as an Asset Management Bank. As an Asset Management Bank, you find that the demand for loans is greater than the supply of fund just from deposits and capital. Part 2 of this problem, since you find that your bank is a liability management bank and must acquire money market deposits, show what the pro-forma balance sheet and income statements will look like, assuming that rates, you determine are constant for all of 2022. Part 1, Assuming an Asset Management Bank Demand function for agriculture loans (LA) TA = 13.00%-0005LA TR, -rL-13L-.00052 DTR 13.00-0014, = 3.00 dL LA-S10,000rA- _8.0% Demand for function for consumer loans (L) Te =9,00% - 0002LC TRe src =9,00L - 0002 TR 9.00-.0004L = 3.00 dlc L-$15,000_C_6.00% Supply function for demand deposits (D) ID 4.00%+.0004375D TC) = -D, = -4.00D, +.0004375D, DTC =-4.00 +.000875D = 3.00% dL Do=$8,000 D= -0.50% Supply function for time deposits (D) IT=0.00+ 00015D- TC =rD, = 0.00D, +.00015D, ATC = 0.00 +0003D. = 3.00 dl, D = $10.000 = 1.50% 2 Using the economics of banking theory covered in class, we show how the pro-forma balance sheet for the Bank of Milan, Tennessee would appear assuming an asset management bank, where, at the margin, you assume that you would invest excess funds in US Treasury Bills at a return of 3 percent. You will show that you have a problem that demand for assets (Loans) are greater than supply of deposits plus capital Bank of Milan, Tennessee Statement of Financial Conditions (pro forma) January 1, 2022 Assuming an Asset Management Bank U.S. Treasury Securities $0 Demand Deposits $8.000.00 Agriculture Loans $10.000.00 Time Deposits $10,000.00 Consumer Loans $15,000.00 Capital 2.000.00 Total Assets $25,000.00 Total Liab & NW $20,000.00 Therefore, since Total Assets are greater than Total Llabilities plus Capital, you need to start over assuming a liability management bank. Determine the new equilibrium balance sheet and proforma income statement, assuming that you will acquire money market funds that have a cost/return of 3.15% Part 2, Assuming a Liability Management Bank Demand function for agriculture loans (LA) TA - 13.00% - 0005LA TR, =rl. =13L-00051 TR = 13.00 - 001L=3.15% dL Las - TA % % Demand for function for consumer loans (L) Ic = 9.00% -.0002LC TR = CLc =9.00L -.0002L. DTR 9.00-.0004Le = 3.15% dle Les rc Supply function for demand deposits (D)) ID -4.00% +.0004375DD TC=rD, = -4,00D, +.0004375D = -4.00 +.000875D, =3.15% dL Dors Supply function for time deposits (Dr) IT=0.00+.00015D TC, =rD, =0.00D, +.00015D, DTC 0.00+.0003D, = 3.15% dl, =$ dTC, rp % 2 Bank of Milan, Tennessee Statement of Financial Conditions (pro forma) January 1, 2021 Assuming an Liability Management Bank U.S. Treasury Securities $0 Demand Deposits Agriculture Loans Time Deposits $ EuroDollars S Consumer Loans Capital 2.000.00 Total Assets Total Liab & NWS Bank of Milan, Tennessee Income Statement (pro forma) January 1, 2022 - December 31, 2022 Assume all rates and balances remain constant for the next year Revenues Interest on Treasury Securities $0 Interest on Agriculture Loans $ Interest on Consumer Loans $ Total Interest Revenue s Interest Expense Interest on Demand Deposits $ Interest on Time Deposits Interest on EuroDollars S Total Interest Expenses Net Interest Revenue $ 1. As an intern with the Bank of Milan, Tennessee, you have observed that this bank makes two types of loans, agriculture loans and consumer loans, and offers two types of deposits, demand deposits and time deposits. You have determined that your bank is not an asset management bank but is a liability management bank, where core deposits plus capital are less than demand for loans. Thus, your bank needs to acquire money market funds in the Eurodollar or Federal Funds markets at a cost of 3.15 percent. If your bank were an asset management bank, you would invest your excess funds in treasury securities that yield an annual rate of 3.00 percent. Your bank has $2,000 in capital. Using the Economics of Banking Handouts for this class. Part 1 of this problem, already worked for you, shows that, using Demand/Supply functions to formulate this bank's pro-forma Balance Sheet, that this bank cannot operate as an Asset Management Bank. As an Asset Management Bank, you find that the demand for loans is greater than the supply of fund just from deposits and capital. Part 2 of this problem, since you find that your bank is a liability management bank and must acquire money market deposits, show what the pro-forma balance sheet and income statements will look like, assuming that rates, you determine are constant for all of 2022. Part 1, Assuming an Asset Management Bank Demand function for agriculture loans (LA) TA = 13.00%-0005LA TR, -rL-13L-.00052 DTR 13.00-0014, = 3.00 dL LA-S10,000rA- _8.0% Demand for function for consumer loans (L) Te =9,00% - 0002LC TRe src =9,00L - 0002 TR 9.00-.0004L = 3.00 dlc L-$15,000_C_6.00% Supply function for demand deposits (D) ID 4.00%+.0004375D TC) = -D, = -4.00D, +.0004375D, DTC =-4.00 +.000875D = 3.00% dL Do=$8,000 D= -0.50% Supply function for time deposits (D) IT=0.00+ 00015D- TC =rD, = 0.00D, +.00015D, ATC = 0.00 +0003D. = 3.00 dl, D = $10.000 = 1.50% 2 Using the economics of banking theory covered in class, we show how the pro-forma balance sheet for the Bank of Milan, Tennessee would appear assuming an asset management bank, where, at the margin, you assume that you would invest excess funds in US Treasury Bills at a return of 3 percent. You will show that you have a problem that demand for assets (Loans) are greater than supply of deposits plus capital Bank of Milan, Tennessee Statement of Financial Conditions (pro forma) January 1, 2022 Assuming an Asset Management Bank U.S. Treasury Securities $0 Demand Deposits $8.000.00 Agriculture Loans $10.000.00 Time Deposits $10,000.00 Consumer Loans $15,000.00 Capital 2.000.00 Total Assets $25,000.00 Total Liab & NW $20,000.00 Therefore, since Total Assets are greater than Total Llabilities plus Capital, you need to start over assuming a liability management bank. Determine the new equilibrium balance sheet and proforma income statement, assuming that you will acquire money market funds that have a cost/return of 3.15% Part 2, Assuming a Liability Management Bank Demand function for agriculture loans (LA) TA - 13.00% - 0005LA TR, =rl. =13L-00051 TR = 13.00 - 001L=3.15% dL Las - TA % % Demand for function for consumer loans (L) Ic = 9.00% -.0002LC TR = CLc =9.00L -.0002L. DTR 9.00-.0004Le = 3.15% dle Les rc Supply function for demand deposits (D)) ID -4.00% +.0004375DD TC=rD, = -4,00D, +.0004375D = -4.00 +.000875D, =3.15% dL Dors Supply function for time deposits (Dr) IT=0.00+.00015D TC, =rD, =0.00D, +.00015D, DTC 0.00+.0003D, = 3.15% dl, =$ dTC, rp % 2 Bank of Milan, Tennessee Statement of Financial Conditions (pro forma) January 1, 2021 Assuming an Liability Management Bank U.S. Treasury Securities $0 Demand Deposits Agriculture Loans Time Deposits $ EuroDollars S Consumer Loans Capital 2.000.00 Total Assets Total Liab & NWS Bank of Milan, Tennessee Income Statement (pro forma) January 1, 2022 - December 31, 2022 Assume all rates and balances remain constant for the next year Revenues Interest on Treasury Securities $0 Interest on Agriculture Loans $ Interest on Consumer Loans $ Total Interest Revenue s Interest Expense Interest on Demand Deposits $ Interest on Time Deposits Interest on EuroDollars S Total Interest Expenses Net Interest Revenue $