IMPROVED 2015 Edition Real Estate Yield Evaluator Includes Mortgage Payment Calculator VIEW SPREADSHEET IMAGE AS A PDF
CLICK TO ENLARGE
The 2015 new and improved Real Estate Evaluator with a Built-In Mortgage Payment Calculator as a Microsoft 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
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 with Built-In Mortgage Payment Calculator 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 during the day. Questions? You can contact me here.
|
SEE THE SPREADSHEET IN ACTION ON A REAL CASE STUDY
The Real Estate Evaluator's new visual prompts and fewer input cells (only 19 input cells) provide more automation and more output results than prior iterations of this spreadsheet.
You 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.
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
