Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Absolutes?

"JudySonger" wrote:
If a couple sets up a savings of $183 per month, for 18 yeasr
at 6.5 % interest. Which areas should be absolute? Their goal
is $75,000


Not sure what you mean by "absolutes", but ....

You can compute the approximate future value of that annuity
as follows:

=FV(6.5%/12, 18*12, -183)

But you will find that falls short of the goal by $274. The
couple would do better to contribute $184 per month. You
can compute that as follows:

=PMT(6.5%/12, 18*12,, -75000)
 
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



All times are GMT +1. The time now is 12:41 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"