Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 8
Default Goalseek gives incorrect results

Hello
Using =PMT formula, I input B1=pmt(14.5%/12,60,A1) and in GoalSeek, I set
cell B1 to 5000 by changing cell A1 and I get 212,510.21 as the result
whereas simply seen 5000 in one year would be 60K and in 5 years it would be
300K. For small values it provides proper results but not for this one. What
wrong am I doing?
Thanks


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,059
Default Goalseek gives incorrect results

"dindigul" wrote:
Using =PMT formula, I input B1=pmt(14.5%/12,60,A1) and
in GoalSeek, I set cell B1 to 5000 by changing cell A1
and I get 212,510.21


That is the correct result, assuming either you are misrepresenting the
signs of some things.

When A1 is 212,510.21, =PMT(14.5%/12,60,-A1) does indeed return about
5000.00 formatted to 2 decimal places. Note that I used -A1, not A1.

Alteratively, with PMT(...,A1), A1 should be -212,510.21; or if A1 is
212,510.21, PMT() should result in -5000.


whereas simply seen 5000 in one year would be 60K and
in 5 years it would be 300K.


Off-hand, I don't know that means. But I confess that I am not giving it
much thought since Goal Seek does indeed produce the correct result.


What wrong am I doing?


I'm biting my tongue ;)

Seriously, if you can explain what you mean by the "whereas" statement
above, perhaps we can help you understand the Goal Seek result and/or
properly structure the Goal Seek problem to meet your expectations.

PS: You do not need Goal Seek for the problem as I understand it. Simply
use:

=PV(14.5%/12,60,-B1)

where B1 is 5000.


----- original message -----

"dindigul" wrote in message
...
Hello
Using =PMT formula, I input B1=pmt(14.5%/12,60,A1) and in GoalSeek, I set
cell B1 to 5000 by changing cell A1 and I get 212,510.21 as the result
whereas simply seen 5000 in one year would be 60K and in 5 years it would
be 300K. For small values it provides proper results but not for this one.
What wrong am I doing?
Thanks


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
results incorrect KMC Excel Discussion (Misc queries) 2 July 18th 08 03:14 PM
vlookup gives incorrect results Forrest G. Excel Worksheet Functions 3 December 18th 06 05:40 PM
Very large workbook now giving incorrect results :( [email protected] Excel Discussion (Misc queries) 0 July 17th 06 11:29 PM
Totals of calculated field in pivot table give incorrect results Jake Excel Worksheet Functions 6 January 12th 06 06:15 PM
How do I prevent incorrect formula results appearing in cell? Marc Todd Excel Worksheet Functions 2 January 26th 05 07:57 AM


All times are GMT +1. The time now is 01:18 AM.

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"