Jayden's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mrs. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Of the firm's sales, 50 percent are for cash and the remaining 50 percent are on credit. Of credit sales, 35 percent are paid in the month after sale and 65 percent are paid in the second month after the sale. Materials cost 30 percent of sales and are purchased and received each month in an amount sufficient to cover the following month's expected sales. Materials are paid for in the month after they are received. Labor expense is 40 percent of sales and is paid for in the month of sales. Selling and administrative expense is 15 percent of sales and is paid in the month of sales. Overhead expense is $30,500 in cash per month. Depreciation expense is $10,500 per month. Taxes of $8,500 will be paid in January, and dividends of $4,500 will be paid in March. Cash at the beginning of January is $90,000, and the minimum desired cash balance is $85,000. a. Prepare a schedule of monthly cash receipts for January, February, and March. c. Prepare a monthly cash budget with borrowings and repayments for January, February, and March. Note: Negative amounts should be indicated by a minus sign. Assume the January beginning loan balance is $0. Leave no cells blank be certain to enter 0 wherever required. Conn Man's Shops, a national clothing chain, had sales of $440 million last year. The business has a steady net profit margin of 8 percent and a dividend payout ratio of 25 percent. The balance sheet for the end of last year is shown. The firm's marketing staff has told the president that in the coming year there will be a large increase in the demand for overcoats and wool slacks. A sales increase of 10 percent is forecast for the company. All balance sheet items are expected to maintain the same percent-of-sales relationships as last year, except for common stock and retained earnings. No change is scheduled in the number of common stock shares outstanding, and retained earnings will change as dictated by the profits and dividend policy of the firm. (Remember, the net profit margin is 8 percent.) *This includes fixed assets, since the firm is at full capacity. a. Will external financing be required for the company during the coming year? No Yes b. What would be the need for external financing if the net profit margin went up to 9.50 percent and the dividend payout ratio was increased to 65 percent? Note: Negative amount should be indicated by a minus sign. Do not round intermediate calculations. Enter your answer in dollars, not millions, (e.g., $1,234,567 ). Input your answer as positive a value