Excel Financial Functions

Excel XIRR Function

This post will guide you how to use Excel XIRR function with syntax and examples in Microsoft excel. Description The Excel XIRR function returns the internal rate of return for a series of cash flows that is not necessarily periodic. And if you want to get the internal rate of return for a series of… read more »

Excel VDB Function

This post will guide you how to use Excel VDB function with syntax and examples in Microsoft excel. Description The Excel VDB function calculates the depreciation of an asset for a specified period based on the double declining balance method. And it will return a numeric value. The VDB function is a build-in function in… read more »

Excel SYD Function

This post will guide you how to use Excel SYD function with syntax and examples in Microsoft excel. Description The Excel SYD function calculates the sum-of-years’digits depreciation of an asset for a specified period. And it will return a numeric value. The SYD function is a build-in function in Microsoft Excel and it is categorized… read more »

Excel SLN Function

This post will guide you how to use Excel SLN function with syntax and examples in Microsoft excel. Description The Excel SLN function calculates the depreciation of an asset for one period based on the straight line depreciation. And it will return a numeric value. The SLN function is a build-in function in Microsoft Excel… read more »

Excel PV Function

This post will guide you how to use Excel PV function with syntax and examples in Microsoft excel. Description The Excel PV function returns the present value of a loan or investment based on constant payments and a constant interest rate. So you can use the PV function to get the present value based on… read more »

Excel RATE Function

This post will guide you how to use Excel RATE function with syntax and examples in Microsoft excel. Description The Excel RATE function returns the interest rate per payment period of an annuity. The RATE function is a build-in function in Microsoft Excel and it is categorized as a Financial Function. The RATE function is… read more »

Excel PPMT Function

This post will guide you how to use Excel PPMT function with syntax and examples in Microsoft excel. Description The Excel PPMT function returns the payment amount on the principal for a given period for a loan or investment based on constant payments and a constant interest rate. So you can use PPMT function to… read more »

Excel PMT Function

This post will guide you how to use Excel PMT function with syntax and examples in Microsoft excel. Description The Excel PMT function returns the payment amount for a loan or investment based on constant payments and a constant interest rate. The PMT function is a build-in function in Microsoft Excel and it is categorized… read more »

Excel NPV Function

This post will guide you how to use Excel NPV function with syntax and examples in Microsoft excel. Description The Excel NPV function returns the net present value of an investment by using a discount rate and a series of future cash flows (future payments and income). The NPV function is a build-in function in… read more »

Excel NPER Function

This post will guide you how to use Excel NPER function with syntax and examples in Microsoft excel. Description The Excel NPER function returns the number of periods for an investment or loan based on periodic payment amount and a constant interest rate. The NPER function is a build-in function in Microsoft Excel and it… read more »

Sidebar