Finance

posted by .

You take out a 30-year $100,000 mortgage loan with an APR of 6 percent and monthly payments. In 12 years you decide to sell your house and pay off the mortgage. What is the principal balance on the loan?

I am working this on the assumption that your monthly rate is .005.

First we find our monthly payment:

100000= paym[1-(1.005)^-360]/.005

paym= 599.55

Now finding the amount of 144 of those payments
=599.55((1.005^144)-1)/.005
=125,995.64

Finding the value of our debt after 144 periods if no payments had been made
=100000(1.005^144
=205,075.08

So the outstanding balance after 12 years
= 205075.08-125995.64
=79,079.44

I hope you are familiar with the formulas I was using.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Finance

    You take out a 30-year $100,000 mortgage loan with an APR of 6 percent and monthly payments. In 12 years you decide to sell your house and pay off the mortgage. What is the principal balance on the loan?
  2. finance

    You borrow $185,000 to buy a house. The mortgage rate is 6.5 percent and the loan period is 32 years. Payments are made monthly. If you pay the mortgage according to the loan agreement, how much total interest will you pay?
  3. public finance

    Your annual income is $50,000. You want to take out a mortgage loan to buy a house. The rule on mortgage loan requires that your annual mortgage payment cannot exceed 30% of your annual income. If the current interest rate is 5% for …
  4. finance

    You take out a 25-year $210,000 mortgage loan with an APR of 12% and monthly payments. In 16 years you decide to sell your house and pay off the mortgage. What is the principal balance on the loan?
  5. Finance

    You take out a 30 year $100000 mortgage loan with an apr of 6% and monthly payments. In 12 years you decide to sell your house and pay off the mortgage. What is the principle balance on the loan?
  6. Maths

    Mortgage company lets you pay a point (1% of total amount of loan)to reduce APR from 6.5% to 6.25% on a $400,000 30-yr mortgage with monthly payments. Plan to be in house for at least five years. Should you pay the point?
  7. finance

    You borrow $149,000 to buy a house. The mortgage rate is 7.5 percent and the loan period is 30 years. Payments are made monthly. If you pay for the house according to the loan agreement, how much total interest will you pay?
  8. Finance

    A mortgage broker is offering a $225,000 30-year mortgage with a teaser rate. In the first two years of the mortgage, the borrower makes monthly payments on only a 2.5 percent APR interest rate. After the second year, the mortgage …
  9. f

    You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 35-year mortgage for 85 percent of the $3,100,000 purchase price. The monthly payment on this loan will be $17,200. What is the APR on this loan?
  10. Finance

    Could someone tell me how to calculate this in excel?

More Similar Questions