You are doing some bookkeeping concerning a mortgage you took out 10 years ago, $500,000 used to finance a home. You presume it is a 30-year mortgage. You are trying to determine the interest rate (mortgage equivalent yield) on the loan. You know that the monthly payments are $4,023.11. So, you assume therefore that the interest rate on the loan is 9% and call your mortgage broker to check this out. Looking at your numbers, he tells you that you have two things incorrect. First, this was a weird mortgage that did not start with a 30-year maturity. Second, the 9%, it turns out, was purely coincidental. He also tells you that the actual interest paid thus far is 8.78% less than that shown in your calculations based on the 9% interest rate and a $500,000 loan – that is the interest paid is .9122 times the figure calculated from your mortgage calculation. From this information, can you determine the actual terms of the mortgage: rate and maturity?
Interest rate on the loan: 8.5%
Maturity: 25 years
First, assuming 9% interest rate on a 30-year mortgage, I can use Excel to calculate howmuch interest I have paid in the past 10 years.
As you can see from the table, the total interest payment that I have made in the past 10 yearsis $429,922.52, assuming 9% interest rate on a 30-year mortgage.
Then, according my broker’s description, I can calculate my actual interest payment, whichis: 429,922.52 * 0.9122 = $392,175.32
Then, using Excel, I keep plugging in different interest rates into my formula until I get thetotal interest payment equals $392,175.32. Using this method, I figure out the interest rate onthe loan is 8.5% and the monthly rate is 0.7083%.
Then, I put monthly payment 4023.11 and monthly rate 0.7083% into the annuity formulaand solve for the maturity, getting the maturity is 300 months, which is equivalent to 25years.
Therefore, I know this is a 25-year mortgage with 8.5% annul interest
You are doing some bookkeeping concerning a mortgage you took out 10 years ago, $500,000 used...
Ten years ago you obtained a 30-year mortgage for $400,000 with a fixed interest rate of 3% APR compounded monthly. The mortgage is a standard fixed rate mortgage with equal monthly payments over the life of the loan. What are the monthly fixed mortgage payments on this mortgage (i.e., the minimum required monthly payments to pay down the mortgage in 30 years)? What is the remaining loan balance immediately after making the 120th monthly payment (i.e., 10 years after initially...
years ago you took out a $350,000, 25-year mortgage with an annual interest rate of 77 percent and monthly payments of $2,473.732. What is the outstanding balance on your current loan if you just make the 108th payment?
[2 points] Suppose that 15 years ago you bought a home for $500,000, paying 20% as a down payment, and financing the rest at 5% interest for 30 years. How much money did you pay as your down payment? [2 points] How much money was your existing mortgage (loan) for? [2 points] What is your current monthly payment on your existing mortgage? Note: Carry at least 4 decimal places during calculations, but round your final answer to the nearest cent....
10 Years ago you took out a 30-year mortgage to buy a house. Your annual payment is $18,162 and your current interest rate is 6%. Suppose you now want to refinance and still pay off the house in 20 years, how much principal do you still owe on the mortgage? I keep getting the wrong answer using my BA II Plus Calculator. The correct Answer is $208,316.71
Five years ago you took out a 5/1 adjustable rate mortgage and the five-year fixed rate period has just expired. The loan was originally for $ 294,000with 360 payments at 4.2 % APR, compounded monthly. a. Now that you have made 60 payments, what is the remaining balance on the loan? b. If the interest rate increases by1 %, to 5.2 % APR, compounded monthly, what will be your new payments? a. Now that you have made 60 payments, what...
Five years ago you took out a 5/1 adjustable rate mortgage and the five-year fixed rate period has just expired. The loan was originally for $ 310 comma 000 with 360 payments at 4.4 % APR, compounded monthly. a. Now that you have made 60 payments, what is the remaining balance on the loan? b. If the interest rate increases by 0.9 %, to 5.3 % APR, compounded monthly, what will be your new payments? a. Now that you have...
You've decided to buy a house that is valued at $1 million. You have $500,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 $500,000 mortgage and is offering a standard 30-year mortgage at a 9% Foxed 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...
Five years ago you took out a 5/1 adjustable rate mortgage and the five-year fixed rate period has just expired. The loan was originally for $302,000 with 360 payments at 4.3% APR, compounded monthly a. Now that you have made 60 payments, what is the remaining balance on the loan? b. If the interest rate increases by 1.1%, to 5.4% APR, compounded monthly, what will be your new payments? a. Now that you have made 60 payments, what is the...
aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is 3%, and you must amortize the loan over 10 years with equal end-of-year payments. A. Calculate the mortgage payment using the Excel function Rate Nper PV FV Payment B. Set up an amortization schedule that shows the annual payments and the amount of each payment that repays the principal and the amount that constitutes interest expense to the borrower and interest income to the...
1.) When you purchased your house 12 years ago, you took out a $300,225 mortgage to be paid back monthly over 30 years, with an APR of 6% compounded monthly. You have just made a payment and now have decided to pay the mortgage off by repaying the outstanding balance. a) What is your monthly payment on the mortgage? b.) What is the remaining balance of your mortgage? (Note there are 18 years left on the mortgage.)