- Cell Phones 609
- Editors 245
- Education, Science & Engineering 290
- Games 1649
- Internet 545
- Stock Market 15
- Web Design 88
- Scripts 354
- Miscellaneous 88
- Mobile Software 26
- Multimedia & Graphics 1023
- PC 379
- Programming 345
- Security 1390
- SEO 60
- Utilities 815
Excel for calculating the yield on bonds from the Finam
Uploaded: 03.01.2022
Content: Калькулятор-SMART-ФИНАМ.xlsx 50,66 kB
Product description
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.