analysis tools for real use.

The REsheets Toolbelt.

The 13 template scenario-specific analysis package.

Contains the broker’s basics. Anchored with 3 executive valuation summaries (apartment, commercial, development), the REsheets toolbelt also consists of the following analysis reports: 1031 Exchange, Refinance, Own vs. Lease, Seller Carry, Net Proceeds, Amortization Schedule, Sales (Apt. & Com.), Comparables (Apt. & Com.). The toolbelt is a must have for every broker.
commercial real estate analysis learn more

 

The Cash Flow Model Valuation Suite.

commercial apartment dcf bundle priceOur best valuation package.

We’ve bundled together our commercial and apartment 10-year discounted cash flow models. Featuring current and pro forma property analysis, underwriting commercial real estate has never been this easy, and this functional. Includes PV, IRR, and Reversion Analysis reports, an Executive Overview, Financing, and a 10-Year Cash Flow.
commercial real estate analysis learn more

Supports Retail, Office, Industrial, Multifamily, Self-Storage.

 

CREproducttestimonial

 

Featuring the ease of Excel, and the feel of software, REsheets cash flow models offer an unparalleled analysis experience at an exceptional price. Whether owner, bank, or broker, our apartment and commercial templates deliver thoroughness and accuracy in property analysis with a modern sense of workflow and reports. It’s commercial real estate analysis made real easy.

Commercial real estate analysis made easy. The commercial cash flow model.

Commercial Analysis Sample Report

Consisting of (5) plug-and-play input pages, and (6) fundamental reports, our commercial model is perfect for pricing, buying, and selling that next value shopping center. Supports Retail/Office/Industrial, and up to 30 commercial tenants. You may purchase the commercial valuation model à la carte here.

 

 

INPUTS:

  1. Basic Property Information.
  2. Income Inputs: Current and pro forma tenant information. Include up to (30) commercial tenant lease agreements, start/end dates, rent, including yearly % increases, NNN or Gross lease types, analysis start date, and tenant improvement & leasing commission rollover income adjustments.
  3. Operating Inputs: Reimbursable and non-reimbursable operating expenses. Also, a chance to input any “other” property income.
  4. Growth Rates and Financing: Yearly increases in vacancy, other income, and expenses. Loan calculations including interest rate, amortization period, and interest only period.
  5. Pricing Inputs: Price the property based on $ amount, per SF, Cap Rate, or GRM, plus a sensitivity analysis. Also reversion price (exit) with cost of sale %.

REPORTS:

  1. Executive Summary: The front page report. Income/expense summaries for current & pro forma, pricing, relevant ratios and metrics,  NOI, debt service, cash flow, cash on cash, and everything at-a-glance.
  2. Upside and Rollover Analysis: Current vs. pro forma upside/downside variance, rollover value, graphic reports.
  3. Tenant Cash Flow: 10 year individual tenant cash flow reports.
  4. Property Cash Flow: 10 year property cash flow with relevant metrics, EGR, NOI, effective cap rate, DSCR and more.
  5. Present Value Discounting: 10 year leveraged and unleveraged PV sensitivity analysis.
  6. IRR: Net proceeds reversion analysis, leveraged and unleveraged IRR.

Back to top.

Commercial real estate analysis made easy. The apartment cash flow model.

Apartment Analysis Sample Report

Consisting of (5) plug-and-play input pages and (5) fundamental reports, our apartment model is perfect for pricing, buying, and selling that next multifamily high-rise. Supports Multifamily and Self-Storage, and up to 20 unit types. You may purchase the apartment valuation model à la carte here.

 

 

 INPUTS:

  1. Basic Property Information.
  2. Income Inputs: Current and pro forma unit mix. Include up to 20 unit types (studio, 1 bedroom, 2 bed 2 bath, etc.), the number of units per unit type, rent, and SF. Also, annual unit rollover.
  3. Operating Inputs: Operating expenses ($ amount, per unit, % of purchase, per SF., per month, or % of EGR), and other income inputs.
  4. Growth Rates and Financing: Income, vacancy, concessions, and expense annual growth rates. Loan calculations including interest rate, amortization period, and interest only period.
  5. Pricing Inputs: Price the property based on $ amount, per SF, per unit, Cap Rate, or GRM, plus a sensitivity analysis. Also reversion price (exit) with cost of sale %.

REPORTS:

  1. Executive Summary: The front page report. Income/expense summaries for current & pro forma, pricing, relevant ratios and metrics,  NOI, debt service, cash flow, cash on cash, and everything at-a-glance.
  2. Unit Analysis: Current and pro forma unit type summary per single, 1 bed, 2 bed, 3 bed. % upside and relevant graphical reports.
  3. Property Cash Flow: 10 year apartment cash flow with relevant metrics, EGR, NOI, effective cap rate, cash on cash, DSCR and more.
  4. Present Value Discounting: 10 year leveraged and unleveraged PV sensitivity analysis.
  5. IRR: Net proceeds reversion analysis, leveraged and unleveraged IRR.

Back to top.

13 essential analysis templates. The REsheets toolbelt.

The REsheets toolbelt contains (13) individual commercial real estate analysis models, each designed to perform a specific and integral valuation. From executive summaries to comparables, our toolbelt is the perfect set of templates for any scenario.

 

 

TEMPLATES INCLUDE:

  1. Apartment Executive Summary: Executive summary, current and pro forma scenarios, and unit analysis. An impressive report highlighting all the key indicators (cap rate, GRM, per unit, per SF, cash on cash).
  2. Commercial Executive Summary: See above, call it commercial with an upside and rollover analysis.
  3. Development Analysis: Hard & soft costs, financing, and reversion values. The template that answers the question: what is land worth? Lends credibility to the most speculative of CRE analysis.
  4. 1031 Exchange Analysis: The return on equity that effectively answers the question: will executing a 1031 exchange increase your bottom line?
  5. Refinance Analysis: An easy to use analysis matrix that answers the question: is it the right time to extract money, and is it even possible?
  6. Own vs. Lease: A model highlighting the value (or detriment) of ownership.
  7. Seller Carry Analysis: The pros and cons of a client considering carrying the note.
  8. Net Proceeds Analysis: The answer to the fundamental question: what ends up in my pocket? Accounting for pricing and loan balance, cost of sale, depreciation and taxes.
  9. Amortization Schedule: A simple and easy loan calculator: principal and interest. Can calculate interest only periods and loan balances for any date in a loan schedule.
  10. Apartment Sales Comparables: Input up to (10) apartment buildings, detailed side by side analysis, and sort by eight indicators including price, cap rate, date, etc. An invaluable tool for sifting through multiple properties.
  11. Commercial Sales Comparables: See above, call it commercial and justify sales prices.
  12. Apartment Rent Comparables: Input up to (10) apartment building rent comparisons, 1 and 2 bed, sortable with detailed analysis.
  13. Commercial Rent Comparables: See above, call it commercial with rent per SF.

Back to top.

About REsheets Valuation Models.

  1. Easy to Maneuver: Adjust rates, pro forma, and all other inputs in easy to follow workflow. It’s plug and play in Excel, a powerful and time saving foundation.
  2. Ready to Print: Each page is formatted to print a market-ready analysis instantly, never worry about adjusting boundaries to get the perfectly printed report.
  3. Customizable: Fully customizable to the boundaries of Excel, simply unprotect any template and add your own thematic colors, logos, calculations, etc.
  4. REsheets on the Go: Enter and adjust analysis reports anywhere you can access Excel. REsheets is also fully compatible with Google Sheets on any device.
  5. Simplified Underwriting: Coded in Excel, REsheets valuation templates perform on an air-tight platform, no pop-up boxes, loading times, or any clunkiness associated with other commercial real estate analysis software programs. Best of all, it feels like software with easy to navigate inputs and instantly populated outputs. No Excel experience necessary.

Back to top.

Questions?

Contact us anytime with our simple contact form, or email us: Contact@REsheets.com