Construction Interest Calculation
-
Lizzie BoyerKeymaster6 years, 6 months ago #2664
How is construction interest calculated?
Spencer BurtonKeymaster6 years, 6 months ago #3186The 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.
AnonymousInactive5 years, 1 month ago #3188Follow 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.
You must be logged in to reply to this topic.