Discover and read the best of Twitter Threads about #excelforfinance
Most recents (1)
10 IMPORTANT EXCEL FUNCTIONS that you should master to perform financial analysis and modeling like a pro. 💯🧵
Save this for future use.
#excelforfinance #financialanalysis #financialmodeling
Save this for future use.
#excelforfinance #financialanalysis #financialmodeling
[1] XNPV:
Calculates the net present value (NPV) for a series of cash flows that may or may not be periodic.
Calculates the net present value (NPV) for a series of cash flows that may or may not be periodic.
Formula: =XNPV(rate, values, dates)
where rate is the discount rate, values are the cash flows, and dates are the corresponding dates of the cash flows.
where rate is the discount rate, values are the cash flows, and dates are the corresponding dates of the cash flows.
