What is a Rent Schedule Module? In this Watch Me Build video I reveal you how to build a custom lease schedule module for long-lasting leases. The foundation of the module is a simple INDEX/MATCH combination that takes a rent schedule and models the rent cash flows across the entire hold period. I likewise consist of an optional file that you can download and use to follow in addition to the video. That file consists of both a 'Template' and 'Completed' tab. You're likewise welcome to take the finished version, and incorporate it directly into your own design. Are you an Accelerator member? See the 'Modeling Short-Term and Long-Term Leases course in the curriculum. Additionally, if you're an Accelerator Advanced Member check out course 4, lesson 7 of the 'Advanced Modeling - Residential Or Commercial Property and Portfolio' recommendation for additional strategies for modeling leases. Not yet an Accelerator member? Consider joining the property financial modeling training program utilized by leading property business and elite universities to train the next generation of CRE specialists. A rent schedule is a table that lists out the base lease by date. So for example, the lease schedule for a 75,000 SF spaced leased to an industrial on a 7-yr lease with 0.15/ SF bumps every year. Rent/Yr - Jan 1, 2018 - $337,500. Jan 1, 2019 - $348,750. Jan 1, 2020 - $360,000. Jan 1, 2021 - $371,250. Jan 1, 2022 - $382,500. Jan 1, 2023 - $393,750 The rent schedule is consisted of in the lease to lay out the base lease paid by the tenant. So using the lease schedule above, we understand that the tenant pays $382,500 rent in 2022 ($ 31,875/ month). The rent schedule thus becomes an important input for modeling the possible rent of a residential or commercial property. A lease schedule module is a part of a real estate model that forecasts the potential rental earnings over the hold period.