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
"Module Mrelated Article Specific Category" (저장소 검색 이력)을 소개한다
By wipaporn Wed 13 Feb 2019 3:46 pm Board korean Language - 한국어
1
2536
Thu 27 Feb 2020 10:20 pm By mindphp
MDFiles Categories Module을 소개한다.
By wipaporn Wed 13 Feb 2019 3:44 pm Board korean Language - 한국어
0
618
Wed 13 Feb 2019 3:44 pm By wipaporn
MDFile의 파일을 보여주는 mod mdfile recent 모듈 소개
By wipaporn Wed 13 Feb 2019 3:41 pm Board korean Language - 한국어
0
797
Wed 13 Feb 2019 3:41 pm By wipaporn
Joomla용 MDFile Components를 소개하고, 웹사이트에서 문서 파일을 다운로드하는 것을 돕는다.
By wipaporn Wed 13 Feb 2019 3:37 pm Board korean Language - 한국어
0
303
Wed 13 Feb 2019 3:37 pm By wipaporn
介绍joomla的components mdfile,帮助在网站上下载文档文件。
By wipaporn Wed 13 Feb 2019 3:32 pm Board Chinese Language - 简体中文
0
10039
Wed 13 Feb 2019 3:32 pm By wipaporn
介绍mod mdfile recent模块以显示mdfile中的文件
By wipaporn Wed 13 Feb 2019 3:29 pm Board Chinese Language - 简体中文
0
15163
Wed 13 Feb 2019 3:29 pm By wipaporn
介绍mod mdfiles categories模块从mdfile中引入类别。
By wipaporn Wed 13 Feb 2019 3:27 pm Board Chinese Language - 简体中文
0
20711
Wed 13 Feb 2019 3:27 pm By wipaporn
介绍Module Mrelated Article Specific Category。存储浏览历史记录。
By wipaporn Wed 13 Feb 2019 3:23 pm Board Chinese Language - 简体中文
0
743
Wed 13 Feb 2019 3:23 pm By wipaporn
介绍Component mFaceBook以帮助在Facebook上注册网站成员资
By wipaporn Wed 13 Feb 2019 3:20 pm Board Chinese Language - 简体中文
0
243
Wed 13 Feb 2019 3:20 pm By wipaporn
介绍Paytoread。插件只显示一些文本。
By wipaporn Wed 13 Feb 2019 3:17 pm Board Chinese Language - 简体中文
0
225
Wed 13 Feb 2019 3:17 pm By wipaporn
介绍插件MD水印(MD水印插件),自动水印插件
By wipaporn Wed 13 Feb 2019 3:15 pm Board Chinese Language - 简体中文
0
971
Wed 13 Feb 2019 3:15 pm By wipaporn
Introducing Plugin MD Watermark, plug for automatic watermarking
By wipaporn Wed 13 Feb 2019 3:11 pm Board English Language
0
1263
Wed 13 Feb 2019 3:11 pm By wipaporn
Introducing PayToRead. The plugin shows only some text.
By wipaporn Wed 13 Feb 2019 3:08 pm Board English Language
0
1388
Wed 13 Feb 2019 3:08 pm By wipaporn
Introducing Component MFacebook to help with website membership registration with Facebook
By wipaporn Wed 13 Feb 2019 3:06 pm Board English Language
0
1362
Wed 13 Feb 2019 3:06 pm By wipaporn
Introducing Mrelated Article Specific Category Module (Storage browsing history).
By wipaporn Wed 13 Feb 2019 3:03 pm Board English Language
0
1472
Wed 13 Feb 2019 3:03 pm By wipaporn
Introducing Mod MDFiles Categories Module Bring Categories from MDFile.
By wipaporn Wed 13 Feb 2019 2:59 pm Board English Language
0
4484
Wed 13 Feb 2019 2:59 pm By wipaporn
Introducing the Mod MDFile recent module to show files from MDFile
By wipaporn Wed 13 Feb 2019 2:56 pm Board English Language
0
5718
Wed 13 Feb 2019 2:56 pm By wipaporn
Introducing MDFile Components for Joomla, helping to download document files on the website.
By wipaporn Wed 13 Feb 2019 2:49 pm Board English Language
1
2107
Tue 04 Feb 2020 5:33 pm By prmindphp
Features Review : Components MDFile membantu memuat turun fail dokumen di laman web.
By abdkode Wed 13 Feb 2019 2:37 pm Board Bahasa Language
0
859
Wed 13 Feb 2019 2:37 pm By abdkode
Features Review : Mod MDFile recent Module yang menunjukkan fail yang diupload
By abdkode Tue 12 Feb 2019 6:45 pm Board Bahasa Language
0
1129
Tue 12 Feb 2019 6:45 pm By abdkode