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.
| +23 | SWF/Pension Funds in RE | 3 | 4d |
| +15 | Development vs. REPE pay gap | 7 | 14h |
| +13 | PGIM Real Estate Equity Opinions? | 9 | 1d |
| +13 | CRE Credit → Capital Markets | 2 | 2d |
| +11 | PRE MBA IB back to IB | 5 | 16h |
| +10 | Reneging - What should I do? | 5 | 2h |
| +9 | To the veterans: What was institutional dev actually like during the last bull run? | 1 | 1d |
| +8 | REPE AM Modelling Test / Case Studies? | 2 | 4d |
| +7 | MBA Pipelines for REPE | 6 | 2h |
| +6 | JD/LLM career path to REPE advice | 1 | 4d |
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).
Veniam molestias nisi voluptatem dicta nihil laborum ut. Neque et ab maxime et ipsum asperiores assumenda. Est minima ut consequatur accusantium natus rem velit. In illo expedita numquam distinctio doloremque. Est qui sunt et vel enim nihil.
Ullam veritatis ea rerum. Consequuntur culpa repellat deleniti deserunt et. Nam vel enim fugiat odit vero et est. Error ut quo animi sint doloremque numquam. Necessitatibus voluptas ex maxime. Voluptatem ducimus odio qui quo.
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...