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.

Response

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

  • Revenue Growth: Total revenues increased from $182,527 million in 2020 to $282,836 million in 2022, demonstrating a significant upward trend over the period.
  • Expense Increase: Total costs and expenses also grew from $141,303 million in 2020 to $207,994 million in 2022, largely driven by increases in the cost of revenues and research and development.
  • Income from Operations Fluctuation: Income from operations saw a substantial rise from $41,224 million in 2020 to $78,714 million in 2021, before decreasing to $74,842 million in 2022.
  • Net Income Trend: Net income increased from $40,269 million in 2020 to a high of $76,033 million in 2021, then declined to $59,972 million in 2022.
  • Impact of Other Income/Expense: The company experienced a shift in "Other income (expense), net," moving from a net income of $6,858 million in 2020 and $12,020 million in 2021 to a net expense of $3,514 million in 2022, which impacted the overall income before income taxes.
Model: gemini-2.5-pro
Temperature: 0.2
Max output tokens: 512
TopK: 40.0
TopP: 0.95