Percentage change in Excel: growth, declines and zero bases
Calculate percentage change in Excel with one formula, catch the ratio-not-change mistake, and handle negative and zero starting values and percentage points on a checked variance table.
THE FINX JOURNAL LEARN BY DOING
Excel for finance
Make formulas behave the way you intend. Work through references, lookups and the small details that make a spreadsheet reliable.
In this topic
PAGE 2
CAGR in Excel: calculate growth and catch the wrong period count
Calculate CAGR in Excel from a five-year revenue series, compare it with the average yearly growth rate, catch the off-by-one period count and convert an annual rate to monthly.
Convert text to numbers in Excel without damaging identifiers
Diagnose a total that silently ignores text-stored amounts, convert the amount column with VALUE or Paste Special, and keep leading-zero account codes intact.
NPV in Excel: formula, worked example and initial investment
Use Excel's NPV formula with a worked cash-flow example. Put the initial investment outside NPV, check timing errors, and compare NPV with XNPV.
PMT in Excel: calculate and check a loan payment
Calculate a loan payment with Excel's PMT function, keep the sign and rate-period conventions straight, and reconcile every payment into interest and principal.
SUMIF vs SUMIFS: build a checked finance report
Compare SUMIF and SUMIFS on a small invoice ledger: entity and status totals, January date boundaries, silent argument-order zeros and a reconciliation check.