Sign in
You're viewing a shared conversation.
$FROG
For 2022 and 2023 data: I want you to extract the full statement of operations from revenue to net income, the balance sheet line items of cash and short term and long term debt, the cash flow statement, the Free Cash Flow and the share-based compensation expense for the four categories (cost of revenue, research and development, sales and marketing and general and administrative) for the two fiscal years. Organize the data into a table in an Excel worksheet with the years in the columns and the line items in the rows.

Below is the organized data for JFrog Ltd. (ticker: FROG) for fiscal years 2022 and 2023, presented in a tabular format suitable for an Excel worksheet. The data includes the statement of operations, balance sheet line items, cash flow statement, free cash flow, and share-based compensation expenses.

MetricFY 2023 (in thousands)FY 2022 (in thousands)
Revenue$349,886 [0000950170-24-015873_frog-20231231.htm:92]$280,040 [0000950170-23-002329_frog-20221231.htm:107]
Subscription—self-managed and SaaS$330,193 [0000950170-24-015873_frog-20231231.htm:92]$261,452 [0000950170-23-002329_frog-20221231.htm:107]
License—self-managed$19,693 [0000950170-24-015873_frog-20231231.htm:92]$18,588 [0000950170-23-002329_frog-20221231.htm:107]
Cost of Revenue$77,043 [0000950170-24-015873_frog-20231231.htm:92]$62,287 [0000950170-23-002329_frog-20221231.htm:107]
Subscription—self-managed and SaaS$76,244 [0000950170-24-015873_frog-20231231.htm:92]$61,407 [0000950170-23-002329_frog-20221231.htm:107]
License—self-managed$799 [0000950170-24-015873_frog-20231231.htm:92]$880 [0000950170-23-002329_frog-20221231.htm:107]
Gross Profit$272,843 [0000950170-24-015873_frog-20231231.htm:92]$217,753 [0000950170-23-002329_frog-20221231.htm:107]
Operating Expenses$348,391 [0000950170-24-015873_frog-20231231.htm:92]$307,593 [0000950170-23-002329_frog-20221231.htm:107]
Research and Development$134,584 [0000950170-24-015873_frog-20231231.htm:92]$121,225 [0000950170-23-002329_frog-20221231.htm:107]
Sales and Marketing$150,675 [0000950170-24-015873_frog-20231231.htm:92]$130,812 [0000950170-23-002329_frog-20221231.htm:107]
General and Administrative$63,132 [0000950170-24-015873_frog-20231231.htm:92]$55,556 [0000950170-23-002329_frog-20221231.htm:107]
Operating Loss$(75,548) [0000950170-24-015873_frog-20231231.htm:92]$(89,840) [0000950170-23-002329_frog-20221231.htm:107]
Interest and Other Income, Net$21,032 [0000950170-24-015873_frog-20231231.htm:92]$5,094 [0000950170-23-002329_frog-20221231.htm:107]
Loss Before Income Taxes$(54,516) [0000950170-24-015873_frog-20231231.htm:92]$(84,746) [0000950170-23-002329_frog-20221231.htm:107]
Income Tax Expense$6,740 [0000950170-24-015873_frog-20231231.htm:92]$5,438 [0000950170-23-002329_frog-20221231.htm:107]
Net Loss$(61,256) [0000950170-24-015873_frog-20231231.htm:92]$(90,184) [0000950170-23-002329_frog-20221231.htm:107]
Net Loss Per Share, Basic and Diluted$(0.59) [0000950170-24-015873_frog-20231231.htm:92]$(0.91) [0000950170-23-002329_frog-20221231.htm:107]
Weighted-Average Shares Used in Computing Net Loss Per Share, Basic and Diluted103,318 [0000950170-24-015207_frog-ex99_1.htm:6]99,244 [0000950170-23-002329_frog-20221231.htm:107]
Cash and Cash Equivalents$84,765 [0000950170-24-015873_frog-20231231.htm:105]$45,595 [0000950170-23-002140_frog-ex99_1.htm:7]
Restricted Cash$12 [0000950170-24-015873_frog-20231231.htm:107]$12 [0000950170-23-002140_frog-ex99_1.htm:8]
Total Cash, Cash Equivalents, and Restricted Cash$84,777 [0000950170-24-015873_frog-20231231.htm:107]$45,607 [0000950170-23-002329_frog-20221231.htm:109]
Short-term InvestmentsN/A$397,605 [0000950170-23-002140_frog-ex99_1.htm:7]
Short-term DebtN/AN/A
Long-term DebtN/AN/A
Net Cash Provided by Operating Activities$74,155 [0000950170-24-015873_frog-20231231.htm:107]$21,425 [0000950170-23-002329_frog-20221231.htm:109]
Net Cash Used in Investing Activities$(53,476) [0000950170-24-015873_frog-20231231.htm:107]$(53,338) [0000950170-23-002329_frog-20221231.htm:109]
Net Cash Provided by Financing Activities$18,371 [0000950170-24-015873_frog-20231231.htm:107]$11,027 [0000950170-23-002329_frog-20221231.htm:109]
Effect of Exchange Rate Changes on Cash$120 [0000950170-24-015873_frog-20231231.htm:107]$(2,047) [0000950170-23-002329_frog-20221231.htm:109]
Net Increase (Decrease) in Cash$39,170 [0000950170-24-015873_frog-20231231.htm:107]$(22,933) [0000950170-23-002329_frog-20221231.htm:109]
Free Cash Flow$72,200 [0000950170-24-015873_frog-20231231.htm:89]$17,100 [0000950170-23-002329_frog-20221231.htm:89]
Share-based Compensation Expense - Cost of Revenue$9,784 [0000950170-24-015873_frog-20231231.htm:95]$6,991 [0000950170-23-002329_frog-20221231.htm:133]
Share-based Compensation Expense - R&D$32,689 [0000950170-24-015873_frog-20231231.htm:130]$24,700 [0000950170-23-002329_frog-20221231.htm:119]
Share-based Compensation Expense - Sales and Marketing$30,338 [0000950170-24-015873_frog-20231231.htm:95]$22,753 [0000950170-23-002329_frog-20221231.htm:95]
Share-based Compensation Expense - G&A$22,360 [0000950170-24-015873_frog-20231231.htm:95]$14,253 [0000950170-23-002329_frog-20221231.htm:95]

This table provides a comprehensive view of JFrog Ltd.'s financial data for the specified years.