Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
punkyh
 
Posts: n/a
Default Wrong answer after using the payment formula in excel

I am trying to get a monthly payment figure by using the payment formula in
excel. It always calculates the payment incorrectly. I try it on my
financial calculator, as well as a financial program I have in the computer
and these two come up with the same figure. Then I try it in excel, the
answer is different.

the formula I am using is: =PMT(.0015,360,375,000)

Any help??
  #2   Report Post  
Andy Wiggins
 
Posts: n/a
Default

What are the answers you get in each environment.

FWIW, I calculate my mortgage payments using PMT and they are correct.

--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"punkyh" wrote in message
...
I am trying to get a monthly payment figure by using the payment formula

in
excel. It always calculates the payment incorrectly. I try it on my
financial calculator, as well as a financial program I have in the

computer
and these two come up with the same figure. Then I try it in excel, the
answer is different.

the formula I am using is: =PMT(.0015,360,375,000)

Any help??



  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Without knowing what you expect to see, it's hard to help.

What your formula implies is:

Annual interest rate: 1.8% (i.e., 0.15%*12)
Term: 30 years (360 months)
Present value: $375
Future value: $0

for a payment of $1.35 per month (the result will be negative since your
PV is positive).

What were you trying to calculate?


In article ,
punkyh wrote:

I am trying to get a monthly payment figure by using the payment formula in
excel. It always calculates the payment incorrectly. I try it on my
financial calculator, as well as a financial program I have in the computer
and these two come up with the same figure. Then I try it in excel, the
answer is different.

the formula I am using is: =PMT(.0015,360,375,000)

  #4   Report Post  
ww
 
Posts: n/a
Default

The way you have it set up is
Amount of loan: $375,000
Years: 30
Interest rate: 1.8%

Is that what you wanted? 1.8% seems low? Also for PMT() the amount 375,000
should be -375000 or it will return a negative payment amount if that would
cause a problem.

"punkyh" wrote:

I am trying to get a monthly payment figure by using the payment formula in
excel. It always calculates the payment incorrectly. I try it on my
financial calculator, as well as a financial program I have in the computer
and these two come up with the same figure. Then I try it in excel, the
answer is different.

the formula I am using is: =PMT(.0015,360,375,000)

Any help??

  #5   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Although you are probably correct that a 30 year loan is $375,000 the OP in
fact is using
$375 :) at least as written in his example

--
Regards,

Peo Sjoblom


"ww" wrote in message
...
The way you have it set up is
Amount of loan: $375,000
Years: 30
Interest rate: 1.8%

Is that what you wanted? 1.8% seems low? Also for PMT() the amount
375,000
should be -375000 or it will return a negative payment amount if that
would
cause a problem.

"punkyh" wrote:

I am trying to get a monthly payment figure by using the payment formula
in
excel. It always calculates the payment incorrectly. I try it on my
financial calculator, as well as a financial program I have in the
computer
and these two come up with the same figure. Then I try it in excel, the
answer is different.

the formula I am using is: =PMT(.0015,360,375,000)

Any help??




  #6   Report Post  
ww
 
Posts: n/a
Default

Yeah I know. I noticed it after I posted. Just saw 375,000 and
automatically thought $375,000 instead of $375 with a FV of 000 :)

"Peo Sjoblom" wrote:

Although you are probably correct that a 30 year loan is $375,000 the OP in
fact is using
$375 :) at least as written in his example

--
Regards,

Peo Sjoblom


"ww" wrote in message
...
The way you have it set up is
Amount of loan: $375,000
Years: 30
Interest rate: 1.8%

Is that what you wanted? 1.8% seems low? Also for PMT() the amount
375,000
should be -375000 or it will return a negative payment amount if that
would
cause a problem.

"punkyh" wrote:

I am trying to get a monthly payment figure by using the payment formula
in
excel. It always calculates the payment incorrectly. I try it on my
financial calculator, as well as a financial program I have in the
computer
and these two come up with the same figure. Then I try it in excel, the
answer is different.

the formula I am using is: =PMT(.0015,360,375,000)

Any help??



  #7   Report Post  
punkyh
 
Posts: n/a
Default

Thank all of you for the responses...

Peo...you must love this stuff huh? You answered my other question!

Okay: When you calculate a payment using a financial calculator with these
values:
1.5%
-256,000
360 months

you should get $883.51. when I do it in Excel, I get $919.45

Help?

"punkyh" wrote:

I am trying to get a monthly payment figure by using the payment formula in
excel. It always calculates the payment incorrectly. I try it on my
financial calculator, as well as a financial program I have in the computer
and these two come up with the same figure. Then I try it in excel, the
answer is different.

the formula I am using is: =PMT(.0015,360,375,000)

Any help??

  #8   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

I get 883.51, using

=PMT(0.015/12,360,-256000)

HTH,
Bernie
MS Excel MVP


"punkyh" wrote in message
...
Thank all of you for the responses...

Peo...you must love this stuff huh? You answered my other question!

Okay: When you calculate a payment using a financial calculator with these
values:
1.5%
-256,000
360 months

you should get $883.51. when I do it in Excel, I get $919.45

Help?

"punkyh" wrote:

I am trying to get a monthly payment figure by using the payment formula

in
excel. It always calculates the payment incorrectly. I try it on my
financial calculator, as well as a financial program I have in the

computer
and these two come up with the same figure. Then I try it in excel, the
answer is different.

the formula I am using is: =PMT(.0015,360,375,000)

Any help??



  #9   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

That must be a Tyco loan to Kozlowski to have a rate that low <g


Regards,

Peo Sjoblom



"Bernie Deitrick" wrote:

I get 883.51, using

=PMT(0.015/12,360,-256000)

HTH,
Bernie
MS Excel MVP


"punkyh" wrote in message
...
Thank all of you for the responses...

Peo...you must love this stuff huh? You answered my other question!

Okay: When you calculate a payment using a financial calculator with these
values:
1.5%
-256,000
360 months

you should get $883.51. when I do it in Excel, I get $919.45

Help?

"punkyh" wrote:

I am trying to get a monthly payment figure by using the payment formula

in
excel. It always calculates the payment incorrectly. I try it on my
financial calculator, as well as a financial program I have in the

computer
and these two come up with the same figure. Then I try it in excel, the
answer is different.

the formula I am using is: =PMT(.0015,360,375,000)

Any help??




Reply
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
Display answer only in another cell of one containing a formula Mally Excel Discussion (Misc queries) 5 January 21st 05 02:07 PM
How do I calculate a formula with a not-to-exceed answer? danfromthelake Excel Discussion (Misc queries) 1 January 19th 05 02:57 AM
Paste is is copying in formula, but display is wrong. Matt Excel Discussion (Misc queries) 2 December 7th 04 09:37 PM
display the answer for a formula from another page? Lou New Users to Excel 2 November 29th 04 01:17 AM
Help w/ algebra equations (wrong formula used in my first 2 posts! ruralkansas Excel Worksheet Functions 2 October 31st 04 09:45 AM


All times are GMT +1. The time now is 01:16 PM.

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

About Us

"It's about Microsoft Excel"