PLS ANSWER WT SOLUTION ON EXCEL URGENT PLS THANK U

XYZ Co. has the following balance sheet for 20XX:

XYZ Co Balance Sheet as at December 31, 20XX
Assets		Liabilities
Cash	$20,500	Accounts Payable	$ 80,000
Accts. Rec	75,000	Notes Payable	45,000
Inventory	70,000	Accrued Expenses	9,000
Current Assets	165,500	Current Liabilities	134,000
Fixed assets (non-spontaneous)	80,000	Common stock	65,500
		Retained earnings	46,000
Total Assets	$245,500	Total Liabilities + S.H Equity	$245,500

XYZ Co. has the following information:

Sales $650,000 for 20XX

Sales increase 12% in 20XY

7% Return on Sales

75% Paid out in Dividends

Calculate the Required new funds to finance growth.

Percent of Sales Table
Cash	7%	Accts, Payable	30.5%
Accts. Rec.	25%	Accrued expenses	4%
Inventory	25%
Current Assets (spontaneous)	57%	Current Liabilities (spontaneous)	34.5%