EN

Excel for calculating the yield on bonds from the Finam

  • USD
    • RUB
    • USD
    • EUR
i agree with "Terms for Customers"
Refunds: 0

Uploaded: 03.01.2022
Content: Калькулятор-SMART-ФИНАМ.xlsx 50,66 kB

Product description

Excel for calculating the yield on bonds from the Finam Excel for calculating the yield on bonds from the Finam Excel for calculating the yield on bonds from the Finam Excel for calculating the yield on bonds from the Finam


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.

Additional information

The presented version runs on a computer and is adapted for use on a smartphone.

Installation of EXCEL is required for correct operation.

Feedback

0
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.market the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)

This website uses cookies to provide a more effective user experience. See our Cookie policy for details.