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 »

Excel MIRR Function

This post will guide you how to use Excel MIRR function with syntax and examples in Microsoft excel. Description The Excel MIRR function returns the modified internal rate of return for a series of cash flows and the cash flows must be occurred at regular intervals (monthly or annually). MIRR considers both the cost of… read more »

Excel ISPMT Function

This post will guide you how to use Excel ISPMT function with syntax and examples in Microsoft excel. Description The Excel ISPMT function used to calculate the interest paid during a specific period of an investment. The ISPMT function is a build-in function in Microsoft Excel and it is categorized as a Financial Function. The… read more »

Excel IRR Function

This post will guide you how to use Excel IRR function with syntax and examples in Microsoft excel. Description The Excel IRR function returns the internal rate of return for a series of cash flows and the cash flows must be occurred at regular intervals (monthly or annually). The internal rate of return is the… read more »

Excel IPMT Function

This post will guide you how to use Excel IPMT function with syntax and examples in Microsoft excel. Description The Excel IPMT function used to calculate the interest payment for an investment based on a constant payment schedule and a constant interest rage. The IPMT function is a build-in function in Microsoft Excel and it… read more »

Excel FV Function

This post will guide you how to use Excel FV function with syntax and examples in Microsoft excel. Description The Excel FV function used to calculate the future value of an investment based on a constant interest rate. So you can use the FV function to get the future value of an investment with either… read more »

Excel DDB Function

This post will guide you how to use Excel DDB function with syntax and examples in Microsoft excel. Description The Excel DB function returns the depreciation of an asset for a specified period using the double-declining balance method or you can also use some other method to get the depreciation. The DB function is a build-in… read more »

Excel DB Function

This post will guide you how to use Excel DB function with syntax and examples in Microsoft excel. Description The Excel DB function returns the depreciation of an asset for a specified period using the fixed-declining balance method. The DB function is a build-in function in Microsoft Excel and it is categorized as a Financial Function…. read more »

Excel Amorlinc Function

This post will guide you how to use Excel AMORLINC function with syntax and examples in Microsoft excel. Description The Excel AMORLINC function returns the linear depreciation of an asset for each accounting period. This function is provided for French accounting system. The AMORLINC function is a build-in function in Microsoft Excel and it is categorized… read more »

Excel Amordegrc Function

This post will guide you how to use Excel AMORDEGRC function with syntax and examples in Microsoft excel. Description The Excel AMORDEGRC function returns the linear depreciation of an asset for each accounting period by using a depreciation coefficient. The AMORDEGRC function is a build-in function in Microsoft Excel and it is categorized as a Financial… read more »

Excel AccrintM Function

This post will guide you how to use Excel ACCRINTM function with syntax and examples in Microsoft excel. Description The Excel ACCRINTM function returns the accrued interest for a security that pays interest at maturity. The ACCRINTM function is a build-in function in Microsoft Excel and it is categorized as a Financial Function. The ACCRINTM function… read more »

Sidebar