0

# How do you work out interest accrued on spreadsheet for compound interest?

Wiki User

2014-08-24 09:18:10

Suppose

Capital invested = Y

Annual Interest Rate = R%

Period of investment = T

Then if the interest is calculated (and compounded) n times a year

total value =

Y*[1 + r/(100*n)]^(n*T)

So interest accrued = Total value - Y

Suppose

Capital invested = Y

Annual Interest Rate = R%

Period of investment = T

Then if the interest is calculated (and compounded) n times a year

total value =

Y*[1 + r/(100*n)]^(n*T)

So interest accrued = Total value - Y

Suppose

Capital invested = Y

Annual Interest Rate = R%

Period of investment = T

Then if the interest is calculated (and compounded) n times a year

total value =

Y*[1 + r/(100*n)]^(n*T)

So interest accrued = Total value - Y

Suppose

Capital invested = Y

Annual Interest Rate = R%

Period of investment = T

Then if the interest is calculated (and compounded) n times a year

total value =

Y*[1 + r/(100*n)]^(n*T)

So interest accrued = Total value - Y

Wiki User

2014-08-24 09:18:10
Study guides

20 cards

## The result of division

➡️
See all cards
4.75
4 Reviews

Wiki User

2014-08-24 09:18:10

Suppose

Capital invested = Y

Annual Interest Rate = R%

Period of investment = T

Then if the interest is calculated (and compounded) n times a year

total value =

Y*[1 + r/(100*n)]^(n*T)

So interest accrued = Total value - Y

Earn +20 pts
Q: How do you work out interest accrued on spreadsheet for compound interest?