G
Guest
Hello,
I have created a chart for a loan I have. It shows the future payment dates
(bi-weekly), interest paid, principal paid and outstanding balance. It
calculates it out until the loan is repaid. What I would like to do is add 2
columns for additional payments. I want one column so I can input the date of
the extra payment, and the other the amount that is applied to the principal.
The trick is that I want Excel to take the date and insert it in
chronological order with the existing dates, and then take the amount off the
principal and re-calculate the rest of the data until the loan is paid down.
Oh, and not to calculate interest on that payment, since it's principal only.
Any help you can give would be great. Thanks!
I have created a chart for a loan I have. It shows the future payment dates
(bi-weekly), interest paid, principal paid and outstanding balance. It
calculates it out until the loan is repaid. What I would like to do is add 2
columns for additional payments. I want one column so I can input the date of
the extra payment, and the other the amount that is applied to the principal.
The trick is that I want Excel to take the date and insert it in
chronological order with the existing dates, and then take the amount off the
principal and re-calculate the rest of the data until the loan is paid down.
Oh, and not to calculate interest on that payment, since it's principal only.
Any help you can give would be great. Thanks!