Excel Formula needed

  • Thread starter Thread starter Mocassin joe
  • Start date Start date
M

Mocassin joe

12864 decreased by 3% for 19 years.

I would like the decreasing value in the fist column and the difference in
value in the second column.

as an example:

12868.00 0000.00
12478.08 385.94

Thanks in advance
 
12864 decreased by 3% for 19 years.

I would like the decreasing value in the fist column and the difference in
value in the second column.

as an example:

12868.00 0000.00
12478.08 385.94

Thanks in advance
Click to expand...

Depends on:
- your Excel version
- interest rate compounding (monthly, yearly ?)

Excel has formulas to calculate this - look under "Financial"
 
But you have calculated the answer. Just continue down the column. If you're
saying you really need the formula, it's

=a1*(1-3%)
or
=a1*0.97

The difference is:
=a2-a1

If you want the final amount in one formula, it's
=fv(-3%,19,0,-12864)

Regards,
Fred
 
Thanks - it was a help.

Fred Smith said:
But you have calculated the answer. Just continue down the column. If
you're saying you really need the formula, it's

=a1*(1-3%)
or
=a1*0.97

The difference is:
=a2-a1

If you want the final amount in one formula, it's
=fv(-3%,19,0,-12864)

Regards,
Fred
Click to expand...
 
Back
Top