This tool is perfect for analyzing a property being considered for purchase and also for reviewing the performance of your portfolio of properties.
Please review and understand the terms in the Glossary before downloading the Deal Analyzer. (10 minute tutorial)
The Deal Analyzer is a Microsoft Excel file with an xlsm extension which means it has macros. Below is a screen shot. After downloading the file using “Add to Cart” button below, open the file and select to enable macros when prompted at top of screen.
If macros are not enabled, the red buttons on the form will not function.
There are 2 sheet tabs at bottom of the file: one “blank” and one “sample”.
There are 3 red macro buttons:
- Bottom center “Unprotect” button: upon opening the file the first time, all non-yellow fields cannot be modified or even clicked into. This is to prevent the user from accidentally deleting critical formulas in these fields. Advanced users who want to customize the form can click this button which allows modification of all fields and all sheet functions.
- Bottom center “Reprotect” button: use this button to reprotect the sheet after unprotecting.
- Top left “Add Property” button: use this once you own more than 8 properties (hopefully soon!) to add another column. If you inadvertently press this button and want to delete a column, simply click “unprotect”, right click on the letter of the column you want to delete and select “delete”, then click “reprotect”.
Note: For Free Checkout, your full name is not required. If preferred, you can just enter your first name or any name.