Answered step by step
Verified Expert Solution
Link Copied!

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

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

Called To Account Financial Frauds That Shaped The Accounting Profession

Authors: Paul M. Clikeman

3rd Edition

1138327085, 9781138327085

More Books

Students also viewed these Accounting questions

Question

=+What are the states of nature?

Answered: 1 week ago