Home Software Realogic Tools

header-tools-2009-11-9

Realogic Tools

Excel Add-In for ARGUS Valuation - DCF™ Reporting & Analytics

Realogic Tools™ uses Excel to leverage your ARGUS Valuation - DCF data like nothing else can! Tools seamlessly extracts ARGUS data into an Excel-based reporting and calculation engine for the analysis, valuation, lending and securitization of commercial real estate.

The Realogic Tools Process

tools-process

Contact us today

There is no better way to evaluate your ARGUS data inputs and outputs, and create multiple reports with unlimited scenarios and perform further analytics on your ARGUS data. Contact Realogic now for a guided webinar or to see your ARGUS data converted to a dynamic Excel workbook using Tools!

Stop Cutting, Pasting and Re-Linking!

stop-icon

Import your ARGUS Valuation – DCF data directly into Excel without cutting and pasting. 

 
  • Select the asset(s), the desired report package and analysis dates with just a few clicks of your mouse.
  • Extract data from an ARGUS file for a single building or portfolio of hundreds of ARGUS files.
  • Leverage the OpenARGUS functionality native to ARGUS Valuation – DCF to look at all data within the model.
 

 

Analyze Individual Assets or Portfolios

building01

Choose from one of three modules that can analyze a single asset or a portfolio of assets. 

 
Underwriting individual properties? Use the “VALUE” module for detailed reporting and analysis for an individual building.

Need the same deep look at a portfolio level in a single workbook? Use the “PORTFOLIO” module without sacrificing any detail. Imagine seeing the ARGUS assumptions for an entire portfolio of properties on a single tab within one Excel workbook. Not a problem with Realogic Tools.

Using ARGUS tenant data to assist in sizing a loan? Use the "SIZER" module for your loan underwriting needs.

 

 

Presentation Quality Reports

paper_content_48

Formatted reports make your presentations shine without any extra clean-up. 

 

Formatted reports make inclusion in your presentation books fast and easy. Reports such as the Executive Summary, Rent Roll, Expiration Report, Cash Flow Schedule and many others are just a click of the mouse away.

Screenshots of several reports are included in the SCREENSHOTS tab on this page.

 

 

Easy-to-Read Building and Market Assumption Schedules

bar-chart-icon

Realogic Tools provides a window of clarity into the assumptions that drive your ARGUS valuation. 

 

The reports in Realogic Tools detail the assumptions used in the ARGUS file for an individual building (inflation, vacant lease-up) and each Market Leasing Assumption (Rent, Tenant Improvements, Leasing Commissions, Downtime, Renewal Probability and Abatements).

Furthermore, the Portfolio module summarizes building and market assumptions for EVERY BUILDING in the portfolio. It is no longer necessary to spend hours (or days!) reviewing ARGUS files to understand the underlying assumptions contained therein.

 

 

Powerful Tenant Analytics

debt-pie-chart

Multiple reports highlight key tenant metrics that are not provided within ARGUS. 

 

Realogic Tools reports highlight key tenant metrics that are not provided within ARGUS.

  • Occupancy cost on a tenant-by-tenant basis. (For retail tenants, occupancy costs are compared against sales per square foot as a measure of tenant's health)
  • Comparison of gross tenant rents at expiration against gross market rents to determine the impact of tenant rollover at building rentals.
  • Editable “in-place” cash flow with tenant detail.
 

 

Review Your ARGUS Valuation – DCF file for Accuracy

warning_48

Don’t let errors in your ARGUS Valuation - DCF file compromise the integrity of your analysis. 

 

Assess internally prepared and third party ARGUS Valuation - DCF files for errors that may compromise the integrity of your analysis. Realogic Tools identifies sixteen different exceptions in each file.

Commonly recognized exceptions include:

  • Double counting rent bumps
  • Using Overrides
  • Entry errors in the rent roll

The Realogic Tools Exceptions Report ensures that you are aware of commonly encountered modeling issues.

 

 

No Hidden Formulas & Formatting within Excel

formulas

Need to understand the calculations? Realogic Tools is not a black box calculation engine. 

 

Realogic Tools exposes its formulas for end-user audit and manipulation. There is no need to figure out how calculations are performed, Realogic Tools shows you. You need to change a calculation for a particular deal? Go ahead! All formulas are editable.

Not only does this transparency allow for auditing and manipulation, Tools illustrates examples of useful Excel techniques to teach users advanced Excel skills.

 

 

Integrated Equity Waterfall Modeling

lightbrown-waterfall-icon

Tired of wondering if your partnership model works correctly? Tired of re-building your waterfall analysis for every scenario? Leverage the waterfall calculation engine.

 

Realogic Tools layers a sophisticated Waterfall model onto the ARGUS cash flows and debt assumptions modeled within the Excel file.

  • Up to 7 different tiers of splits can be added between 2 Limited Partners (LPs) and 1 General Partner (GP).
  • A wide range of GP fees may be modeled.
  • Partner distributions may be modeled on a monthly, quarterly or annual basis.
 

Sophisticated Valuation Analytics

scale

Quickly calculate values and returns for individual assets and portfolios. 

 

Quickly calculate Internal Rate of Return (IRRs) for individual assets and portfolios. Capitalization rate, discount rate and other assumptions can be modified on a  building-by-building basis.

  • Calculate both "free and clear" returns and returns on equity
  • Calculate returns on both a leveraged and unleveraged basis
     

 

Flexible Debt Modeling

flexible-debt-model-icon

Structure debt at the property or portfolio level with a variety of debt assumptions. 

 

Structure debt at the property or portfolio level with a variety of debt assumptions.

  • Incorporate up to three pieces of debt, including a refinance.
  • Choose loan type: fixed & floating rate, amortizing or interest only.
  • Choose interest calculation type: 30/360, Actual 360, Actual 365, or Semi-annual.
  • Want to finance CapEx? Pay points or penalties? Realogic Tools makes it easy and guides the user through the inputs.
 

 

Dynamic In-Place Rent Functionality

budgetIcon

Calculate in-place rent “on the fly”; Easily include and exclude tenants to gain accuracy. 

 

Calculate in-place rents with a click of the mouse.

  • View the speculative and contractual status of all tenants.
  • Change the “Yes”/”No” designation to modify the actual in-place underwriting analysis.
  • Define the desired cash flow components to be used in the in-place calculation.
  • For loan sizing, include in-place rents at two different points in time & see expiring square footage/rent bumps.
 

Benefits of tools


Quality Control

The cost of cash flow modeling errors can be devastating, resulting in flawed decision making related to acquisition, disposition, financing and asset management. Realogic Tools enhances cash flow modeling via numerous quality control features.

Realogic Tools automates the transfer of data between ARGUS and Excel, eliminating the risk of errors encountered when cutting and pasting or relinking.

The standardized Realogic Tools template eliminates errors often found in custom-built spreadsheets, and viewable formulas provide an easy audit trail for your numbers.

The Exception Report highlights potential errors or oversights within the ARGUS files, thereby reducing careless modeling errors or hidden "modeling tricks" in files received from third parties.

Better Analytics

Stop wasting time combining multiple ARGUS reports together to get the analytics you need. Realogic Tools expands on the standard ARGUS reporting package to provide improved analytics including contract vs. market rent at expiration, occupancy cost analysis and "in-place" rent calculations.

Realogic Tools also provides an easy-to-use interface to add debt and partnership structuring to your models.

Understand Deals Quicker

Realogic Tools provides a quick look into your ARGUS models to understand the input assumptions as well as the deal economics, allowing you to focus your time where it is needed most: on the deals themselves.

Standardized Reporting

Presentation quality reports can be shared across the organization or between organizations. Standardization creates a layer of consistency that allows all parties to understand the deal faster and better.

ARGUS Valuation - DCF and Excel Best Practices

Expose yourself to Excel and ARGUS Valuation - DCF best practices. Fully exposed formulas show the end user how data is calculated.

Screenshots of Realogic Tools

Unleveraged Cash Flow Tools Rent Roll Rollover vs. Market Waterfall Report