Stock Analysis on Net

Etsy Inc. (NASDAQ:ETSY)

$22.49

This company has been moved to the archive! The financial data has not been updated since November 3, 2022.

Economic Value Added (EVA)

Microsoft Excel

EVA is registered trademark of Stern Stewart.

Economic value added or economic profit is the difference between revenues and costs,where costs include not only expenses, but also cost of capital.

Paying user area


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Economic Profit

Etsy Inc., economic profit calculation

US$ in thousands

Microsoft Excel
12 months ended: Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Net operating profit after taxes (NOPAT)1
Cost of capital2
Invested capital3
 
Economic profit4

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 NOPAT. See details »

2 Cost of capital. See details »

3 Invested capital. See details »

4 2021 Calculation
Economic profit = NOPAT – Cost of capital × Invested capital
= × =


Net Operating Profit after Taxes (NOPAT)

Etsy Inc., NOPAT calculation

US$ in thousands

Microsoft Excel
12 months ended: Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Net income
Deferred income tax expense (benefit)1
Increase (decrease) in allowance for credit losses2
Increase (decrease) in deferred revenue3
Increase (decrease) in equity equivalents4
Interest expense
Interest expense, operating lease liability5
Adjusted interest expense
Tax benefit of interest expense6
Adjusted interest expense, after taxes7
Net operating profit after taxes (NOPAT)

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 Elimination of deferred tax expense. See details »

2 Addition of increase (decrease) in allowance for credit losses.

3 Addition of increase (decrease) in deferred revenue.

4 Addition of increase (decrease) in equity equivalents to net income.

5 2021 Calculation
Interest expense on capitalized operating leases = Operating lease liability × Discount rate
= × =

6 2021 Calculation
Tax benefit of interest expense = Adjusted interest expense × Statutory income tax rate
= × 21.00% =

7 Addition of after taxes interest expense to net income.


Net Income
The net income demonstrates a generally increasing trend over the five-year period. Initially, the net income registers at 81,800 thousand USD at the end of 2017, followed by a slight decline to 77,491 thousand USD in 2018. From 2018 onwards, there is consistent growth, with net income rising to 95,894 thousand USD in 2019. This growth accelerates significantly in 2020, reaching 349,246 thousand USD, and continues to increase substantially in 2021, amounting to 493,507 thousand USD. The sharp increase during 2020 and 2021 indicates a notable improvement in profitability.
Net Operating Profit After Taxes (NOPAT)
The NOPAT figures also show a positive trajectory throughout the period. Starting at 47,642 thousand USD in 2017, NOPAT rises to 76,568 thousand USD in 2018, reflecting an increase in operating efficiency or profitability. The upward trend continues in 2019 with NOPAT reaching 103,763 thousand USD. A marked jump occurs in 2020, with NOPAT surging to 393,749 thousand USD, aligning with the sharp increase observed in net income during the same year. In 2021, NOPAT grows further but at a slower pace, reaching 413,095 thousand USD. This overall trend indicates enhanced operational performance and effective tax management over the years considered.
Summary of Trends
Both net income and NOPAT exhibit substantial growth, particularly between 2019 and 2021. The periods of 2020 and 2021 stand out as years of significant earnings expansion, indicating improved operational efficiency and overall profitability. The rise in NOPAT more closely aligns with operational improvements, while net income additionally reflects the impact of non-operational factors and tax considerations. The data suggests strengthened financial health and operational leverage leading to improved earnings capacity.

Cash Operating Taxes

Etsy Inc., cash operating taxes calculation

US$ in thousands

Microsoft Excel
12 months ended: Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Income tax provision (benefit)
Less: Deferred income tax expense (benefit)
Add: Tax savings from interest expense
Cash operating taxes

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Income Tax Provision (Benefit)
The income tax provision shows significant fluctuations over the five-year period. Beginning in 2017, the provision was a substantial negative figure indicating a tax benefit of -$49,535 thousand. This negative trend decreased in magnitude over the following years, with the benefit lessening to -$22,413 thousand in 2018 and further narrowing to -$15,248 thousand in 2019. Notably, in 2020, the trend reversed to a positive tax provision of $16,463 thousand, indicating an actual tax expense during this year. However, in 2021, the tax provision returned to a negative value of -$21,853 thousand. This irregular pattern suggests volatility in taxable income or tax strategy changes across the years.
Cash Operating Taxes
Cash operating taxes displayed a marked upward trend throughout the observed period. The value, which was a minor negative amount of -$1,409 thousand in 2017, shifted to positive in 2018 at $5,774 thousand. Following this, the amount continued to increase consistently each year, reaching $2,782 thousand in 2019, then sharply rising to $23,282 thousand in 2020, and culminating in a substantial $69,622 thousand in 2021. This steady and sharp increase suggests a growing cash outflow related to taxes paid from operating activities, possibly reflecting higher taxable earnings or changes in tax payment timing or policies.

Invested Capital

Etsy Inc., invested capital calculation (financing approach)

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Finance lease obligations, current
Finance lease obligations, net of current portion
Facility financing obligation
Long-term debt, net
Operating lease liability1
Total reported debt & leases
Stockholders’ equity
Net deferred tax (assets) liabilities2
Allowance for credit losses3
Deferred revenue4
Equity equivalents5
Accumulated other comprehensive (income) loss, net of tax6
Adjusted stockholders’ equity
Construction in progress7
Marketable securities8
Invested capital

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 Addition of capitalized operating leases.

2 Elimination of deferred taxes from assets and liabilities. See details »

3 Addition of allowance for doubtful accounts receivable.

4 Addition of deferred revenue.

5 Addition of equity equivalents to stockholders’ equity.

6 Removal of accumulated other comprehensive income.

7 Subtraction of construction in progress.

8 Subtraction of marketable securities.


Total reported debt & leases
The total reported debt and leases show a significant and consistent increase over the five-year period. Starting from 88,048 thousand US dollars at the end of 2017, the figure rose substantially to 2,435,883 thousand US dollars by the end of 2021. This represents a nearly 28-fold increase, indicating a sharp rise in the company's leverage and financial obligations.
Stockholders’ equity
Stockholders’ equity experienced moderate growth from 396,894 thousand US dollars in 2017 to 742,424 thousand in 2020, peaking during the year 2020. However, there was a decline in 2021 to 628,619 thousand US dollars. Overall, equity increased by approximately 58% from 2017 to 2021, but the decline in the final year suggests potential pressures or adjustments impacting the company's net assets.
Invested capital
Invested capital exhibited a continuous and pronounced increase throughout the period evaluated. Beginning at 498,789 thousand US dollars in 2017, it more than quintupled to 2,842,921 thousand US dollars by the end of 2021. This upward trajectory suggests substantial capital deployment, likely reflecting expansion activities supported by rising debt levels and equity contributions.

Cost of Capital

Etsy Inc., cost of capital calculations

Capital (fair value)1 Weights Cost of capital
Equity2 ÷ = × =
Debt and finance lease liabilities3 ÷ = × × (1 – 21.00%) =
Operating lease liability4 ÷ = × × (1 – 21.00%) =
Total:

Based on: 10-K (reporting date: 2021-12-31).

1 US$ in thousands

2 Equity. See details »

3 Debt and finance lease liabilities. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 ÷ = × =
Debt and finance lease liabilities3 ÷ = × × (1 – 21.00%) =
Operating lease liability4 ÷ = × × (1 – 21.00%) =
Total:

Based on: 10-K (reporting date: 2020-12-31).

1 US$ in thousands

2 Equity. See details »

3 Debt and finance lease liabilities. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 ÷ = × =
Debt and finance lease liabilities3 ÷ = × × (1 – 21.00%) =
Operating lease liability4 ÷ = × × (1 – 21.00%) =
Total:

Based on: 10-K (reporting date: 2019-12-31).

1 US$ in thousands

2 Equity. See details »

3 Debt and finance lease liabilities. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 ÷ = × =
Debt and finance lease liabilities3 ÷ = × × (1 – 21.00%) =
Operating lease liability4 ÷ = × × (1 – 21.00%) =
Total:

Based on: 10-K (reporting date: 2018-12-31).

1 US$ in thousands

2 Equity. See details »

3 Debt and finance lease liabilities. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 ÷ = × =
Debt and finance lease liabilities3 ÷ = × × (1 – 35.00%) =
Operating lease liability4 ÷ = × × (1 – 35.00%) =
Total:

Based on: 10-K (reporting date: 2017-12-31).

1 US$ in thousands

2 Equity. See details »

3 Debt and finance lease liabilities. See details »

4 Operating lease liability. See details »


Economic Spread Ratio

Etsy Inc., economic spread ratio calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Economic profit1
Invested capital2
Performance Ratio
Economic spread ratio3
Benchmarks
Economic Spread Ratio, Competitors4
Amazon.com Inc.
Home Depot Inc.
Lowe’s Cos. Inc.
TJX Cos. Inc.

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 Economic profit. See details »

2 Invested capital. See details »

3 2021 Calculation
Economic spread ratio = 100 × Economic profit ÷ Invested capital
= 100 × ÷ =

4 Click competitor name to see calculations.


Economic Profit Margin

Etsy Inc., economic profit margin calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Economic profit1
 
Revenue
Add: Increase (decrease) in deferred revenue
Adjusted revenue
Performance Ratio
Economic profit margin2
Benchmarks
Economic Profit Margin, Competitors3
Amazon.com Inc.
Home Depot Inc.
Lowe’s Cos. Inc.
TJX Cos. Inc.

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 Economic profit. See details »

2 2021 Calculation
Economic profit margin = 100 × Economic profit ÷ Adjusted revenue
= 100 × ÷ =

3 Click competitor name to see calculations.