![]() ![]() We will cover this type of copy-paste macro as well as a DSRA target balance copy-paste macro in this tutorial. In this quite common situation the debt limit will be calculated as the total amount of principal repayments able to be paid over the loan tenor given the project cash flows (CFADS / DSCR – Interest), however the interest in this calculation is dependent on the debt limit as this affects the amount of debt drawn initially and therefore will depend on itself (a circularity). The typical project finance example is the case of debt sizing based on a DSCR-sculpted repayment methodology. A circularity just means that the value of a cell is dependent on itself and therefore Excel cannot properly calculate as a result. You may have encountered a circular reference in your modelling before or seen the dreaded pop-up and blue arrows, however you may not necessarily know what a circularity is or why they exist in financial models. This tutorial will demonstrate the best practice approach to implementing such copy-paste macros and discuss potential optimisations which will help you in applying this code robustly and efficiently in different situations. Although VBA is to be avoided where possible in project finance models, due to the inherent circularities in some aspects of project finance calculations VBA is sometimes needed to implement copy-paste functionality in a model in order to ‘break’ these circularities.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |