Hi, I have one large file and I need to compute the final value of investing a particular amount based on the returns given by the stock market. I'm trying to figure out a way that I can compute the answer without going into cell after cell with the same kind of formula. The formula that I'm looking for is like the formula for a compound interest. I.e. Final value = P(1+r)^n. However, in my case, r is always changing and hence P is also changing as well. What I'm currently doing is typing the same kind of formula into each cell. For example to find the year-end value I input: 1000(1.05) then the next year, the year-end value is this: (1000)(1.05)(1.10), and the next may be (1000)(1.05)(0.96)...and so on....does anyone know of a simpler way to do this?
Hi
I want to know the function to calculate the SI and the CI in Excel. I know manually we calculate the Simple Interest = P*R*T and compound Interest = P(1+i)^n . When I calculate the SI using inbuilt function of Excel i.e. PMT as shown in the following link
http://www.ehow.com/how_4813646_calc...est-excel.html
It given right answer. But if on same data i apply P*R*T it gives something different. Also I saw following site
http://www.busysoftorder.com/npv/1.htm
it uses FV function. Kindly advice how to calculate the Si and CI using inbuilt functions. I just want to calculate it when there is no change in the rate of interest in the subsequent years and it will remain same.
Regards
Harbinder Singh
I'm trying to find an elegant way of calculating compound interest on outstanding debts; one big problem is that clients occasionally make ad-hoc payments so I need to maintain a running total, using a changing bank base lending rate. I have taken quite a long look round and it seems this question has not come up before, I hope!
Hi
I need to create a formula that calculates compound Interest.
Eg:
I deposit $10 000 in the bank.
I earn 4% interest annually, paid monthly
If I leave the money for 5 years, How much interest would I earn?
Thanks
How can I calculate the amount I would receive in compound interest on a
fixed amount at a fixed interest rate for a fixed peirod. Should be easy !
How to calculate past due fees on balances over 30 days past due?
The balances are past due for 1 to 40 or more months. The monthly payment is 1500.00 and a 10% past due fee is to be added to the balance each month plus the previous months interest. Is there a formula to show interest each month and the new balance by month?
Hello,
I'm doing a project for university and am having some real trouble...
And it is due by midnight!
Attached is the required information...
I only really need help with the first page (Array formulae).
Thanks for any urgent responses!
Az
