DB Function in Excel: Declining-Balance Depreciation
DB calculates depreciation using a fixed-rate declining balance derived from cost, salvage and life, with an optional first-year month count.
Read article →Financial
Excel Financial functions explained with syntax, examples and common mistakes.
SLN Function in Excel: Straight-Line Depreciation
SLN Function in Excel: Straight-Line Depreciation
FinancialLevel: IntermediateAvailable in: Excel 2007+SLN returns equal depreciation for each period of an asset's life.Syntax=SLN(cost, salvage.
Read article →CUMIPMT Function in Excel: Total Interest Over a Range of EMIs
CUMIPMT Function in Excel: Total Interest Over a Range of EMIs
CUMIPMT totals the interest paid between two payment numbers — e.g. for one financial year. CUMPRINC does the same for principal.
Read article →IPMT Function in Excel: Interest Part of an EMI
IPMT Function in Excel: Interest Part of an EMI
IPMT returns how much of a given EMI is interest; PPMT returns the principal part. Together they always equal PMT.
Read article →EFFECT Function in Excel: Real Annual Rate With Compounding
EFFECT Function in Excel: Real Annual Rate With Compounding
EFFECT converts a nominal annual rate into the effective rate after compounding. NOMINAL does the reverse.
Read article →RATE Function in Excel: The Interest Rate Hidden in a Loan
RATE Function in Excel: The Interest Rate Hidden in a Loan
RATE works out the interest rate from the loan amount, EMI and term — useful for checking “0% EMI” and flat-rate offers.
Read article →NPV Function in Excel: Net Present Value of Future Cash Flows
NPV Function in Excel: Net Present Value of Future Cash Flows
NPV discounts future cash flows to today’s value at a given rate — the core of investment appraisal.
Read article →PMT Function in Excel: Loan EMI in One Formula
PMT Function in Excel: Loan EMI in One Formula
PMT calculates the fixed periodic payment for a loan — the EMI on home, car and personal loans.
Read article →