Calculate Effective Rent Spreadsheet

Description
This template aims to adjust uneven rent payments to ultimately make the effective rent (in other words the equivalent period payment) have the same present value. Three things are considered here: discount rates, the perspectives of landlords and the perspectives of tenants.

In the landlord's perspective, the following inputs are needed:
- SQFT Leased
- Term (In Months)
- Commencement Date
- Contract Rent
- Month Free Rent
- Above TI
- Annual Escalations
- Discount Rate

In this, we get the following outputs:
- Effective Rent Monthly
- Per Sq ft Per Month
- Per Sq Ft Per Year

In the tenant's perspective, the following inputs are needed:
- SQFT Leased
- Term (In Months)
- Commencement Date
- Contract Rent
- Month Free Rent
- Above TI Provided By Landlord
- Annual Escalations
- Discount Rate
- TI Paid by Tenant
- Occupancy expenses PSF
- Growth Rate in Operating Expenses

Lastly we get the correspondent outputs:
- Effective Rent PSF
- Effective Rent Monthly
- Level Annuity Cost to Occupy PSF
- Level Annuity Cost to Occupy

by Prof. Norm Miller, PhD

If you have any questions about this tool, feel free to start a discussion below, or privately message via my Eloquens author channel. If you've enjoyed using this tool, please show your appreciation by leaving a review or a rating after use.