LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Savings account interest?

I am trying to figure out a function that can be used to find the balance in
a savings account after a period of time. To make it a little more
complicated, I want to include a monthly deposit during that time. Is there
a function that can do this? I am trying to develop a savings plan that will
be for a specific purchase I want to make in 5 years and want to know how
much I need to put put in the account monthly.

For example.....
If I have an account with $500 and deposit $50 dollars every month for the
next 5 years and there is a 25% annual interest rate...how much will be in it
after 5 years?

Or opposite, although I know how to do what-if anaysis if that is what it
takes...
If I want to save 10,000 in 5 years, how much would I have to deposit
monthly.

These are not the specific numbers but this is what I want it to do for me
for several different saving's projects I want to do.

I tried a couple of the suggested functions, but they didn't come out right,
and I could find anything that included adding to the account throughout the
time period. Does anyone know how to do this? And I am a not clear on all
the financial terms they use in the help mode, so if you can explain it as
simply as possible I would really appreciate it. Thanks.
 
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
What function to calculate interest on savings SnooziSuzi Excel Worksheet Functions 2 June 23rd 08 12:32 AM
interest rates on savings accounts Kim Excel Worksheet Functions 4 March 6th 08 03:38 PM
Savings with interest and regular payments bonjella Excel Worksheet Functions 2 August 10th 07 07:40 PM
Template to calculate Compound Interest on Savings Graham Excel Discussion (Misc queries) 1 October 18th 06 01:26 PM
Find Future Value of a Savings Account gingerjane New Users to Excel 1 June 14th 05 11:57 PM


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