Data chose from Emerald Corp.: Additional Data: Please, pay attention to the cash expenses and non-cash expenses, and their implication when computing the Cash Budget: 1. The firm collects 60% of sales for cash same month, and 40% one month later based on history. 2. Interest Income of $250,000 on Marketable Securities investments will be received in December. 3. The firm will sell machinery for cash for $650,000 in October. 4. The firm will pay in cash for 75% of its purchases (same month) and 25% of its purchases in cash the following month. 5. Salaries and Wages amount to 20% of the preceding month's sales 6. Sales commissions paid amount to 10% of the preceding month's sales. 7. Lease Payments of $75,000 must be made each month. 8. A principal and interest payment on an Outstanding loan is due in November for $125,000 9. The firm will pay cash dividends of $200,000 at the end of December. 10. Fixed assets costing $100,000 in cash will be purchased in November. 11. Depreciation expense is expected to be $100,000 each month. 12. The firm has a beginning cash balance in October of $500,000. 13. The firm wishes to maintain a monthly cash balance of $500,000. Required: Prepare and Evaluate a Cash Budget for the Months of October, November, and December based on the information shown below, and determine if the firm would have a required financing (deficit) or excess cash balance (surplus) for each period. Then answer the questions. I. PREPARATION OF CASH BUDGET- DEVELOP IN ALL OF ITS PARTS-34 points SEPT. OCTOBER NOVEMBER DECEMBER II. Analyze the results obtained in the Cash Budget in a minimum of three sentences. What do the planned deficit or surplus results represent for each month? (3 points)