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
Benefits and applications of moving averages
By numtan5839 Mon 18 Nov 2019 10:47 am Board English Language
0
140
Mon 18 Nov 2019 10:47 am By numtan5839
Moving Average
By numtan5839 Sat 16 Nov 2019 2:45 pm Board English Language
0
121
Sat 16 Nov 2019 2:45 pm By numtan5839
weighted arithmetic mean
By numtan5839 Sat 16 Nov 2019 11:56 am Board English Language
0
96
Sat 16 Nov 2019 11:56 am By numtan5839
Digital Marketing Training in Mumbai
By Kanchaan Fri 15 Nov 2019 6:10 pm Board English Language
1
701
Fri 06 Dec 2019 3:16 pm By benjamin28
Thailand Post appease e-commerce with ePacket service
By numtan5839 Fri 15 Nov 2019 5:59 pm Board English Language
0
240
Fri 15 Nov 2019 5:59 pm By numtan5839
The character that precedes Tracking Number - Thailand Post Track & Trace
By numtan5839 Fri 15 Nov 2019 5:09 pm Board English Language
0
94
Fri 15 Nov 2019 5:09 pm By numtan5839
downloading MD Watermark
By bfred Fri 04 Oct 2019 3:21 pm Board English Language
6
1116
Mon 30 Dec 2019 7:26 pm By mindphp
Features Review : Component Mjform Advance untuk meningkatkan form atau borang untuk laman web dgn lebih baik
By abdkode Mon 22 Apr 2019 6:51 pm Board Bahasa Language
0
8411
Mon 22 Apr 2019 6:51 pm By abdkode
Features Review : Mhosting Components untuk mengumpul Packet hosting
By abdkode Mon 22 Apr 2019 6:50 pm Board Bahasa Language
0
1649
Mon 22 Apr 2019 6:50 pm By abdkode
Features Review : Components MD Gallery untuk membuat gelari dalam laman web
By abdkode Mon 22 Apr 2019 6:49 pm Board Bahasa Language
0
3757
Mon 22 Apr 2019 6:49 pm By abdkode
3 Investment Worthly in Thaland
By wannapat Tue 19 Mar 2019 4:38 pm Board Chinese Language - 简体中文
0
14955
Tue 19 Mar 2019 4:38 pm By wannapat
Features Review : Plugin Addons Payment Omise untuk membuat pembayaran melalui Omise
By abdkode Mon 11 Mar 2019 6:58 pm Board Bahasa Language
0
2081
Mon 11 Mar 2019 6:58 pm By abdkode
Features Review : Memperkenalkan Mooziicart untuk Joomla
By abdkode Thu 07 Mar 2019 7:06 pm Board Bahasa Language
0
2433
Thu 07 Mar 2019 7:06 pm By abdkode
Features Review : Plugin M Product Match untuk menghungkan produk dengan artikel
By abdkode Thu 07 Mar 2019 6:19 pm Board Bahasa Language
0
2540
Thu 07 Mar 2019 6:19 pm By abdkode
Features Review : Module MD Client History modul memapar sajarah yang telah masuk
By abdkode Tue 05 Mar 2019 7:15 pm Board Bahasa Language
0
1808
Tue 05 Mar 2019 7:15 pm By abdkode
Features Review : Plugin M Animate Number untuk memaparkan nombor yang bergerak
By abdkode Mon 04 Mar 2019 7:02 pm Board Bahasa Language
0
1995
Mon 04 Mar 2019 7:02 pm By abdkode
Features Review : Plugin PayToRead untuk mempaparkan teks hanya sebahagian
By abdkode Mon 04 Mar 2019 7:01 pm Board Bahasa Language
0
2193
Mon 04 Mar 2019 7:01 pm By abdkode
Features Review : Component MFacebook untuk membantu pendaftaran laman web dgn Facebook
By abdkode Mon 04 Mar 2019 6:57 pm Board Bahasa Language
0
2630
Mon 04 Mar 2019 6:57 pm By abdkode
Features Review : MJClone untuk mengklon laman web joomla dan backup
By abdkode Thu 28 Feb 2019 6:59 pm Board Bahasa Language
0
2906
Thu 28 Feb 2019 6:59 pm By abdkode
Features Review : Module Mrelated Article Specific Category untuk menyimpan sejarah lawatan
By abdkode Thu 28 Feb 2019 6:48 pm Board Bahasa Language
0
1728
Thu 28 Feb 2019 6:48 pm By abdkode