Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Balance sheet for 4 years CONSOLIDATED BALANCE SHEETS - USD ($) Jan. 31, 2019 Jan. 31, 2020 CONSOLIDATED BALANCE SHEETS - USD ($) Jan. 31,
Balance sheet for 4 years
CONSOLIDATED BALANCE SHEETS - USD ($) | Jan. 31, 2019 | Jan. 31, 2020 | CONSOLIDATED BALANCE SHEETS - USD ($) | Jan. 31, 2017 | Jan. 31, 2018 | ||
$ in Thousands | $ in Thousands | ||||||
Current assets: | Current assets: | ||||||
Cash and cash equivalents | 147831 | 706192 | Cash and cash equivalents | 69305 | 61902 | ||
Short-term investments | 318139 | 280326 | Short-term investments | 47195 | 217072 | ||
Accounts receivable, net of allowance for doubtful accounts of $2,515 and $1,539 as of January 31, 2020 and 2019, respectively | 72808 | 85554 | Accounts receivable, net of allowance for doubtful accounts of $1,238 and $958 as of January 31, 2018 and 2017, respectively | 31340 | 46872 | ||
Deferred commissions | 15878 | 24219 | Deferred commissions | 7481 | 11820 | ||
Prepaid expenses and other current assets | 11580 | 16905 | Prepaid expenses and other current assets | 3131 | 5884 | ||
Total current assets | 566236 | 1113196 | Total current assets | 158452 | 343550 | ||
Property and equipment, net | 73664 | 58316 | Property and equipment, net | 4877 | 59557 | ||
Operating lease right-of-use assets | 0 | 11147 | Goodwill | 1700 | 1700 | ||
Goodwill | 41878 | 55830 | Acquired intangible assets, net | 2511 | 1627 | ||
Acquired intangible assets, net | 15894 | 34779 | Deferred tax assets | 114 | 326 | ||
Deferred tax assets | 1193 | 615 | Other assets | 6778 | 8436 | ||
Other assets | 34611 | 54684 | Total assets | 174432 | 415196 | ||
Total assets | 733476 | 1328567 | Current liabilities: | ||||
Current liabilities: | Accounts payable | 2841 | 2261 | ||||
Accounts payable | 2153 | 2849 | Accrued compensation and benefits | 11402 | 17433 | ||
Accrued compensation and benefits | 25982 | 41427 | Other accrued liabilities | 5269 | 8423 | ||
Operating lease liabilities | 0 | 3750 | Deferred revenue | 78278 | 114500 | ||
Other accrued liabilities | 14169 | 26860 | Total current liabilities | 97790 | 142617 | ||
Deferred revenue | 122333 | 167498 | Redeemable convertible preferred stock warrant liability | 1272 | 0 | ||
Total current liabilities | 164637 | 242384 | Deferred rent, non-current | 1058 | 925 | ||
Deferred rent, non-current | 2567 | 0 | Deferred tax liability, non-current | 108 | 18 | ||
Deferred tax liability, non-current | 106 | 821 | Deferred revenue, non-current | 15461 | 22930 | ||
Operating lease liabilities, non-current | 0 | 8113 | Other liabilities, non-current | 0 | 55213 | ||
Deferred revenue, non-current | 15343 | 23281 | Total liabilities | 115689 | 221703 | ||
Convertible senior notes, net | 216858 | 911075 | Commitments and contingencies (Note 6) | ||||
Other liabilities, non-current | 69399 | 60035 | Redeemable convertible preferred stock, par value $0.001 per share; no shares authorized, issued or outstanding as of January 31, 2018; 41,234,841 shares authorized as of January 31, 2017; 41,148,282 shares issued and outstanding with aggregate liquidation preference of $345,997 as of January 31, 2017 | 345257 | 0 | ||
Total liabilities | 468910 | 1245709 | Stockholders equity (deficit): | ||||
Commitments and contingencies (Note 9) | Additional paid-in capital | 62557 | 638680 | ||||
Stockholders equity: | Treasury stock, 99,371 shares (repurchased at an average of $13.27 per share) as of January 31, 2018 and 2017 | -1319 | -1319 | ||||
Additional paid-in capital | 754612 | 752127 | Accumulated other comprehensive loss | -364 | -159 | ||
Treasury stock, 99,371 shares (repurchased at an average of $13.27 per share) as of January 31, 2020 and 2019 | -1319 | -1319 | Accumulated deficit | -347401 | -443760 | ||
Accumulated other comprehensive income (loss) | -174 | 225 | Total stockholders equity (deficit) | -286514 | 193493 | ||
Accumulated deficit | -488607 | -668232 | Total liabilities, redeemable convertible preferred stock and stockholders equity (deficit) | 174432 | 415196 | ||
Total stockholders equity | 264566 | 82858 | |||||
Total liabilities and stockholders equity | 733476 | 1328567 | |||||
Income statement for 4 years
CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) | 12 Months Ended | CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) | 12 Months Ended | ||||||
$ in Thousands | Jan. 31, 2018 | Jan. 31, 2019 | Jan. 31, 2020 | $ in Thousands | Jan. 31, 2016 | Jan. 31, 2017 | Jan. 31, 2018 | ||
Revenue: | Revenue: | ||||||||
Total revenue | 166028 | 267016 | 421720 | Subscription | 58561 | 91235 | 141490 | ||
Cost of revenue: | Services | 6710 | 10123 | 13029 | |||||
Total cost of revenue | 42859 | 73568 | 125356 | Total revenue | 65271 | 101358 | 154519 | ||
Gross profit | 123169 | 193448 | 296364 | Cost of revenue: | |||||
Operating expenses: | Subscription | 13146 | 19352 | 30766 | |||||
Sales and marketing | 109073 | 148296 | 223893 | Services | 7715 | 10515 | 12093 | ||
Research and development | 62202 | 89854 | 149033 | Total cost of revenue | 20861 | 29867 | 42859 | ||
General and administrative | 36775 | 53063 | 71304 | Gross profit | 44410 | 71491 | 111660 | ||
Total operating expenses | 208050 | 291213 | 444230 | Operating expenses: | |||||
Loss from operations | -84881 | -97765 | -147866 | Sales and marketing | 56613 | 78584 | 109950 | ||
Other income (expense): | Research and development | 43465 | 51772 | 62202 | |||||
Interest income | 1308 | 7163 | 8556 | General and administrative | 17070 | 27082 | 36775 | ||
Interest expense | -8 | -10290 | -20983 | Total operating expenses | 117148 | 157438 | 208927 | ||
Other income (expense), net | 895 | -1437 | -15885 | Loss from operations | -72738 | -85947 | -97267 | ||
Loss before provision for (benefit from) income taxes | -82686 | -102329 | -176178 | Other income (expense): | |||||
Provision for (benefit from) income taxes | 1287 | -3318 | -656 | Interest income | 146 | 302 | 1308 | ||
Net loss | -83973 | -99011 | -175522 | Interest expense | -24 | -9 | -8 | ||
Other income (expense), net | -428 | -308 | 895 | ||||||
Loss before provision for income taxes | -73044 | -85962 | -95072 | ||||||
Provision for income taxes | 442 | 719 | 1287 | ||||||
Revenue: | Net loss | -73486 | -86681 | -96359 | |||||
Total revenue | 151853 | 248391 | 399826 | ||||||
Cost of revenue: | |||||||||
Total cost of revenue | 30766 | 56255 | 101691 | ||||||
Services | |||||||||
Revenue: | |||||||||
Total revenue | 14175 | 18625 | 21894 | ||||||
Cost of revenue: | |||||||||
Total cost of revenue | 12093 | 17313 | 23665 | ||||||
please prepare a pro-forma forecast of the income statement and balance sheet for the company for 2021.
| |
1) Based on your forecast, does the firm need to raise any external capital for its operations in 2021? | |
2) The firm is currently making a loss. However, firms have value in part because of the expectation that at some point, they will make a profit. Is there a way to determine the potential value of this firm based on its earnings? |
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