Chosen company : Estee Lauder

from $10$ k form$-$ as of $6/20/2023$

Horizontal & Vertical Analysis

Step $1$: Compute Dollar Change Percent

Compute dollar change percent $($for this fiscal year vs last fiscal year$)$ for the following accounts for your chosen company:

Cash$-2023=$ $$4\mathrm{.}03$ billion and $2022=$ $$3\mathrm{.}96$ billion

Accounts$/$Trade Receivables $=2023=$ $$1,452$ million and $2022=$ $$1,629$ million

Inventory $=2023=$ $$2,979$ million and $2022=$ $$2,920$ million

Total current assets $=2023=$ $$9,139$ million and $2022=$ $$9,298$ million

Total assets$=2023=$ $$23,415$ million and $2022=$ $$20,910$ million

Total current liabilities$=2023=$ $$6,240$ million and $2022=$ $$5,815$ million

Net Sales$/$Revenue$=2023=$ $$15\mathrm{.}91$ billion and $2022=$ $$17\mathrm{.}74$ billion

Cost of Sales$/$Cost of Goods Sold $=2023=$ $$4\mathrm{.}564$ billion and $2022=$ $$4\mathrm{.}305$ billion

Operating Expenses $($or selling & general$/$administrative expenses$)$: $2023=$ $$2,420$ million and $2022=$ $$2,334$ million

Operating Income $($income before interest and taxes$)$ : $2023=$ $$1\mathrm{.}51$ billion $(1,509$ billion$)$ and $2022=$ $$3\mathrm{.}17$ billion $($$$3,170$ billion$)$

Net Income: $2023=$ $$1\mathrm{.}006$ billion and $2022=$ $$2\mathrm{.}39$ billion

Step $2$: Compute Common Size Percent

Compute common size percent for the most current fiscal year for the following accounts for your chosen company:

Cash$-2023=$ $$4\mathrm{.}03$ billion and $2022=$ $$3\mathrm{.}96$ billion

Accounts$/$Trade Receivables $=2023=$ $$1,452$ million and $2022=$ $$1,629$ million

Inventory $=2023=$ $$2,979$ million and $2022=$ $$2,920$ million

Total current assets $=2023=$ $$9,139$ million and $2022=$ $$9,298$ million

Total assets$=2023=$ $$23,415$ million and $2022=$ $$20,910$ million

Total current liabilities$=2023=$ $$6,240$ million and $2022=$ $$5,815$ million

Net Sales$/$Revenue$=2023=$ $$15\mathrm{.}91$ billion and $2022=$ $$17\mathrm{.}74$ billion

Cost of Sales$/$Cost of Goods Sold $=2023=$ $$4\mathrm{.}564$ billion and $2022=$ $$4\mathrm{.}305$ billion

Operating Expenses $($or selling & general$/$administrative expenses$)$: $2023=$ $$2,420$ million and $2022=$ $$2,334$ million

Operating Income $($income before interest and taxes$)$ : $2023=$ $$1\mathrm{.}51$ billion $(1,509$ billion$)$ and $2022=$ $$3\mathrm{.}17$ billion $($$$3,170$ billion$)$

Net Income: $2023=$ $$1\mathrm{.}006$ billion and $2022=$ $$2\mathrm{.}39$ billion