can you please prepare the cash budget and please show the workings for the beginning cash balance . I know the beginning cash balance for october is 10300 , how do you calculate for the other months ?

Carol is a true accountant: she not only likes knowing where every dollar is going, she is obsessed with it. So she is happy to take on the cash budget for this small company. She wants to go back through the fourth-quarter plan with a fine-toothed comb before working on the following calendar year's cash budget. After reviewing many notes from the management team, she has the following information. Addition information: - Line of credit withdrawals must be made on the first of the month in $1,000 increments. - Line of credit payments must be made on the last day of the month in $1,000 increments. - Credit line balance, September 30,$2,000. - Annual loan interest rate, 6%, with monthly interest payments required. - Minimum monthly cash account balance, $10,000. - Cash balance, September 30,$10,300