Bank Discount Yield – Excel Template

Ivan Kitov
Ivan Kitov

Bank discount yield is the annualized rate of return on a purely discount-based financial instrument. It is used to calculate the expected return of a bond purchased at a discount and held until maturity.

Other related topics you might be interested to explore are Holding Period Yield, Effective Annual Yield, and Money Market Yield.

This is an open-access Excel template in XLSX format that will be useful for anyone who wants to work as a Banker, Investment Professional, Corporate Finance Practitioner, or Portfolio Manager.

You can now download the Excel template for free.

Bank discount yield is among the topics included in the Quantitative Methods module of the CFA Level 1 Curriculum.