NEW & IMPROVED Real Estate Evaluator

CLICK TO ENLARGE

VIEW SPREADSHEET IMAGE AS A PDF
The 2013 new and improved Real Estate Evaluator MS XLSX Spreadsheet can be used to quickly calculate the return on your investment from any kind of real estate anywhere in the world based on the cash flow. 

The 2 column layout produces a side by side comparison between a 100% cash purchase of real estate and a leveraged purchase via mortgage of any house, condo, apartment block, commercial, industrial or investment property.

SEE THE SPREADSHEET IN ACTION ON A REAL CASE STUDY

---

CLICK TO ENLARGE

From spring 2006 to spring 2012 I sold over 170 of the above pictured First Edition Real Estate Evaluators. Then for a year through the spring of 2013, I gave them away. This edition is now retired.

SCREEN TIP: If you want to view the image enlargement of the thumbnail above even bigger than the default and you are using Google Chrome as your browser, right click on the image enlargement and select "open image in a new tab" and then Ctrl + to enlarge the image even more.

Real Estate Evaluator
ONLY CAD$12

Purchase the new and improved Real Estate Evaluator for just CAD$12 (Includes all tax). Paypal will take care of the exchange if you are from outside Canada. I will send you the spreadsheet by email as soon as I get notification of the sale via Paypal. I check my email frequently during the day. Questions? You can contact me here.

The Real Estate Evaluator's new visual prompts and fewer input cells (38% fewer inputs) provide more automation and more output results.

This simple spreadsheet will quickly determine ROI, GRM and CAP RATE (Return on Investment, Gross Rent Multiplier and Capitalization Rate) as well as establish the net operating income (NOI) and compare yield results to the 10 year bond yield benchmark for real estate.

The spreadsheet is very easy to use, just enter the cash flow data of the property you are examining into the empty white cells of the spreadsheet. Copy the spreadsheet in your Excel workbook and keep an archive of the properties you are considering, or already own in your portfolio for quick comparisons. SEE THE SPREADSHEET IN ACTION ON A REAL CASE STUDY

Register your opinion every month on where you think average Vancouver, Calgary & Toronto single family detached prices will be one year from now. VOTE HERE

Verify Income and Expense

An accurate cash flow analysis leads to better investments. Make any offer to purchase subject to your examination and approval of the documents that will verify income and expense. 

Documentation:

• Owner or property manager records including service contracts and maintenance history.
  
• Copies of current lease and rental agreements.
  
• Correspondence with tenants and service suppliers.
  
• Owner's rental property statement submitted to Revenue Collection to calculate income tax.
  
• City or Municipal records concerning licensing, legality and conformity to bylaws and regulations that might affect cash flow.
  
• Title Registration records of liens or encumbrances that might affect cash flow.
  
• If the property is a Strata or Coop building, examine the minutes from all the meetings.

Determine:

• If the current rents are under or over market rents.
  
• If the tenants pay on time.
  
• What vacancies have occurred and when.
  
• If the property vacancy rate is less or more than market vacancy rates.
  
• What will affect the vacancy rate in the future.
  
• When the rents were last increased.
  
• When the property was last upgraded.
  
• If additional revenue sources such as Laundry and Parking can be improved or if they require further investment.
  
• What the annual operating expenses are for:
  
• Accounting, Legal or other Professional Fees
  
• Advertising, Signage and Promotion
  
• Common Area Utilities
  
• Maintenance and Repairs
  
• Management Fees
  
• Property Insurance (If it is a strata building, look at the history of premiums. If they are rising much faster than comparable buildings, the insurer considers the subject to be a risk)
  
• Property Taxes
  
• Rental or Leasing Commissions
  
• Services (Garbage, Landscaping, Pest Control etc)
  
• Supplies