On the original 30-year loan, monthly payment is calculated using PMT function in Excel :
rate = 12% / 12 (converting annual rate into monthly rate)
nper = 30*12 (30 year loan with 12 monthly payments each year)
pv = 450000 (loan amount = house cost * (1 - down payment %) = $500,000 * (1 - 10%) = $450,000).
PMT is calculated to be $4,628.76.
Now, we calculate the principal paid off after 10 years (120 months) using CUMPRINC function in Excel :
rate = 12%/12 (converting annual rate into monthly rate)
nper = 30*12 (30 year loan with 12 monthly payments each year)
pv = 450000 (loan amount)
start period = 1 (We are calculating principal paid off between 1st and 120th month)
end period = 120 (We are calculating principal paid off between 1st and 120th month)
type = 0 (each payment is made at the end of month)
CUMPRINC is calculated to be $29,619.02.
The balance loan principal outstanding after 10 years = $450,000 - $29,619.02 = $420,380.98.
On the refinanced loan, monthly payment is calculated using PMT function in Excel :
rate = 6% / 12 (converting annual rate into monthly rate)
nper = 20*12 (20 year loan with 12 monthly payments each year)
pv = 420380.98 (balance loan principal outstanding after 10 years).
PMT is calculated to be $3,011.74.
Saving in monthly payment = $4,628.76 - $3,011.74
Saving in monthly payment = $1,617.02
You bought a house for $500,000 with a 10% down. The mortgage is 30 year and...
10.A (7 points) You just bought a house for 500,000 dollars. You put 100,000 + 100.000 dollars as the down hly compounding. You get a payment and borrow the rest from a bank at 3.75 percent APR with monthly 30-year mortgage. What is your monthly mortgage payment? Show your payments go to interest? Just 10B. (3 points) In the first year of your mortgage, how much of your paymer give me the answer. 11. (10 points) What is the present...
You bought a house a year ago for $250,000, borrowing $200,000 at 10% on a 30-year term- loan (with monthly payments Interest rates have since come down to 9%. You can refinance your mortgage at this rate, with a closing cost that will be 3% of the loan. Your opportunity cost is 8%. Ignore tax effects. 17. ow much are your monthly payments on your current loan (at 10%)? How would your monthly payments be if you could refinance your...
Bubba bought his house 20 years ago, he borrowed $200,000 with a 30-year mortgage with a 5.0% APR. His mortgage broker has offered him a 10-year mortgage with a 4% APR with 3 points closing costs. What is Charlie's old monthly payment? What is the balance on Bubba's mortgage? What is Bubba's new monthly payment? How many months does Bubba need to live in the house to justify the refinancing costs?
Suppose you bought a house with a mortgage of $245,000 borrowed at 5.5% fixed APR for 30 years with monthly payments and compounding. After making the required payments for 4 years, you are ready to sell the house and move even though the market value of your home has fallen. How much would you need to receive from the sale of your house (after all transaction costs) to be able to pay off the mortgage?
Barb bought a house with 20% down and the rest financed by a 30-year mortgage with monthly payments calculated at a nominal annual rate of interest 8.4% compounded monthly. She notices that one-third of the way through the mortgage she will still owe 200,000. Determine the purchase price of the house. 252,706 262,706 272,806 282,706 292,706
Suppose you bought a house with a mortgage of $245,000 borrowed at 5.5% fixed APR for 30 years with monthly payments and compounding. After making the required payments for 4 years, you are ready to sell the house and move even though the market value of your home has fallen. How much would you need to receive from the sale of your house (after all transaction costs) to be able to pay off the mortgage?
3. Your dad bought a house for you 10 years ago. He took out a $200,000 mortgage then. The mortgage has a 15year term with monthly payments and has an APR of 8.00%. He paid monthly mortgage for 10 years or 120 months. On October1, 2018, you became the owner of the house and started to be responsible for the rest of the mortgage payments. (Hint: If you continue with the mortgage, you will pay the monthly payment for another...
The mortgage on your house is five years old. It required
monthly payments of $ 1,422, had an original term of 30 years and
had an interest rate of 9% (APR). In the intervening five years,
interest rates have fallen and so you have decided to refinance,
that is, you will roll over the outstanding balance into a new
mortgage. The new mortgage has a 30-year term, requires monthly
payments, and has an interest rate of 6.125 % (APR).
a....
Intro You just took out a 15-year traditional fixed-rate mortgage for $500,000 to buy a house. The interest rate is 2.4% (APR) and you have to make payments monthly. Attempt 1/10 for 10 pts. Part 1 What is your monthly payment? No decima Submit Part 2 Attempt 1/10 for 10 pts. How much of your first monthly payment goes towards paying down the outstanding balance (in $)? No decima Submit Part 3 Attempt 1/10 for 10 pts. What is the...
The mortgage on your house is five years old. It required monthly payments of $1,450, had an original term of 30 years, and had an interest rate of 10% (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance — that is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 6.625% (APR).a. What monthly...