ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
How to find ROI using RATE formula??
2
3
4
RATE function
5
Loan typePersonalMain arguments
6
Loan Amount-pv-200000NPERNo of payments
7
Period(Year)-Nper5pmtEMI amount
8
EMI(Monthly)-pmt4550.00pvPresent value
9
Optional arguments
10
fvFuture value
11
typepayment time 0 or 1
12
guessDefault to 10%
13
Rate of Interest(monthly)
14
Rate of Interest(Annually)
15
16
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