In this video on Top 15 Financial Functions in Excel, here we discuss top financial functions used in excel.
๐๐จ๐ฉ ๐
๐ข๐ง๐๐ง๐๐ข๐๐ฅ ๐
๐ฎ๐ง๐๐ญ๐ข๐จ๐ง๐ฌ ๐ข๐ง ๐๐ฑ๐๐๐ฅ
———————————————————-
Below are the top financial functions used in excel.
#1 โ Future Value (FV)
Future Value (FV) Formula
FV (Rate, Nper, [Pmt], PV, [Type])
#2 โ FVSCHEDULE
FVSCHEDULE Formula
FVSCHEDULE = (Principal, Schedule)
#3 โ Present Value (PV)
Present Value (PV) Formula
PV = (Rate, Nper, [Pmt], FV, [Type])
#4 โ Net Present Value (NPV)
Net Present Value (NPV) Formula
NPV = (Rate, Value 1, [Value 2], [Value 3]โฆ)
#5 โ XNPV
XNPV Formula
XNPV = (Rate, Values, Dates)
#6 โ PMT
PMT Formula
PMT = (Rate, Nper, PV, [FV], [Type])
#7 โ PPMT
PPMT Formula
PPMT = (Rate, Per, Nper, PV, [FV], [Type])
#8 โ Internal Rate of Return (IRR)
Internal Rate of Return (IRR) Formula
IRR = (Values, [Guess])
#9 โ Modified Internal Rate of Return (MIRR)
Modified Internal Rate of Return (MIRR) Formula
MIRR = (Values, Finance rate, Reinvestment rate)
#10 โ XIRR
XIRR Formula
XIRR = (Values, Dates, [Guess])
To know more about the ๐๐จ๐ฉ ๐๐ ๐ ๐ข๐ง๐๐ง๐๐ข๐๐ฅ ๐ ๐ฎ๐ง๐๐ญ๐ข๐จ๐ง๐ฌ ๐ข๐ง ๐๐ฑ๐๐๐ฅ, you can go to this ๐ฅ๐ข๐ง๐ค ๐ก๐๐ซ๐:- https://www.wallstreetmojo.com/financial-functions-in-excel/
Subscribe to our channel to get new updated videos. Click the button above to subscribe or click on the link below to subscribe – https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1