Excel template: Loan Amortization for random/irregular payments, .

V

Vear01

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top