tgoop.com/R_Experts/1326
Last Update:
Excel functions you should know if you're into financial modeling.
1- XNPV
Formula: =XNPV(discount_rate, cash_flows, dates)
2- XIRR
Formula: =XIRR(cash flows, dates)
3- MIRR
Formula: =MIRR(cash flows, cost of borrowing, reinvestment rate)
4- PMT
Formula: =PMT(rate, number of periods, present value)
5- IPMT
Formula: = IPMT(rate, current period #, total # of periods, present value)
6- EFFECT
Formula: =EFFECT(interest rate, # of periods per year)
7- DB
Formula: =DB(cost, salvage value, life/# of periods, current period)
8- RATE
Formula: =RATE(# of periods, coupon payment per period, price of bond, face value of bond, type)
9- FV
Formula: =FV(rate, # of periods, payments, starting value, type)
10- SLOPE
Formula: =SLOPE(dependent variable, independent variable)
🌐تهیه شده توسط تیم تحلیلی
╭──•═✾®✾═•──╮
•• @R_Experts •••
╰──•═✾®✾═•──╯
BY |R| Experts
Share with your friend now:
tgoop.com/R_Experts/1326