This post has already been read 1549 times!

100 Essential Financial Formulas with Practical Examples

100 essential financial formulas · practical examples

Illustration displaying 100 key financial formulas, charts, and graphs for finance professionals and students

100 Essential Financial Formulas with Practical Examples

Whether you’re a finance student or a professional, mastering these formulas is key to making sound decisions. In this article, each formula is explained and paired with a practical example to show you how it’s applied in real-world scenarios.

I. Banking & Loan Formulas
II. Investment & Valuation Formulas
III. Corporate Finance & Business Analysis
IV. Excel & Data Analysis Formulas
V. Risk & Portfolio Management Formulas

I. Banking & Loan Formulas

1. Loan EMI Formula

EMI = [P × r × (1+r)ⁿ] / [(1+r)ⁿ – 1]

Explanation: P = principal, r = monthly interest rate (annual rate/12), n = total number of months.

Example: For a ₹1,00,000 loan at 12% p.a. over 5 years (60 months), r = 0.01; EMI ≈ ₹2,220 per month.

The EMI amount is your fixed monthly payment. A lower EMI means lower monthly burden, but may extend the loan term. Use this to compare loan offers.

2. Compound Interest

FV = PV × (1 + r)ⁿ

Explanation: PV = present value, r = interest rate per period, n = number of periods.

Example: ₹10,000 at 8% compounded annually for 5 years gives FV = 10,000 × (1.08)⁵ ≈ ₹14,693.

This shows how your money grows over time. Useful for retirement planning or comparing investment returns.

3. Simple Interest

SI = P × r × t

Explanation: P = principal; r = annual rate; t = time in years.

Example: ₹10,000 at 6% for 3 years: SI = 10,000 × 0.06 × 3 = ₹1,800.

Used for short-term loans or bonds that do not compound. The interest earned (or paid) is linear over time.

4. Present Value (PV)

PV = FV / (1 + r)ⁿ

Explanation: Discounts a future sum (FV) to its value today.

Example: To have ₹15,000 in 4 years at 5% annual discount rate: PV = 15,000 / (1.05)⁴ ≈ ₹12,313.

Helps you decide how much to invest now to reach a future goal. Also used in bond pricing.

5. Future Value (Single Sum)

FV = PV × (1 + r)ⁿ

Explanation: Finds the future value of a current sum.

Example: ₹8,000 at 7% for 3 years: FV = 8,000 × (1.07)³ ≈ ₹9,793.

Estimates what a current investment will grow to. Key for savings targets.

6. Annual Percentage Rate (APR)

Explanation: The yearly interest rate charged on a loan, not accounting for compounding.

Example: A monthly rate of 1% yields an APR of approximately 12%.

APR is the base rate you see in loan ads. Use it to compare loans with the same compounding frequency.

7. Effective Annual Rate (EAR)

EAR = (1 + r/n)ⁿ – 1

Explanation: Converts a nominal rate to an annualized rate accounting for compounding.

Example: For a 12% nominal rate compounded monthly: EAR = (1 + 0.12/12)¹² – 1 ≈ 12.68%.

EAR reveals the true cost of borrowing or true return, considering compounding. Always compare using EAR.

8. Discount Factor

DF = 1 / (1 + r)ⁿ

Explanation: Factor used to discount future cash flows.

Example: With r = 5% and n = 3, DF = 1 / (1.05)³ ≈ 0.8638.

Multiply any future cash flow by the DF to get its present value. Essential for NPV and DCF models.

9. Sinking Fund Payment

PMT = (FV × r) / [(1 + r)ⁿ – 1]

Explanation: Calculates periodic deposits needed to accumulate a desired future value.

Example: To accumulate ₹50,000 in 5 years at 6% annual rate: PMT ≈ ₹743 per year.

Used by companies to set aside money for debt repayment or by individuals for a future goal like a car purchase.

10. Rule of 72

Years to Double ≈ 72 / (annual growth rate in %)

Explanation: Estimates the number of years required to double an investment.

Example: At a 9% growth rate: 72 / 9 = 8 years.

Quick mental math to gauge investment growth. Works for any compounding rate.

II. Investment & Valuation Formulas

11. Net Present Value (NPV)

NPV = Σ [CFₜ / (1 + r)^t] – Initial Investment

Explanation: Sums the present values of future cash flows then subtracts the initial cost.

Example: For cash flows of ₹3,000, ₹4,000, and ₹5,000 over 3 years at 10%, with an investment of ₹10,000, NPV ≈ (3000/1.1 + 4000/1.21 + 5000/1.331) – 10,000 ≈ -₹644.

If NPV > 0, the investment adds value. Negative NPV suggests reject. Used in capital budgeting.

12. Internal Rate of Return (IRR)

Explanation: The discount rate that makes the NPV equal to zero.

Example: For cash flows of -₹10,000, ₹3,000, ₹4,000, ₹5,000, and ₹6,000, the IRR is approximately 12% (calculated using iterative methods).

IRR is the expected annual return. Compare with hurdle rate to decide on projects.

13. Modified IRR (MIRR)

MIRR = [(FV of positive CF / PV of negative CF)^(1/n)] – 1

Explanation: Adjusts for different reinvestment and finance rates.

Example: If positive CF’s FV is ₹15,000, negative CF’s PV is ₹10,000 over 3 years, MIRR ≈ [(15000/10000)^(1/3)] – 1 ≈ 14.47%.

MIRR gives a more realistic picture than IRR by assuming reinvestment at the firm’s cost of capital.

14. Return on Investment (ROI)

ROI = [(Gain – Cost) / Cost] × 100%

Explanation: Measures profit relative to investment cost.

Example: If an investment costs ₹10,000 and returns ₹15,000, ROI = [(15,000–10,000)/10,000]×100% = 50%.

Simple profitability metric. Use to compare efficiency of different investments.

15. Compound Annual Growth Rate (CAGR)

CAGR = (Ending Value / Beginning Value)^(1/n) – 1

Explanation: The mean annual growth rate over n years.

Example: From ₹100,000 to ₹144,000 over 2 years: CAGR = (144,000/100,000)^(1/2) – 1 ≈ 20%.

Smooths volatility; best for comparing historical returns of investments.

16. Discounted Cash Flow (DCF)

Explanation: Uses forecasted cash flows discounted at a chosen rate to determine value.

Example: Forecasted cash flows of ₹10,000 per year for 5 years at 8% discount rate yield DCF ≈ ₹40,000.

Core valuation method. If DCF > current cost, the asset may be undervalued.

17. Dividend Discount Model (DDM)

Price = D₁ / (r – g)

Explanation: Values a stock based on expected future dividends.

Example: With next year’s dividend of ₹5, required return 10%, and growth 3%, Price = 5/(0.10–0.03) ≈ ₹71.43.

Used for stable, dividend-paying companies. If market price < model price, stock may be undervalued.

18. Price-to-Earnings (P/E) Ratio

P/E = Market Price per Share / EPS

Explanation: Indicates how much investors pay per rupee of earnings.

Example: Stock at ₹50 and EPS ₹2 gives a P/E of 25.

High P/E may mean overvaluation or high growth expectations. Compare with industry average.

19. Price-to-Book (P/B) Ratio

P/B = Market Price per Share / Book Value per Share

Explanation: Compares market value to accounting value.

Example: If market price is ₹80 and book value is ₹40, P/B = 2.

P/B < 1 can signal undervaluation; common for banks and asset-heavy firms.

20. Dividend Yield

Dividend Yield = Annual Dividend per Share / Market Price per Share

Explanation: Shows the return from dividends relative to share price.

Example: Annual dividend ₹4 and price ₹100 gives 4% yield.

Income-focused investors look for high dividend yield, but ensure sustainability.

21. Weighted Average Cost of Capital (WACC)

WACC = (E/V × Re) + (D/V × Rd × (1 – Tc))

Explanation: Combines cost of equity and after-tax cost of debt, weighted by market values.

Example: For a firm with equity ₹500,000 (cost 12%), debt ₹300,000 (cost 7%, tax 30%), WACC = (500/800×0.12) + (300/800×0.07×0.7) = 0.075 + 0.0184 = 9.34%.

WACC is the minimum return a company must earn on its assets. Used as discount rate for investment decisions. A lower WACC means cheaper financing.

22. Free Cash Flow (FCF)

FCF = Operating Cash Flow – Capital Expenditures

Explanation: Cash generated after accounting for capital expenditures needed to maintain or expand assets.

Example: If OCF is ₹200,000 and CapEx is ₹50,000, FCF = ₹150,000.

FCF shows how much cash is available for shareholders, debt repayment, or reinvestment. Positive FCF is a sign of financial health.

23. Net Operating Profit After Tax (NOPAT)

NOPAT = Operating Income × (1 – Tax Rate)

Explanation: Profit from operations after taxes, excluding interest.

Example: Operating income ₹100,000, tax 30% => NOPAT = 70,000.

Measures operational efficiency. Used in EVA and free cash flow calculations. It shows profit if the company had no debt.

24. Current Ratio

Current Ratio = Current Assets / Current Liabilities

Explanation: Measures ability to pay short-term obligations.

Example: Current assets ₹200,000, current liabilities ₹100,000 => ratio = 2.

A ratio above 1 indicates good short-term health; too high (>3) may indicate inefficient use of assets. Creditors prefer at least 1.5.

25. Quick Ratio (Acid-Test)

Quick Ratio = (Current Assets – Inventory) / Current Liabilities

Explanation: More conservative than current ratio, excludes inventory.

Example: Current assets ₹200,000, inventory ₹50,000, current liabilities ₹100,000 => (150,000/100,000)=1.5.

Measures ability to meet short-term obligations without selling inventory. A quick ratio < 1 may signal liquidity issues.

26. Debt-to-Equity Ratio

Debt-to-Equity = Total Liabilities / Shareholders' Equity

Explanation: Measures financial leverage.

Example: Total liabilities ₹400,000, equity ₹500,000 => ratio = 0.8.

Indicates how much debt a company uses to finance assets. High ratio (>1-2) means higher risk; lenders use it to assess solvency.

27. Inventory Turnover

Inventory Turnover = Cost of Goods Sold / Average Inventory

Explanation: How many times inventory is sold and replaced over a period.

Example: COGS ₹300,000, average inventory ₹50,000 => turnover = 6.

Higher turnover indicates efficient inventory management. Compare with industry average; too high may risk stockouts.

28. Days Sales Outstanding (DSO)

DSO = (Accounts Receivable / Total Credit Sales) × Number of Days

Explanation: Average collection period for receivables.

Example: AR ₹40,000, credit sales ₹400,000, 365 days => (40,000/400,000)×365 = 36.5 days.

Lower DSO means faster cash collection. If DSO is rising, customers are paying slower – a red flag.

29. Return on Equity (ROE)

ROE = Net Income / Shareholders' Equity

Explanation: Measures profitability relative to equity.

Example: Net income ₹50,000, equity ₹250,000 => ROE = 20%.

Key metric for investors; shows how well equity capital is used. Compare with industry peers. High ROE often indicates competitive advantage.

30. Return on Assets (ROA)

ROA = Net Income / Total Assets

Explanation: Measures how efficiently assets generate profit.

Example: Net income ₹50,000, total assets ₹500,000 => ROA = 10%.

Indicates asset efficiency. A low ROA relative to industry may suggest poor management. Used by banks to assess performance.

III. Corporate Finance & Business Analysis Formulas

31. Net Income

Net Income = Revenue – Expenses

Example: Revenue ₹500,000 minus expenses ₹350,000 gives net income of ₹150,000.

Bottom-line profit. Essential for EPS, ROE, and overall profitability analysis.

32. Gross Profit Margin

Gross Margin = [(Revenue – COGS) / Revenue] × 100%

Example: Revenue ₹400,000 and COGS ₹250,000 yields margin = ((400,000–250,000)/400,000)*100 = 37.5%.

Shows production efficiency. Compare with competitors; declining margin may indicate cost pressure.

33. Operating Profit Margin

Operating Margin = (Operating Profit / Revenue) × 100%

Example: Operating profit ₹80,000 on revenue of ₹400,000 gives 20% margin.

Reflects operating efficiency before financing costs. Used to assess core business profitability.

34. EBITDA

EBITDA = Operating Profit + Depreciation + Amortization

Example: Operating profit ₹70,000, Depreciation ₹20,000, Amortization ₹10,000 yield EBITDA = ₹100,000.

Proxy for operating cash flow. Often used in valuation multiples (EV/EBITDA).

35. Contribution Margin

Contribution Margin = Price per Unit – Variable Cost per Unit

Example: Selling price ₹100 and variable cost ₹60 gives a margin of ₹40 per unit.

Shows how much each unit contributes to fixed costs and profit. Key for pricing and breakeven analysis.

36. Breakeven Point (Units)

Breakeven Units = Fixed Costs / (Price per Unit – Variable Cost per Unit)

Example: Fixed costs ₹50,000, margin per unit ₹25 yields 50,000/25 = 2,000 units.

Minimum sales to avoid loss. Helps set sales targets.

37. Breakeven Point (Revenue)

Breakeven Revenue = Fixed Costs / Contribution Margin Ratio

Example: Fixed costs ₹75,000 and margin ratio 0.5 yields 75,000/0.5 = ₹150,000.

Revenue needed to cover all costs. Useful for planning.

38. Margin of Safety

Margin of Safety = [(Actual Sales – Breakeven Sales) / Actual Sales] × 100%

Example: Actual sales ₹200,000, breakeven ₹150,000 gives (50,000/200,000)*100 = 25%.

Cushion before losses. Higher margin = lower risk.

39. Operating Leverage

Explanation: Reflects how a change in sales volume affects operating income.

Example: If a 10% sales increase leads to a 20% increase in operating profit, operating leverage is high.

High operating leverage magnifies profits in good times but also losses in downturns.

40. Financial Leverage

Financial Leverage = Total Assets / Equity

Example: Assets ₹1,000,000 and equity ₹500,000 yield leverage of 2.

Shows how much assets are funded by equity. Higher leverage increases potential returns but also risk.

41. Combined Leverage

Explanation: The combined effect of operating and financial leverage.

Example: If operating leverage is 1.5 and financial leverage is 2, combined leverage = 1.5×2 = 3.

Measures total risk. A 1% change in sales causes a 3% change in EPS.

42. DuPont Analysis

ROE = (Net Profit Margin) × (Asset Turnover) × (Equity Multiplier)

Example: Margin 10%, turnover 1.8, equity multiplier 1.5 yield ROE = 0.10×1.8×1.5 = 27%.

Breaks down ROE into drivers: profitability, efficiency, and leverage. Helps identify sources of strength/weakness.

43. Economic Value Added (EVA)

EVA = NOPAT – (Capital Employed × WACC)

Example: NOPAT ₹120,000, capital ₹800,000, WACC 10% yield EVA = 120,000 – (800,000×0.10) = ₹40,000.

Positive EVA means value creation. Used for performance-based compensation.

44. Market Value Added (MVA)

Explanation: The difference between the market value and invested capital.

Example: If market value is ₹1,200,000 and invested capital is ₹1,000,000, then MVA = ₹200,000.

MVA measures wealth created for shareholders. A rising MVA indicates good management.

45. Cash Flow Return on Investment (CFROI)

Explanation: A cash-based performance measure comparing operating cash flow to invested capital.

Example: Operating cash flow ₹150,000, invested capital ₹1,000,000 yield CFROI = 15%.

CFROI adjusts for inflation and is used to compare returns across companies/industries.

46. Price-to-Cash Flow Ratio

P/CF = Market Cap / Operating Cash Flow

Example: Market cap ₹2,000,000 and operating cash flow ₹250,000 yield P/CF = 8.

Similar to P/E but based on cash flow; less subject to accounting distortions.

47. EBITDA Margin

EBITDA Margin = (EBITDA / Revenue) × 100%

Example: EBITDA ₹100,000 on revenue ₹500,000 gives margin = 20%.

Measures operating profitability before non-cash charges. Useful for comparing firms with different depreciation.

48. Straight-Line Depreciation

Depreciation = (Cost – Salvage Value) / Useful Life

Example: Cost ₹50,000, salvage ₹5,000, life 10 years: Depreciation = (50,000-5,000)/10 = ₹4,500 per year.

Allocates asset cost evenly over its life. Used for tax and financial reporting.

49. Accumulated Depreciation

Explanation: The total depreciation charged on an asset since acquisition.

Example: After 3 years at ₹4,500 per year, accumulated depreciation = 3 × 4,500 = ₹13,500.

Shows how much of the asset's cost has been expensed. Book value = cost – accumulated depreciation.

50. Amortization of Intangible Assets

Amortization = Cost of Intangible Asset / Useful Life

Example: A patent costing ₹10,000 over 20 years: Amortization = 10,000/20 = ₹500 per year.

Analogous to depreciation for intangibles. Reduces taxable income over the asset's life.

IV. Excel & Data Analysis Formulas

51. SUM

=SUM(range)

Example: =SUM(A1:A5) adds all numbers in cells A1 through A5.

Basic aggregation. Use for totals in financial models.

52. AVERAGE

=AVERAGE(range)

Example: =AVERAGE(B1:B10) calculates the mean of cells B1 to B10.

Quickly find typical value. Often used for historical averages.

53. COUNT

=COUNT(range)

Example: =COUNT(C1:C8) counts numerical cells in the range C1 to C8.

Counts numeric entries; useful for checking data completeness.

54. VLOOKUP

=VLOOKUP(lookup_value, table_array, col_index, [range_lookup])

Example: =VLOOKUP(D1, A1:B10, 2, FALSE) finds D1 in column A and returns corresponding value from column B.

Essential for merging data from different tables. Use exact match (FALSE) for reliable results.

55. HLOOKUP

=HLOOKUP(lookup_value, table_array, row_index, [range_lookup])

Example: =HLOOKUP("Total", A1:Z3, 2, FALSE) finds "Total" in first row and returns value from second row.

Same as VLOOKUP but for horizontal tables.

56. IF

=IF(logical_test, value_if_true, value_if_false)

Example: =IF(E1>50, "High", "Low") returns "High" if E1 > 50.

Creates conditional logic. Used for scenario analysis and data classification.

57. COUNTIF

=COUNTIF(range, criteria)

Example: =COUNTIF(F1:F10, ">100") counts cells in F1:F10 greater than 100.

Counts cells meeting a condition. Helpful for outlier detection.

58. SUMIF

=SUMIF(range, criteria, [sum_range])

Example: =SUMIF(G1:G10, "Apples", H1:H10) sums H1:H10 where G1:G10 equals "Apples".

Conditional sum. Useful for category-wise totals.

59. INDEX-MATCH

Explanation: A powerful alternative to VLOOKUP. MATCH finds the position, INDEX returns the value.

Example: =INDEX(J1:J10, MATCH("Oranges", I1:I10, 0)) finds "Oranges" in I1:I10 and returns corresponding value from J1:J10.

More flexible than VLOOKUP; can look left and handle column insertions.

60. TEXTJOIN

=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)

Example: =TEXTJOIN(", ", TRUE, K1:K5) concatenates text in K1:K5 separated by commas.

Combines text strings. Great for creating dynamic headers or lists.

V. Risk & Portfolio Management Formulas

61. Beta

Explanation: Measures a stock’s volatility relative to the market.

Example: A beta of 1.2 means the stock is 20% more volatile than the market.

Beta >1 indicates higher risk/reward. Used in CAPM to estimate expected return.

62. Standard Deviation

σ = √[Σ (xᵢ – μ)² / (n – 1)]

Explanation: Measures the dispersion of returns around the mean.

Example: Calculated standard deviation of portfolio returns might be 8%.

Higher standard deviation means higher risk. Used in the Sharpe ratio and volatility analysis.

63. Variance

Variance = σ²

Explanation: The square of standard deviation; measures return dispersion.

Example: If σ = 8%, then variance = 0.08² = 0.0064 or 0.64%².

Variance is used in portfolio optimization and risk assessment. Lower variance implies more stable returns.

64. Covariance

Cov(X, Y) = Σ [(Xᵢ – μₓ)(Yᵢ – μᵧ)] / (n – 1)

Explanation: Measures how two assets move together.

Example: A positive covariance indicates that two assets tend to move together.

Positive covariance → assets move in same direction; negative → opposite. Used to construct diversified portfolios.

65. Correlation Coefficient

ρ = Cov(X, Y) / (σₓ × σᵧ)

Explanation: Standardized measure of co-movement between -1 and +1.

Example: ρ = 0.8 indicates a strong positive relationship between two assets.

Correlation close to +1 means they move alike; -1 means opposite. Used to diversify risk.

66. Value at Risk (VaR)

Explanation: Estimates the maximum loss over a specified period at a given confidence level.

Example: A 95% VaR of 10% on a ₹1,000,000 portfolio suggests a maximum loss of ₹100,000 on 5% of days.

VaR helps quantify downside risk. Often used by banks to set capital reserves.

67. Expected Shortfall (ES)

Explanation: The average loss given that losses exceed the VaR threshold.

Example: If losses beyond VaR average 12%, then ES is 12% of portfolio value.

ES provides a more complete picture of tail risk than VaR. Used in stress testing.

68. Sharpe Ratio

Sharpe Ratio = (Rₚ – Rf) / σₚ

Explanation: Measures excess return per unit of risk.

Example: Portfolio return 12%, risk-free 3%, σₚ 9% yields (12–3)/9 = 1.

Higher Sharpe ratio means better risk-adjusted performance. Compare across funds.

69. Treynor Ratio

Treynor Ratio = (Rₚ – Rf) / βₚ

Explanation: Excess return per unit of systematic risk (beta).

Example: If Rₚ = 12%, Rf = 3%, βₚ = 1.2, then Treynor Ratio = (9%)/1.2 = 7.5%.

Useful for comparing portfolios with different levels of market risk.

70. Jensen's Alpha

Alpha = Rₚ – [Rf + βₚ (Rₘ – Rf)]

Explanation: Measures excess return above the CAPM expected return.

Example: With Rₚ=15%, Rf=3%, βₚ=1.1, and Rₘ=12%, Alpha = 15% – [3% + 1.1*(9%)] = 15% – 12.9% = 2.1%.

Positive alpha indicates outperformance. Used to evaluate fund managers.

71. Information Ratio

Information Ratio = Active Return / Tracking Error

Explanation: Measures consistency of active return relative to a benchmark.

Example: If active return is 4% and tracking error is 2%, ratio = 4/2 = 2.

Higher ratio means better risk-adjusted active management. Used for fund selection.

72. Sortino Ratio

Sortino Ratio = (Rₚ – Rf) / Downside Deviation

Explanation: Similar to Sharpe but penalizes only downside volatility.

Example: With Rₚ=14%, Rf=3%, and downside deviation 5%, ratio = (11%)/5 = 2.2.

Focuses on harmful risk. Useful when returns are not symmetric.

73. R-Squared

Explanation: Indicates the proportion of a portfolio’s variance explained by the benchmark.

Example: An R² of 0.85 means 85% of portfolio variability is explained by market movements.

Ranges from 0 to 1. High R² suggests the portfolio moves closely with the market.

74. Downside Deviation

Explanation: The standard deviation of only the negative returns.

Example: If only losses have a standard deviation of 4%, then downside deviation = 4%.

Focuses on harmful volatility. Used in Sortino ratio and downside risk analysis.

75. Real Rate of Return

Real Return = (1 + Nominal Return) / (1 + Inflation Rate) – 1

Explanation: Return after adjusting for inflation.

Example: Nominal return 10%, inflation 3% yields (1.10/1.03)-1 ≈ 6.8% real return.

Real return measures true purchasing power gain. Essential for long-term planning.

76. Nominal Rate of Return

Explanation: The stated return without adjusting for inflation.

Example: If an investment grows from ₹100,000 to ₹110,000, nominal return = 10%.

This is the raw return you see in statements. Always consider inflation to get real return.

77. Fisher Equation

Explanation: Relates nominal rate, real rate, and inflation: (1 + Nominal Rate) = (1 + Real Rate) × (1 + Inflation Rate).

Example: If real rate = 5% and inflation = 2%, nominal rate ≈ (1.05×1.02) – 1 = 7.1%.

Shows how inflation erodes returns. Used to convert between nominal and real rates.

78. Effective Interest Rate (Non-Annual)

EIR = (1 + r/n)ⁿ – 1

Explanation: Converts a nominal rate with n compounding periods to an effective annual rate.

Example: A 12% rate compounded quarterly gives EIR = (1+0.12/4)⁴ – 1 ≈ 12.55%.

Always compare effective rates, not nominal, when compounding differs.

79. Discount Rate

Explanation: The rate used to discount future cash flows; reflects risk and opportunity cost.

Example: A discount rate of 8% means future cash flows are worth 8% less per year.

Choice of discount rate significantly impacts NPV and valuation. Often based on WACC or required return.

80. Terminal Value (Gordon Growth)

Terminal Value = Final CF × (1+g) / (r – g)

Explanation: Estimates the value of a project or company beyond the forecast period assuming perpetual growth.

Example: Final cash flow ₹20,000, growth 3%, discount rate 8% gives Terminal Value = 20,000×1.03/(0.08–0.03) ≈ ₹412,000.

Used in DCF valuation. The growth rate (g) must be less than r, typically stable and low.

81. Perpetuity

PV = Cash Flow / r

Explanation: Present value of a constant cash flow stream that continues forever.

Example: A perpetuity paying ₹5,000 annually at a discount rate of 5% has PV = 5,000/0.05 = ₹100,000.

Used for valuing preferred stock, consols, or long-term stable cash flows.

82. Dividend Payout Ratio

Dividend Payout Ratio = (Dividends per Share / EPS) × 100%

Explanation: Proportion of earnings paid out as dividends.

Example: If EPS is ₹8 and dividend is ₹2, ratio = (2/8)*100 = 25%.

Low payout may indicate reinvestment for growth; high payout appeals to income investors.

83. Retention Ratio

Retention Ratio = 1 – Dividend Payout Ratio

Explanation: Proportion of earnings retained in the business.

Example: If dividend payout is 25%, retention ratio = 75%.

High retention suggests growth focus. Used in sustainable growth rate calculation.

84. Sustainable Growth Rate

SGR = ROE × Retention Ratio

Explanation: Maximum growth rate a firm can sustain without external equity financing.

Example: ROE 15% and retention ratio 60% yield SGR = 0.15×0.60 = 9%.

If actual growth exceeds SGR, the company may need to raise debt or equity.

85. Beta Calculation (Statistical)

Explanation: Beta is typically computed via regression of asset returns on market returns.

Example: A regression might yield a beta of 1.2, meaning 20% more volatility than the market.

Beta can be calculated in Excel using SLOPE function. Used in CAPM and cost of equity.

86. Tracking Error

Tracking Error = Standard Deviation of (Portfolio Return – Benchmark Return)

Explanation: Measures how closely a portfolio follows its benchmark.

Example: A tracking error of 2% indicates small deviations from the benchmark.

Low tracking error means passive replication; active managers aim for higher but compensated by alpha.

87. Active Return

Explanation: The difference between portfolio return and benchmark return.

Example: If portfolio return is 14% and benchmark is 11%, active return = 3%.

Positive active return indicates outperformance. Also known as excess return.

88. Information Ratio (Reiterated)

Information Ratio = Active Return / Tracking Error

Explanation: Measures risk-adjusted active return.

Example: With active return 4% and tracking error 2%, ratio = 2.

Higher IR means consistent outperformance. Used to rank active managers.

89. R-Squared

Explanation: The percentage of return variability explained by the market.

Example: An R² of 0.85 means 85% of the variation is market-driven.

High R² indicates the fund is well-diversified relative to the market.

90. Downside Deviation

Explanation: Standard deviation computed using only negative returns.

Example: Calculated downside deviation might be 3.5%.

Focuses on harmful volatility. Used in Sortino ratio and downside risk analysis.

91. Sortino Ratio (already covered)

Explanation: (Refer to formula 72)

Refer to formula 72 for details and example.

92. Maximum Drawdown

Explanation: The largest percentage drop from a peak to a trough in portfolio value.

Example: A portfolio peak of ₹1,000,000 dropping to ₹800,000 gives a drawdown of 20%.

Maximum drawdown shows worst-case historical loss. Important for risk tolerance assessment.

93. Calmar Ratio

Calmar Ratio = Annualized Return / Maximum Drawdown

Explanation: Measures return relative to the worst drawdown.

Example: Annual return 12% and drawdown 20% yield 0.6.

Higher Calmar ratio indicates better risk-adjusted performance during downturns.

94. Downside Beta

Explanation: Measures sensitivity of asset returns during market downturns.

Example: A downside beta of 0.8 suggests lower volatility in downturns.

Useful for investors concerned about losses in bear markets.

95. Upside Beta

Explanation: Measures sensitivity during market upswings.

Example: An upside beta of 1.3 indicates higher gains when the market rises.

Investors seeking growth may prefer high upside beta.

96. Active Risk (Tracking Error)

Active Risk = √[Σ (Portfolio Return – Benchmark Return)² / (n – 1)]

Explanation: The standard deviation of active returns.

Example: If computed active risk is 2.5%, that is the volatility of active returns.

Measures how much the portfolio deviates from benchmark. Used in information ratio.

97. Portfolio Variance

Portfolio Variance = wᵀΣw

Explanation: Variance of a portfolio given weights and covariance matrix.

Example: With a given weights vector and covariance matrix, variance might compute to 0.004 (or 0.4%²).

Fundamental for modern portfolio theory. Used to optimize asset allocation.

98. Portfolio Standard Deviation

Portfolio Std. Dev. = √(Portfolio Variance)

Explanation: The square root of portfolio variance; total risk of the portfolio.

Example: If variance is 0.004, then standard deviation ≈ 6.32%.

This is the volatility you see in reports. Used in Sharpe ratio and risk budgeting.

99. CAPM – Security Market Line (SML)

Expected Return = Rf + β (Rₘ – Rf)

Explanation: Estimates expected return based on systematic risk.

Example: With Rf 3%, market premium 7%, and β of 1.2, expected return = 3 + 1.2×7 = 11.4%.

Used to price assets and calculate cost of equity. If actual return > expected, asset may be undervalued.

100. Custom Portfolio Metric

Explanation: Combine various metrics to gauge overall portfolio performance.

Example: An analyst might use a weighted combination of Sharpe Ratio and active return to decide on portfolio adjustments.

Tailor metrics to your investment philosophy. For example, a balanced scorecard of risk and return.

Interactive Financial Analysis Dashboard

50 Functional Practical Calculators for ICMAI Students

Conclusion

This comprehensive guide has presented 100 essential financial formulas across banking, investment valuation, corporate finance, Excel data analysis, and risk/portfolio management. Each formula is accompanied by a practical example and a real‑life insight to help you interpret and apply the result.

Mastering these formulas will help you analyze financial performance, evaluate investments, manage risks, and make informed decisions. Bookmark this guide and refer back to it as you enhance your financial acumen.

Post Views: 1,253