LIHTC Ground-Up Development Model
Hi all,
I am working to develop a 9% LIHTC model for my shop and am getting stuck on how to make the financing section dynamic enough to run through projects quickly. Does anyone have an active model that they could share for reference?
Thanks in advance
Interested as well
There are all sorts of nuances to tax credit development deals:
All this goes to say, you're not going to get a one size fits all model, but ou can certainly develop a model for a specific state that is dynamic. Also, people aren't going to share a model with you because they've probably curated it for a specific state, so it won't be very generic and therefore more of an IP issue.
In your development budget section add a column for percent basis eligible. If not eligible you can quickly go and zero out specific items for ease of adjusting basis calculations.
Always calculate net fee and deferred fee. Have a set of "check" inputs that will let you know if your dynamic calculations exceed the limits you have input.
Same as fee
Not much help here
Add a line item for syndication expenses to your budget. They won't be basis eligible.
In your pay in have these tied to event driven dates (% completion, Perm loan, 8609) then build your construction period flow of funds with the ability to match to those dates.
Same as 6, just account for timing and interest in your FoF
Use the check method to make sure your net fee is ok. Input the deferred fee as a loan with the rest of your sources.
Generally treated as loans.
CF waterfalls are generally a PITA but tied to dollar amounts rather than %s so its pretty easy to slap one together for a new deal.
Yup, that's the way to do it. Then either create one for each state with slightly different calculation for developer fee and syndication costs/random jurisdiction related fees or create a table that does it based on a state selection drop down. That way the base will be the same, but the various random things that each state does different will require you to either refer to X if state is NJ or Y if NY or Z if California, etc.
Maybe you can share your base model with OP.
They'll learn more from building it themselves. Other than basis calcs they aren't any different than regular models.
Et odit totam ut voluptatibus. Nobis molestiae vitae rerum et rerum. A et accusantium minus voluptas eum. Possimus distinctio eos quasi neque ab qui. Doloribus soluta architecto quis aliquam et nam aliquid iure.
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...