- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel calculation help- annual price increase
Posted on 4/20/15 at 10:48 am
Posted on 4/20/15 at 10:48 am
Trying to add some information to a pricing calculator I use for work but can't find the right calculation.
Here is a brief example of the data:
Price- $100
Annual maintenance- $10
Annual maintenance increase- 2%
Term Length- 5 years
what I'm trying to do is get the total cost, and have it auto calculate when I change the maintenance increase and term length.
I can get the calculation by I can't figure out the formula to auto calculate when I change the term length and maintenance. Does that make sense? Anyone have any ideas?
Here is a brief example of the data:
Price- $100
Annual maintenance- $10
Annual maintenance increase- 2%
Term Length- 5 years
what I'm trying to do is get the total cost, and have it auto calculate when I change the maintenance increase and term length.
I can get the calculation by I can't figure out the formula to auto calculate when I change the term length and maintenance. Does that make sense? Anyone have any ideas?
Posted on 4/20/15 at 10:54 am to GoldenSombrero
You just make those amounts cell references in the formula. Then change the values in the cells - answer spits out.
Posted on 4/20/15 at 10:56 am to GoldenSombrero
quote:
I can get the calculation by I can't figure out the formula to auto calculate when I change the term length and maintenance. Does that make sense? Anyone have any ideas?
How are you determining total cost now?
The formula you are using to determine total cost should reference the cells that have annual maintenance and term length, thus when they change so does the total cost. Maybe you aren't explaining it right, sounds too easy.
Posted on 4/20/15 at 10:58 am to HurricaneDunc
ok. I guess what I need to know then is what the formula is for $10, with a 2% increase over 5 years. Right now I'm calculating year over year and adding them up. But doing it that way doesn't allow me to actually reference the term length.
Posted on 4/20/15 at 11:00 am to hiltacular
quote:
How are you determining total cost now?
The formula you are using to determine total cost should reference the cells that have annual maintenance and term length, thus when they change so does the total cost. Maybe you aren't explaining it right, sounds too easy.
Total cost now is just the 1st year Total cost of ownership (TCO). I'm manually calculating years 2+ by calculating year 1 increase, year 2 increase, etc then adding them up. Doing it this way doesn't reference the actual term length cell.
Posted on 4/20/15 at 11:32 am to GoldenSombrero
quote:
ok. I guess what I need to know then is what the formula is for $10, with a 2% increase over 5 years. Right now I'm calculating year over year and adding them up. But doing it that way doesn't allow me to actually reference the term length.
For this part: A=Pe^(rt)
A=10(e)^.02*5
In Excel it will be: F(x)= B1*(1+B2/B3)^(B3).
B1= Principal, B2= Interest Rate, B3= Years
And I can't tell from your post whether $100 is a fixed cost.
This post was edited on 4/20/15 at 11:41 am
Posted on 4/20/15 at 11:44 am to GoldenSombrero
(no message)
This post was edited on 4/20/15 at 2:50 pm
Posted on 4/20/15 at 12:19 pm to LSUtoOmaha
Thanks. I ended up getting it to work using the formula FV, which may be essentially what you are referencing.
Posted on 4/21/15 at 7:29 am to GoldenSombrero
I was going to post that. FV should work. Just make sure you are putting the lump sum and the payment in the correct fields or else it will get wonky on you in a hurry.
Back to top
Follow TigerDroppings for LSU Football News