(4) XBCS – Banks Comparison Sheet – compares a list of credit ratings, current market data, loan and capital details, profitability ratios, and asset quality. (3) XIDA – In-depth company analysis – gives company fundamentals, estimates, and pricing data historically and in relation to peers. (2) XCSF – Company snapshot with financial analysis – provides company fundamentals, detailed earnings data, and peer group analysis. (1) XCVA – Comparable Valuation Analysis – side by side detailed analysis for multiple securities. From the menu screen, click on OPEN to transfer the template to Excel. Below we give brief descriptions of ten templates that are useful for company analysis. To access a specific Template, type XLTP followed by the code for the specific Template. For example, for the Template giving comparable valuation analysis, type: To search or browse for Bloomberg Templates by subject or keyword, type XLTP. This is just one of hundreds of Excel templates available in Bloomberg. This Template (XCRA) allows you to change the default risk settings and calculate country risk based on weights that you choose. In a recent post, we described Country Risk Assessment, the Bloomberg Excel Template that calculates country risk for 60 countries based on 25 financial, economic and political risk factors.
0 Comments
Leave a Reply. |