prepay loan vs invest

	B	C	E	F	G	H	I	K	L	M	N
1
2	Either way is fine		Scenario 1: Invest		125,656	43,958		Scenario 2: Repay		125,656
3			Month	Principal	Interest	EMI	Investment	Month	Amount	Interest	Investment
4			0	500,000				0	500,000
5	Loan	500,000	1	460,209	4,167	43,958	10,000	1	450,209	4,167	53,958
6	Years	1	2	420,086	3,835	43,958	20,083	2	400,003	3,752	53,958
7	Interest	10.00%	3	379,629	3,501	43,958	30,251	3	349,378	3,333	53,958
8			4	338,834	3,164	43,958	40,503	4	298,331	2,911	53,958
9			5	297,700	2,824	43,958	50,840	5	246,860	2,486	53,958
10	Savings	10,000	6	256,223	2,481	43,958	61,264	6	194,959	2,057	53,958
11	Returns	10.00%	7	214,400	2,135	43,958	71,775	7	142,626	1,625	53,958
12			8	172,229	1,787	43,958	82,373	8	89,856	1,189	53,958
13			9	129,706	1,435	43,958	93,059	9	36,647	749	53,958
14			10	86,829	1,081	43,958	103,835	10	-17,006	305	53,958
15			11	43,595	724	43,958	114,700	11	-71,105	-142	53,958
16			12	0	363	43,958	125,656	12	-125,656	-593	53,958
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