PDA

View Full Version : Solved: Calculating Future Costs



Opv
11-08-2012, 04:08 PM
I need a formula that factors in inflation in order to project the future cost of a service provided. For example, if the current average monthly cost of a service is $5,000 per month, how would I calculate what the average monthly cost would be in, say, 5 years, 10 years, etc., assuming costs will increase 4% per year? A B C D E 1 RATE: 4% COMPOUND AT: 1 (1 for daily; 2 for monthly) 2 >>>> YEARS