Several years ago you got a mortgage loan at 8.75% interest. You currently owe $138,743.03 with a monthly payment of $1108.05. How long until the loan will be paid off?   Please make sure to show the formula for this question for better understanding. The answer in the back of the book is 268 months

Q: Suppose you take out a mortgage for $265000 at 2.88% interest, compounded monthly, for 20 years!…

A: Compounding frequency refers to the number of times a sum of money is compounded within a year. This…

Q: 27. You get an interest-only mortgage loan of $215,000 at 8.25%. For the first 2 years, your monthly…

A: Given, Mortgage Loan =$215000 Rate =8.25%

Q: Find the monthly payment (in $) and the total interest (in $) for a mortgage of $46,000 at  5 1/4 %…

A: Monthly payment=4.14Total interest=$42,987.20So, the monthly payment is $4.14 and the total interest…

Q: You buy a house for $800,000.  It is a 20 Year mortgage where the payments are made quarterly and at…

A: Borrowings are the liability of the company which is used to finance the requirement of the funds.…

Q: Suppose you take out a mortgage for $170000 at 3.12% interest, compounded monthly, for 15 years.…

A: Monthly payment refers to an amount that is being paid every month for the repayment of the loan…

Q: Please show how to solve this problem using excel and please show the spreadsheet formulas.…

A: Part 2: Explanation:Step 1: Calculate the Monthly Interest RateThe annual interest rate is 7.5%. To…

Q: Find the monthly payment (in $) and the total interest (in $) for a mortgage of $48,000 at  5 1/4%…

A: The monthly payment for a mortgage is made is such a way that the mortgage amortizes to zero by the…

Q: A hair stylist obtains a home loan for $414,000 at an annual interest rate of 5.75% compounded…

A: Monthly payment is calculated using PMT function in excel

Q: What is the unpaid balance on the $9000 loan you obtained five years ago with monthly payments and…

A: A loan refers to a contract between parties where money is exchanged on the promise of future…

Q: Consider a home mortgage of $125,000 at a fixed APR of 12% for 30 years. a. Calculate the monthly…

A: Payment per period can be calculated using PMT function in excel.   PMT(rate, nper, pv, [fv],…

Q: Extra # 3. Suppose you borrow $250,000 as a mortgage at annual effective rate of 7.5%. Equal…

A: The payment made towards a loan consists of both interest as well as principal. The interest amount…

Q: For Problems 17-24, assume you get a 30-year $90,000 mortgage loan at 7.25% interest. 23. How months…

A: Loan Amount = $ 90,000 Terms (n) = 30 years = 30*12 = 360  Rate of interest(r) = 7.25%/12 =0.604167%…

Q: Doreen Short was looking over the repayment schedule for a loan of $37,858 at 7% interest for 5…

A: The remaining balance after making payments for 15 months as the remaining payments will be 45 is…

Q: A mortgage for a condominium had a principal balance of $44, 700 that had to be amortized over the…

A: The loan amount is $44,700.The loan period is 6 years.The interest rate is 4.42% compounded…

Q: Please show how to solve this problem. Interest-only mortgage with monthly payments and loan amount:…

A: Calculate the monthly payment for the interest-only mortgage: Monthly Payment = Loan Amount × Annual…

Q: A 30-year mortgage has an annual interest rate of 5.85 percent and a loan amount of $245,000. (Hint:…

A: Mortgage loans are paid by the monthly payments that carry the payment of interest and payment of…

Q: 2. Prepare a loan amortization schedule for the first 3 months of the mortgage loan shown in the…

A: Total loan is $250,000. Number of years is 20. Thus, number of total monthly payment is 240. Annual…

Q: A fully amortizing mortgage loan is made for $84,000 at 6 percent interest for 25 years. Payments…

A: A mortgage is a covered loan that is borrowed to purchase a property. The property in question acts…

Q: mula or a calculator application to find the total interest paid for the home mortgage of ​$279,185…

A: Homes are purchased by the mortgage loans and mortgage loans are secured loans and there is…

Q: received a 20-year, $500,000 mortgage with a 12% annual interest rate (APR). What portion of the…

A: When the borrower borrows a loan from the lender, he has to pay a rate of interest on the borrowed…

Q: A mortgage of $26, 252.00 is to be repaid by making payments of $ 1368.00 at the end of each year.…

A: A mortgage is a covered loan that is taken out for the purchase of a property with the property…