I will provide you a standard real estate valuation model template in excel

The purpose of this spreadsheet model is two-fold:

1) to estimate the valuation of commercial property

2) to determine the financial feasibility of an investment in the subject property for a 10 year holding period. 

The uncertainty in this model lies in the many economic factors to be input as assumptions by the user. The most important assumptions in this analysis are the Net Operating Income assumptions (Annual Gross Rent, Vacancy and Collection Loss Factor, and Operating Expenses) and the Cap Rate at Purchase. Special attention should be given to these assumptions.

This is the same tool taught by the real estate education website realnewbies.com