Vacation Rental Underwriting and Business Valuation

[Tanner Queen]

Hello all. 

I am working on creating and establishing a solid financial model to encapsulate current owned and operated SFR vacation rentals cash flows, expenses and capital improvements. I would like to also be able to indicate timeline for rentals by month i.e. our spring and fall months are peak seasons and i would like to be able to model that monthly and then roll it up to an annual number, and keep the same formatting and thought for all future projected cashflows for those current homes. In addition, I would like to also show or have the ability to continually incorporate new acquisitions of homes which will also be rolled up into the future cashflows.

At the end of the day, my goal is to effectively value the business based on a certain time period given the net cash flow of the portfolio. 

I know it seems daunting and I think Im almost there in my head but would like to get some insight or perhaps a look at someone else's efforts with the same structure. 

If you need more clarification please ask!