ABCDEGHIJKLMNOPQRSTUVWXYZ
1
2
Buying vs Renting Calculator By ChilliWealth.com
3
4
Buy Now Scenario InputsValuesInstructions
5
Cost of the property today₹ 20,000,000.00Current 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, years15
10
11
Save Now Buy Later Scenario InputsValuesInstructions
12
Years to stay on rent7Choose 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
Save Now Buy Later
21
Property
Scenario A (Buy Now)
Scenario B (Buy Later)Comments
22
Year of BuyingYear 1Year 8
23
Home Loan start yearYear 1Year 8
24
Value₹ 20,000,000.00₹ 28,142,008.455% CAGR aprreciation in 7 years
25
Rent p.m.₹ 0.00₹ 50,000.00
26
Rent CAGR0.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 CAGR0.0%13.33%
Based on Nifty 50 Historical CAGR for 7 years
30
Investment Maturity Value₹ 0.00₹ 19,525,219.13
31
Downpayment₹ 2,000,000.00₹ 19,525,219.13
32
Home Loan Principal₹ 18,000,000.00₹ 8,616,789.32
33
Home Loan Rate of Interest10%10%
34
Home Loan duration, years158
35
Total Interest Payment ( Total Debt paid)₹ 16,529,460.31₹ 3,831,720.31Total Debt Saved = INR 12697740
36
EMI p.m.₹ 191,830.34₹ 129,671.98
37
Equal Annual Payments₹ 2,301,964.02₹ 1,556,063.70
38
Total Cost of the property₹ 36,529,460.31₹ 36,173,728.77
39
Total Own money outflow₹ 36,529,460.31₹ 29,715,939.80Direct Saving = INR 6813521
40
Total Money gained by compounding of investment
₹ 0.00₹ 7,611,470.99Compounding helped with INR 7611471
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