Commercial Real Estate Valuation Model Template

The model includes various valuation techniques - stepped from simple to complex as you proceed. Yield, DCF, Discount Rate, Cap Rate, Leveraged Yield calculations are all automated and easy to visualize on 2 print pages. The model also includes all typical range & medians of expense line items.

Download it today - click here for details.

Worksheet 1: Simple cap rate, simple-income and expense line-item calculations. You can easily adjust items like price, cap rate, rent, expenses, vacancy, and square feet.

Note: Actual rent/income is hard to manipulate by sellers, so expenses and vacancy are the main manipulation areas. This worksheet allows you to easily change vacancy, expenses, etc. and see the resulting effect on price. Very importantly, you can compare apples-to-apples the line items expenses/sf to the range and median of those which are typical.

Worksheet 2: Leases and weighted & non-weighted rent per sf calculations, and more.

Worksheet 3: Lease expirations showing dollars expiring and percent expiring per year. This presentation is completely automated from data inputed into the "Lease" Worksheet 2.

Worksheet 4: Valuation Overview sheet. Sensitivity adjustments can be done on this one page. The percentage annual growth of the different line items such as rent, vacancy & expenses can be viewed and analyzed. Yield, DCF, Discount Rate, Cap Rate, Leveraged Yield - all automated and easy to visualize on 2 print pages.

Worksheet 5: Loan Calculation

Worksheet 6: Includes an easy to understand and visualize NNN to Full Service rent adjustment calculator. Typical range & medians of expense line items as dollar/sf. 5 line item categories included: Taxes, Insurance, Utilities, Maintenance, Janitorial & Management. Of course every property's expenses are unique, but this data helps when you don't have any idea of the norms.

Worksheet 7: Sample Argus cash flow output to Excel. Data can be merged into ModernValue in Excel.

Download it today - click here for details.