RRI Function in Excel: Equivalent Annual Growth Rate (CAGR)
RRI returns the constant growth rate needed to go from a start value to an end value — i.e. CAGR in one function.
Read article →MIRR Function in Excel: IRR With Realistic Reinvestment
MIRR Function in Excel: IRR With Realistic Reinvestment
MIRR fixes IRR's optimistic assumption that cash is reinvested at the IRR itself, using separate finance and reinvestment rates.
Read article →XNPV Function in Excel: NPV for Cash Flows on Specific Dates
XNPV Function in Excel: NPV for Cash Flows on Specific Dates
XNPV discounts cash flows that happen on irregular dates — more accurate than NPV for real projects.
Read article →DB Function in Excel: Declining-Balance Depreciation
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 →SLN Function in Excel: Straight-Line Depreciation
SLN Function in Excel: Straight-Line Depreciation
SLN returns equal depreciation for each period of an asset's life.
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 →SQL GROUP BY and HAVING: Pivot Tables Written in SQL
SQL GROUP BY and HAVING: Pivot Tables Written in SQL
Summarise data with SQL GROUP BY, filter groups with HAVING, and understand the difference from WHERE — explained for Excel users with pivot-table comparisons.
Read article →NPER Function in Excel: How Many Payments Until Paid Off
NPER Function in Excel: How Many Payments Until Paid Off
NPER returns the number of periods needed to repay a loan or reach a savings goal.
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 →PPMT Function in Excel: Principal Part of an EMI
PPMT Function in Excel: Principal Part of an EMI
PPMT returns the principal repaid by a specific EMI.
Read article →Linux Command Line for Windows Users: 20 Commands to Survive a Server
Linux Command Line for Windows Users: 20 Commands to Survive a Server
The 20 Linux terminal commands you need when you first log in to a server — moving around, reading logs, finding files, permissions and…
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 →