Question
Draft a one-page spreadsheet showing the financial history and projected performance for Alteryx. The rows should include revenue, expenses, calculated profit, and calculated profit margin
Draft a one-page spreadsheet showing the financial history and projected performance for Alteryx.
The rows should include revenue, expenses, calculated profit, and calculated profit margin. The columns should be years: two years of history, plus three years of your reasonable future projections. Include a few sentences of key assumptions and conclusions.
Specifically, the following critical elements must be addressed:
Show two years of financial history including revenue, expenses, calculated profit, and calculated profit margins.
Show three years of future financial projections for revenue, expenses, calculated profit, and calculated profit margins.
Show calculation formulas in cells where appropriate rather than inputting numbers.
Identify key assumptions and conclusions regarding financial projections.
Present data in a professional manner with headings and meaningful number formatting.
Example Format:
Example: For data use the most current year you can find.
Company Income Statement | |||
Company Financial History | |||
USD Mil | 2016 | 2017 | |
Revenues | $14,437 | $14,757 |
|
Expenses | $9,168 | $9,440 | |
Calculated Profit | $5,269 | $5,317 |
|
Calculated Profit Margin | 36.50% | 36.03% | |
Company Financial Projections | |||
USD Mil | 2018 | 2019 | 2020 |
Revenues | 15,500 | 15,700 | 16,400 |
Expenses | $9,880 | $9,999 | $10,300 |
Calculated Profit | $5,620 | $5,701 | $6,100 |
Calculated Profit Margin | 36.26% | 36.31% | 37.20% |
Financial Statements from SEC:
Condensed Consolidated Statements of Operations and Comprehensive Income (Loss) - USD ($) shares in Thousands, $ in Thousands | 12 Months Ended | ||
---|---|---|---|
Dec. 31, 2020 | Dec. 31, 2019 | Dec. 31, 2018 | |
Revenue: | |||
Total revenue | $ 495,308 | $ 417,910 | $ 253,570 |
Cost of revenue: | |||
Total cost of revenue | 43,839 | 39,151 | 22,800 |
Gross profit | 451,469 | 378,759 | 230,770 |
Operating expenses: | |||
Research and development | 101,117 | 69,100 | 43,449 |
Sales and marketing | 252,820 | 191,735 | 109,284 |
General and administrative | 101,439 | 79,943 | 48,267 |
Total operating expenses | 455,376 | 340,778 | 201,000 |
Income (loss) from operations | (3,907) | 37,981 | 29,770 |
Interest expense | (38,119) | (21,844) | (7,378) |
Other income, net | 14,382 | 10,434 | 3,042 |
Loss on induced conversion and debt extinguishment | (1) | (20,507) | 0 |
Income (loss) before benefit of income taxes | (27,645) | 6,064 | 25,434 |
Benefit of income taxes | (3,271) | (21,079) | (2,586) |
Net income (loss) | $ (24,374) | $ 27,143 | $ 28,020 |
Net Income (loss) per share attributable to common stockholders, basic (in dollars per share) | $ (0.37) | $ 0.43 | $ 0.46 |
Net income (loss) per share attributable to common stockholders, diluted (in dollars per share) | $ (0.37) | $ 0.40 | $ 0.43 |
Weighted-average shares used to compute net income (loss) per share attributable to common stockholders, basic (in shares) | 66,058 | 63,424 | 60,829 |
Weighted-average shares used to compute net income (loss) per share attributable to common stockholders, diluted (in shares) | 66,058 | 68,661 | 64,744 |
Other comprehensive income (loss), net of tax: | |||
Net unrealized holding gain (loss) on investments, net of tax | $ 925 | $ 714 | $ (22) |
Foreign currency translation adjustments, net of tax | (892) | (1,669) | (195) |
Other comprehensive income (loss), net of tax | 33 | (955) | (217) |
Total comprehensive income (loss) | (24,341) | 26,188 | 27,803 |
Subscription-based software license | |||
Revenue: | |||
Total revenue | 237,035 | 229,194 | 124,669 |
Cost of revenue: | |||
Total cost of revenue | 5,125 | 3,923 | 1,505 |
PCS and services | |||
Revenue: | |||
Total revenue | 258,273 | 188,716 | 128,901 |
Cost of revenue: | |||
Total cost of revenue | $ 38,714 | $ 35,228 | $ 21,295 |
Consolidated Balance Sheets - USD ($) $ in Thousands | Dec. 31, 2020 | Dec. 31, 2019 |
---|---|---|
Current assets: | ||
Cash and cash equivalents | $ 171,891 | $ 409,949 |
Short-term investments | 584,445 | 376,995 |
Accounts receivable, net | 136,985 | 129,912 |
Prepaid expenses and other current assets | 79,144 | 55,129 |
Total current assets | 972,465 | 971,985 |
Property and equipment, net | 40,645 | 20,296 |
Operating lease right-of-use assets | 62,508 | 33,600 |
Long-term investments | 265,800 | 187,921 |
Goodwill | 37,070 | 36,910 |
Intangible assets, net | 16,191 | 22,083 |
Other assets | 70,616 | 69,543 |
Total assets | 1,465,295 | 1,342,338 |
Current liabilities: | ||
Accounts payable | 5,340 | 9,383 |
Accrued payroll and payroll related liabilities | 46,569 | 53,683 |
Accrued expenses and other current liabilities | 34,987 | 31,715 |
Deferred revenue | 108,664 | 83,895 |
Convertible senior notes, net | 72,619 | 68,154 |
Total current liabilities | 268,179 | 246,830 |
Convertible senior notes, net | 657,501 | 630,321 |
Deferred revenue | 3,806 | 2,733 |
Operating lease liabilities | 53,860 | 29,293 |
Other liabilities | 5,158 | 2,660 |
Deferred income tax, net | 0 | 5,594 |
Total liabilities | 988,504 | 917,431 |
Commitments and contingencies (Note 15) | ||
Stockholders equity: | ||
Preferred stock, $0.0001 par value: 10,000 shares authorized as of December 31, 2020 and December 31, 2019, respectively; no shares issued and outstanding as of December 31, 2020 and December 31, 2019, respectively | 0 | 0 |
Common stock, $0.0001 par value: 500,000 Class A shares authorized, 58,634 and 52,056 shares issued and outstanding, as of December 31, 2020 and December 31, 2019, respectively; 500,000 Class B shares authorized, 8,108 and 13,204 shares issued and outstanding as of December 31, 2020 and December 31, 2019, respectively | 7 | 7 |
Additional paid-in capital | 489,025 | 412,191 |
Retained earnings (accumulated deficit) | (10,748) | 14,235 |
Accumulated other comprehensive loss | (1,493) | (1,526) |
Total stockholders equity | 476,791 | 424,907 |
Total liabilities and stockholders equity | $ 1,465,295 | $ 1,342,338 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started