Transcription of Tutorial on Excel Rent Roll Modeling to Enhance DCF
{{id}} {{{paragraph}}}
Tutorial on Excel Rent roll Modeling to Enhnace DCF JR DeLisle, Tutorial on Excel Rent roll Modeling to Enhance DCF. Overview In a basic Discounted Cash Flow Model, income and expenses are often treated as a single line item. This approach has some appeal and is adequate for preliminary analysis or for analysis of a single-tenant building on a NNN lease. However, it lacks the precision needed for fine-tuning the value of a multi-tenant building, or a building in which more detailed treatment of expenses is warranted. The objective of this Tutorial is to explore two enhancements that can be incorporated in DCF models: First, we will discussion how the rent roll for a multi-tenant building can be modeled to arrive at more precise forecasts of gross income. Second, we will explore the treatment of fixed and variable expenses in term of different types of leases and allocation of expenses.
Before launching into an example of constructing a rent roll, along with related expenses and other financial elements, it is useful to see where this type
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}