LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 418
Default PMT question

SMAlvarez wrote:
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?


No.

SMAlvarez wrote later:
maybe im wrong. Is the monthly payment whatever the answer is to
PMT(.06/12,30*12,255000)


Yes, with the caveats that I mentioned in an earlier posting. The
monthly payment is probably either PMT(6%/12,30*12,255000) or
PMT(RATE(12,0,-1,1+6%),30*12,255000), depending on what your teacher
meant by "6% APR". I suspect your teacher did mean "6% annual interest
rate". In that case, your formula is correct. (Note that .06/12 is
the same as 6%/12.)

I had said that 30*12*PMT(...) is the total amount paid in 30 years.
That is very much more than $300,000. Enter the formula
=30*12*PMT(...) into a cell and see the result.

And I said that the "total interest paid" is the "total amount paid"
minus the principal ($255,000). That is =30*12*PMT(...)-255000.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Possibly a loaded question, but I think mileslit Excel Discussion (Misc queries) 1 September 10th 05 01:18 AM
How do I find and replace a question mark in Excel? Ranpalandil Excel Discussion (Misc queries) 1 September 7th 05 10:20 PM
Newbie With A Question Michael Excel Worksheet Functions 0 July 28th 05 11:50 PM
Anybody Help with previous question Anthony Excel Discussion (Misc queries) 1 July 26th 05 01:26 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM


All times are GMT +1. The time now is 04:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"