(please answer in excel form) This data provides you with the following information for the coming months of January, February, and March.

Accounts receivable regularly settle their accounts as follows: * 85% pay in the month following sale (these accounts take advantage of a 5% discount) 10% pay in the 2nd month 3% pay in the 3rd month * The balance is written off as bad. October accounts were paid in full in December. Accounts payable are settled in the month following purchase. From 85% of suppliers, a disco of 5% is received. For the remaining 15%, no discount is received. Other operating expenses include an amount of $800 per month for depreciation as follows: Capital expenditure of $55,000 will be paid in February. Bank balance as at 31 December was $175,000. Required: Prepare a cash budget for January, February and March assuming: Hints: 1. Calculate collection from accounts receivable including any discount allowed. 2. Calculate payments to accounts payable including any discount received. 3. Calculate other cash income and expenditure. 4. Prepare cash budget