Excel help

Vikingfan

Not sure on the calculation and how to input it.
How can I calculate a 3% increase per day with compunding?

stevemcol

Original amount in A1

then in A2
=a1+(a1*0.03)


then fill down

Wombat

Or slightly faster calculation (if a large amount of cells is involved):

Original amount in A1

then in A2
=a1*1.03


then fill down

Gorgeous_George

Or

=PV*(1+R)^N

where,
PV = Present Value (sum borrowed?)
R= Interest Rate (given as 0.04 i.e., 4%)
N=number of periods (days in your case)

so for £10 and 8 days
=£12.67



GG