For help call:

208  344-0249

208 794-4950 cell

202 N. 9th Street, 3rd Floor, Boise, ID 83702

shaxton(at)clearwire.net

• Phone Support

• Valuation Training

• Excel Training

• Argus Training

• Brochures & Financials for sellers

• & more ...

ModernValue Pro

  Investment Real Estate Total Valuation

FREE TRIAL by Email

Developed by Stuart Haxton - former commercial r.e. appraiser and award-winning multi-million dollar investment real estate acquisitions.

($148 million in 19 transactions)

• Includes 1 hour of value modeling or consulting help by Stuart Haxton!

• Stepped valuation - from simple to complex as you proceed.

• The most educational, intuitive and visual valuation model.

• Built for efficient and total analysis ... by a valuation expert!

• Stand-alone valuation or use with Argus - a vital complement to Argus for final calculations.

• Includes typical range & medians of expense line item dollar cost/sf!

• Yield, DCF, Discount Rate, Cap Rate, Leveraged Yield - all these value measures

   are easy to adjust and visualize on 2 print pages!

• Compared to Argus

"I enjoy using the model. You did a great job with it."  A.M., Florida

"The model clarifies the complexities and presents the investment details very well."   R.B., New York

ModernValue V1.3 Professional

ModernValue in Excel is my process to value and buy properties. - Stuart Haxton

 Start                                                                                                                                                   

Red/Maroon font cells - input your numbers.

Blue font - auto-calculating cells.

Worksheets can be modified. No locked cells.

Step 1: Simple valuation

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.

Stop! Is this worthy of further work?

Step 2: Proceed to ... Detailed valuation

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!

Click this image to enlarge above worksheet!

Worksheet 4: This is the big value overview!! Sensitivity adjustments are done on this one page! You

can easily see the percentage annual growth of the different line items such as rent, vacancy & expenses!

Yield, DCF, Discount Rate, Cap Rate, Leveraged Yield - all automated and easy to visualize on 2 print pages!

Click this image to enlarge above worksheet!

Worksheet 5: Loan calculation.

Worksheet 6:

- Not shown -

1) An easy to adjust and visualize NNN to Full Service rent adjustment calculator.

2) Typical range & medians of expense line items as dollar/sf. (It is very hard to get this data!)

     For the 5 line item categories of: 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!

     High expenses found in NY, CA, etc. are not included in this data.

 Finish: Print ModernValue pages for a professional presentation!                                 

If Argus is needed? See what Argus does

Step 3: Proceed to ... highest level of complex valuation (using Argus)

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

Step 4: Merge Argus' Excel output into ModernValue in Excel.

Now you can visualize the total investment in the "Value" Worksheet 4 and make the Price change by adjusting your chosen value-measure of Cap Rate, Yield, Leveraged Yield, or Discount Rate. Its easy. Its powerful!

 Finish: Print ModernValue pages for a professional presentation!                                 

ModernValue V1.3 professional

$649 Full Version (1 user per purchase)

$549 Limited (1 user per purchase)

(no loan or lease expiration chart worksheets)

Bulk Discounts Available

Consulting & training, $65 per hour

On-sight: add travel costs

For general valuation or ModernValue phone support call:   208  344-0249

After credit card purchase, call to us recieve product by email.

Thank you!

Stuart Haxton Company

208  344-0249

208 794-4950 cell

202 N. 9th Street, Ste. 302
Boise, ID 83702

Individuals • Companies • USA • International

| Copyright © 2008 | All Rights Reserved |

Valuation Software 1

for Investment Real Estate

Argus Software

"Industry standard for the most complex cash flow analysis."

Below is my understanding of the software:

Pros

• Cash flows can be developed to high accuracy beyond Excel, when changes in lease rates and structures are present upon lease expirations. 

• The industry standard platform for brokers of large multi-tenant properties.

Cons

• Argus is expensive. Usually requires annual fee.

• Argus requires extensive learning.

• Common inputs are not intuitive or efficient.

• Calculates slowly, doesn't calculate automatically.

• Exporting to Excel usually necessary for final analysis.

• Poor presentations of cash flows.

• Cumbersome sensitivity analysis.

• No stepped valuation - from simple to complex.

• Have to print many, many worksheets and tricky-print other windows to easily see sensitivity variable inputs.

• Inputting lease details is inefficient.

• Can't see how the model calculates.

• Difficult to error check.

• No presentation or adjustment worksheets to visualize rents on different basis for comparison purposes (i.e. NNN, Modified Net, or Full Service rent basis').

• Inflexibility sometimes requires creative inputs to model unprogrammed inputs/methods.

• Does not calculate average rent or weighted average rent.

- by Stuart Haxton, Stuart Haxton Company

ModernValue Professional solves the problems which Argus does not solve. It is stand-alone with Excel, or can merge Argus data into its valuation model!

Valuation Software 2

for Investment Real Estate

ModernValue V1.3 professional

"Stand-alone or use with Argus data - Argus results can be exported to Excel and merged into this model."

Pros

• The best total presentation and intuitive software available! Built to impress the critical analyst!

• Stand-alone or use with exported Argus cash flow.

• Ideally presents Argus output!

• The most educational and visual valuation model.

• Built for the analyst ... by a valuation expert!

• Includes typical range & medians of expense line items!

• Stepped valuation - from simple to complex as you proceed.

• For most complex cash flows, Argus users can merge data into this model.

•  Presentation or adjustment worksheets to visualize rents on different basis for comparison purposes (i.e. NNN, Modified Net, or Full Service rent basis').

• Yield, DCF, Discount Rate, Cap Rate, Leveraged Yield - all automated and easy to visualize on 2 print pages!

• Inexpensive. One-time cost. No updates required.

• Very flexible

• Excellent printable presentations

Cons

• Cash flow changes don't automate when changes in lease rates and structures are present upon lease expirations. (Data merge from Argus solves this).

  - Stuart Haxton, Stuart Haxton Company

   creator of ModernValue Professional.