Excel calculator for calculating the yield of bonds when buying through a broker Finam.

The table takes into account the specifics of the tariff plan with the minimum transaction amount.

After filling in all the gray cells, the formulas will automatically calculate the yield of the selected bond to maturity and estimate the required number of securities to reduce the commission burden.

Excel allows novice investors to step by step collect all the necessary information and form an idea of ​​the circulation conditions of the selected bond.

It is based on the formula for calculating the bond yield to maturity, which consists of three parts. From the beginning, the full value of the security (purchase costs) will be determined. Then, the calculation of the amount that the investor can receive by the maturity date will take place. At the final stage, the obtained values ​​are compared in order to determine the possible profit or loss.

Excel calculator is fully adapted only for working with Finam broker. For other financial institutions, use different tables.