Hi everyone,
I am making a DCF model for a project, and it asks to consider capital reserves for each unit. I can PM you if you want more details and photos. But there isn't much online about capital reserves being used in a DCF model. Is anyone familiar with this? Thank you.
| +30 | Uncertain of what To Do Next | 5 | 1d |
| +29 | What should we be buying? | 23 | 41m |
| +28 | Capital Restricted Developer | 2 | 2d |
| +27 | Basis play / value-add office in high-growth markets - value trap or generational buy? | 10 | 3d |
| +23 | Warning: J. Shaw Recruiters | 5 | 2d |
| +20 | Laughable Job Posting | 3 | 1d |
| +18 | Due Diligence - ALTA Survey | 3 | 2d |
| +15 | Seeking Advice: How Do You Get Value from ULI Membership? | 2 | 5d |
| +11 | PGIM Real Estate Equity vs. Private Credit | 3 | 5d |
| +6 | First-year REPE analyst comp check (London) | 1 | 3d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Could be wrong, but I thought it was after NOI and incorporated when calculating unlevered and levered returns. But, you do not include it when calculating sale proceeds.
I have seen CapEX as a whole included in DCFs from appraisals and also not included from appraisers.
After NOI, before debt service. Create a sweep account that you add to every month, then as the units turn you get hit with the capital expense and it gets offset by pulling from the sweep account. I just put the sweep below the model where I do debt service.
NOI
Capex Reserve
Capex
(Sweep Used)
CFO
This. Have the model add up the sweeps and then budget out capex needs. As capex and turnover occurs, you can draw down on the balance that's been accrued.
Building on the above comments - if you don't have a specific capex budget or additional W/C is being carried for major capex items, it doesn't mean you shouldn't have a capex reserve. My firm models capex reserve as an additional buffer on top of the capex budget for unexpected costs, as opposed to using it as a sweep account to offset.
EDIT: To your question about incorporating in a DCF - if this is an acquisition model and you're modeling returns, then follow the above. If you're just trying to get a value for the property then capital reserves may or may not be factored in depending on your company's practice. Some will discount adjusted NOI net of capital reserves (and even leasing costs at times), others will just discount base NOI (this is the more standard practice).
Quos velit sequi commodi aliquam. Enim ut veritatis voluptate quam dolorum voluptatem autem.
Ut consequatur expedita temporibus qui et perferendis id laudantium. Fugiat quis aut quisquam totam minima. Qui non illum ut dolor excepturi sequi est et. Numquam quia illum ad. Delectus quia veritatis hic veritatis nemo. Voluptate consequatur hic magnam similique nihil sequi ut asperiores.
Quibusdam qui libero deleniti nisi dolorem nihil. Iusto consequatur voluptas sed autem dolorum.
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...