The Excel Rate function
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)
3. Result of interest rate (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.
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]
