BuildingsOne Accounting & Operating Expenses (OPEX) Series comprises a complete set of documents and templates, that incorporate accounting, budgeting and operating expense (OPEX) concepts and applications, across a broad range of operational and administrative programs, routinely encountered in the commercial real estate industry. The Accounting & Operating Expenses (OPEX) Series includes a standard format property “Annual Operating Budget Workbook” (summary and detailed version) and a comprehensive “Annual Operating Expense (OPEX) Reconciliation Workbook”. Many of the Excel templates are multi-tabbed and formula-linked so that dollars ($’s) auto calculate with the template user’s “cell field input”. These templates are ready to download, for input and modification, to suit the property owner’s or manager’s specific requirements. Pre-formatted workbook ‘columns and rows’ provide helpful data, such as total $’s per year and $ per RSF information, automatically calculated upon input in the workbook “cell fields”. The operating expense (OPEX) documents encompass high-quality templates covering all aspects of OPEX concepts. Specific operating expense (OPEX) applications, including “Base Year”, “General Ledger Review”, “Gross Up”, “Multi-Year Expense Analysis” and “Operating Expense CAP’s” provide a unique opportunity, for BuildingsOne customers to ensure accurate operating expense reconciliations and statements while maximizing annual cash flow and long-term investment value for your property owners and investors.
-
Amortization & Depreciation – Concepts & Applications
{PDF Document}
Amortization & Depreciation – Concepts & Applications
{PDF Document}
3 page document introducing amortization and depreciation concepts encountered in the commercial real estate industry. Includes the review of 2 real estate applications pertaining to the amortization of a landlord’s Tenant Improvement CAPEX investment and the depreciation of expenses associated with an energy savings CAPEX project
-
Amortization Calculation Workbook Sample – CAPEX Project
{Excel Template}
Amortization Calculation Workbook Sample – CAPEX Project
{Excel Template}
Single tab, pre-formatted, formula-linked excel workbook illustrating the amortization (or depreciation) associated with an energy saving CAPEX project.
Includes instructions & supporting notes on the right side of the workbook.
-
Amortization Calculation Workbook Sample – Tenant Early Lease Termination
{Excel Template}
Amortization Calculation Workbook Sample – Tenant Early Lease Termination
{Excel Template}
Single tab, pre-formatted, formula-linked excel workbook illustrating the amortization (or depreciation) of a landlord’s CAPEX investment into a tenant lease (Tenant Improvement, Lease Commissions and Legal Expenses). Includes instructions and supporting notes on the right side of the workbook.
-
Annual Operating Budget Workbook – Office Property Detailed Format
{Excel Template}
Annual Operating Budget Workbook – Office Property Detailed Format
{Excel Template}
14 tab pre-formatted, formula-linked excel workbook with over 200 detailed revenue, operating expense and capital expense line item categories. The workbook includes industry standard entries and descriptions, for each category, that can be adjusted to suit the manager’s specific requirements.
Cell formulas automatically calculate $ per RSF, Total Revenue & Operating Expenses, NOI & Cash Flow.
The following tabs are included in the workbook: Budget Summary, Operating Expenses (7 tabs), RE Taxes, Non-Recoverable Expenses, CAPEX, Owner Expenses, Occupancy, and Tenant Income Details
-
Annual Operating Budget Workbook – Office Property Summary Format
{Excel Template}
Annual Operating Budget Workbook – Office Property Summary Format
{Excel Template}
5 page pre-formatted, formula-linked excel workbook including industry standard revenue, operating and capital expense categories.
-
Annual Operating Expense (OPEX) Reconciliation Workbook
{Excel Template}
Annual Operating Expense (OPEX) Reconciliation Workbook
{Excel Template}
Comprehensive 24 tab pre-formatted, formula-linked excel workbook including the following tabs: Trial Balance; Building Occupancy; Gross Up Calculations; Year End Adjusted Final OPEX; Tenant Multi-Year OPEX Comparison; Tenant OPEX Monthly Estimates; Tenant OPEX Lease Abstract & OPEX Recovery Summary; Tenant Invoice Tabs
The workbook and instructions represent a compilation all OPEX concepts and applications offered in other BuildingsOne documents. This workbook represents an industry best practice approach to the annual OPEX reconciliation process.
-
Capital Expense (CAPEX) Budget – 5 Year Building Improvement
{Excel Template}
Capital Expense (CAPEX) Budget – 5 Year Building Improvement
{Excel Template}
6 tab pre-formatted, formula-linked workbook consisting of 5 individual tabs (1 for each year) rolled up into a 5 Year CAPEX budget plan. 34 pre-formatted sub-categories roll up into the following industry standard categories: Building Envelope, MEP Systems, Life Safety & Security, Common Area Interior, Vertical Transportation and Roads & Grounds
-
Loan Amortization & Depreciation Schedule Workbook – Blank
{Excel Template}
Loan Amortization & Depreciation Schedule Workbook – Blank
{Excel Template}
Single tab, formula-linked excel workbook (blank workbook – no notes) for auto-calculation of amortization or depreciation associated with various commercial real estate applications.
-
Operating Expense (OPEX) Base Year Concepts & Applications
{PDF Document}
Operating Expense (OPEX) Base Year Concepts & Applications
{PDF Document}
5 page document covering the base year and ‘operating expense escalation’ concept encountered in a ‘modified gross lease format’. Provides several methods, of base year operating expenses review, in order to ensure the tenant’s base year is accurately established.
-
Operating Expense (OPEX) Escalation Groups – Concepts & Applications
{PDF Document}
Operating Expense (OPEX) Escalation Groups – Concepts & Applications
{PDF Document}
2 page document that explores the trend, and potential landlord benefits, of multiple operating expense reconciliation ‘groups’ (3 groups vs. 2 groups or 1 group). Compares operating expense escalation recovery under three different scenarios:
- Operating Expense Group (including Utilities & RE Taxes);
- Operating Expenses (including Utilities) and RE Taxes (2 Groups) and
- Operating Expenses, Utilities Expenses and RE Taxes (3 Groups).
-
Operating Expense (OPEX) Gross Up Calculations Workbook
{Excel Template}
Operating Expense (OPEX) Gross Up Calculations Workbook
{Excel Template}
3 tab pre-formatted, formula-linked excel workbook, with detailed instructions and supporting comments, in order to illustrate gross up methods for Fixed, Variable and Fixed – Variable (hybrid) operating expense categories. Provides sample 95% and 100% gross up calculations, for several operating expense categories, including: Janitorial Night Cleaning | Janitorial Supplies | Trash Removal | Utilities Water | Utilities Electricity | Management Fee
-
Operating Expense (OPEX) Gross Up Concepts & Applications
{PDF Document}
Operating Expense (OPEX) Gross Up Concepts & Applications
{PDF Document}
5 page document summarizing the Gross Up concept including an overview of various gross up methods. Operating expense category “classifications” are defined along with their correlation with the occupancy adjusted gross up calculation: Fixed Expenses | Variable Expenses | Fixed – Variable Expenses (hybrid).
-
Operating Expense (OPEX) Reconciliation – General Ledger Analysis
{PDF Document}
Operating Expense (OPEX) Reconciliation – General Ledger Analysis
{PDF Document}
5 page document that provides insight into general ledger review techniques, in particular the first and last month’s general ledger accrual entries. A general ledger review analysis is conducted, in order to illustrate examples of how manual operating expense adjustments can have a significant impact to property value, in particular during the establishment (setting) of a tenant’s base year.
-
Operating Expense (OPEX) Reconciliation – Multi-Year Comparison
{PDF Document}
Operating Expense (OPEX) Reconciliation – Multi-Year Comparison
{PDF Document}
4 page document providing insight into the importance of a “macro perspective” comparative review, of final annual operating expenses – multi-year comparison of operating expense categories – in particular, during the establishment (setting) of a tenant’s base year.
-
Operating Expense (OPEX) Reconciliation – Multi-Year Comparison Workbook
{Excel Template}
Operating Expense (OPEX) Reconciliation – Multi-Year Comparison Workbook
{Excel Template}
4 page excel workbook that can be utilized by the manager in performing a multi-year operating expense category comparison. The workbook coincides with the Multi-Year Comparison PDF Document.
-
Operating Expense (OPEX) “CAP” Analysis & Calculations Workbook
{Excel Template}
Operating Expense (OPEX) “CAP” Analysis & Calculations Workbook
{Excel Template}
2 tab document, with calculations and comparison analysis, associated with 3 CAP Methods: Year over Base Cumulative, Year Over Base Compounded, Year Over Year Cumulative Compares operating expense recovery, with each of the 3 CAP methods, over an 8 year period.
Illustrates the calculation of operating expense recovery, for each CAP method, over a 3 year period.
-
Operating Expense (OPEX) “CAP” Concepts, Applications & Calculations
{PDF Document}
Operating Expense (OPEX) “CAP” Concepts, Applications & Calculations
{PDF Document}
4 page document covering the concepts and applications of operating expense CAP’s – “expense stop”.
Provides characteristics of the 3 most common “Cap Classifications”:
1. “Year Over Base Cumulative”; 2. “Year Over Base Compounded” and 3. “Year Over Year Cumulative”. Defines specific expense categories that are routinely subject to a “Controllable Expense Cap”. The document also provides examples of routinely encountered “operating expense CAP clause” lease language.