calculating interest reveived

Trotzali

New Member
Joined
Jul 3, 2016
Messages
17
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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,394
Office Version
  1. 365
Platform
  1. Windows
It would be helpful if you would provide some sample data together with desired outcomes.
 

Watch MrExcel Video

Forum statistics

Threads
1,133,532
Messages
5,659,368
Members
418,499
Latest member
mbcmel

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

Which adblocker are you using?

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
Top