hardgrafting
New Member
- Joined
- Feb 6, 2017
- Messages
- 25
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
<colgroup><col><col><col></colgroup><tbody>
</tbody>
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>