Results 1 to 3 of 3

Calculate compounding "interest"

Threaded View

  1. #1
    Registered User
    Join Date
    06-01-2010
    Location
    MA, USA
    MS-Off Ver
    Excel 2013
    Posts
    18

    Calculate compounding "interest"

    Not really compounding interest, but sort of. Here's what I need in layman's terms. Hopefully someone will understand this logic.

    In the attachment, I need to calculate "Est. Purchase" for the number of "value in B1" purchases of each item in Column A for Rows 4 through 30 where "Value in A" <> "". Each time a purchase of Row A (let's stick with A4) is made, the value of the item increases ~15%, so the second item of A4 will be ("value of B4" * 1.15), the third will be (("value of B4" * 1.15) * 1.15), and so on. I need to calculate the total purchase price of "value in B1" items of A4.

    So if B1=3, I need C4 to be ("value of B4" + ("value of B4" * 1.15) + (("value of B4" * 1.15) * 1.15)), and then I need that repeated for all rows where "Value in A" <> "". The value in B1 will be changed by the user in order to determine which item in Column A has the highest return value of other calculations that I left out of the attachment (they are irrelevant to this problem), so it will be anywhere from 2 to 20 (or even greater).
    Attached Files Attached Files
    Last edited by DrStrangepork; 10-11-2012 at 01:38 PM. Reason: second calculation explanation was incorrect

Thread Information

Users Browsing this Thread

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

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