Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Collaborative Auditing

Authors: James Pelletier, Yuki Matsuura

2nd Edition

0894139606, 9780894139604

More Books

Students also viewed these Accounting questions