Excel Assignment

soosa

Assignment_ChewyFY2020.xlsx

Home >Business & Finance homework help >Accounting homework help >Excel Assignment

Determination of Exchange Rates

Students should answer the questions on this page before working on the financial statement tabs.

Use the following website to collect the daily USD to Japanese Yen (JPY) exchange rates:

https://finance.yahoo.com/quote/JPY%3DX/history?p=JPY%3DX

Determine the following exchange rates:

Current Rate

Historical Rate

Average Rate

Base your exchange rates on the Adjusted Close price provided by the website above.

What currency are the rates above stated in?

Are they direct or indirect rates to Unicharm Corp?

Include the data used to determine the relevant exchange rates in the space below.

Remember: this is the only space where you should enter a number into Excel. Everything in the yellow cells above (and on the other tabs) should be a cell reference or a formula.

BALANCE_SHEET

Created by EDGAR Online, Inc.
		Information from "Determination of Exchange Rates" tab:
CHEWY, INC.		Current Rate	0.0000000	These rates will populate when you have completed the "determination of exchange rates" tab.
BALANCE_SHEET		Historical Rate	0.0000000
Form Type: 10-K		Average Rate	0.0000000
Period End: Jan 31, 2021
Date Filed: Mar 30, 2021
	CHEWY, INC.
	CONSOLIDATED BALANCE SHEETS
	(in thousands, except share and per share data)
		January 31, 2021	Exchange Rate	Amount in Yen
	Assets
	Current assets:
	Cash and cash equivalents	$ 563,345
	Accounts receivable	100,699
	Inventories	513,304
	Due from Parent, net	21,869
	Prepaid expenses and other current assets	27,561
	Total current assets	1,226,778
	Property and equipment, net	210,017
	Operating lease right-of-use assets	297,213
	Other non-current assets	6,902
	Total assets	$ 1,740,910
	Liabilities and stockholders' deficit
	Current liabilities:
	Trade accounts payable	$ 778,365
	Accrued expenses and other current liabilities	602,497
	Total current liabilities	1,380,862
	Operating lease liabilities	328,231
	Other long-term liabilities	33,821
	Total liabilities	1,742,914
	Commitments and contingencies (Note 4)
	Stockholders' deficit:
	Preferred stock, $0.01 par value per share, 5,000,000 shares
	authorized, no shares issued and outstanding as of January 31,
	2021 and February 2, 2020	- 0
	Class A common stock, $0.01 par value per share, 1,500,000,000
	shares authorized, 97,708,518 and 66,445,422 shares issued and
	outstanding as of January 31, 2021 and February 2, 2020,
	respectively	977
	Class B common stock, $0.01 par value per share, 395,000,000
	shares authorized, 317,338,356 and 334,922,454 shares issued
	and outstanding as of January 31, 2021 and February 2, 2020,
	respectively	3,173
	Additional paid-in capital	1,930,804
	Accumulated deficit	(1,936,958)
	Total stockholders' deficit	(2,004)
	Total liabilities and stockholders' deficit	$ 1,740,910

INCOME_STATEMENT

Created by EDGAR Online, Inc.
		Information from "Determination of Exchange Rates" tab:
CHEWY, INC.		Current Rate	0.0000000	These rates will populate when you have completed the "determination of exchange rates" tab.
INCOME_STATEMENT2		Historical Rate	0.0000000
Form Type: 10-K		Average Rate	0.0000000
Period End: Jan 31, 2021
Date Filed: Mar 30, 2021
	CHEWY, INC.
	CONSOLIDATED STATEMENTS OF OPERATIONS
	(in thousands, except per share data)

		2020	Exchange Rate	Amount in Yen
	Net sales	$ 7,146,264
	Cost of goods sold	5,325,457
	Gross profit	1,820,807
	Operating expenses:
	Selling, general and administrative	1,397,969
	Advertising and marketing	513,302
	Total operating expenses	1,911,271
	Loss from operations	(90,464)
	Interest (expense) income, net	(2,022)
	Loss before income tax provision	(92,486)
	Income tax provision	- 0
	Net loss	$ (92,486)
	Net loss per share attributable to common Class A
	and Class B stockholders, basic and diluted	$ (0.23)
	Weighted average common shares used in computing
	net loss per share attributable to common Class A
	and Class B stockholders, basic and diluted	407,240

STOCKHOLDERS_EQUITY

Created by EDGAR Online, Inc.
		Information from "Determination of Exchange Rates" tab:
CHEWY, INC.		Current Rate	0.0000000	These rates will populate when you have completed the "determination of exchange rates" tab.
STOCKHOLDERS_EQUITY		Historical Rate	0.0000000
Form Type: 10-K		Average Rate	0.0000000
Period End: Jan 31, 2021
Date Filed: Mar 30, 2021
	CHEWY, INC.
	CONSOLIDATED STATEMENTS OF STOCKHOLDERS' DEFICIT
	(in thousands)
		Accumulated Deficit	Exchange Rate	Amount in Yen
	Balance as of February 2, 2020	$ (1,844,472)
	Issuance of Class A common stock, net of
	offering costs	- 0
	Share-based compensation expense	- 0
	Vesting of share-based compensation
	awards	- 0
	Distribution to Parent	- 0
	Contribution from Parent	- 0
	Tax sharing agreement with Parent	- 0
	Net loss	(92,486)
	Balance as of January 31, 2021	$ (1,936,958)