Alphabet
Remember, in this example we will not cover every possible case: some questions, such as those on historical trend, estimates, percentages or behavior during crises, you will need to work on independently.
This is the list of questions that will be answered. For convenience, I have grouped the questions according to whether they can be answered using the accounting template or NotebookLM.
Click to see the ordered list of questions
Accounting template
Company earnings
- Check EBITDA, EBIT, Net Income and FCF
- Check margins: EBITDA, EBIT and Net
- Check ROIC and ROE
- What is the reinvestment rate?
Company financial health
- Check whether the company has Net Cash or Net Debt
- Check the Net Debt/EBITDA ratio
NotebookLM
Company revenue
What type of sales are they? Organic or inorganic?
- Is it possible to get the percentage of total?
Sales segmentation
- Sales segmentation by business line
- Sales segmentation by country
- Sales segmentation by customer: what percentage of sales comes from the largest customer?
Recurrence in sales: is there pricing power?
Is there seasonality in sales throughout the year?
Company profit margins
- Is it possible to get the margins for the different business lines?
- Which business line contributes the most profit?
Company financial health
Is it possible to know the type of debt?
- Is it at a fixed or variable rate?
- Is it possible to know at what interest rate the company is financed?
Is it possible to know how the company uses its debt? To create value or to destroy it?