Thread: PMT question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SMAlvarez SMAlvarez is offline
external usenet poster
 
Posts: 1
Default PMT question


I need help with the following problem.

"A person is going to buy a house. The cost of the house is $300,000,
and the person is going to make a 15% down payment. The balance will be
financed with a 30-year mortgage at 6% APR, with monthly payments. Using
the PMT function, calculate the amount of the monthly payment, the total
amount paid in 30 years, and the total interest paid."

Ok I think the pmt function is PMT(.06/12,30*12,255,000)

Is that correct?

What does he mean by "Using the PMT function, calculate the amount of
the monthly payment, the total amount paid in 30 years, and the total
interest paid."?

Thanks for any help!!!


--
SMAlvarez
------------------------------------------------------------------------
SMAlvarez's Profile: http://www.excelforum.com/member.php...o&userid=33287
View this thread: http://www.excelforum.com/showthread...hreadid=560939