my model to calculate ROI on my investment property

I am thinking about buying investment property at Tracy, CA

can master landlords here review my model and see if any of my assumptions or calculation are off:

- assume 1 month vacancy

- assume no price appreciation except to cover closing cost at sales 10 year later (I am a CF believer, so don't want to bet on appreciation)

- is my assumption on annual maintenance fee reasonable? I assume 1k/year for regular maintenance and additional 2k every 5 year for misc. replacement such as carpet etc.

Is this 5% return per year a good investment? Thank you very much!

 

Purchase Price		$ 210,000
Loan Balance		$ 157,500
Rate		4.75%
Term		30
Down Payment		$   52,500
Closing Cost		$      6,300
Remodel Cost
Monthly Rent		$      1,550
Year Built		2004
		Rent	Principal	Equity		Interest	Prop Tax	Insu	Maint.	Depr		Tax Benefit		CF		Profit %	ROI
10 Year		195,459	(30,760)			(68,795)	(31,296)	(7,222)	(14,000)	(57,273)		(5,062)		38,324		5.6%	5.1%
Period	1	17,050	(2,474)	61,274		(7,481)	(2,730)	(630)	-1000	(5,727)		156		2,890		-2.1%	4.7%
Period	2	17,562	(2,592)	63,866		(7,364)	(2,812)	(649)	-1000	(5,727)		(3)		3,142		0.0%	4.9%
Period	3	18,088	(2,715)	66,581		(7,241)	(2,896)	(668)	-1000	(5,727)		(167)		3,401		2.2%	5.1%
Period	4	18,631	(2,844)	69,425		(7,112)	(2,983)	(688)	-1000	(5,727)		(336)		3,668		4.2%	5.3%
Period	5	19,190	(2,979)	72,404		(6,977)	(3,073)	(709)	-3000	(5,727)		89		2,541		-1.1%	3.5%
Period	6	19,766	(3,120)	75,524		(6,835)	(3,165)	(730)	-1000	(5,727)		(692)		4,223		8.2%	5.6%
Period	7	20,359	(3,269)	78,793		(6,687)	(3,260)	(752)	-1000	(5,727)		(880)		4,511		10.1%	5.7%
Period	8	20,969	(3,424)	82,217		(6,532)	(3,358)	(775)	-1000	(5,727)		(1,073)		4,808		11.9%	5.8%
Period	9	21,598	(3,587)	85,803		(6,369)	(3,458)	(798)	-1000	(5,727)		(1,274)		5,113		13.8%	6.0%
Period	10	22,246	(3,757)	89,560		(6,199)	(3,562)	(822)	-3000	(5,727)		(881)		4,026		9.2%	4.5%

所有跟帖： 

• 回复：my model to calculate ROI on my investment property -凌长老- ♂ (84 bytes) () 12/15/2011 postreply 17:07:14

• 回复：回复：my model to calculate ROI on my investment property -whatif2007- ♀ (260 bytes) () 12/15/2011 postreply 20:15:42

• 放眼往东北角看看 -凌长老- ♂ (146 bytes) () 12/15/2011 postreply 21:32:51

• 回复：放眼往东北角看看 -whatif2007- ♀ (186 bytes) () 12/15/2011 postreply 22:47:44

• 加州地震多也要考虑。 -一夫- ♀ (0 bytes) () 12/15/2011 postreply 17:44:36

• 回复：加州地震多也要考虑。 -whatif2007- ♀ (51 bytes) () 12/15/2011 postreply 20:17:49

• 因为看你想的这么周到才给你加上。 -一夫- ♀ (100 bytes) () 12/15/2011 postreply 20:43:22

• 回复：因为看你想的这么周到才给你加上。 -whatif2007- ♀ (144 bytes) () 12/15/2011 postreply 21:41:14

• 回复：回复：因为看你想的这么周到才给你加上。 -一夫- ♀ (146 bytes) () 12/15/2011 postreply 21:55:06

• 如果是小区周围MOBILE HOMES比较多呢? -whatif2007- ♀ (155 bytes) () 12/15/2011 postreply 22:11:27

• 回复：如果是小区周围MOBILE HOMES比较多呢? -一夫- ♀ (150 bytes) () 12/15/2011 postreply 22:27:53

• 另外，20万，我肯定不买在这个区里。 -一夫- ♀ (71 bytes) () 12/15/2011 postreply 22:34:43

• 回复：另外，20万，我肯定不买在这个区里。 -whatif2007- ♀ (136 bytes) () 12/15/2011 postreply 22:51:14

• 回复：my model to calculate ROI on my investment property -forqi- ♀ (58 bytes) () 12/15/2011 postreply 21:35:15

• 回复：回复：my model to calculate ROI on my investment property -whatif2007- ♀ (93 bytes) () 12/15/2011 postreply 21:43:50