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

The Answer is in the image, click to view ...

Question: 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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

1. Financial Data Using the same company you selected in Module Three, add another two years of financial statement data so that you have three years of annual data to review for historical analysis....

I NEEDTHIS ASSIGNMENT DONE i WILL TIP 30 Here is the assignment and my spread sheet so far The financial statements were given, I just need to do the calculations at the bottom of the first three...

As Reported Annual Balance Sheet Report Date 12/31/2017 USD 12/31/2018 USD 12/31/2019! USD Currency Audit Status Not Qualified Yes Thousands 17504 171471 53651 9300 63 9237 4402 6384 Not Available...

Please help me figure out these ratios, I made mistake in the first Excel assignment, and cannot figure out the second one. I attached the my excel assignment along with the question pdf. For my...

Please see attached for assignment details. I have the balance sheet, income statement, and statement of cash flow data already - I need all the new ratios. I've tried and tried and I'm just not...

I just need someone to look over my work. It is completed just need someone to double check if I did it correctly. These are the instructions (below) and I am attaching my completed assignment. If...

This is for Procter and Gamble stock. I have attached the information needed. ii bb.snhuedu FIN 320 Module Four Excel Assignment Rubric This assignment builds on the work you did for the Excel...

Directions: Ratio Calculation On each data tab, use formulas to calculate the following financial indicators for each year of data: o Current ratio o Debt/equity ratio o Free cash flow o Earnings per...

Finance Excel ASS: Ratios 1. Financial Data Using the same company you selected in Module Three, add another two years of financial statement data so that you have three years of annual data to...

A box contains 8 burritos. 3 are chicken and 5 are beef. Three of the burritos will be chosen randomly. What is the probability that one chicken and 2 beef will be chosen?

Water at 93.3 C is pumped from a large storage tank at a pressure of 1 atm abs with a flow rate of 0.189 m3 /minute using the pump. the motor that drives the energy pump to the pump at 1.49 kW. Air...

differentiate \ ( f \ left ( x \ right ) = 7 \ sqrt { 4 x - 5 } - 2 e ^ { - x } \ cdot \ textrm { sin } \ left ( 3 x \ right ) + 5 \ cdot 2 ^ { 6 x } \ )

During a stay in a hotel, which of the following is NOT a tangible component? The complimentary newspaper The towels The hotel bed The wake up call The room key

Debate: Argue for or against the mandatory localization law and the possible consequences for HRM policies and procedures.

Predict how cultural dimensions can impact the quality of internal service and proactive behavior.

Design an organizational intervention using needs analysis, HRM tactics, and evaluation processes to improve organizational effectiveness.