Buy and Hold Calculations

[Bill Flannagan]

Wondering if you all can help me out. I am putting together a spreadsheet that will calculate cash flow and ROI to evaluate a Buy and Hold investment. I have been using the UBG and information from other sources to put it together. The basics of course are Income - Expense = Cash Flow.

I am struggling to figure out what kind of things I should include in the investment cost and the monthly costs. I am currently assuming the following:

Investment costs: 

- Down Payment 

- Closing Costs

- Repair Costs

Monthly Costs: 

- Loan Payment 

- Property Taxes 

- HOA

- Insurance 

- Garbage 

- Realtor Charges (my realtor charges one months rent) 

- Vacancy (Assuming one month) 

If you could help out with more information or a template that you use or know of I would appreciate it. 

Thanks,

Bill