Financial
Fisher Equation formula: Exact Real Interest Rate ((1 + i) / (1 + pi) - 1)
Convert effective nominal and real returns over the same period using an explicit inflation factor, with guards against invalid price-level changes.
Match periods and distinguish a return identity from a forecast
For realized effective returns over the same period, divide the nominal wealth factor by the observed price-level factor: real=(1+nominal)/(1+inflation)-1. Enter decimals, so 8% is0.08. A quoted APR or continuously compounded rate must first be converted to the matching effective-period rate.
The subtraction approximation is not always an overestimate. Its error equals (nominal-inflation)*inflation/(1+inflation), whose sign depends on both inputs. Negative inflation and negative real returns are valid cases when the price-level factor stays positive.
For future scenarios, inflation and returns are assumptions rather than guaranteed purchasing power. Treasury/TIPS yield differences also reflect risk and liquidity premia; this two-input exercise is not a TIPS pricing or pure expected-inflation estimator. Fees, taxes and interim cash flows are excluded.
| Market Scenario | Nominal Rate (B2) | Inflation pi (B3) | Exact Fisher Real vs Naive |
|---|---|---|---|
| Illustrative same-period return | 8.00% (0.08) | 5.00% (0.05) | 2.86% exact (vs 3.00% naive) |
| Required Nominal for 3% Real | (1 + B4)*(1 + B3) - 1 | Target r=3%, pi=5% | 8.15% nominal (+15 bps cross-term!) |
| Emerging Market High CPI | 32.00% (0.32) | 25.00% (0.25) | 5.60% exact (vs 7.00% naive!) |
| Zero Inflation (pi = 0%) | 8.00% | 0.00% | 8.00% (Exact = Naive) |
Exact Fisher Real Interest Rate = ((1 + Nominal) / (1 + Inflation)) - 1
Divides gross nominal wealth factor (1 + B2) by price-level factor (1 + B3) to measure true purchasing-power growth.
=IF(COUNT(B2:B3)<>2,"Invalid inputs",IF(OR(B2< -1,B3<= -1),"Invalid inputs",ROUND(((1 + B2) / (1 + B3)) - 1, 4)))Required Nominal Yield for a Target Real Return B4: (1 + r_real)*(1 + pi) - 1
Includes the cross-product r_real * pi needed to protect interest earnings from inflation.
=IF(COUNT(B3:B4)<>2,"Invalid inputs",IF(OR(B4< -1,B3<= -1),"Invalid inputs",ROUND((1 + B4) * (1 + B3) - 1, 4)))Try the example
Use the original values or change them to test your understanding.