Can you help me fill out this chart?

Do we or Don't we Do the Deal? We need to weigh the costs of owning real estate vs the expected income stream. More importantly, we also need to factor in our local market real estate appreciation. What is our income stream projection? $1 ,500 /month. Based on local data. What are the costs associated with buying and owning this Townhome? Loan Amount $152,000 @ 6.859% for 30- year loan term City and County Tax Homeowners Insurance HOA Repairs Vacancy Rate 1 mos. Total Cost/Mo Projected Monthly Income Stream Monthly Profit or Loss Annual Profit or Loss 1 Profit or Loss with Appreciation 5 Profit or Loss with A reciation DO WE OR DON'T We Do the Deal? WHY? Total Yearly Cost County $ 1 ,400/yc City $ 800/yr $ 1 ,200/yc $900/YL $900/yyv. 9 Yes Cost Per Month 9 9 9 9 9 9 Projected Yearly Appreciation in $ 's 5% 9 9 Year 1 Net Appreciation Year 5 Net Appreciation No