Problem 20-2 (LG 20-1) Consider the following balance sheet for WatchoverU Savings Incorporated ($ in millions): Assets Floating-rate mortgages (currently 11% annually) 30-year fixed-rate loans (currently 8% annually). $ 51 51 Liabilities NOW accounts (currently 7% annually) Time deposits (currently 7% annually) Equity $ 71 21 10 Total $ 102 $ 102 a. What is WatchoverU's expected net interest income at year-end? b. What will be the net interest income at year-end if interest rates rise by 1 percent? (For all requirements, do not round intermediate calculations. Enter your answers in millions rounded to 2 decimal places. (e.g., 32.16)) a. Net interest income million b. Net interest income million

Consider the following balance sheet for Watchover Savings Incorporated (in millions): Assets Floating-rate mortgages (currently 10% per annum) 30-year fixed-rate loans (currently 7% per annum) Total Liabilities and Equity $ 60 Now deposits (currently 6% per annum) 90 5-year time deposits (currently 6% per annum) Equity $ 150 Total a. What is Watchover's expected net interest income at year-end? (Enter your answer in millions rounded to 1 decimal place. (e.g., 32.1)) b. What will be the net interest income at year-end if interest rates rise by 2 percent? (Enter your answer in millions rounded to 1 decimal place. (e.g., 32.1)) $ 105 25 20 $ 150 c. Using the one-year cumulative repricing gap model, what is the change in the expected net interest income for a 2 percent increase in interest rates? (Negative amount should be indicated by a minus sign. Enter your answer in millions rounded to 1 decimal place. (e.g., 32.1)) a. Net interest income b. Net interest income million million c.…

Consider the following balance sheet for Watchover Savings Incorporated (in millions): Assets Floating-rate mortgages (currently 10% per annum) 30-year fixed-rate loans (currently 7% per annum) Total Liabilities and Equity $ 60 Now deposits (currently 6% per annum) 90 5-year time deposits (currently 6% per annum) Equity $ 150 Total a. What is Watchover's expected net interest income at year-end? (Enter your answer in millions rounded to 1 decimal place. (e.g., 32.1)) b. What will be the net interest income at year-end if interest rates rise by 2 percent? (Enter your answer in millions rounded to 1 decimal place. (e.g., 32.1)) $ 105 25 20 $ 150 c. Using the one-year cumulative repricing gap model, what is the change in the expected net interest income for a 2 percent increase in interest rates? (Negative amount should be indicated by a minus sign. Enter your answer in millions rounded to 1 decimal place. (e.g., 32.1)) Answer is complete but not entirely correct. a. Net interest income $…

Show steps to calculation in excel

18 .Use the following amortization chart: Selling price of home Down payment Principal (loan) Rate of interest Years Payment per $1,000 Monthly mortgage payment $ 90,000 $ 5,000 $ 85,000 5  1/2% 30 $ 5.67789 $ 482.62 What is the total cost of interest? Note: Do not round intermediate calculations. Round your answer to the nearest cent. Total cost of interest:???

Part a. Loan payments you borrow $100,000 over a period of 30 years at a fixed APR of 5.5% calculate the monthly payment Part b. Determine the total amount paid, then figure out what percentage is paid towards the principal and what percentage is paid for interest. Please solve part A and B they go together. I included an example problem

[Table 1] Consider the following balance sheet for MMC Bancorp (in millions of dollars): Assets 1. Cash and due from 2. Short-term consumer loans (1-year maturity) 3. Long-term consumer loans (2-year maturity) 4. Three-month T-bills 5. Six-month T-notes 6. 3-year T-bonds 7. 10-year, fixed-rate mortgages S. 30-year, floating rate mortgages (reset every nie months) 9. Premises Total Assets $6.25 62.50 31.30 37.50 43.70 75.00 25.00 50.00 6.25 $337.50 Liabilities and Equity 1. Equity capital (fixed) 2. Demand deposits 3. One-month CDs 4. Three-month CDs 5. Three-month bankers' acceptances 6. Six-month commercial paper 7. 1-year time deposits 8. 2-year time deposits Total Liabilities and Equity $25.00 50.00 37.50 50.00 25.00 75.00 25.00 50.00 $337.50

4. Consider the following financing information for a loan of $103,000: Item Value Loan amount $103,000 2 years Loan length Contractual interest rate 8% Origination fee Payment type 4.3% Quarterly payments, equally amortized Find the actuarial interest te, the annual percentage interest rate, and the effective interest rate.

Question 1: Part A.  The current 10 year treasury note is approaching the important threshold of: a) 2.75% b) 2.95% c) 3.25% d) 2.0%   Part B.  In a real estate investment, you may want to obtain a mortgage. In so doing, which year would you expect to see the highest amount of principal pay-down (in a payment mix of principal and interest)? a) year 15 b) year 20 c) year 10 d) year 25Part C.  In a Fast Market, you would rather sell a stock using a: a) Market Order b) Market On Close Order c) Limit Order d) Market On Open OrderPart D. Given that equity markets are asymmetric in their respective moves, markets are said to take________________________  a) the slow grind higher into perpetuity b) the stairs down and the elevator up c) the stairs up and your mom home d) the stairs up and the elevator down     Part E. It is said that traders have come to employ the use of technical analysis potentially for all of the following reasons except:…

26. Complete the following amortization chart by using Table 15.1.  Note: Round your "Payment per $1,000" answer to 5 decimal places and other answers to the nearest cent. Selling price of home down payment principal (loan) rate of interest Years payment per $1,000 Monthly mortgage payment $189,000 $40,000   7.5% 40     TABLE 15.1 Amortization table (mortgage principal and interest per $1,000) Rate Interest Only 10 Year 15 Year 20 Year 25 Year 30 Year 40 Year 2.000 0.16667 9.20135 6.43509 5.05883 4.23854 3.69619 3.02826 2.125 0.17708 9.25743 6.49281 5.11825 4.29966 3.75902 3.09444 2.250 0.18750 9.31374 6.55085 5.17808 4.36131 3.82246 3.16142 2.375 0.19792 9.37026 6.60921 5.23834 4.42348 3.88653 3.22921 2.500 0.20833 9.42699 6.66789 5.29903 4.48617 3.95121 3.29778 2.625 0.21875 9.48394 6.72689 5.36014 4.54938 4.01651 3.36714 2.750 0.22917 9.54110 6.78622 5.42166 4.61311 4.08241 3.43728 2.875 0.23958 9.59848 6.84586 5.48361 4.67735 4.14892 3.50818 3.000…