Excel Functions for Financial Analysis

Excel Functions for Financial Analysis for Finance Manager:

AMORDEGRC (cost, date purchased, first period, salvage, period, rate, basis)

If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account.

AMORLINC (cost, date purchased, first period, salvage, period, rate, basis)

Returns the depreciation for each accounting period. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account.

CUMIPMT

Returns the cumulative interest paid between two periods.

CUMPRINC

Returns the cumulative principal paid on a loan between two periods

DB (cost, salvage, life, period, month)

Returns the depreciation of an asset for a specified period using the fixed-declining balance method.

DDB (cost, salvage, life, period, factor)

Returns the depreciation of an asset for a specified period using the double declining balance method or some other method you specify

MIRR (values, finance rate reinvest rate)

Returns the modified internal rate of return for a series of periodic cash flows. MIRR considers both the cost of the investment and the interest received on reinvestment of cash.

IRR (values, guess)

Returns the internal rate of return for a series of cash flows

PV (rate, nper pmt, fv, type)

Returns the present value of an investment

NPV (rate, value1, value2,)

Returns the net present value of an investment based on a series of periodic cash flows and a discount rate

XNPV (rate, values, dates)

Returns the net present value for a schedule of cash flows that is not necessarily periodic.

SLN (cost, salvage, life)

Returns the straight-line depreciation of an asset for one period

SYD (cost, salvage, life, per)

Returns the sum-of-years' digits depreciation of an asset for a specified period

        SYD = (cost-salvage) x (life – per + 1) x 2

                (Life)(Life + 1)

VDB (cost, salvage, life, start period, end period, factor, no switch)

Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. VDB stands for variable declining balance.

XIRR (values, dates, guess)

Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.