What is RedMol Analyzer?
It's for people who have real estate investment and would like to crunch numbers without spending $1500 on ridiculous "commercial" investment analysis tools.
Why did you make this and make it freely available?
Because we didn't feel like paying $1500 just to get a widget on our site, we made our own. We figured, heck, someone else might want to use this too.
How do you come up with your calculations?
Some terms / abbreviations:
Formulas used to dervice them (all amounts are in ANNUAL, not monthly):
Tax depreciation is not accounted for because we cannot know what type of accounting method you use nor how aggressive you are in your tax depreciation strategies.
How do I add your analyzer to my site?
Stick the JavaScript (below) into your web page like so:
<html>
<body>
<script type="text/javascript">
var gpi = 65000;
var opex = 10000;
var purchase_price = 450000;
var vacancy_rate = 5;
var holding_period = 5;
var gpi_growth_rate = 2;
var opex_growth_rate = 1;
var appreciation_rate = 2;
var financing =
[{"principal":350000,"interest_rate":7,"amortization_period":30,"interest_only":0}]
</script>
<script type="text/javascript"
language="javascript"
src="http://www.redmol.com/analyzer/embed/"></script>
</body>
</html>
Here's how this one looks:
Here's what you need to fill in. Please note:
| Value | What it means | Notes |
|---|---|---|
| gpi | Gross Potential Income | Greater than 0, Per year, required |
| opex | Operating Expense | Greater than 0, per year, required |
| purchase_price | Purchase Price | Greater than 0, required |
| vacancy_rate | Percentage of time property is vacant | Non-negative |
| holding_period | Number of years investment is expect to be held | Greater than 1 |
| gpi_growth_rate | Rate of rent/income growth | |
| opex_growth_rate | Rate of expense growth | |
| appreciation_rate | Rate of property appreciation | |
| financing | see below |
financing field can support multiple financing/mortgages:
| Sub-Value | What it means | Notes |
|---|---|---|
| principal | Amount of mortgage/financing | |
| interest_rate | Interest rate | |
| interest_only | Whether or not loan is interest only | 1 if interest only, 0 if amortized |
| amortization_period | Number of years a loan is to be amortized | Greater than 0, applies only if interest_only is set to 0 |
For example, two loan scenario (first $350,000 at 7% amortized over 30 years and second $50,000 interest only at 8.5%) can be written this way:
<html>
<body>
<script type="text/javascript">
var gpi = 65000;
var opex = 10000;
var purchase_price = 450000;
var vacancy_rate = 5;
var holding_period = 5;
var gpi_growth_rate = 2;
var opex_growth_rate = 1;
var appreciation_rate = 2;
var financing =
[{"principal":350000,"interest_rate":7,"amortization_period":30,"interest_only":0},
{"principal":50000,"interest_rate":8.5,"amortization_period":0,"interest_only":1}]
</script>
<script type="text/javascript"
language="javascript"
src="http://www.redmol.com/analyzer/embed/"></script>
</body>
</html>
That's it! Here's a sample code of how it should look (ignore the black box border, that's just for contrast)
What new features will you add?
I need something. Can you help me?
Well, as long as you're not asking us to debug your page, ask here
Last updated 5/1/2008
