Calculate Effective Rent Spreadsheet
  • Calculate Effective Rent Spreadsheet
  • Calculate Effective Rent Spreadsheet
Originally published: 04/10/2016 17:51
Last version published: 20/03/2019 16:00
Publication number: ELQ-85493-3
View all versions & Certificate
certified

Calculate Effective Rent Spreadsheet

Determine effective rent of landlords and tenants while considering discount rates and uneven rent payments.

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.

This business tool includes
1 Excel spreadsheet

Acquire business license for $9.00

Add to cart

Add to bookmarks

Discuss

Reviews


keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Calculate Effective Rent Spreadsheet

The user community and author are here to help. Go ahead!

  • Mike Terranova
    Also is there a similar spreadsheet for gross effective rent?
    arrow_drop_uparrow_drop_downReply reply
    • Mike Terranova
      How can I increase the length of the lease term beyond 5 years on this sheet?
      1arrow_drop_uparrow_drop_downReply reply
      please wait...