, ,

Calculating Retail Tenant Sales PSF and Occupancy Cost

Calculating Retail Tenant Sales PSF and Occupancy Cost
3089 Downloads
  • Basic Excel workbook showing the method I use to calculate tenant sales PSF and occupancy cost ratio
  • Use with unlimited number of tenants
  • Built in one tab for easy export to your Retail Excel Model

Frequently Asked Questions about Calculating Retail Tenant Sales PSF and Occupancy Cost

 

The workbook is designed to calculate tenant sales per square foot (PSF) and the occupancy cost ratio for retail tenants in a commercial property.

This workbook has been downloaded 3,085 times.

Yes, the workbook is designed for use with an unlimited number of tenants.

It calculates two key metrics: retail tenant sales per square foot (PSF) and occupancy cost ratio.

Yes, it is built on a single tab, making it simple to export and integrate into other retail Excel models.

The occupancy cost ratio compares a tenant’s total occupancy costs (e.g., rent, CAM, taxes) to their sales revenue. It’s a key metric used to evaluate a tenant’s financial health and rent affordability.