Construction Interest Calculation

  • Lizzie Boyer
    Keymaster
    6 years, 6 months ago #2664

    How is construction interest calculated?

    Spencer Burton
    Keymaster
    6 years, 6 months ago #3186

    The construction interest is modeled on the Dev-Interest Calc tab (show that tab by setting F43 on the Summary tab to ‘Show’). Interest is calculated as the Construction Interest Rate (Sources and Uses C15) divided by 12 (to arrive at a monthly interest rate) times the construction loan balance in each month (row 21) plus any accrued interest. This calculation is a circular reference, hence the ‘Set Construction Loan Amount’ macro on the Sources and Uses tab which iterates the calculation to arrive at an interest reserve and total construction loan amount.

    Anonymous
    Inactive
    5 years, 1 month ago #3188

    Follow up question: How do I reduce the interest reserve number by the amount of available operating cash flow that could be used to pay it before full stabilization and a take-out loan is arranged? This causes the interest reserve to be too high. Am i missing something?

    Dan

    PS: I realize I’m posting this question on a couple of threads. Sorry for any inconvenience.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.