Test the maximum term-loan refinance on income (ICR) and value (LTV) against your development redemption figure.
Inputs
Workings
Gross annual rent
Less haircut
Net income for ICR
Gross yield on GDV
Net yield on GDV
Pay rate (base + margin)
Stressed interest cover (rate × ICR)
Max loan on income
Max loan on LTV
Gross refinance (lower of the two)
Less lender fees
Net refinance proceeds
Gross loan needed to clear redemption
ICR at that loan
LTV at that loan
Break-even rent to clear redemption
Max on income (ICR)
Max on LTV
Yield on GDV
Maximum refinance (net of fees)
For illustrative purposes only. Magnet Capital does not provide term lending. This calculator shows how a term lender might assess a refinance, based solely on the figures entered. It does not constitute an offer or agreement to lend.