Please answer the questions on the following tabs. This assignment is due on Friday, October 13, 2023 by 11:59 pm. An uploaded EXCEL document should include the following: 1. Company Information tab 2. Balance Sheet tab 3. Income Statement tab 4. Statement of Cash Flows tab 5. Common-Size I/S tab,

To begin, (1) go to www.sec.gov; click "Company Filings"; go to "Fast Search" and enter your company's ticker symbol; and find "10-K" under Filings and click "Interactive Data," or download your Company's most recent SEC Form 10-K in pdf format from its investor relation's site, and (2) use it to answer the questions herein. Stock prices for any given day can be found using Google Finance or Yahoo Finance.

The goal of common-size statements is to compare a company across time and to other companies. common-size income statement for your company and insert it below. Common-size income statements express each line item as a percentage of revenue, e.g., revenue will be shown as 100%. Below is the example for iRobot. Below is iRobot as an example. (Replace iRobot with your company - three years is sufficient. Note that your company's income statement is likely to have different line items. Use what is reported for your company.)

Consolidated Statements of Income - USD ($) shares in Thousands, $ in Thousands	12 Months Ended	12 Months Ended
Jan. 1, 2022	Jan. 2, 2021	Dec. 28, 2019	Jan. 1, 2022	Jan. 2, 2021	Dec. 28, 2019
Revenue	$ 1,564,987	$ 1,430,390	$ 1,214,010	100.0%	100.0%	100.0%
Cost of product revenue	1,013,465	758,241	658,362	64.8%	53.0%	54.2%
Amortization of acquired intangible assets	1,223	1,920	11,721	0.1%	0.1%	1.0%
Total cost of revenue	1,014,688	760,161	670,083	64.8%	53.1%	55.2%
Gross profit	550,299	670,229	543,927	35.2%	46.9%	44.8%
Operating expenses:
Research and development	161,331	156,670	141,607	10.3%	11.0%	11.7%
Selling and marketing	289,848	265,475	231,548	18.5%	18.6%	19.1%
General and administrative	99,190	100,770	83,103	6.3%	7.0%	6.8%
Amortization of acquired intangible assets	1,030	992	1,051	0.1%	0.1%	0.1%
Total operating expenses	551,399	523,907	457,309	35.2%	36.6%	37.7%
Operating (loss) income	(1,100)	146,322	86,618	-0.1%	10.2%	7.1%
Other income, net	29,384	41,593	12,215	1.9%	2.9%	1.0%
Income before income taxes	28,284	187,915	98,833	1.8%	13.1%	8.1%
Income tax (benefit) expense	(2,106)	40,847	13,533	-0.1%	2.9%	1.1%
Net income	$ 30,390	$ 147,068	$ 85,300	1.9%	10.3%	7.0%
What do you observe from the common-size analysis of your company?

Insert numbers and compute financial ratios	Most recent year available	1st Prior Year
What is the balance sheet date? (e.g., 12/31/21 and 12/31/22)
What is the dollar amount of total assets?
What is the dollar amount of total liabilities?
What is the dollar amount of total shareholders' equity?
Does A = L + OE? (Yes or No)
Name the Company's largest asset. Is it "current" or "noncurrent"?
Does the Company have inventory? Why or why not?
Name the Company's largest liability? Is it "current" or "noncurrent"?
Calculate working capital [= current assets - current liabilities]
Calculate the current ratio [= current assets current liabilities]
Based on the current ratio, did the Company become more or less liquid comparing its current year to the prior year?
Calculate the total debt to total assets ratio [= total liabilities total assets]
Based on the total debt to total assets ratio computed above, is the Company better off or worse off in its ability to withstand long-term financial difficulties?
What is your overall assessment of your Company's financial condition? Refer to any of the above numbers or ratios in your brief summary.

Your name
Income Statement
Insert numbers and compute financial ratios	Most recent year available	1st Prior Year
What is the dollar amount of total Sales Revenue (a.k.a., net sales or net revenue)?
Compute the % change in revenue [= (most recent year's Revenue prior year's Revenue) - 1]		N/A
What is the dollar amount of Gross Profit? [If it is not given, Gross Profit = sales revenue minus cost of goods sold]
Compute Gross Profit rate [= gross profit net sales revenue]
What is the dollar amount of Operating Income? [often shown as a subtotal in the I/S; if not given, Operating Income is revenues minus expenses related to day-to-day operations.]
Compute the % change in Operating Income [= (most recent year's Op Inc prior year's Op Inc) - 1]		N/A
What is the dollar amount of Net Income?
Compute the % change in Net Income (NI) [= (most recent year's NI prior year's NI) - 1]		N/A
Compute Operating Profit Margin [= operating income net sales]
Compute Profit Margin [= net income net sales]
What is reported as basic earnings per share (EPS)? (look it up - no need to calculate)
What is your overall assessment of your Company's performance? Refer to any of the above numbers or ratios in your brief summary.

Your name
Basic Company Data
Company name	Ralph Lauren Corp (RL)
Company stock ticker symbol
Company headquarters location
Industry name
CEO (who signed the letter to shareholders)
Company's key Products or Services include:
Customers tend to be: (this of course will be a generalization; examples include: business, consumers, women, young professionals, teens, etc.)
Company's closest competitors are:
Who is the Company's external audit firm? (found on the Report from Independent Auditor in 10K)
Does the Company follow a calendar year (ending approximately December 31)? (Yes or No)
If they do not use a calendar year, why do you believe that is?
Company's closing stock price as of September 20, 2023?
Company's closing stock price as of October 11, 2023?
If you invested $10,000 in your company on September 20, 2023, what would your total investment be on October 11, 2023? Please let Excel makes the calculaton in cell address B16!	#DIV/0!

For Ralph Lauren corp (RL)