+ Reply to Thread
Results 1 to 3 of 3

Cumulative present value in a single function

  1. #1
    Registered User
    Join Date
    11-25-2019
    Location
    Korea
    MS-Off Ver
    2010
    Posts
    12

    Cumulative present value in a single function

    Hi all,

    I am trying to cumulatively sum the amounts across a row while accumulating with given interest rates in a single function.

    I've provided the information in the attachment (I want a single function so it can be dragged to solve the answer unlike what I have done in example excel).

    Appreciate your help! Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,221

    Re: Cumulative present value in a single function

    Please try at B4

    =SUMPRODUCT(FV($B3:B3,COLUMN(B2)-COLUMN($B2:B2),,-$B2:B2))

    or

    =SUMPRODUCT((1+$B3:B3)^(COLUMN(B2)-COLUMN($B2:B2)),$B2:B2)
    Attached Files Attached Files
    Last edited by Bo_Ry; 06-22-2021 at 01:32 AM.

  3. #3
    Registered User
    Join Date
    11-25-2019
    Location
    Korea
    MS-Off Ver
    2010
    Posts
    12

    Re: Cumulative present value in a single function

    Thank you!!

+ 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] Cumulative total in single cell
    By woolsocks in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-07-2015, 05:29 PM
  2. How to present cumulative data using a chart and pivot table
    By Rob (SA) in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 04-29-2014, 06:14 AM
  3. [SOLVED] How to present a table segment (range) using a single function?
    By yoniman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-09-2013, 11:20 PM
  4. [SOLVED] Check a Single Cell to See if Any Words from an Array are Present
    By sweetrevelation in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-01-2013, 08:48 PM
  5. Cumulative Total with Single Data Entry
    By George Cooper in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-19-2011, 03:31 AM
  6. Cumulative Total with Single Data Entry
    By Infman in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-07-2009, 09:56 AM
  7. How do I calculate present value of a single sum?
    By Carmen in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-29-2005, 03:06 PM

Tags for this Thread

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