Honest Joe has a dairy and wants to expand and needs a bank loan to do this. The bank requires that he submit an acceptable three- month cash budget for January through March. Honest Joe has prepared the cash receipts and cash payments for the three months are given below. Cash at the beginning of January is $106.000, and the minimum desired cash balance is $101,000. Prepare a schedule of monthly cash budget with borrowings and repayments for January February and March (40 marks) January February March 486,800 518.400 563,600 Total cash receipts 493,800 518,200 537,000 Total cash payments A A-1 A-2 A-3 B-1 B-2 B-3 C-1 C+2 C-3 B D D-1 D-2 D-3 E E-1 E-2 E-3 F F-1 F-2 F-3 While answering in the response space below pls type the number of the box/cell (eg. A and A-1) and than write the answer which comes in that box/cell. Negative numbers should be in bracket Pls do it in a column (vertically in one line from top to bottom) so its not garbled and in sequence. Follow the sample below (first one is done for you) A: Net Cash Flows A-1 Honest Joe has a dairy and wants to expand and needs a bank loan to do this. The bank requires that he submit an acceptable three- month cash budget for January through March. Honest Joe has prepared the cash receipts and cash payments for the three months are given below. Cash at the beginning of January is $106.000, and the minimum desired cash balance is $101,000. Prepare a schedule of monthly cash budget with borrowings and repayments for January February and March (40 marks) January February March 486,800 518.400 563,600 Total cash receipts 493,800 518,200 537,000 Total cash payments A A-1 A-2 A-3 B-1 B-2 B-3 C-1 C+2 C-3 B D D-1 D-2 D-3 E E-1 E-2 E-3 F F-1 F-2 F-3 While answering in the response space below pls type the number of the box/cell (eg. A and A-1) and than write the answer which comes in that box/cell. Negative numbers should be in bracket Pls do it in a column (vertically in one line from top to bottom) so its not garbled and in sequence. Follow the sample below (first one is done for you) A: Net Cash Flows A-1