+ Reply to Thread
Results 1 to 2 of 2

Find out monthly and future savings

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Find out monthly and future savings

    Hello everyone
    I need your help in this request please
    find out the amount of monthly savings she has to deposit to have $250,000 savings after two years. 2) find out the future savings given the monthly saving range from $700-$1200 ($100 as increment) and interest rate ranges from .8% to 1.2% (increment is .1%)
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Find out monthly and future savings

    Hi,

    I don't understand your requirement.
    Are there two requirements.
    1. The amount of monthly savings to achieve $250000 (including the original $180000) after two years.
    2. The future value of savings for amounts from $700 - $1200

    Both requirements usingf rates from .8% to 1.2%
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Future Value (FV)-function - Calculate monthly contributions
    By bakerman2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-31-2016, 07:28 AM
  2. Calculating monthly value of savings using an annual rate
    By -Mike- in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-06-2015, 10:42 PM
  3. Design Question for Monthly savings worksheets
    By DavelinaJolie in forum Excel General
    Replies: 0
    Last Post: 01-29-2015, 09:27 AM
  4. how do I set monthly totals, but keep future months at zero?
    By Neutrino Two in forum Excel General
    Replies: 3
    Last Post: 12-16-2011, 02:59 AM
  5. Unlocking Future Monthly Cell Ranges
    By goodwinh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2011, 05:35 AM
  6. [SOLVED] How to find how much to put aside monthly to reach savings goal
    By Learning Excel for finances in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-04-2006, 08:50 PM
  7. [SOLVED] Find Future Value of a Savings Account
    By gingerjane in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-14-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1