Convert Excel Spreedsheet to Python
Budget: $30 – $250 USD
I have a debt sizing model in excel that I need converted into python (most likely using Jupyter). The annual revenues are variable, so a loan amortization model doesn't work. Also, need to loop through all the revenues in order to maximize the sizing.
Here is a brief example:
Debt service coverage factor = 1.20x
Revenues = variable (assume they are increasing over time)
Annual Interest rate = 5.5%
term/years = 30
For example, the excel equation is this (Revenue/debt service coverage factor-semiannual interest (next period)*2)/(1+interest rate)
Basically, python needs to size level debt service coverage (annual revenues / annual debt service = 1.20x) and return back principal in the years in which it can. Annual Debt Service can not exceed annual revenues
Here is a brief example:
Debt service coverage factor = 1.20x
Revenues = variable (assume they are increasing over time)
Annual Interest rate = 5.5%
term/years = 30
For example, the excel equation is this (Revenue/debt service coverage factor-semiannual interest (next period)*2)/(1+interest rate)
Basically, python needs to size level debt service coverage (annual revenues / annual debt service = 1.20x) and return back principal in the years in which it can. Annual Debt Service can not exceed annual revenues