StockEducation
Fundamental Analysis

Chapter 21 · Master formula sheet

Formula sheet — by sector

Banking, microfinance, hydropower, hotels, investment companies and both insurance types.

27 of 30 · 8 min

Banking and microfinance

MetricFormulaDirection
NPL ratioNPL ÷ Total loans × 100Lower better
Provision coverageProvisions ÷ Gross NPL × 100Higher safer
NIMNet interest income ÷ Avg earning assets × 100Higher better
Cost-to-incomeOpex ÷ Operating income × 100Lower better
CARCapital ÷ Risk-weighted assets × 100Above regulatory minimum
CD ratioCredit ÷ Deposits (NRB definition)Headroom matters
Opex ÷ portfolioOperating expense ÷ Avg loan portfolioLower better (MFI)

Hydropower and hotels

MetricFormulaDirection
CUFActual generation ÷ Max possible × 100Against design estimate
Revenue per MWRevenue ÷ Installed MWHigher better
Cost per MWProject cost ÷ Installed MWLower better
Debt per MWProject debt ÷ Installed MWLower safer
DSCRCash available for debt service ÷ Debt serviceAbove 1.0 required
OccupancyOccupied ÷ Available rooms × 100Higher better
ADRRoom revenue ÷ Rooms soldHigher better
RevPARADR × OccupancyHigher better

Investment companies and insurance

MetricFormulaDirection
NAV per share(Assets − Liabilities) ÷ Shares
Premium / discount(Price − NAV/sh) ÷ NAV/sh × 100Discount common
Loss ratioIncurred claims ÷ Earned premium × 100Lower better
Expense ratioUnderwriting expenses ÷ Earned premium × 100Lower better
Combined ratioLoss ratio + Expense ratioBelow 100% = underwriting profit
Solvency ratioAvailable ÷ Required solvency marginAbove regulatory minimum
PersistencyPolicies still in force ÷ Policies written × 100Higher better

Saved in this browser only — there is no account to create. Clearing your browser data clears your progress.