VACANCY AND COLLECTION LOSS IN MY FIRST PROPERTY

[Account Closed]

Good Evening All,

First, thank you for taking out the time to read and help me. I just bought my first quadplex last week. 

Although, I know BP has an excel finance form for landlords, I prefer to make my own my which I am in the process of doing. Currently, I am calculating my Cash Flow analysis and I need help with the Vacancy and Collection Loss portion. Currently, I have one vacant unit that needs to be remolded then rented at $900 per month, which is the areas going rate. However, my other tenants are between $700-750.

When calculating the vacancy rate, do I multiply the future or current rent by the vacancy %? Also, because I have one 1/4 units vacant, does that percentage equal 25%? I maybe way off on my math already, however, that's why I need some serious help to get this right and accurate! 

Thanks so much for your time and advice!