Results 1 to 5 of 5

Thread: Discounted Cumulative Interest Calculation in One Cell
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2018
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Discounted Cumulative Interest Calculation in One Cell

    I am trying to discount cumulative interest over a period of time.

    Say I have an original mortgage for $100,000 and a term of 60 months, then the borrower prepays on month 1 for $50,000. I want to know what the cumulative interest lost over that period is at a discounted rate of 15%.

    I want to do this without having to build an amortization table, ideally want to do it using a formula in one cell.

    Thanks

  2. #2
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,587
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Discounted Cumulative Interest Calculation in One Cell

    Hello,

    Which formula are you using to calculate interest ...???
    Last edited by James006; Nov 5th, 2018 at 12:28 PM.

  3. #3
    New Member
    Join Date
    Sep 2018
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Discounted Cumulative Interest Calculation in One Cell

    I'm using CUMIPMT.

  4. #4
    New Member
    Join Date
    Sep 2018
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Discounted Cumulative Interest Calculation in One Cell

    The problem I'm having is CUMIPMT is really just the combined cumulative interest undiscounted. What I really need is a way to discount each period of lost interest then sum the total.

  5. #5
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,587
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Discounted Cumulative Interest Calculation in One Cell

    Hi,

    In terms of the formula you are using to calculate interest ...

    1. Do you have a fixed annuity ...

    2. Or is it interest on remaining outstanding capital ?

Some videos you may like

User Tag List

Tags for this Thread

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
  •