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

1. ## 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  Reply With Quote

2. ## Re: Discounted Cumulative Interest Calculation in One Cell

Hello,

Which formula are you using to calculate interest ...???  Reply With Quote

3. ## Re: Discounted Cumulative Interest Calculation in One Cell

I'm using CUMIPMT.  Reply With Quote

4. ## 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.  Reply With Quote

5. ## 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 ?  Reply With Quote

## User Tag List

cell, cumulative, discounted, interest, period 