THE 3 MINUTE RENTAL PROPERTY ANALYZER

[Pages:2]THE 3 MINUTE RENTAL PROPERTY ANALYZER

Thank you for your interest in my 3 Minute Rental Property Analyzer. I developed this analyzer to help me to quickly evaluate properties to allow the "cream of the crop" properties to rise to the surface. When I am cracking, going through multiple properties (sometimes 50 or more at a time) I needed a way to plug in the basics and see if there is even a reason to proceed further. As I plug in information, all of the properties fill out the "Comparison" Tab in the Excel spreadsheet. When I'm done, I can go back to the Comparison tabs and either sort by a key category (i.e. Cash Flow, CAP rate, Cash-on-Cash, Return on Investment, etc.) and look at the best in that category to know which to research further.

Keep in mind; in order to do these quick assessments, I had to make a number of assumptions. Those assumptions are:

I used the 50% Rule - The 50% rule states that expenses are generally 50% of income. I assumed 25% down on purchase ? that number could vary greatly I understand but again, this

is for quick assessment. I don't acknowledge any extra capital expenditures, You must manually input closing costs. This is very subjective depending on the type of loan but

a safe estimate is generally 1% of the loan value.

This is meant to be a quick temporary assessment tool to help you weed through many properties in a short period of time. Once you narrow down to your top properties, you'll have to do a much more intense deep analysis.

Warning: Do not attempt to change the values of cells outside of the Input Data Pop-up. Once you start changing formulas it could greatly impact the accuracy of the final numbers.

This is a Beta version and we welcome your comments, suggestions, corrections, etc.

HOW TO USE

1) First, save an additional copy of the Analyzer. That way you will have an extra "clear" copy if you need it.

2) Make sure you are on the "HOME" tab. 3) Do not input data on the "HOME" tab form, instead, click the box in the upper left hand corner

that reads "Click to Input Data." 4) After you've clicked "Click to Input Date" button, a pop-up form will appear. This is the form

you use to input property data. 5) Make sure you have the necessary property data before you complete the pop-up form. If you

don't know or the answer is zero, you can type in "0" but try to estimate those fields, as best as you can, where there should be data. 6) When you're done with the pop-up form, hit "OK." The pop-up form will disappear.

7) The form on your "HOME" tab will instantly be populated and so will a line in the "COMPARISON" tab. If you want to print the results on the "HOME" tab form just push the "Print" button.

8) To input another property, repeat the process noted above at number 1. 9) You can input as many properties as you want. Each time you input another property and hit

"OK," it will be added to the list in the "COMPARISON" tab. You can then sort and compare the properties in the comparison tab like you would a regular Excel sheet. 10) You can repeat this process for as many properties as you want and each property will be added to the comparison list where later you can sort and evaluate the data.

PLEASE NOTE: If you have any questions or need assistance, please feel free to email me a bill@. Thank you.

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download