This is all one problem, I need help filling out the green and yellow on this sheet. I would attach the spreadsheet, but his program doesn't allow me me to do that. You have to use the information from the bottom portion to calculate the top and the top to calculate the bottom. The jumbled letters is the formula, and this program will not let you attach a file. Below is the formula to the figure out the top.

AFN = (A*/So) ?S (L*/So) ?S (MS1) (RR)

AFN = Required Assets Inc. Spontaneous Liability Inc. Inc. in retained earnings

A*= assets that are tied directly to sales. They must increase if sales increase.

So = sales during last year

A*/So = assets to sales ratio

L* = liabilities that increase spontaneously Include accounts payable and accruals, but not bank loans and bonds

L*/So = liabilities that increase spontaneously as a percentage of sales.

S1 = total sales projected for next year

?S = change in sales = S1 So

M = profit margin

RR = retained ratio, which is the percentage of net income that is retained.[1]

[1] Retained earnings divided by net income

8 Sales 9 Net Income 10 M Profit Margin) 11 Dividends Paid 12 Payout Ratio 13 RR 14 350.00 10.50 4.20 40.00% 60.00% 2011 70.00 16 Sales-Increase 17 %Increase 18 Sales M Profit Margin) 20 Net Income 21 Payout Ratio 22 Dividends Paid 23 RR 24 25 AFN-(AIS,S-LIS,S-MS,(RR) 28 | (L.IS S 29 MS, RR) 30 AFIN 13.44