TCI Rapid XRay Tab Details
1 Key Financial Metrics Overview
2 Profitability, Growth, Return and Operational Metrics and Trend Summary
Note: The trend lines in the screenshot above are drawn using sparklines, an Office 2010 and later feature. In older versions of Office, the trend lines will not be visible, all other functionality is present.
3 Market Cap and Per Share Metrics Growth
4 Directional Valuation based on three frameworks (CFO-derived, FCF-perpetuity, DCF Conservative – Aggressive)
Note: The grey-shaded cells: Input (Max Interest / CFO) and Input (Cost of Debt) are editable to see the impact of higher discount rates on the valuation numbers
5 In-built charts summarizing CFO-derived price vs actual, EPS vs Price Growth
Available for immediate download.
For detailed instructions on setting up and using the template, click here