Modeling Construction Loan Extension
Like the title, how do you model a loan extension (3+1+1 or 4+1)? I've never had to do this before and there is an extension fee attached to the option. Anybody able to give a quick and dirty explanation on how this is to be structured?
Generally the extension term for construction loans has some significant hurdles it needs to hit to be exercise-able. Usually the project needs to be complete with a certain % of units leased (in MF) or hitting a certain LTV and DSCR. Generally construction loan extensions are designed on the basis that you'll be done with the construction and for whatever reason need some time to get your perm financing. There is also more often than not an amortizing component to construction loan extension terms.
If you already new the above then in terms of modeling there's not much to it. You'll need to make an assumption about what LIBOR will be (like you have to for the original term of you construction loan) and plug in your extension fee and if applicable the amort.
If you have any specific questions I'll be happy to reply.
Agree with the above. Not that much to it other than assuming 4 or 5 year term vs. 3 year initial term, making sure you hit the extension tests, modeling in the extension fees, and make sure the loan starts amortizing down if that's how it's structured.
Got it. Thanks for the responses. In terms of modeling it, would you create an additional line item for the extension fees and some sort of =IF/THEN statement or just kind of wrap it into the initial debt service line item?
Where exactly are you getting tripped up? Just change whatever cell is driving your debt schedule...so if it's a 3 year term, but you want to underwrite an extension, change the 3 to a 4.
Reprehenderit et amet et recusandae ut. Cumque porro beatae aspernatur sit aut dolorem laboriosam. Saepe velit distinctio laboriosam et quia cum amet delectus. Autem mollitia sint voluptatibus consequatur dolore nisi aut consequatur. Laboriosam iusto exercitationem magni aut autem repellat. Ipsum porro distinctio exercitationem. Totam culpa et qui provident maiores. A magni consequatur ducimus vitae.
Perferendis ipsa aperiam consequuntur enim. Dolores aut molestias ipsam et architecto laudantium. Id voluptatum sint dolorem porro quasi minus est. Quia eaque qui omnis officiis.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...