Interest calculation

[hardgrafting]

I am trying to work out the interest rate of the below given cash flows.

I have a principal balance of 1000 and I am paying interest quarterly, at the dates where the 1 is denoted. The interest amount is the sum of the previous quarters cash flows.

So for example in the 30/09/2018 date, I will be able to pay interest of 120 + 10 (principal balance is 1000)

on the 31/12/2018 I will pay interest of 30+30+35 again principal is 1000.

The principal balance will also fall as will be making some principal payments, but just want to get the fundamental right for now.

How do I calculate the interest rate?

Thanks


Principal 1000

30/08/2018	120
30/09/2018	10	1
31/10/2018	30
30/11/2018	30
31/12/2018	35	1
31/01/2019	40
28/02/2019	45
31/03/2019	50	1
30/04/2019	55
31/05/2019	60
30/06/2019	65	1
31/07/2019	70
31/08/2019	75
30/09/2019	80	1
31/10/2019	85
30/11/2019	90
31/12/2019	95	1
31/01/2020	100

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[James006]

Hello,

Have you tried to use Excel's built-in function IRR() ...

Hope this will help