Financial table summarization

Summarize key insights from a financial report table with heavy numerical info.

You can query a model directly and test the results returned when using different parameter values with the Cloud console, or by calling the Vertex AI API directly.

System instructions
As a financial analysis expert, your role is to interpret complex financial data, offer personalized advice, and evaluate investments using statistical methods to gain insights across different financial areas.

Accuracy is the top priority. All information, especially numbers and calculations, must be correct and reliable. Always double-check for errors before giving a response. The way you respond should change based on what the user needs. For tasks with calculations or data analysis, focus on being precise and following instructions rather than giving long explanations. If you're unsure, ask the user for more information to ensure your response meets their needs.

For tasks that are not about numbers:

  • Use clear and simple language, avoiding jargon and confusion.
  • Make sure you address all parts of the user's request and provide complete information.
  • Think about the user's background knowledge and provide additional context or explanation when needed.

Formatting and Language:

  • Follow any specific instructions the user gives about formatting or language.
  • Use proper formatting like JSON or tables to make complex data or results easier to understand.

Prompt Freeform

You are a financial analyst and you are required to summarize the key insights of given numerical tables.

CONSOLIDATED STATEMENTS OF INCOME (In millions, except per share amounts) |Year Ended December 31 | 2020 | 2021 | 2022 | |--- | --- | --- | --- | |Revenues | $ 182,527| $ 257,637| $ 282,836| |Costs and expenses:| |Cost of revenues | 84,732 | 110,939 | 126,203| |Research and development | 27,573 | 31,562 | 39,500| |Sales and marketing | 17,946 | 22,912 | 26,567| |General and administrative | 11,052 | 13,510 | 15,724| |Total costs and expenses | 141,303| 178,923| 207,994| |Income from operations | 41,224 | 78,714 | 74,842| |Other income (expense), net | 6,858 | 12,020 | (3,514)| |Income before income taxes | 48,082 | 90,734 | 71,328| |Provision for income taxes | 7,813 | 14,701 | 11,356| |Net income | $40,269| $76,033 | $59,972| |Basic net income per share of Class A, Class B, and Class C stock | $2.96| $5.69| $4.59| |Diluted net income per share of Class A, Class B, and Class C stock| $2.93| $5.61| $4.56|

Please list important, but no more than five, highlights from 2020 to 2022 in the given table. Please write in a professional and business-neutral tone. The summary should only be based on the information presented in the table.


Here are five key highlights from the Consolidated Statements of Income from 2020 to 2022:

  1. Revenue Growth: The company experienced significant revenue growth, increasing from $182,527 million in 2020 to $282,836 million in 2022.
  2. Increased Costs and Expenses: Total costs and expenses also rose considerably, from $141,303 million in 2020 to $207,994 million in 2022. This suggests that the company is investing in growth, potentially through increased research and development, sales and marketing, or general and administrative activities.
  3. Stable Income from Operations: While revenue and expenses both increased, income from operations remained relatively stable, ranging from $41,224 million to $78,714 million over the three years.
  4. Fluctuating Other Income: Other income (expense), net, showed significant volatility, moving from a positive $6,858 million in 2020 to a negative $3,514 million in 2022. This suggests potential fluctuations in non-operating activities.
  5. Consistent Net Income Growth: Despite the fluctuations in other income, net income consistently increased from $40,269 million in 2020 to $59,972 million in 2022, indicating overall profitability growth.
Model: gemini-1.5-flash-001
Temperature: 1
Max output tokens: 512
TopK: 40
TopP: 0.95