Problem 7-3 (LG 7-4) You plan to purchase an $140,000 house using a 30-year mortgage obtained from your local bank. The mortgage rate offered to you is 4 percent. You will make a down payment of 10 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Calculate the amount of interest and, separately, principal paid in the 230th payment. c. Calculate the amount of interest and, separately, principal paid in the 260th payment. d. Calculate the amount of interest paid over the life of this mortgage. (For all requirements, do not round intermediate calculations. Round your answers to 2 decimal places. (e.g.. 32.16)) a, b. Answer is complete but not entirely correct. Amount Monthly payment Amount of interest Amount of principal 601.54 388.99 212.553

Date Name Section 8.7 - Worksheet The Cost of Home Ownership Comparing Mortgage Interest for 30-year rate vs 15-year rate. In the lesson notes example, the $175,500 mortgage was financed with a 30-year fixed rate at 7.5%. The total interest paid over 30 years was approximately $266,220. a) Use the loan payment formula for installment loans to find the monthly payment if the time of the mortgage is reduced to 15 years. Round to the nearest dollar. b) Find the total interest paid over 15 years. c) How much interest is saved by reducing the mortgage from 30 to 15 years?

son.3

Chapter 7 Self Test Problem #2

13. Mortgage payments Mortgages, loans taken to purchase a property, involve regular payments at fixed intervals and are treated as reverse annuities. Mortgages are the reverse of annuities, because you get a lump-sum amount as a loan in the beginning, and then you make monthly payments to the lender. You've decided to buy a house that is valued at $1 million. You have $100,000 to use as a down payment on the house, and want to take out a mortgage for the remainder of the purchase price. Your bank has approved your $900,000 mortgage, and is offering a standard 30-year mortgage at a 10% fixed nominal interest rate (called the loan's annual percentage rate or APR). Under this loan proposal, your mortgage payment will be per month. (Note: Round the final value of any interest rate used to four decimal places.) Your friends suggest that you take a 15-year mortgage, because a 30-year mortgage is too long and you will pay a lot of money on interest. If your bank approves a 15-year, $900,000…

Problem 6-10 A borrower is making a choice between a mortgage with monthly payments or biweekly payments. The loan will be $200,000 at 6 percent interest for 20 years. Required: a. What would be the maturity period if payments are bi-weekly? How much will the borrower pay in total under each payment option? Which choice would be less costly to the borrower? b. Assume that the bi-weekly loan was available for 575% What would be the maturity period if payments are bi-weekly? How much will the borrower pay in total under each payment option? Which choice would be less costly to the borrower? Complete this question by entering your answers in the tabs below. Required A Required B What would be the maturity period if payments are bi-weekly? How much will the borrower pay in total under each payment option? Which choice would be less costly to the borrower? (Do not round intermediate calculations. Round your final answers to 2 decimal places.) Maturity period Total monthly payments Total…

What interest rate would it take for a 30 year mortgage to buy a $415,000 house with a $2,000 monthly payment? 3. A) 3.636% 4. B) 4.078% 5. C) 4.276% 6. D) 4.897% N= 360

Narrative 14-1For problems in this section, use Table 14-1 from your text to find the monthly mortgage payments, whennecessary.   Refer to Narrative 14-1. You purchase a home for $69,750 at 6.75% for 30 years. The property taxes are $2,450per year, and the hazard insurance premium is $256 semiannually. Find the monthly PITI payment.   Group of answer choices 699.51 $594.73 $1,059.40 $246.83

QUESTIONS 1,2,3 ARE CONNECTED. I SOLVED QUESTIONS 1 and 2 and need help solving QUESTION 3 ONLY  1. A bank customer obtains a $150,000 mortgage with a term of 15 years and a nominal interest rate of 4.20%. The monthly debt service/payment for the mortgage : Answer - $1,124.63 2) If the homeowner makes the minimum monthly required payments on the mortgage, what is the balance on the mortgage after 5 years – i.e. after the 60th payment is made: Answer - $110,043.38 3) Assume the homeowner has made the minimum required monthly payments on the mortgage and 5 years have passed. If the homeowner’s income has increased and he/she decides to increase the monthly payments to $1500, how many months and years will it take to retire the mortgage? Months Years?  *PLEASE SOLVE #3 USING EXCEL ONLY AND SHOW THE FUNCTIONS/FORMULAS USED*

Problem 7-3 (LG 7-4) You plan to purchase an $110,000 house using a 15-year mortgage obtained from your local bank. The mortgage rate offered to you is 4.25 percent. You will make a down payment of 12 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Calculate the amount of interest and, separately, principal paid in the 100th payment. c. Calculate the amount of interest and, separately, principal paid in the 115th payment. d. Calculate the amount of interest paid over the life of this mortgage. (For all requirements, do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) a. Monthly payment b. Amount of interest Amount of principal C. Amount of interest Amount of principal d. Amount of interest paid Amount