+ Reply to Thread
Results 1 to 2 of 2

WANTED: Excel template for loan payment record with random/irregular payments

  1. #1
    cassidy
    Guest

    WANTED: Excel template for loan payment record with random/irregular payments

    A previous poster explained what I also need; there were no responses,
    so I thought I would try again.

    Does anyone know of an Excel template--or a small stand-alone
    program--that will calculate the interest/principal breakdown when
    payments are varied in amount and frequency? Free or low-cost, please.
    I need one that will work on my Mac/Office 2004. I will need to print
    out periodic reports.

    Here is the way the previous poster described it:
    "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."

    Thanks very much.


  2. #2
    Dave O
    Guest

    Re: WANTED: Excel template for loan payment record with random/irregular payments

    Microsoft offers this template

    http://office.microsoft.com/en-us/te...&AxInstalled=1

    ....which you could alter to do the things you need.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1