Suppose that gyp sum industries currently have the balance sheet shown below and that sales for the year just ended were 10.2 million. The firm also has a profit margin of 30 percent, a retention ratio of 20 percent, and expectant sales of 8.2 million next year.

Assets and Liabilities

Current Assets	2124000	long term debt | 1600000
Fixed Assests	4200000
Current Liabilities	1707480
Equity	3016520

( if all assets and current liabilities are expected to shrink with sales, what amount of additional funds will GYP SUM need from external sources to fund the expected growth? Enter your answer in dollars, not millions. Negative amounts should be indicated by a minus sign. )

Sales Last Year	10200000
Profit Margin	30%
Retention Ratio	20%
Sales Next year	8200000
Assets	6324000
Current liabilities	1707480

Complete the following analysis in Excel Formulas. do not hard code your answers. and do not round your intermediate calculations.

Please

Necessary Increase in sales
Spontaneous increase in liabilities
projected increase in retained earnings
Additional funds needed

please answer in an excel formula and explain how you got to that formula.