Asset Management, Income Investing & 1940-Act Funds
Closed-End Fund NAV Discount & Market Yield Formula
Calculate Closed-End Fund (CEF) Share Price Discount/Premium to NAV (Price - NAV)/NAV, Required Portfolio NAV Distribution Rate vs Amplified Market Distribution Yield, and 1940-Act Structural Leverage Ratio.
Distinguish a CEF’s cash yield on market price from the NAV hurdle its portfolio must earn!
Unlike open-end ETFs with continuous creation/redemption arbitrage, Closed-End Funds (CEFs) issue a fixed share count that routinely trades at a double-digit Discount (Z < 0) or Premium (Z > 0) to Net Asset Value: Z = (Market_Price - NAV) / NAV! Buying a CEF at a -15.0% discount boosts your cash Market Distribution Yield = Annual_Distribution / Market_Price = NAV_Distribution_Rate / (1 + Z) ABOVE the underlying portfolio’s NAV Distribution Rate = Annual_Distribution / NAV—whereas buying at a +20% premium depresses your cash yield below what the manager must earn (often masking destructive Return of Capital when NAV_Dist_Rate exceeds portfolio net investment income)! Simultaneously, US Investment Company Act of 1940 Section 18 caps structural debt leverage Debt / (Debt + Common_Net_Assets) at 33.33% (300% asset coverage)!
Verify on a Municipal Bond CEF—Net_Asset_Value NAV = $20.00/sh (B2), Secondary_Market_Price = $17.00/sh (B3 -> Price-to-NAV Discount Z = (17 - 20) / 20 = -0.1500 = -15.00% in E2), Annual_Cash_Distribution = $1.36/sh (B4), Structural_Debt_Borrowings = $100M (B5), and Common_Shareholder_Equity = $200M (B6 -> $300M Total Managed Assets): Portfolio NAV Hurdle Rate is 1.36 / 20.00 = 0.0680 (6.80% in E3); Buyer Market Cash Yield jumps +120 bps to 1.36 / 17.00 = 0.0800 (8.00% in E4); and 1940-Act Debt Leverage Ratio is 100 / 300 = 0.3333 (33.33% statutory ceiling in E5)!
| Closed-End Fund Metric (NAV=$20, Price=$17, Dist=$1.36/yr, Debt=$100M, Equity=$200M) | Formula | Verified Output |
|---|---|---|
| Price-to-NAV Discount / Premium Z | (Market_Price - NAV) / NAV | -0.1500 (-15.00%; +0.1000 @ $22) |
| Portfolio NAV Hurdle Yield | Annual_Distribution / NAV | 0.0680 (6.80% Manager Hurdle) |
| Buyer Market Distribution Yield | Annual_Distribution / Market_Price | 0.0800 (8.00%; 0.0618 @ $22 Prem) |
| 1940-Act Structural Leverage | Debt / (Debt + Common_Net_Assets) | 0.3333 (33.33% = 300% Coverage) |
Closed-End Fund Market Yield & 1940-Act Leverage Formula
Validate NAV > 0, Market_Price > 0, Distribution >= 0, Debt >= 0, and Common_Net_Assets > 0!
=LET(nv_s, B2, mk_p, B3, ds_a, B4, db_m, B5, eq_m, B6, IF(OR(nv_s <= 0, mk_p <= 0, ds_a < 0, db_m < 0, eq_m <= 0), "Invalid CEF Snapshot", ROUND(ds_a / mk_p, 4)))10% Market Premium Compression Check (Set Market_Price = $22.00)
Bid Market_Price B3 up to $22.00 (+10.00% premium over $20 NAV): Discount Z flips to +0.1000 and Buyer Market Yield E4 compresses from 8.00% down to 6.18% (< 6.80% NAV payout hurdle)!
=IF(ISTEXT(E4), E4, ROUND(B5 / (B5 + B6), 4))Try the example
Use the original values or change them to test your understanding.