|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 18th, 2005, 07:28 PM
|
|||
|
|||
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
August 18th, 2005, 07:55 PM
|
|||
|
|||
|
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" wrote in message ... 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
August 19th, 2005, 02:19 AM
|
|||
|
|||
|
Chip Pearson wrote:
Use the FV (Future Value) function. E.g., =FV(3.5%,YEAR(TODAY())-1920,0,-56000) Thank you !
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Access Mail Merge to Word.doc files ? | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 18th, 2005 06:31 PM |
| Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
| Query Only Creent Record? | Hulk | Running & Setting Up Queries | 10 | January 25th, 2005 06:39 PM |
| How can I check suggested changes someone else made to original do | BYUTE | Visio | 0 | January 15th, 2005 12:01 AM |
| Outlook 2003 spelkl check does not ignore original message | John | General Discussion | 2 | August 31st, 2004 12:03 PM |
Linear Mode
