For the purposes of the schedule for receiving and paying loans and interest, the following additional data is required: Estimated cash balance at the end of December 2020 IDR 1,000,000 Cash iron inventory is set at Rp. 500,000,- The loan from bank X is received at the beginning of the month and interest payments are made at the end of the month. Repayment of debts is made at the beginning of the month. Bank interest is set at 2% per month. The next step is to determine the amount of credit that will be requested for the months of January and February. The deficit in January is Rp. 4,000,000.- Cash iron inventory is set at Rp. 500,000. At the beginning of January, Rp. 1,000,000 cash is available. 2% credit interest must be paid at the end of the month. Then the amount of credit that will be requested is: 4,000,000 + 500,000 -1,000,000 + 2/100X = X X 3,571,428,571,- So if we borrow from the bank for IDR 3,571,428,571, then at the end of January the cash balance is equal to the iron stock. In this example, for example, the amount of credit requested from bank X for the month of January is Rp. 3,600,000 and for the month of February, Rp. 3,300,000. Part of the repayment of the credit will be made at the beginning of April in the amount of Rp. 2,000,000, and the remaining Rp. 4,900,000, - paid at the beginning of May. Then make the schedule cash budget. PT AA prepares estimates of cash receipts and disbursements for the first 6 months of 2021 as follows: a. Estimated Acceptance Month Sales AR Other Revenue January 4.000.000 4.000.000 2.000.000 February 5.000.000 5.000.000 2.000.000 March 7.300.000 6.500.000 2.300.000 April 9.600.000 7.600.000 1.300 000 May June 8,000,000 6.600.000 1.400.000 9,000,000 6.700.000 1.340,000 b. The estimated expenses are as follows: Month Purchase Raw Labor Sales Expenses Administrative Material January 6.000.000 2.500.000 2.000.000 3.500.000 February 6.000.000 2.500.000 3.000.000 3.500.000 March 5.000.000 2.000.000 2.000.000 4.000.000 April 5.500.000 2.500.000 2.000.000 4.000.000 May 6.000.000 2.500.000 2.500.000 4000.000 June 6.000.000 3.000.000 2.300.000 4.200.000 c. Payment of income tax in March is IDR 1,000,000 Requested: From the data above, prepare a cash budget for the company. Solution: 1. Created an operating transaction at PT AA PT AA's 2021 first semester cash receipts and disbursements budget (in thousands of Rp) Description Jan Feb Mar April May June Estimation income Cash Sales 4,000 5.000 7.300 9.600 8.000 9,000 AR Collection 4.000 5.000 6.500 7.600 6.500 6.700 Other 2.000 2.000 2.200 1.800 1.400 1.240 Total 10.000 12.000 16.000 19,000 16.000 16.940 Estimation Expenditures - Purchase Raw Material 6.000 6.000 5.000 5.500 6.000 6.000 Labour 2.500 2.500 2.000 2.500 2500 3.000 Sales Exp 2.000 3.000 2.000 2.000 2.500 2.300 Adm Exp 3,500 3.500 4.000 4.000 4.000 4.200 Tax 0 1.000 0 0 Total 14.000 15.000 14.000 14.000 15.000 15.500 Surplus (defisit) (4.000) (3.000) 2.000 5.000 1.000 1.400