Ok so the "the monthly payment" is 30*12*PMT(.06/12,30*12,255000)?
and "the total amount paid in 30 years" is $300,000?
and "total interest paid" - whatever 300,000 - 255,000 is?
Is that true?
Thanks for all your help man!.
--
SMAlvarez
------------------------------------------------------------------------
SMAlvarez's Profile:
http://www.excelforum.com/member.php...o&userid=33287
View this thread:
http://www.excelforum.com/showthread...hreadid=560939