# Saving Calculation Question

I inherited a report with the following formula for savings.

=(a2)/(1-6.8%)-a2  where 6.8% is the savings rate

When I calculate savings I was doing a2*6.8%. Anyone know what they were trying to accomplish? You get slightly different numbers.
###### Who is Participating?

Manager; IT ConsultantCommented:
Your formula  is used to calculate the discount on the original price
The formula above uses the discounted price and calculated what the discount was

e.g.
Original price = \$100, discount = 100 * 0.068 = \$6.80.
Then Discounted price is \$100-\$6.80= \$93.20

Formula above starts with the discounted price

( 93.20 / (1-0.068) ) - 93.20 = ( 93.20 / 0.930 ) - 93.20 = 100 - 93.20 = 6.80

Hope this helped
0

Commented:
If a2 is the amount you have now
(a2)/(1-6.8%) is the amount you had a year ago
and (a2)/(1-6.8%)-a2 is the amount of interest you received last year.

This assumes no monthly compounding and is probably not the right way to do the calculation.
0

Commented:
>>  and (a2)/(1-6.8%)-a2 is the amount of interest you received last year.

That should be paid out not  received  since it will be negative.
0

Commented:
both equations are exactly the same.
Put them equal to each other and simplify
0

Commented:
I was invited to help close this.  I believe it is resolved.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.