answersLogoWhite

0


Best Answer

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

User Avatar

Wiki User

โˆ™ 2014-08-24 09:18:10
This answer is:
User Avatar
Study guides

What follows a linking or action verb

A mathematical expression of a natural law

A letter that is used in place of a numeral

The result of division

โžก๏ธ
See all cards
4.75
โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…
4 Reviews
More answers
User Avatar

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

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you work out interest accrued on spreadsheet for compound interest?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is earning interest on interest?

Compound interest. This is where you work out the interest on a number, then work out the interest on top of the number with the interest added.


Explian why or why not an external Excel spreadsheet linked into a word document and a web page are or are not compound document within the Microsoft office frame work or environment?

The spreadsheet does not change. The combination is called a compound document because of definition.


Why do people use formulae to work things out when using spreadsheets?

Because formulae save typing, and brain power - especially if it's a complicated spreadsheet. Take something simple - like a spreadsheet to work out the interest and repayments on a loan... It's much quicker to let the spreadsheet work out the amount of interest to be added each month - than to work it out manually. Additionally, the formula can be copied to more than one cell.


How do you know whether a maths question is asking you to work out compound or simple interest?

For the second (and subsequent) periods, if the interest is to be calculated for the original sum PLUS the interest earned so far then it is compound interest. If only the original amount earns interest in all periods then it is simple interest.


How does a spreadsheet work?

A spreadsheet works by showing the line relationships and the jobs and who is in charge


What is Microsoft Excel and How does it work?

a spreadsheet


What does an accountant use a spreadsheet to do?

a acountant uses the spreadsheet to help to maths an work things out quicker


How does spreadsheet makes work more efficient?

They can


How does compound interest work?

AnswerCompound interest works like this.Take a principle (The amount of money you deposit) of $10,000.Lets say that the interest rate is 8% and that it compounds anually.At the end of one year you would have $10,800.With simple interest, at the end of two years, you would have $11,600 because you only earn interst on the principle.After three years you would have $12,400.However, with compound interest, you will earn interest on not just the principle, but the compounded interest as well.Therefore, with compound interest, at the end of two years, you would have 11,664.After three years it would be $12,597.12 and so on.


In Excel the electronic spreadsheet you work in is called?

Workbook


Who use a spreadsheet in their daily work?

Your mom bicth


How electronic spreadsheet work?

with study at string electronic.

People also asked