- Cell Phones 631
- Editors 267
- Education, Science & Engineering 314
- Games 1636
- Internet 566
- Stock Market 12
- Web Design 100
- Scripts 362
- Miscellaneous 92
- Mobile Software 4
- Multimedia & Graphics 1130
- PC 409
- Programming 351
- Security 1411
- SEO 76
- Utilities 843
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.