nickg5
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Above where you have a result of 133.10 what does that represent.
$133.10 cost for ?