Use Excel Functions please

Chugging Along, Inc., is attempting to forecast its financial future and develop a financial plan. The firms most recent income statement and balance sheet have been constructed. Highly condensed versions are shown in the Tables. For simplicity, we are ignoring depreciation.

Chugging along, Inc. - Year 1 Condensed Income Statement
(in $000s)
Revenues	$100
Expenses	80
Net income	$ 20
Chugging Along, Inc. - Year 1 Condensed Balance Sheet
(in $000s)
Net working capital	$ 50
Fixed assets	150
Total Assets	$200
Long-term debt	$ 0
Equity	200
Total Debt and Equity	$200

The president of Chugging Along, Inc., is rather confident that revenues will grow by $10,000 per year. Expenses tend to run about 80 percent of revenues. It is, therefore, rather straightforward to construct a forecast of next years income statement:

Chugging Along, Inc. - Year 2 Forecasted Income Statement
(in $000s)
Revenues	$110
Expenses	88
Net income	$ 22

You have been asked to compile a forecast of the balance sheet for the end of the next year. You are told that net working capital will need to expand by $5,000, but that fixed assets will not need to expand because there is already excess capacity. You are also told that the firm desires to grow without taking on new debt and that any profits not needed to fund growth should be sent to the shareholders as a dividend. Begin by computing the statement of cash flows for Year 2 using the given format. (Hint: All variables are determined except the dividend amount, which must be set equal to the number that will sum to the change in net working capital.)

Chugging Along, Inc. - Year 2 Forecasted Statement of Cash Flows

Operating Activities
Net income	$__________
Depreciation	$ 0
Investing Activity
Fixed assets	___________
Financing Activities
Dividends	___________
Debt	___________
Change in Net Working Capital	___________