Results 1 to 3 of 3

Thread: Running total

  1. #1
    New Lounger
    Join Date
    Feb 2012
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Running total

    variables given
    BeginYear
    NoYears
    Cost
    Fvrate
    rate2

    Formulas:
    FutureValue: cost * (1+Fvrate)^NoYears
    PresentValue: FutureValue / (1+ rate2) ^NoYears
    Year1: PresentValue * rate2
    Year2: (Year1 + PresentValue) * rate2
    etc

    What I am needing to show is for each NoYears the running total

    Year Cost RunningTotal
    1 "Year1" ????
    2 "Year2" ????
    ...
    NoYears

    RESULTS last entry for RunningTotal + PresentValue = FutureValue

    Excel File attached as an example
    Attached Files Attached Files
    Last edited by paweaver; 2014-02-18 at 18:01. Reason: added file

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    New Lounger
    Join Date
    Feb 2012
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Added sample file

    This is a sample file of the Excel spreadsheet of the formulas and what the expectations are.
    Attached Files Attached Files

  4. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,496
    Thanks
    3
    Thanked 42 Times in 42 Posts
    Do you need to do this as an Access form, report, web page or some other file format, such as Excel? In order to do this in Access you will probably need to create a VBA function to create the records for each year. Are you comfortable writing a VBA process using DAO or ADO to create a temporary table? In general there isn't a way to easily connect a pair of records in the same table without resorting to code, while Excel does this sort of thing very well.
    Wendell

Posting Permissions

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