inflation

Hi All, I have a large workbook that has a sheet which calculates results with and without inflation. I have code that changes inflation to 0 and then back to what it was originally. Before I copy the original assumptions back I need to calculate just one sheet that is selected in a drop-down...

Just wondering if its possible to update prices by inflation on specific dates. As an example, i'd like a loaf of bread at $1 to automatically adjust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. I...

Just wondering if its possible to update prices by inflation on specific dates. As an example, i'd like a loaf of bread at $1 to automatically adjust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. I...

Just wondering if its possible to update numbers by inflation on specific dates. As an example, i'd like a loaf of bread at $1 to automatically adjust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually...

Just wondering if its possible to update numbers by inflation on specific dates. As an example, i'd like a loaf of bread at $1 to automatically adust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. Thanks

Hello, I am looking for a formula that properly pulls a Baseline Expense depending on location (this part is done) and then multiplies it by looking up the inflation rate for a given year. Second half of the formula is below. Inflation portion...

Hello, I have a table with 40 rows and depending on input the values change from positive to negative. So with an inflation rate of 2.5% then row 23 will be the first row in negative numbers, if I change inflation rate to 1% then row 28 will be the first row in negative. How do I conditionally...

I have a "Pivot Table" with 6 columns A thru F. header = Fiscal Years. There is a row A thru F for total costs in each Fiscal Year. I have defined that range/row as Total Costs. I want to take each Total Costs and bump it up by an inflation rate without have to go in each cell and add the...

I've got a date measure that works with some operators but not others. Perhaps someone can tell me what I'm doing wrong in formatting? I get an error that the date measure is a text measure and DAX cannot compare text and dates, but only for certain operations. I've got an inflation formula...

For my model I have constants to be applied such as projected inflation rate, depreciation years, and other values to be set by users as what-if options. There are too many variations the users want to create disconnected tables - e.g. listing every inflation rate by hundredths of a percent -...

Hi :) I am working on a project to forecast monthly change of inflation rate. I used SLR but the forecast doesnt seem to be correct. Could someone take a look please? :confused: I am also not sure how to diagnose time series (stationarity, trend, ARMA..) in Excel( is this even possible?) I...

I'm looking for a formula that gives me an average unit price value that considers annual inflation. For example: Inflation is 2% Year 1, Unit Price is 100.00 Year 2, Unit Price is 102.00 { =100*1.02 } for an average unit price of 101 { =(100+(100*1.02))/2 }. Year 3, Unit Price is 104.04 {...

So I have an excel problem (first time user) and I have to adjust for inflation for a fortnightly payment. So the payment comes in every fortnight and its $900. Inflation is estimated approx. 4% and its to occur on a yearly basis on and after 1/07/2014 (so the next one would be 1/07/2015 and...

I am interested to know whether there is a compound interest formula which takes inflation into account. I am familiar with the compound interest formula. The type of calculation I'm looking to do is Monthly investment of: $250 Annual interest rate: 4% Annual inflation rate: 3% Period of...