G
Guest
Excel template: Loan Amortization for random/irregular payments, figures days
between payment dates.
I have a loan with a variable beginning balance and irregular payments with
annual large payment. (based on collections)
Would like to enter payment and date.
then Excel would figure days since last payment, interest amount, principal
amount, Ending Principal balance.
And total interest paid, total pricipal paid
If I change the starting principal, excel would recalculate all entries.
I have tried to use Mr Excel on Excel example on page 389 for random
payments, but it does not work.
I am a complete novice with excel. Looking for a template or help--someone I
could send excel file to help me set it up
between payment dates.
I have a loan with a variable beginning balance and irregular payments with
annual large payment. (based on collections)
Would like to enter payment and date.
then Excel would figure days since last payment, interest amount, principal
amount, Ending Principal balance.
And total interest paid, total pricipal paid
If I change the starting principal, excel would recalculate all entries.
I have tried to use Mr Excel on Excel example on page 389 for random
payments, but it does not work.
I am a complete novice with excel. Looking for a template or help--someone I
could send excel file to help me set it up