Question

Please calculate 2020,2021,2022 common sized and leave formula.

PROJECTED BALANCE SHEETS							Common Sized
		Opening	2020	2021	2022		2020	2021	2022
ASSETS
Current Assets
	Cash	$       125,000	$       125,000	$       125,000	$       125,000
	Accounts Recievable		89,260	115,452	152,877
	Inventory		30,736	28,863	38,219
	Prepaid and Other Assets		219	274	329
	Total Current Assets		245,215	269,589	316,425
Long Lived Assets
	Property, Plant and Equipment		500	550	750
	Accumulated Depreciation		(320)	(431)	(577)
	Net P,P&E		180	119	173
	TOTAL ASSETS		$       245,395	$       269,708	$       316,598

Answer 1

PROJECTED BALANCE SHEETS						Common Sized
	Opening	2020	2021	2022		2020	2021	2022
ASSETS
Current Assets
Cash	$       125,000	125,000	125,000	125,000		50.94%	46.35%	39.48%
Accounts Recievable		89260	115452	152877		36.37%	42.81%	48.29%
Inventory		30736	28863	38219		12.53%	10.70%	12.07%
Prepaid and Other Assets		219	274	329		0.09%	0.10%	0.10%
Total Current Assets		245,215	269,589	316,425		99.93%	99.96%	99.95%
Long Lived Assets
Property, Plant and Equipment		500	550	750		0.20%	0.20%	0.24%
Accumulated Depreciation		($320)	($431)	($577)		-0.13%	-0.16%	-0.18%
Net P,P&E		180	119	173		0.07%	0.04%	0.05%
TOTAL ASSETS		245,395	269,708	316,598		100.00%	100.00%	100.00%

*Respective amounts ÷ Total assets