How to Analyse Financial Reports with AI
A step-by-step guide to extracting valuable insights from financial reports using AI
Want to analyse financial reports like a pro without spending years in business school? I've created a powerful AI prompt that helps you extract valuable insights and trends from financial data in seconds. I've tested it with Tesla's quarterly reports, and now you can use it for your business!
Process Walkthrough
Follow these simple steps to analyse your financial data:
Step 1: Paste the Initial Prompt
Copy and paste this prompt into AI:
I am feeding you financial data as context for my following directions and questions.
[YOUR DATA HERE: Paste the .CSV data of your previous 5 quarters Profit & Loss Statement here]
Now you will act as an experienced and respected CFO and put together key insights from the previous statistics for the company.
Give this section an H2 of 'Quarterly Financials Summary' and split your key insights into 3 sections with H3 headings of 'Revenue', 'Profitability' and 'Cash'.
For each of these three sections, begin with an overall summary in one sentence in italics under the H3.
Under each section, add your key takeaways as bullet points and include both positive and negative points in each section with 'Positive:' or 'Negative:' as pretext.
Represent instances of basis points as percentages down to two decimal places, ie 50.96%.
Add a divider line.
For the next section, add a H2 heading of "Additional Insights" and you will do the following.
1 - Summarise these results in 1 paragraph. Add H3 heading of "Summary"
2 - Give me your thoughts on whether this is overall a positive or negative result, by simply giving me a thumbs up emoji for positive, or a thumbs down emoji for negative. Write 'Positive' or 'Negative' beside the emoji. Add H3 heading of "Overall Result"
3 - Give me some key takeaways on the difference between this quarter, and the previous quarter. Add H3 heading of "Differences from last quarter."
4 - Give me some key takeaways on the difference between this quarter, and the same quarter last year. Add H3 heading of "Differences from same quarter last year."
5 - Give me some key takeaways on the past 12 months. Add H3 heading of "Key Takeaways from the past 12 months."
6 - Based on this data, what trends do you foresee over the next year? Add H3 heading of "Forecast"
7 - You will act as an experienced stock market investor for this question only. You have evaluated the data provided and will give a paragraph of content around why you will or will not be investing right now and why. Add H3 heading of "Stock Recommendation"
8 - Put together a list of 10 key takeaways from 'Quarterly Financials Summary' and 'Additional Questions 1 to 6' as bullet points and explain it to a 5 year old in easy to understand language. Add H3 heading of "Explain it to a 5-Year-Old"
Step 2: Answer AI's Questions
AI will ask you a series of questions about your data and what insights you're looking for. For each question, you have two options:
- Provide your specific requirements and preferences
- Simply reply with "Unsure, go ahead with your recommendation" if you're not certain
This flexibility means you don't need to be a financial expert to get valuable insights - AI will make smart recommendations based on industry best practices.
Tesla Example Data (For Demo Purposes)
Here's an example using Tesla's quarterly financial data to demonstrate the power of this analysis. Below is the exact prompt used with Tesla's data:
I am feeding you financial data as context for my following directions and questions.
FINANCIALS SUMMARY (Unaudited) ($ in millions, except percentages and per share data)Q1-2022Q2-2022Q3-2022Q4-2022Q1-2023YoY Total automotive revenues16,861 14,602 18,69221,307 19,96318% Energy generation and storage revenue616 866 1,1171,310 1,529148% Services and other revenue1,279 1,466 1,6451,701 1,83744% Total revenues18,75616,93421,45424,31823,32924% Total gross profit5,4604,2345,3825,7774,511-17% Total GAAP gross margin29.1%25.0%25.1%23.8%19.3%-977 bp Operating expenses1,857 1,770 1,694 1,876 1,847-1% Income from operations3,603 2,464 3,688 3,901 2,664-26% Operating margin19.2%14.6%17.2%16.0%11.4%-779 bp Adjusted EBITDA5,023 3,791 4,968 5,404 4,267 -15% Adjusted EBITDA margin26.8%22.4%23.2%22.2%18.3%-849 bp Net income attributable to common stockholders (GAAP)3,318 2,259 3,292 3,687 2,513 -24% Net income attributable to common stockholders (non-GAAP)3,736 2,620 3,654 4,106 2,931 -22% EPS attributable to common stockholders, diluted (GAAP)(1)0.95 0.65 0.95 1.07 0.73 -23% EPS attributable to common stockholders, diluted (non-GAAP)(1)1.07 0.76 1.05 1.19 0.85 -21% Net cash provided by operating activities3,995 2,351 5,100 3,278 2,513 -37% Capital expenditures(1,767)(1,730)(1,803)(1,858)(2,072)17% Free cash flow2,228 621 3,297 1,420 441 -80% Cash, cash equivalents and investments18,013 18,915 21,107 22,185 22,402 24%
Now you will act as an experienced and respected CFO and put together key insights from the previous statistics for the company.
Give this section an H2 of 'Quarterly Financials Summary' and split your key insights into 3 sections with H3 headings of 'Revenue', 'Profitability' and 'Cash'.
For each of these three sections, begin with an overall summary in one sentence in italics under the H3.
Under each section, add your key takeaways as bullet points and include both positive and negative points in each section with 'Positive:' or 'Negative:' as pretext.
Represent instances of basis points as percentages down to two decimal places, ie 50.96%.
Add a divider line.
For the next section, add a H2 heading of "Additional Insights" and you will do the following.
1 - Summarise these results in 1 paragraph. Add H3 heading of "Summary"
2 - Give me your thoughts on whether this is overall a positive or negative result, by simply giving me a thumbs up emoji for positive, or a thumbs down emoji for negative. Write 'Positive' or 'Negative' beside the emoji. Add H3 heading of "Overall Result"
3 - Give me some key takeaways on the difference between this quarter, and the previous quarter. Add H3 heading of "Differences from last quarter."
4 - Give me some key takeaways on the difference between this quarter, and the same quarter last year. Add H3 heading of "Differences from same quarter last year."
5 - Give me some key takeaways on the past 12 months. Add H3 heading of "Key Takeaways from the past 12 months."
6 - Based on this data, what trends do you foresee over the next year? Add H3 heading of "Forecast"
7 - You will act as an experienced stock market investor for this question only. You have evaluated the data provided and will give a paragraph of content around why you will or will not be investing right now and why. Add H3 heading of "Stock Recommendation"
8 - Put together a list of 10 key takeaways from 'Quarterly Financials Summary' and 'Additional Questions 1 to 6' as bullet points and explain it to a 5 year old in easy to understand language. Add H3 heading of "Explain it to a 5-Year-Old"
Linkedin Tutorial
Important Notes for Best Results
-
Simplify Your Data: For optimal results, simplify your P&L or financial data before analysis. If you use Xero, create a custom report and group similar line items together. This reduces complexity while maintaining valuable insights. For very complex P&Ls, consider analysing different sections separately (Revenue, Direct Costs, Operational Costs).
-
Data Structure: The prompt works best with quarterly data spanning 5 quarters. This covers a full 12-month period plus the same quarter from the previous year, similar to Tesla's reporting structure. Feel free to customise the prompt based on your specific needs.
Pro Tips
- Clean your data before analysis to ensure accurate insights
- Use consistent time periods for better comparative analysis
- Start with a small dataset to test the prompt's effectiveness
- Customise the prompt based on your specific industry or needs
- Save the analysed insights for historical comparison