ExcelFinanceGlobalUDFs is a collection of custom built finance Excel functions that can be used globally, i.e. in any Excel workbook.
- Copy time_value.xlam into Excel Startup folder:
- For Microsoft 2011, it is HD:Applications:Microsoft Office 2011:Office:Startup:Excel
- Copy time_value.xlam into Excel Startup folder:
- Unfortunately the Startup folder varies quite a bit on Windows
- Ex: C:\Program Files\Microsoft Office\Office14\XLSTART
NNPV: NPV function that accounts for outflows at time zero
- requires inputs rate and cashflows, in that order
PVA: present value of an annuity
- requires inputs rate, number of periods and payments, in that order
FVA: future value of an annuity
- requires inputs rate, number of periods and payments, in that order
PVGA: present value of a growing annuity
- requires inputs rate, growth rate, number of periods and payments, in that order
FVGA: future value of a growing annuity
- requires inputs rate, growth rate, number of periods and growth rate, in that order
PVGP: present value of growing perpetuity
- requires inputs rate, growth rate, growth rate, in that order
YTM: yield to maturity
- requires inputs rate, number of periods, price, face_value, in that order