IRR analysis

	A	B	C	D	E	F	G	H	I	J	K	L
1	Property Analysis
2
3	Purchase Price		130000		Market Capital Growth			2.00%
4	Market Value		130000		Rental Growth			2.00%
5					Increase in rent from Improvements p.a
6					Cost of Improvements				(enter negative number)
7	Rent Per Week		310		Agent Commision
8	Net Rent (Rent-Rates-R&M-Insurance)		11962
9
10
11	Year	0	1	2	3	4	5	6	7	8	9	10
12	Cashflow	-130000	12,201	12,445	12,694	12,948	13,207	13,471	13,741	14,015	14,296	14,582
13	Improvements
14		-130,000	12,201	12,445	12,694	12,948	13,207	13,471	13,741	14,015	14,296	144,582
15	House Value	130,000	130,000	130,000	130,000	130,000	130,000	130,000	130,000	130,000	130,000	130,000
16	Internal Rate of Return	10.12%	Cashflow
17
18	Year	0	1	2	3	4	5	6	7	8	9	10
19	Capital/Cashflow	-130000	12,201	12,445	12,694	12,948	13,207	13,471	13,741	14,015	14,296	14,296
20	Improvements
21		-130,000	12,201	12,445	12,694	12,948	13,207	13,471	13,741	14,015	14,296	172,765
22	Capital Growth	2,600	2,652	2,705	2,759	2,814	2,871	2,928	2,987	3,046	3,107	3,107
23	House Value	132,600	135,252	137,957	140,716	143,531	146,401	149,329	152,316	155,362	158,469	158,469
24	Internal Rate of Return	11.37%	Capital/Cashflow
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41