    0

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

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 Study guides

20 cards

## The result of division

➡️
See all cards
4.75
4 Reviews

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  