Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

The Excel Rate function

excel rate function for calculates interest rate

Interest rate calculates or many poeple may be say rate is the calculates the interest rate to investment. if you want to calculates Rate you can caluculates by formula but, this articel introducing to Rate function in Excel. The Excel Rate function is a financial function that returns the interest rate. you can use the rate function to get the number of periods, future value, present value and periodic payment amount.  

 

Arguments

FV = Future Value
PV = Present Value
Rate = Interest Rate per period
Nper = Number of periods
Type = Payment At (Beginning = 1 , End = 0)
Pmt = Payment Value

 

Step to use Rate function

1. Syntax = Rate(nper, pmt, pv[fv], [type],[guess])

2. Select payment schedule (0 = end of period. 1 = beginning of period)

select payment schedule

3. Result of interest rate (Rate)

result of interest rate

now, you can know about interest rate. for people who want to calculate the Rate. we have rate calculator program. this program will help us to know about the interest rate. so, we don't need to calculate by yourself.

Rate (Interest Rate) 

 

References

Rate.[Online].accessed from: https://support.office.com/th-th/article/rate-.[24-Dec-2019]

How to use excel Rate.[Online].accessed from: https://exceljet.net/excel-functions/excel-rate-function.[24-Dec-2019]

Excel Rate.[Online].accessed from: http://vba-msexcell.blogspot.com/2013/09/rate.html.[24-Dec-2019]

Finance Excel.[Online].accessed from: https://www.thepexcel.com/finance-01-theory/.[24-Dec-2019]

What is the rate function.[Online].accessed from: https://corporatefinanceinstitute.com/resources/excel/functions/rate-function/.[24-Dec-2019]

Recent Topics
Subject
Post Reply
Open
Recent
Features Review : Plugin MLinkarticle untuk menghubungkan konten artikel kepada artikel yang berkaitan
By abdkode Tue 26 Feb 2019 6:37 pm Board Bahasa Language
0
2357
Tue 26 Feb 2019 6:37 pm By abdkode
Features Review : Plugin Authentication untuk login Joomla dengan phpBB
By abdkode Tue 26 Feb 2019 6:29 pm Board Bahasa Language
0
3161
Tue 26 Feb 2019 6:29 pm By abdkode
Features Review : untuk menghasilkan link memuat naik video pada artikel, Joomla 2.5, 3.x
By abdkode Tue 26 Feb 2019 5:26 pm Board Bahasa Language
0
1911
Tue 26 Feb 2019 5:26 pm By abdkode
Features Review : Plugin MVDO untuk memuat naik video Youtube dan Clipmass
By abdkode Mon 25 Feb 2019 5:54 pm Board Bahasa Language
0
2177
Mon 25 Feb 2019 5:54 pm By abdkode
Features Review : Content Msocial untuk berkongsi kandungan artikel ke Facebook, Twitter, Google Plus dan Line
By abdkode Mon 25 Feb 2019 4:56 pm Board Bahasa Language
0
1849
Mon 25 Feb 2019 4:56 pm By abdkode
Features Review : Module Mod slideshowck untuk membantu memaparkan imej dan video Youtube secara slaid
By abdkode Mon 25 Feb 2019 2:19 pm Board Bahasa Language
0
1877
Mon 25 Feb 2019 2:19 pm By abdkode
Features Review : Mod MD recent untuk menunjukkan Papan phpbb pada Joomla.
By abdkode Fri 22 Feb 2019 6:59 pm Board Bahasa Language
0
2482
Fri 22 Feb 2019 6:59 pm By abdkode
Features Review : Mod vinaora visitors counter untuk menghitungkan pelewat laman web di joomla
By abdkode Fri 22 Feb 2019 4:17 pm Board Bahasa Language
0
2370
Fri 22 Feb 2019 4:17 pm By abdkode
Features Review : Components MApplication Form untuk permohonan pekerjaan melalui laman web.
By abdkode Fri 22 Feb 2019 3:25 pm Board Bahasa Language
0
2620
Fri 22 Feb 2019 3:25 pm By abdkode
Features Review : Components MComponentgen & M Packet untuk membantu dengan Menjana Komponen, Modul, Plugin
By abdkode Fri 22 Feb 2019 2:26 pm Board Bahasa Language
0
2547
Fri 22 Feb 2019 2:26 pm By abdkode
Features Review : Components MCharts untuk memproses data dari MJForms menjadi graf
By abdkode Fri 22 Feb 2019 2:02 pm Board Bahasa Language
0
2404
Fri 22 Feb 2019 2:02 pm By abdkode
Features Review : Components MDBridge untuk menyambung data pengguna antara Joomla dan PHPbb Webboard
By abdkode Thu 21 Feb 2019 6:04 pm Board Bahasa Language
0
2523
Thu 21 Feb 2019 6:04 pm By abdkode
Features Review : MDEvents untuk mengurus pelbagai jadual data aktiviti
By abdkode Thu 21 Feb 2019 4:51 pm Board Bahasa Language
0
1593
Thu 21 Feb 2019 4:51 pm By abdkode
Features Review : Component MJUpgrade untuk menaik taraf Joomla 1.5 ke Joomla 2.5, 3.X
By abdkode Thu 21 Feb 2019 4:10 pm Board Bahasa Language
0
5446
Thu 21 Feb 2019 4:10 pm By abdkode
Features Review : Mod Mslideshows untuk memaparkan gambar, video Youtube dari kandungan
By abdkode Thu 21 Feb 2019 3:29 pm Board Bahasa Language
0
1206
Thu 21 Feb 2019 3:29 pm By abdkode
Plugin Editors XTD Multicontent 사용 지침과 설명
By wipaporn Thu 21 Feb 2019 12:28 pm Board korean Language - 한국어
0
9052
Thu 21 Feb 2019 12:28 pm By wipaporn
Module M Slideshows 사용 지침과 설명
By wipaporn Thu 21 Feb 2019 12:27 pm Board korean Language - 한국어
0
4812
Thu 21 Feb 2019 12:27 pm By wipaporn
Component M Multisite Master 사용 지침과 설명
By wipaporn Thu 21 Feb 2019 12:27 pm Board korean Language - 한국어
0
4974
Thu 21 Feb 2019 12:27 pm By wipaporn
Component M Multisite Client 사용 지침과 설명
By wipaporn Thu 21 Feb 2019 12:27 pm Board korean Language - 한국어
0
7831
Thu 21 Feb 2019 12:27 pm By wipaporn
MDFiles Featured 사용 지침과 설명
By wipaporn Thu 21 Feb 2019 12:26 pm Board korean Language - 한국어
0
9000
Thu 21 Feb 2019 12:26 pm By wipaporn