Buying vs Renting Calculator_ChilliWealth.com.xlsx

	B	C	D	E
1
2	Buying vs Renting Calculator			By ChilliWealth.com
3
4	Buy Now Scenario Inputs	Values	Instructions
5	Cost of the property today	₹ 20,000,000.00	Current value of the property
6	Downpayment %age of total cost of the property	10%	%age of current cost to be paid as downpayment (INR 2000000)
7	Current rent p.m. of the same property	₹ 50,000.00
8	Loan rate of interest % p.a.	10%
9	Loan period, years	15
10
11	Save Now Buy Later Scenario Inputs	Values	Instructions
12	Years to stay on rent	7	Choose years less than Loan period years
13	Property Value growth Rate CAGR %	5%	Avg annual growth rate at which property will appreciate
14	Rent growth Rate CAGR %	8%	Avg annual growth rate at which rent will grow
15
16	All numbers of OK!
17	Input in color cells
18
19	Results
20	Recommendation	Buy Now
21	Property	Scenario A (Buy Now)	Scenario B (Buy Later)	Comments
22	Year of Buying	Year 1	Year 8
23	Home Loan start year	Year 1	Year 8
24	Value	₹ 20,000,000.00	₹ 28,142,008.45	5% CAGR aprreciation in 7 years
25	Rent p.m.	₹ 0.00	₹ 50,000.00
26	Rent CAGR	0.0%	8.0%	CAGR for 7 years
27	Total Rent Paid	₹ 0.00	₹ 5,353,682.02
28	Investment amount p.m.	₹ 0.00	₹ 141,830.34	Fixed and shortfall covered by salary increment
29	Investment Growth CAGR	0.0%	0.00%	Based on Nifty 50 Historical CAGR for 7 years
30	Investment Maturity Value	₹ 0.00	₹ 11,913,748.15
31	Downpayment	₹ 2,000,000.00	₹ 11,913,748.15
32	Home Loan Principal	₹ 18,000,000.00	₹ 16,228,260.31
33	Home Loan Rate of Interest	10%	10%
34	Home Loan duration, years	15	8
35	Total Interest Payment ( Total Debt paid)	₹ 16,529,460.31	₹ 7,216,394.92	Total Debt Saved = INR 9313066
36	EMI p.m.	₹ 191,830.34	₹ 244,215.16
37	Equal Annual Payments	₹ 2,301,964.02	₹ 2,930,581.90
38	Total Cost of the property	₹ 36,529,460.31	₹ 39,558,403.37
39	Total Own money outflow	₹ 36,529,460.31	₹ 40,712,085.39	Direct Saving = INR 0
40	Total Money gained by compounding of investment	₹ 0.00	₹ 0.00	Compounding helped with INR 1
41
42	Please note this is a mathematical calculator for indicative result purposes. Take a financial decision to invest in financial instrument or asset type after thorough due diligence and research.
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