Calculating Retail Tenant Sales PSF and Occupancy Cost
- 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
What is the purpose of this Excel workbook?
The workbook is designed to calculate tenant sales per square foot (PSF) and the occupancy cost ratio for retail tenants in a commercial property.
How many times has this workbook been downloaded?
This workbook has been downloaded 3,085 times.
Can the workbook handle multiple tenants?
Yes, the workbook is designed for use with an unlimited number of tenants.
What key metrics does this workbook calculate?
It calculates two key metrics: retail tenant sales per square foot (PSF) and occupancy cost ratio.
Is the workbook easy to integrate into other models?
Yes, it is built on a single tab, making it simple to export and integrate into other retail Excel models.
What is the occupancy cost ratio and why is it important?
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.