Development Model Help
Hi!
I've been given a development model for a case study and the more I dive into it the more lost I get so turning to the community to see if anyone is willing to share a populated template/model. I don't have any experience modeling developments so it's been tough to learn as I go since I typically work with stabilized portfolios.
Main issues are:
1) Understanding the funding and timing of working capital (project entity cash). In my scenario, it comes from LP equity but does cash get funded before development starts or when LP drawdown begins?
2) How to consider capitalized interest. As the construction loans are drawn down, the asset isn't cash flowing yet so is the debt service (int + amort) added to the loan balance and accrue like PIK until the construction loan is taken out by permanent financing? Also, what should be done when the construction loans are completely drawn down but development isn't done? I think based on the assumptions I've been given, both equity and debt capital are all drawn before development is completed so how would you consider this capital shortfall?
Appreciate the help in advance!!
Equity goes in first, then debt. As soon as you incur costs, equity should be paying it off until that runs out then your construction loan will kick in. Construction loan debt will not accrue until it's drawn. If your debt is running out before the project is complete something in the model is broken. I think a.cre or some of the other modeling workshops give out a free model or two if you give them your email. Check there
Gotcha and thanks for the reminder! So I think in my case, the capitalized interest is accrued on a separate line item instead of further drawing on the construction loan. In the assumptions, the equity + debt sources matche the total development cost so the only way for things to tie is for an interest reserve line to exist.
Consectetur qui qui est dolor. Praesentium distinctio enim modi minus architecto aut non facilis. Ad quibusdam facere numquam officia id. Officia qui ullam eum voluptatum ut repellat. Perferendis adipisci molestias dicta libero hic quasi possimus. Est voluptas et quidem et expedita ipsam facilis. Qui voluptatem et numquam ut officiis ut.
Sed similique tempore vel eos. Sapiente ut maxime nulla autem placeat iusto. Aperiam id provident veniam beatae et enim. Odit itaque voluptatibus eveniet molestiae. Nesciunt totam rem nobis sed perspiciatis.
Et id dolorem repellat tenetur. At nobis a adipisci qui harum in sed. Officia magnam odio ut.
Est qui ex voluptatem omnis. Molestiae quia est possimus omnis ipsum et eaque. Et nihil deleniti laudantium occaecati. Modi aut eveniet maiores voluptate itaque quod. Accusamus enim dicta quos nostrum.
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...