interest

Is there a way to create some kind of output into multiple cells? For instance, I have a dollar amount that I want to increase by 5% each year but I don't know how many years yet. But based on user input (say 10yrs) 10 cells would be created, each 5% larger than the next?

I am giving a loan with a large initial disbursement, and then once certain contingencies are met, there are other disbursements. Payments won't start until next year, and then will be quarterly. (The assumption is that all the disbursements will happen before payments start.) I am trying to...

I am trying to develop a spreadsheet that will enable me to calculate the exact amount of accrued interest (compounded annually based on actual investment date). Typically I would just use a FV formula, but that only works if there is an investment made DAY 1 and no subsequent transactions...

Hi there, I am needing to do some calculations on a loan, the tricky part is that the interest and the payment is not the same. Lets see how to explain PV = 200.000 PMT = ?? (added monthly) Interest = 10% pro anno (but added quaterly) FV = 0 Can excel with out making a tabel calculate the...

Hi I have a series of 5 capital payments over a period of years and then two repayments with a few years in between. How can i use excel to calculate the inherent interest rate if it was compound and simple. So, say: Loans out of: 5 June 1998 68,900 5 June 1999 98,950 5 June 2001 384,900...

Does anyone know how to adjust the IPMT and PPMT formulas to account for a 365 day year versus a 360 day year? Or is there another way for this to be done?