Net Effective Rent Calculator
I am looking for a effective rent calculator that takes into account lease type (Full Service, Net Lease, and Modified Gross), TI costs, Operating expenses, Lease term, Free month(s), Discount rate etc.

How do these factors affect Net Effective rent? Also, has anyone found a good glossary that explains these terms?
[{"id": "g27i86v", "text": "That takes like 35 seconds to build in excel. Net effective rent is the sum of the total rents (+CAM if MG/NNN or - expenses If gross), less leasing commission, TI expense, and landlord work, divided by the number of months of the lease (including free rent period). NPV of it is just throwing a discount rate onto the entire cash flow, where DR is typically your deal level IRR", "replies": [], "depth": 1}]