Default / Calculated System Fields
Learn more about the system fields in TermSheet that are set up to populate a value based on their relationship to other fields.
System Fields are fields that come pre-populated into every workspace. Below is a list of system fields that will automatically populate a value based on entries made in other system fields.
If you decide to hide and replace any of these system fields, reach out to a TermSheet representative to get assistance to adjust the associated calculations.
Column 1 is the System Field that will be populated
Column 2 is the equation that populates the System Field. This is by Label Name which is visible in the UI.
Column 3 represents the same equation as column 2 but shows the Field Name instead of the label name.
| System Field | Equation (Label Name) | Equation (Field Name) |
| Asking NOI going_in_noi |
= Asking Price x Asking Cap Rate |
= broker_guidance_price x going_in_cap_rate |
|
Asking Price |
= Asking NOI / Asking Cap Rate | = going_in_noi / going_in_cap_rate |
| Asking Cap Rate going_in_cap_rate |
= Asking NOI / Asking Price | = going_in_noi / broker_guidance_price |
| Asking PSF guidance_price_per_sq_ft |
= Asking Price / Rentable Sq. Ft. | = broker_guidance_price / rentable_square_feet |
| Asking Price Per Acre guidance_price_per_parcel_acre |
= Asking Price / Parcel Acres | = broker_guidance_price / parcel_size |
| Asking Price/Unit guidance_price_per_unit |
= Asking Price / # Units | = broker_guidance_price / unit_size |
| Internal Cap Rate bid_cap_rate |
= Internal Price x Internal Cap Rate | = bid_price x bid_cap_rate |
| Internal NOI noi |
= Internal NOI / Internal Cap Rate | = noi / bid_cap_rate |
| Internal Price bid_price |
= Internal NOI / Internal Price | = noi / bid_price |
| Internal PSF price_per_sq_ft |
= Internal Price/ Rentable Sq. Ft. | = bid_price / rentable_square_feet |
| Internal Price Per Acre price_per_parcel_acre |
= Internal Price / Parcel Acres | = bid_price / parcel_size |
| Internal Price Per Bed price_per_bed |
= Internal Price / # Beds | = bid_price / num_beds |
| Internal Price Per Key price_per_key |
= Internal Price / # Keys | = bid_price / num_keys |
| Internal Price/Unit price_per_unit |
= Internal Price / # Units | = bid_price / unit_size |
| Sale PSF sale_price_per_sq_ft |
= Sale Price / Rentable Sq. Ft. | = sale_price / rentable_square_feet |
| Sale Price Per Acre sale_price_per_parcel_acre |
= Sale Price / Parcel Acres | = sale_price / parcel_size |
| Sale Price/Unit sale_price_per_unit |
= Sale Price / # Units | = sale_price / unit_size |