4 Star Award

Stuart Haxton Company

ModernValue Software

270 W. Parliament

Boise, ID 83706 USA

ModernValue software is easy to use, easy to visualize, and ideal for beginners and experienced professionals! Sold Worldwide!

ModernValue Professional, in Excel

Complete Cash Flow Valuation Software

 For office, retail ...any mult-tenant!

... income properties of any size!

"Stuart Haxton has done it

...smarter, easier, better!"

•  Designed by Stuart Haxton - commercial re appraiser and award-winning buyer

   of investment-grade commercial real estate ($148 million in 19 transactions).

•  Only $100 Full Version!   On sale now for a limited time! (Normally $349)  Download Today!

No annual fees. No updates required. Just one low price!

Plus, it includes 1 hour of free phone support - software or valuation help!  English only.

This program is in MS Excel. Full flexibility! No locked cells or formats!

Not designed by an accountant! The difference is the logic and professional methods used by a well-practiced Commercial RE valuation expert. Examples of this difference: 

    • Many autocalculations for reality checks (like average rent/sf, growth percentages, etc.)

    • Compare Expense Line Items to real-world dollar-per-sf amounts.

    • Easily change interrelated numbers on one screen! (estimates I am always changing & fine-tuning -

      like vacancy, TI's, and leasing commissions)! It is very easily done here!

    • Miscellaneous notes throughout on possibly confusing items and market practices!

    • Plus many more elements including easy, intuitive inputs methods, and impressive presentations for reports!

More about....

ModernValue is your complete commercial real estate discounted cash flow valuation model software! In Excel, this model is sophisticated and smartly fine tuned. Plug your inputs into this smooth flowing logical model and it will give you the Cap Rate, Yield Rate, Discount Rate and more... all on one final easy-to-visualize screen! Color-coded inputs and flexible cells make it very functional for you! And you can easily follow the calculations. Designed by a professional appraiser and buyer of multi-tenant commercial real estate, this cash flow modeling solution has the best value analysis, ease of use, and overall presentation on-screen and on paper available!

 - Stuart Haxton

• "I enjoy using the model. You did a great job with it."

 - A.M., Florida

• "The model clarifies valuation complexities and presents the investment details very well."

 - R.B., New York

• "ModernValue is what I used to value and buy investment-grade properties."

- Stuart Haxton, creator of ModernValue

1) Non-Regular Cash Flow dynamic worksheet for modeling these cash flows.

    Examples of this: 1) Specific roof repair in year three, 2) Specific downtime vacancy for six months including,

    TI's, LC's, etc. for each tenant, 3) Change to market rent after a lease expires.

Simple Valuation Model

"Cap Rate Calculator"

ModernValue

Its simple:  Red/Maroon font cells - your input numbers  •  Blue font cells - autocalculating formula cells

   Click to see larger image!

Complete Cash Flow Valuation Model

ModernValue

1) Income: Rent & Other Income  Tenant list can be added to indefinitely - or as many rows that Excel will allow! Includes Reimbursement Income to owner and Other Income to owner (screenshot not shown).

 Click to see larger image!

Lease Expirations (This chart is fully automated from lease data - no inputs here)

Lenders are very interested in this chart - the timing and amounts of leases expiring. This chart shows the number of leases expiring, percentage by square foot expiring, and percentage by lease-dollars expiring - each year.

  Click to see larger image!

2) Expenses

Often, it is expenses which are the most difficult to estimate, because good data is hard to get. But the included real-world expense numbers will help guide you!  Here, you can compare apples-to-apples line-item expenses per-square foot to the range and median of typical office/retail in the U.S. market - based on my extensive research. Expenses are the primary numbers manipulated by sellers. It is hard to mis-represent leases - although vacancy and market rent is another story.

3) Final Valuation

This is the big value overview!! This is where you see the final cash flow and your developed value based on your inputs of returns, growth rates, vacancy, tenanting costs, capital expenditures (major items like roof and parking lot repairs) and more! The return measures - Yield / IRR, Discount Rate, Cap Rate, Leveraged Yield - are automated and easy to visualize on 1 screen! You plug in only one of the returns and the software automates the others - so you can see them all.

This software was expertly-designed for practicality and professionalism. It is easy to use, offers great clarity with the number-input process - the valuation process, and prints excellent professional presentations! It is built to impress the most critical analyst and the visual executive. It will make you fully competent!

Click to see larger image!

Leveraged Yield / LIRR  (Screenshot shown on PDF download)

3a) Loan  Loan inputs and Loan Amortization Schedule

(partial screenshot below)

Graphs  (fully automated) Two of four graphs presented below - first is cf without buy/sell, second is leveraged cf with buy/sell.

BONUS ITEMS  (screenshots not shown)

1) Management Expense Estimator
Because applying a percentage of EGI for management expense is usually not accurate.
This estimator is simple with its few variables.
 

2) NNN to Full Service Rent & Expense Reconcilers
(for apples-to-apples comparisons of comparable rents & expenses)
Because this analysis is quite confusing, these calculators were developed to clear up the confusion.
You can change it to adjust Modified Net to FS or NNN, as well.
 

3) Comparable Nationwide Office/Retail Data - of Per-SF Expense Line-Items
Typical range & medians of expenses per sf - for 4 of the 5 common line-item categories of: Taxes, Insurance, Utilities, Maintenance, & Janitorial (it is very hard to get this data!). Of course every property's expenses are unique, but this data can be a helpful guide! Note: High/low outlier property expenses found in certain areas of the U.S. are not included in this data. More information about the research is detailed in the software.

4) (for optional use) Imported Data worksheet

You can export/copy Argus data (as well as other software data) to ModernValue's "Imported Data" worksheet (just a blank worksheet). Then properly link the respective numbers to ModernValue's "Value Model".

ModernValue Professional     4 Star Award

Sale Price $100  Full Version (1 user per purchase)  On sale now! (Normally $349)

For Excel 97-2003 and later. For PC's. (for conversion to MAC please call)

Products sold to: Individuals • Companies • USA • International

| Copyright © 2007-2011 | All Rights Reserved |