0
How do you work out interest accrued on spreadsheet for compound interest?
Wiki User
∙ 9y ago
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
∙ 9y ago
Wiki User
∙ 9y agoSuppose
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
Add your answer:
Earn +20 pts
How does simple interest work?
Multiply together the capital, the interest rate (as a fraction) and the number of periods to find out the interest.
Why APJ Abdul Kalam did not marry?
due to his interest and work as scientist and other he was not married
Why are Kpop stars not allowed to be in relationships?
They are concentrated on their work, having a romantic interest is impractical in their booked schedules. The executives usually force them into signing contracts forbidding such acts during their tenure.
Do NGOs in India really work for others or work for their own vested interest- for gd?
Ya.. NGOs play major roll in our country..they are stood behind overcome poverty who needs help in critical situations like Gathering food, Living in hut , die with normal disease also...
What is the summary for our local team poem by Ruskin Bond?
Indian youth have become inspired by great cricketers from around the world.The game has caught on like hot fire.Children who show interest in the game are often on the look out for support and encouragement from all quarters.sometimes however,some games don't work
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.
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 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.
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 compound interest work on loans?
It's when you have to pay interest on the principal cost and on the interest from past years.M = P( 1 + i )nM is the final amount including the principal.P is the principal amount.i is the rate of interest per year.n is the number of years invested.
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 work out compound interest?
P{1-r/100}^n _p where p is the principal and r the rate and n the years
How electronic spreadsheet work?
with study at string electronic.
Accrued payroll is based on work performed in a period but paid in the next period?
false
Is Accrued payroll based on work performed in a period but paid in the next period?
false
Is accrued payroll is based on work performed in a period but paid in the next period?
false
