Finance rates & interest calculator by Finacue

	A	B	D	E	G	H	J	K	M	N	P	Q
1	DISCOUNTED VALUE OF MONEY		COMPOUND INTEREST YEARLY		COMPOUND INTEREST HALFYEAR		COMPOUND INTEREST QUARTER		COMPOUND INTEREST MONTHLY		FINDS CAGR
2
3
4
5
6
7			PRINCIPAL	12000	PRINCIPAL	100	PRINCIPAL	12000	PRINCIPAL	6000	Principal	110
8			INTEREST	12%	INTEREST	10%	INTEREST	12%	INTEREST	15%	Invest Dt	10-Oct-02
9	AMOUNT	500000	YEAR	20	YEAR	2	YEAR	20	YEAR	20	Maturity	121
10	INTEREST	20%									Redeem Dt	10-Oct-04
11	YEAR	5
12			INTEREST	103755.52	INTEREST	21.55	INTEREST	115690.69	INTEREST	112292.96
13	PRINCIPAL	200938.786	AMOUNT	115755.52	AMOUNT	121.55	AMOUNT	127690.69	AMOUNT	118292.96	CAGR	4.87%
14										.
15
16
17
18	FINDS INVESTMENT AMOUNT FOR RECEIVING YEARLY ANNUITY		YEARLY PAYMENTS MATURITY VALUE		MONTHLY SIP PAYMENTS MATURITY VALUE		PRESENT INVESTMENT FINDER FOR MATURITY REQUIRED		FINDS RATE OF INTEREST ON ANNUAL SIP FOR A TARGET MATURITY		Interest Rate on a loan with fixed monthly payment
19
20
21
22
23
24
25	ANNUITY	1000	INVEST	45000	INVEST	100	MATURITY	500	INVEST	25000	Instalment	41000
26	YEAR	25	YEAR	20	MONTH	60	YEAR	10	YEAR	30	MONTH	300
27	INTEREST	6%	INTEREST	13%	INTEREST	7.25%	INTEREST	7%	Maturity	11500000	Loan Amt	4800000
28
29
30	PRINCIPAL	12783	MATURITY	3,642,607	MATURITY	7,206	PRINCIPAL	254.1746461	Int Rate	14.60%	Int Rate	9%
31
32
33
34
35
36
37	FINDS CAGR		FINDS THE AMOUNT OF SIP FOR A SPECIFIC MATURITY, PERIOD AND INTEREST RATE		Interest Rate on a loan with fixed monthly payment		FINDS RATE OF INTEREST ON MONTHLY SIP FOR A TARGET MATURITY
38
39
40
41
42
43	Principal	100
44	Invest Dt	10-Oct-02	MONTH	120	Instalment	1500	INVEST	2000
45	Maturity	121	Maturity	1500000	MONTH	84	MONTH	13
46	Redeem Dt	10-Oct-04	Int Rate	15%	Loan Amt	100000	Maturity	28700
47
48
49	CAGR	10%	Monthly	5,450	Int Rate	7%	Int Rate	16.82%
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