ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Rent Vs Buying a home calculatorif you don't understand this calcultor visit our website and read slides-
https://www.quantzaar.com/personal-finance/level-0/chapter-4		For more details- please contact us at www.quantzaar.com
2
3
4
5
Decision - What is better?BUYYou could change things in red according to your personal detail and find your personalize answerHow to use this calculator- Go to File-->>Make a copy(This will make a copy of this excel to your google drive than you can change numbers or use calculator)
6
7
No of Years15
8
9
RENTING CALCULATIONBUYING CALCULATION
10
11
Monthly Rent25,000Cost of Property6,000,000
12
Tax Benefit30%Downpayment20%
13
Effective Rent17,500Downpayment Amount1,200,000
14
Annual Rent210,000Loan Amount4,800,000
15
Interest rate for Loan8.20%
16
Average Annual Rental Increment7%Loan Duration15
17
Total Rent for the period5,277,095EMI46,427
18
Tax Bracket30%
19
Downpayment Amount1,200,000Effective Interest rate for Loan5.7%
20
Saving in Monthly EMI22,334Effective EMI39,834
21
22
Rate of Return on investment10%
Total Net Interest Paid over the period
2,370,117
23
Maintenance Cost0.90%
24
Value of Downpayment saved5,344,703Maintenance Amount4,500
25
Value of EMI saved9,256,775Annual Increase in Maintenance3%
26
Total Maintenance over the period1,021,377
27
Net Benefit of Renting a House9,324,384
28
Total Cost of Buying the House9,391,495
29
30
Increase in Property Value8%
31
Value of Property after the period19,033,015
32
33
Net Benefit of Buying a House9,641,520
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