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 |
= 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 | = Asking NOI / Asking Price | = going_in_noi / broker_guidance_price |
| Asking PSF | = Asking Price / Rentable Sq. Ft. | = broker_guidance_price / rentable_square_feet |
| Asking Price Per Acre | = Asking Price / Parcel Acres | = broker_guidance_price / parcel_size |
| Asking Price/Unit | = Asking Price / # Units | = broker_guidance_price / unit_size |
| Internal Cap Rate | = Internal Price x Internal Cap Rate | = bid_price x bid_cap_rate |
| Internal NOI | = Internal NOI / Internal Cap Rate | = noi / bid_cap_rate |
| Internal Price | = Internal NOI / Internal Price | = noi / bid_price |
| Internal PSF | = Internal Price/ Rentable Sq. Ft. | = bid_price / rentable_square_feet |
| Internal Price Per Acre | = Internal Price / Parcel Acres | = bid_price / parcel_size |
| Internal Price Per Bed | = Internal Price / # Beds | = bid_price / num_beds |
| Internal Price Per Key | = Internal Price / # Keys | = bid_price / num_keys |
| Internal Price/Unit | = Internal Price / # Units | = bid_price / unit_size |
| Sale PSF | = Sale Price / Rentable Sq. Ft. | = sale_price / rentable_square_feet |
| Sale Price Per Acre | = Sale Price / Parcel Acres | = sale_price / parcel_size |
| Sale Price/Unit" | = Sale Price / # Units | = sale_price / unit_size |