PPMT Function Repost

Thank you both (Fred Smith and JoeU2004) for your responses. My apologies for replying so late therefore have lost the thread! What I am trying to compile is an Annuity Template where the user enters the various parameters and all calculations are ...

Message posted on the April 24th, 2009 - 9:55 AM ET

PPMT Function

using Excel 2003 I have taken the following from the Excel Help. I cannot Understand exactly how this function works. 10% Annual interest 1 Period for which you want to find the interest 3 Years of loan 8,000.00 Present value of loan -2,000 FV ...

Message posted on the April 20th, 2009 - 11:05 AM ET

Excel Function inside FOR loop.

Please help. Why this little peace of VBA in a EXCEL project Work Well if inside the PPMT Function ,instead of i ,we put one numeric integer number, or a cell (with a integer number), but not with the i, wich is what we need to actualize each line? ...

Message posted on the January 30th, 2009 - 11:24 AM ET

Loan Principal Payments

I have a series of loans I am trying to calcluate the principal portion of the payment for. I have maturity date, interest rate, payment frequency, and current loan balance. I need to know how to calculate the remaining principal payments by ...

Message posted on the October 6th, 2009 - 3:48 PM ET

ppmt