To calculate project cost with inflation

Ask the Community Formulas
#1

Give me example to calculate project cost with inflation in data sets in stackby.

#2

You can use the following formula:

  • Cost: The initial or current cost of the project.
  • Inflation Rate: The annual rate of inflation (expressed as a decimal). For example, if the inflation rate is 5%, enter it as 0.05.
  • Years: The number of years you expect the project to last or the period over which inflation will affect the cost.

How to Use in Stackby:

  1. Set Up Your Columns:
  • Create a column for Cost (e.g., $10,000).
  • Create a column for Inflation Rate (e.g., 0.04 for 4%).
  • Create a column for Years (e.g., 5).
  1. Apply the Formula:
  • Use the formula in Stackby as: POWER( (1+{Inflation rate}), {Years})*Cost
  1. Example Calculation:
  • If your project cost is $10,000, the inflation rate is 4% (0.04), and the project spans 5 years:
  • The project cost after 5 years will be approximately $12,167.