Please see attachment andanswer in excel format. Thank you.

1. During the coming year, Gold & Gold wants to increase its free cash flow by $180 million, which should result in a higher EVA and stock price. The CFO has made these projections for the upcoming year: EBIT is projected to equal $850 million. Gross capital expenditures are expected to total to $360 million versus depreciation of $120 million, so its net capital expenditures should total $240 million. The tax rate is 40%. There will be no changes in cash or marketable securities, nor will there be any changes in notes payable or accruals. What increase in net working capital (in millions of dollars) would enable the firm to meet its target increase in FCF? 2. Humphrey's Housing has been practicing cash management for some time by using the Baumol model for determining cash balances. Some time ago, the model called for an average balance (C*/2) of $500; at that time, the rate on marketable securities was 4 percent. A rapid increase in interest rates has driven the interest rate up to 9.5 percent. What is the appropriate average cash balance now