4. (10 pts) The Amber Magic Shoppe has forecast its sales revenues and purchases for the last 5 months of 200x to be as follows: ? ?60% of sales are on credit. On the basis of past experience, 50% of the accounts receivable are collected the month after the sale and the remainder are collected 2 months after the sale. Purchases are paid 30 days after they are incurred. The firm had a cash balance of $5,000 as of September 30th, and its minimum required cash balance is $4,000. It had no beginning loan balance. Prepare a cash budget for October, November and December. This table gives you a fair start. Use Excel if you like and paste that table here (try to size it so it doesnt leap off the page) or attach your Excel files to the Finance Exam Assignment separately. August September October November December Cash (40%) Credit (60%) Collections Cash Sales Following Month Second Month Total Collections Cash Budget Collections Less Payments Cash Flow + Beginning Cash Balance Cumulative Cash Balance Loan (Repayment) Cumulative Loan Balance Ending Cash Balance