+ Reply to Thread
Results 1 to 3 of 3

Current Cost versus Original Cost

  1. #1
    A Boe
    Guest

    Current Cost versus Original Cost

    New to using Excel here. How does one calculate the current cost if one
    knows a building cost $56,000 in 1920. I am assuming annual inflation
    rate is 3.5%.

    What formula or function would I use?

    Thank you.

    AB

  2. #2
    Chip Pearson
    Guest

    Re: Current Cost versus Original Cost

    Use the FV (Future Value) function. E.g.,

    =FV(3.5%,YEAR(TODAY())-1920,0,-56000)

    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com



    "A Boe" <"\"m-in-sfca/*No*Spam*\\\""@comcast.net> wrote in
    message news:[email protected]...
    > New to using Excel here. How does one calculate the current
    > cost if one knows a building cost $56,000 in 1920. I am
    > assuming annual inflation rate is 3.5%.
    >
    > What formula or function would I use?
    >
    > Thank you.
    >
    > AB




  3. #3
    A Boe
    Guest

    Re: Current Cost versus Original Cost

    Chip Pearson wrote:
    > Use the FV (Future Value) function. E.g.,
    >
    > =FV(3.5%,YEAR(TODAY())-1920,0,-56000)
    >

    Thank you !

+ Reply to Thread

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