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 month. If i use the PPMT function, can i use this, my
starting point as my first period, even though it is not the first period of
the loan. i do not have the loan origination date. thanks.