Link to home
Start Free TrialLog in
Avatar of nickg5
nickg5Flag for United States of America

asked on

Formula to calculate cost

Calculating the cost with a 10% per year penalty.

These were the cost in the respective years.
2013 - $105
2014 - $105
2015 - $105
2016 - $105
2017 - $134
2018 - $134
2019 - $135
2020 - $145
2021 - $148

Starting point is 2013 and $105.
Applying a 10% penalty for 2013 we get $11 and $105 + $11 = $116 cost for 2014.
Another 10% penalty for 2014 is say $12 + $116 = $128 cost for 2015.
We'd like to do the same for all years up and through the $148 for the year 2021 which would give the cost for 2022.

Anything beyond an algebraic formula we would be stumped.
Yes we can do each one by hand I'm sure but the look of a formula would be interesting.
Pen and paper formula not using Excel, etc. Thanks. 


ASKER CERTIFIED SOLUTION
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of nickg5

ASKER

Thanks Ken, I'm not familair with some of the nomenclature you use.

Above where you have a result of 133.10 what does that represent.
$133.10 cost for ?
That would be the current cost on a 3 year old bill of $100.

It's 10% higher after 1 year, or $110.00
Another 10% higher after 2 years, or $121.00
And another 10% higher after 3 years, or $133.10


SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial