RE Analysis Calculator Feedback

[Yu Liu]

Just starting to get into RE and started analyzing property. I created a calculator using excel and was wondering if there were any other metrics I should include or things that I did wrong or didn't account for or just any feedback in general to improve it. I use very conservative values (10% Capex, repairs, vacancy rates, etc)

I compared it with a couple of other online calculators and it gave me similar results. 

This is the link: 

My formulas for the "Key Metrics" are shown in the "Notes" section. 

The mortgage is calculated using the 

For a screenshot:

Feel free to use it and improve it for your own endeavors

[Hai Loc]

Minor adjustment.. 

Mortgage is not an expense and I noticed you not did calculate it as an expense

Proper way is to add a column between NOI and Cash Flow and call it "debt service" that is where you plug in Mortgage payment..