Hi All,
I need a simple amortization schedule by month where:
Opening Balance = Closing Balance of Month -1
Amortisation = e.g. 30% of Opening Balance *-1
Closing Balance = Opening Balance + Amortization
I created three separate metrics but I am struggling - I am getting a circular reference when calculating Amortisation. Can you help?
Regards,
Adam
Best answer by Benoit
View original
+12
Hi Adam,
To avoid the circular reference I believe you can reverse the logic by starting from your output:
I made a little model to help you:
Steps:
I hope it helps, also I’ll inquire about existing models so we can share better insights about this use case.
Best,
Benoit
+12
And we do have exisiting models that are covering this use case and that can be added on to your workspace upon request. They are called:
If you’re under implementation, you can refer to your CSM or SA.
If you’re already implemented, you can create a support ticket to request these models.
Hope that helps.
Best,
Benoit
Thanks Benoit, it helps. I do not think I need and existing model as I need to apply this logic to other calculations in the balance sheet. I will check it out though.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
