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