# calculating interest reveived

#### Trotzali

##### New Member
I need to calculate the interest I would get from writing multiple loans. (Interest payments only)

Where:

Loan Amount is E8 (this will be an average - set number)
Interest Rate is E11
Duration of loan (yrs) is E12
Loans written per month is E7

I want a column showing months Jan '17, Feb '17 etc. - G4 down

Then in I4 - I need the calc for the interest received for that month.

So If (E7=10) and I had 10 lpayments incoming in Jan '17, then I4 would show interest received for that month from 10 loans.
In the following months, the figures in column G would increase as I would have more interest payments coming in each month. So in Feb '17 (I5) I would have 20 payments incoming, March '17 (I6) - 30 payments etc...

Then after the Loan duration (E12) is up for the first loans, I expect that the figures should even out as the original loans from Jan '17 would be paid out Jan '20. So 10 loans would stop but another 10 would sign up. (Assuming new loans per month stays constant)

Sounds a bit confusing to even me, and I wrote it.

Hope someone can decipher my ramblings.

Thanks in advance

Last edited:

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

#### DRSteele

##### Well-known Member
It would be helpful if you would provide some sample data together with desired outcomes.

Replies
4
Views
503
Replies
1
Views
580
Replies
1
Views
792
Replies
0
Views
683
Replies
3
Views
216

Threads
1,171,630
Messages
5,876,539
Members
433,199
Latest member
guerin47

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back