Financial Statement Analysis Elventh Edition K.R. Subramanyam, Promblem 9-2.

What ratios provide the numbers for the year 3 forecast? I'm having a hard time completing the balance sheet scetion. Specificly finding how the Year 3 Cash, Assets and Debt is calculated.

Income Statement		Y 2	Y 1
Net Sales		15,326.00	12,494.00
COGS		12,267.00	10,101.00
Gross Profit		3,059.00	2,393.00
Selling general & admin		2,251.00	1,728.00
Depreciation		167.00	103.00
Inc Before Tax		641.00	562.00
Inc Tax Exp		245.00	215.00
Net Income		396.00	347.00
Outstanding Shares		208.00	200.00
Balance Sheet
Cash		746.00	751.00
Receivables		313.00	262.00
Inventories		1,767.00	1,184.00
Other Current Assets		102.00	41.00
Total Current Assets		2,928.00	2,238.00
PPE		1,987.00	1,093.00
Accumliated Depreciation		543.00	395.00
Net PPE		1,444.00	698.00
Other Non Current Assets		466.00	59.00
Total Assets		4,838.00	2,995.00
AP		2,473.00	1,704.00
Short Term Debt		114.00	16.00
Inc Tax Liab		127.00	65.00
Total Short Term Liab		2,714.00	1,785.00
Long Term Liab		122.00	100.00
Long Term Debt		181.00	15.00
Total Long Term Liab		303.00	115.00
Common Stock		20.00	20.00
Cap Surplus		576.00	247.00
RE		1,225.00	828.00
Shareholders EQ		1,821.00	1,095.00
Total Liabilities and EQ		4,838.00	2,995.00

Ratios

Sales Growth	22.67%
Gross Profit Margin	19.96%
Selling General & Admin / Sales	14.69%
Deprecation EXP / Prior Yr PPE Gross	15.28%
Inc Tax Exp / Pretax Inc	38.22%
AR Turnover AR/Sales	48.96
Inventory Turnover COGS / Inv	6.94
AP turnover COGS / AP	4.96
Tax Pay / Tax Exp	51.84%
Total Assets / Share Holder EQTY	2.55
Dividend Per Share	0
CAPEX / Sales	6.71%