Finance
posted by Antoinette .
You take out a 30year $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.08125995.64
=79,079.44
I hope you are familiar with the formulas I was using.
Respond to this Question
Similar Questions

Finance
You take out a 30year $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? 
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? 
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 … 
finance
You take out a 25year $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? 
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? 
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 30yr mortgage with monthly payments. Plan to be in house for at least five years. Should you pay the point? 
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? 
Finance
A mortgage broker is offering a $225,000 30year 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 … 
f
You have just purchased a new warehouse. To finance the purchase, youâ€™ve arranged for a 35year 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? 
Finance
Could someone tell me how to calculate this in excel?