Brayden.Applegate-InterestRates-Excel-ICP-6b

The Ruffins are negotiating with two banks for a mortgage to buy a house selling for $145,000. The terms at bank A are a 25% down payment, an interest rate of 10%, a 30-year conventional mortgage, and 3 points to be paid at the time of closing. The terms at bank B are a 15% down payment, an interest rate of 11.0%, a 25-year conventional mortgage, and no points. Which loan should the Ruffins select in order for the total cost of the house to be less? Click the icon to view the table of monthly payments. From which bank should the Ruffins take the loan? Bank B O Bank A

✅✅✅✅✅✅✅✅

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:…

CD interest rates vary. In 1981, the average rate was 16.7%. In 2000, it was 8.1% and in 2009, it was 2%.  Find the interest earned by a $1000 two-year cd with interest compounded quarterly in: A. 1981 B. 2000 C. 2009

Stephen has just purchased a home for $136,000. A mortgage company has approved his loan application for a 30-year fixed-rate loan at 5.00%. Stephen has agreed to pay 30% of the purchase price as a down payment. Find the down payment, amount of mortgage, and monthly payment. Click the icon to view the table of the monthly payment of principal and interest per $1,000 of the amount financed. (Round to the nearest cent as needed.) (Round to the nearest cent as needed.) The down payment is about S The mortgage amount is about $ The monthly mortgage payment is about S CODE (Round to the nearest cent as needed.)

Assuming a 14% interest rate, which of the following is closest to the total present value of the following payments? Year 3 $12,000 Year 5 $10,000 Present Value of $1 Periods 14% 1 0.877 2 0.769 3 0.675 4 0.592 5 0.519 0.456 0.400 6 7 8 9 0.351 0.308 10 0,270 $12.978 $13,290 $8,100 O $32,054 Present Value of Annuity Periods 14% 0.877 2 1.647 3 2.322 4 2.914 3.433 3.889 4.288 1 5 6 7 8 9 10 4.639 4.946 5.216

Solve the problem. Monthly Payment per $1000 of Mortgage Interest 15-year rate loan 9.5% $10.45 10.0% 10.5% 11.0% 11.5% 12.0% 12.5% 13.0% Monthly Payment 25-year loan $8.73 $9.09 $9.45 20-year loan $9.33 $10.75 $9.66 $11.06 $9.99 $11.37 $10.33 $11.69 $10.66 $12.01 $11.01 $12.33 $12.66 $11.36 $11.72 $9.81 $10.16 $10.53 $10.90 $11.28 30-year loan $8.41 $8.78 $9.15 $9.531 $9.90 $10.29 $10.67 $11.06 Eugene Merzbacher obtains a 20-year, $102,550 mortgage at 11% on a house selling for $123,000. His monthly payment, including principal and interest, is $1058.32. How much of the first payment on the mortgage is applied to the principal?

Determine the monthly principal and interest payment for a 20-year mortgage when the amount financed is $285,000 and the annual percentage rate (APR) is 4.0%. The monthly principal and interest payment is (Round to the nearest cent as needed.).

What is the annual percentage rate on a loan with a stated rate of 2 percent per quarter? A. 2.00 percent B. 2.71 percent C. 4.04 percent D. 8.00 percent E. 8.24 percent

Home detail- $499,900

9.) Find the first month of the amortization schedule for a fixed-rate mortgage if the loan amount is $300,000 with an interest rate of 6.0% on a 20-year loan. Annual rate, r (b) Interest payment: 5 (d) Balance of principal 10 2.0% $17.52776 $9.20135 2.5% $ 17.74736 $9.42699 3.0% $17.96869 $ 9.65607 3.5% $ 18.19174 $ 9.88859 4.0% $18.41652 $10.12451 4.5% $18.64302 $10.36384 5.0% $18.87123 $10.60655 5.5% $ 19.10116 $10.85263 6.0% $19.33280 $11.10205 6.5% $19.56615 $11.35480 7.0% $19.80120 $11.61085 7.5% $ 20.03795 $11.87018 8.0% $ 20.27639 $12.13276 8.5% $ 20.51653 $12.39857 9.0% $ 20.75836 $12.66758 $10.14267 (a) Total payment: (use the table above or the payment formula) Terms of Mortgage (in years), t 15 20 $ 6.43509 $ 6.66789 $ 6.90582 $7.14883 $ 7.39688 $ 7.64993 $ 7.90794 $ 8.17083 $ 8.43857 $ 8.71107 $ 8.98828 $ 9.27012 $ 9.55652 $ 9.84740 $ 5.05883 $5.29903 $ 5.54598 $ 5.79960 $ 6.05980 $ 6.32649 $ 6.59956 $ 6.87887 $ 7.16431 $ 7.45573 $ 7.75299 $ 8.05593 $ 8.36440 $ 8.67823 $…

Amount of mortgage Annual interest rate Years in mortgage Monthly payment ​$405,643 5.00​% 35 ​$2047.23       Month Monthly payment Interest Principal ​End-of-month principal 1 ​$2047.23 ​     2 ​$2047.23

Find the mortgage balance after the first three payments on a 3030-year $170,000$⁢170,000 mortgage that was financed at an APR of 4.25%4.25% and has a monthly payment of $836.30$⁢836.30.  Payment Number Interest Payment Principal Payment Mortgage Balance 11 $602.08$⁢602.08 $234.22$⁢234.22 Balance 1 22 $601.25$⁢601.25 $235.05$⁢235.05 Balance 2 33 $600.42$⁢600.42 $235.88$⁢235.88 Balance 3

Rate of interest 5 1/2 equals 5.67789 of 30 years

At a annual effective rate of interest i, payment of $100 from now,$200 two years from now and $100 four years from now have a total present value of $300. Calculate i A.11.7% B.13% C.14.5% D.15.8% E.16.9%

(16) Here is a table for the present value of $1 at compound interest. Year 6% 10% 12% 1 0.943 0.909 0.893 2 0.890 0.826 0.797 3 0.840 0.751 0.712 4 0.792 0.683 0.636 5 0.747 0.621 0.567 Here is a table for the present value of an annuity of $1 at compound interest. Year 6% 10% 12% 1 0.943 0.909 0.893 2 1.833 1.736 1.690 3 2.673 2.487 2.402 4 3.465 3.170 3.037 5 4.212 3.791 3.605 Using the provided present value tables, what would be the present value of $11,000 to be received 4 years from today, assuming an earnings rate of 10%?

Determine the monthly principal and interest payment for a 20​-year mortgage when the amount financed is ​$255,000 and the annual percentage rate​ (APR) is 5.0​%. Click here for table of Monthly Payments LOADING... The monthly principal and interest payment is ​$ Number of Years Rate​ % 10 15 20 25 30 4.0 ​$10.12451 ​$7.39688 ​$6.05980 ​$5.27837 ​$4.77415 4.5 ​$10.36384 ​$7.64993 ​$6.32649 ​$5.55832 ​$5.06685 5.0 ​$10.60555 ​$7.90794 ​$6.59956 ​$5.84590 ​$5.36822 5.5 ​$10.85263 ​$8.17083 ​$6.87887 ​$6.14087 ​$5.67789 6.0 ​$11.10205 ​$8.43857 ​$7.16431 ​$6.44301 ​$5.99551 6.5 ​$11.35480 ​$8.71107 ​$7.45573 ​$6.75207 ​$6.32068 7.0 ​$11.61085 ​$8.98828 ​$7.75299 ​$7.06779 ​$6.65302 7.5 ​$11.87018 ​$9.27012 ​$8.05593 ​$7.38991 ​$6.99215 8.0 ​$12.13276 ​$9.55652 ​$8.36440 ​$7.71816 ​$7.33765 8.5 ​$12.39857 ​$9.84740…

.

Problem 4. Consider the following balance sheet for Watchover Savings Incorporated (in millions): Assets Liabilities and Equity Floating-rate mortgages (currently 12% per annum) Now deposits (currently 8% per $ 82 annum) $ 116 30-year fixed-rate loans (currently 9% per annum) 5-year time deposits (currently 8% per 101 annum) 29 Equity 38 $ 183 Total $ 183 Total a. What is Watchover's expected net interest income at year-end? b. What will be the net interest income at year-end if interest rates rise by 3 percent? c. Using the one-year cumulative repricing gap model, what is the change in the expected net interest income for a 3 percent increase in interest rates?

Based on Exhibit 7-7, what would be the monthly mortgage payments for each of the following situations? (Round your answers to 2 decimal places.) a. A $161,000, 15-year loan at 5.5 percent. b. A $216,000, 30-year loan at 6 percent. c. A $192,000, 20-year loan at 5.5 percent.

Ef 253.

Which of the following has the most effective annual rate of interest? A. 12.50 % compounded annually B. 11.95% compounded quarterly C. 12.15% compounded semi-annually D. 11.88% compounded monthly

Find the future value. (Use the Table 12.1.) (Do not round intermediate calculations. Round the "FV factor" to 4 decimal places and final answer to the nearest cent.) $ Present value 11,129.37 Length of time 5 years Rate 12% Compounded Quarterly On FV Table 12.1 Period used 20 Rate used 3% FV factor used Future value

You choose to invest your $3,110 income tax refund check (rather than spend it!) in an account earning 5% compounded annually. How much will the account be worth in 30 years? (Use the Table provided.) (Round your answer to the nearest cent.) Worth OVi 5: acer

Table 9.2 Average Returns for Bonds       Long-TermTreasury Bonds 1950 to 1959 Average   0.0 % 1960 to 1969 Average   1.6   1970 to 1979 Average   5.7   1980 to 1989 Average   13.5   1990 to 1999 Average   9.5   2000 to 2009 Average   8.0     Table 9.4 Annual Standard Deviation for Bonds     Long-TermTreasury Bonds 1950 to 1959   4.9 % 1960 to 1969   6.2   1970 to 1979   6.8   1980 to 1989   15.1   1990 to 1999   12.8   2000 to 2009   10.3         Use the tables above to calculate the coefficient of variation of the risk-return relationship of the bond market during each decade since the 1950s. (Round your answers to 2 decimal places.)       I used copy and paste to subit this question. I have no idea how to begin to solve this problem. Please help!

What is the interest rate on a loan of $52,000 for 54 days that yields $780.00 interest? Group of answer choices 110% 0.3% 0.1%10%

1 year 0.38% Source: U.S. Department of the Treasury. Date 03/05/2010 2 year 0.9% 3 year 1.47% Assuming that the liquidity premium theory is correct, on March 5, 2010, what did investors expect the interest rate to be on the one-year Treasury bill two years from that date if the term premium on a two-year Treasury note was 0.01% and the term premium on a three-year Treasury note was 0.05%? The expected interest rate is%. (Round your response to two decimal places.)

Conchita has made a $210,400 loan for a home. Her 22-year fixed-rate loan has an interest rate of 6.00%. Create an amortization schedule for the first two payments. E Click the icon to view the table to find the monthly payment of principal and interest per $1,000 of the amount financed. Complete the table for the first month below. Monthly End-of-month Month payment Interest Principal principal 1 (Round to the nearest cent as needed.) Complete the table for the second month below. Monthly рayment End-of-month Month Interest Principal principal 2 (Round to the nearest cent as needed.)