Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Loan Amortization

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a group of mortgage loans I want to amortize the first 5 payments listing the detail principal and interest payment separately. Is there an easy way to do this? Can you do this efficiently in a pivot table?

  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-06 13:15, Lalic wrote:
    I have a group of mortgage loans I want to amortize the first 5 payments listing the detail principal and interest payment separately. Is there an easy way to do this? Can you do this efficiently in a pivot table?
    I believe this was answered for you by Paul B at:

    http://www.mrexcel.com/board/viewtop...1454&forum=2&1

    Was the response not sufficient?

    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  3. #3
    Guest

    Default

    I don't know about pivot tables, but if you use the PMT function to figure out the total payment, then figure the interest paid by (Current Balance*(Interest Rate/12)), the difference between those numbers will be your payment toward principal.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    WA state
    Posts
    412
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    See help on the CUMPRINC and CUMIPMT functions. That's exactly what you need.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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