Property Investment Comparison v0.1b

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
1	Title:	Property Investment Comparison Workbook			Author:	Alejandro Erickson		Version:	0.1b
2	About	The Property Investment Comparison Workbook calculates cash flows, investment returns, equity, and other financial effects of an investment property. Checked against calculations at http://www.calculator.net/rental-property-calculator.html
3	Instructions	Add a property and related attributes to the 'Inputs' sheet, and enter the 'Unique Label' in 'Outputs' sheet to view the calculations. Duplicate the 'Outputs' sheet as necessary.
4	Disclaimer	The Author does not warrant the correctness of the calculations. The Author takes no responsibility for the consequences of using any version of my Property Investment Comparison workbook for any reason. Do not use this to make your own financial decisions until you have verified the calculations independently.
5	Licensing	Derivatives must include the above disclaimer. The Property Investment Comparison Workbook is released by the Author under the additional terms of https://creativecommons.org/licenses/by-nc/4.0/ .
6		Purchase								Annual Expenses										Annual Income						Financial Parameters	Sale
8	Unique Label	Purchase Price	Description	Down Payment %	Interest Rate	Loan Term	Closing Cost	Initial Repair Cost	Value Post Initial Repair	Property Tax	T. Increase	Insurance	I. Increase	Strata	S. Increase	Maintenance	M. Increase	Other	O. Increase	Rent	Rent Increase	Other	O. Increase	Vacancy Rate	Management	Inflation Rate	Appreciation	Holding Length	Commissions	Sell Closing Costs

9	calculator_net_test	300,000.00	Test	50.00%	5.00%	15	2,000.00	15,000.00	330,000.00	1,500.00	3.00%	600.00	2.00%	3,000.00	2%	3,000.00	3%	0.00	0.00%	18,000.00	2.20%	0.00	0.00%	2.00%	10.00%			25	3.50%	0.00
10	calculator_net_test2	300,000.00	Test	50.00%	5.00%	30	2,000.00	15,000.00	330,000.00	1,500.00	3.00%	600.00	2.00%	3,000.00	2%	3,000.00	3%	0.00	0.00%	18,000.00	2.20%	0.00	0.00%	2.00%	10.00%		5.00%	30		0.00
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101