Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Ratio Calculation On each data tab, use formulas to calculate the following financial indicators for each year of data: o Currentratio o Debt/equityratio o Freecashflow
Ratio Calculation
On each data tab, use formulas to calculate the following financial indicators for each year of data:
o Currentratio o Debt/equityratio o Freecashflow o Earnings per share o Price/earnings ratio o Returnonequity o Netprofitmargin
Exchange rate used is that of the Year End reported date | ||||
As Reported Annual Balance Sheet | ||||
Report Date | 06/30/2020 | 06/30/2019 | 06/30/2018 | |
Currency | USD | USD | USD | |
Audit Status | Not Qualified | Not Qualified | Not Qualified | |
Consolidated | Yes | Yes | Yes | |
Scale | Thousands | Thousands | Thousands | |
Cash & cash equivalents | 1035500 | 162100 | 150600 | |
Marketable securities | 719500 | 216000 | - | |
Accounts receivable, net | 34600 | 18500 | 9400 | |
Raw materials | 17800 | - | - | |
Work-in-process | 4600 | - | - | |
Finished products | 232500 | - | - | |
Total inventories | 254900 | - | - | |
Less: reserves | 10500 | - | - | |
Inventories, net | 244500 | 136600 | 25300 | |
Prepaid expenses & other current assets | 124500 | 48400 | 18400 | |
Total current assets | 2158600 | 581700 | 203800 | |
Land | 7100 | - | - | |
Buildings | 9200 | - | - | |
Leasehold improvements | 115400 | 47600 | 24600 | |
Equipment | 35100 | - | - | |
Machinery & equipment | - | 11700 | 5100 | |
Capitalized software | - | 16000 | 5800 | |
Furniture & fixtures | 9800 | 7500 | 3800 | |
Software | 32700 | - | - | |
Property | - | 2300 | 2200 | |
Construction in progress | 97100 | 40100 | 3100 | |
Building - build-to-suit asset | - | 147100 | - | |
Pre-production tooling | - | 3300 | 1000 | |
Property & equipment, gross | 306200 | 275400 | 45600 | |
Less: accumulated depreciation & amortization | 64000 | 25600 | 9500 | |
Property & equipment, net | 242300 | 249700 | 36200 | |
Intangible assets, net | 16000 | 19500 | 24500 | |
Goodwill | 39100 | 4300 | 4200 | |
Restricted cash | 1500 | 800 | 1000 | |
Right-of-use assets, net | 492500 | - | - | |
Other assets | 31800 | 8500 | 1600 | |
Total assets | 2981800 | 864500 | 271200 | |
Accounts payable | 135800 | 92200 | 28100 | |
Inventory received but not billed | 88600 | - | - | |
Accrued music licensing royalties | 37900 | - | - | |
Employee-related liabilities | 35100 | - | - | |
Accrued marketing | 5800 | 19300 | 5900 | |
Content costs for past use reserve | - | 18900 | 18600 | |
Other accrued expenses | 58500 | 66300 | 26800 | |
Accrued expenses | 225900 | 104500 | 51400 | |
Customer deposits & deferred revenue | 363600 | 90800 | 88500 | |
Current portion of lease liabilities & other current liabilities | 46900 | - | - | |
Other current liabilities | - | 3300 | 2200 | |
Total current liabilities | 772200 | 290800 | 170200 | |
Deferred rent | - | 23700 | 9400 | |
Build-to-suit liability | - | 147100 | - | |
Long term lease liabilities, net | 508200 | - | - | |
Other non-current liabilities | 23400 | 400 | 1000 | |
Total liabilities | 1303800 | 462000 | 180500 | |
Redeemable convertible preferred stock | - | 941100 | 406300 | |
Additional paid-in capital | 2361800 | 90700 | 20500 | |
Accumulated other comprehensive income (loss) | 10100 | 200 | - | |
Retained earnings (accumulated deficit) | -693900 | -629500 | -336100 | |
Total stockholders' equity (deficit) | 1678000 | -538600 | -315600 | |
Powered by Clearbit | ||||
Peloton Interactive Inc (NMS: PTON) | ||||
Exchange rate used is that of the Year End reported date | ||||
As Reported Annual Income Statement | ||||
Report Date | 06/30/2020 | 06/30/2019 | 06/30/2018 | |
Currency | USD | USD | USD | |
Audit Status | Not Qualified | Not Qualified | Not Qualified | |
Consolidated | Yes | Yes | Yes | |
Scale | Thousands | Thousands | Thousands | |
Revenue - connected fitness products | 1462200 | 719200 | 348600 | |
Revenue - subscription | 363700 | 181100 | 80300 | |
Revenue - other | - | 14700 | 6200 | |
Total revenue | 1825900 | 915000 | 435000 | |
Cost of revenue: connected fitness products | 833500 | 410800 | 195000 | |
Cost of revenue: subscription | 155700 | 103700 | 45500 | |
Cost of revenue: other | - | 17000 | 4900 | |
Total cost of revenue | 989100 | 531400 | 245400 | |
Gross profit (loss) | 836700 | 383600 | 189600 | |
Research & development expenses | 89000 | 54800 | 23400 | |
Sales & marketing expenses | 477000 | 324000 | 151400 | |
General & administrative expenses | 351600 | 207000 | 62400 | |
Total operating expenses | 917600 | 585800 | 237100 | |
Income (loss) from operations | -80800 | -202300 | -47500 | |
Interest income (expense), net | 16200 | 7000 | -300 | |
Other income (expense), net | -3800 | -300 | - | |
Total other income (expense), net | 12400 | 6700 | -300 | |
Income (loss) before provision for income taxes - U.S. | -15600 | - | - | |
Income (loss) before provision for income taxes - foreign | -52800 | - | - | |
Income (loss) before provision for income taxes | -68400 | -195600 | -47900 | |
Current state income tax expense (benefit) | 1200 | - | - | |
Current foreign income tax expense (benefit) | 3000 | - | - | |
Total current income tax expense (benefit) | 4200 | - | - | |
Deferred foreign income tax expense (benefit) | -900 | - | - | |
Total deferred income tax expense (benefit) | -900 | - | - | |
Income tax expense (benefit) | 3300 | 100 | 100 | |
Net income (loss) | -71600 | -195600 | -47900 | |
Less: premium on repurchase of convertible preferred stock | - | 50100 | - | |
Net income (loss) attributable to class A & class B common stockholders | -71600 | -245700 | -47900 | |
Weighted average shares outstanding - basic | 220952.237 | 22911.764 | 21934.228 | |
Weighted average shares outstanding - diluted | 220952.237 | 22911.764 | 21934.228 | |
Year end shares outstanding | 288057.112 | 25301.604 | 25936.848 | |
Net earnings (loss) per share - basic | -0.32 | -10.72 | -2.18 | |
Net earnings (loss) per share - diluted | -0.32 | -10.72 | -2.18 | |
Total number of employees | 3281 | 1800 | - | |
Number of A common stockholders | 27 | - | - | |
Number of B common stockholders | 191 | 428 | - | |
Foreign currency translation adjustments | 6000 | - | - |
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