P6.5 (LO 1, 2, 3, 4), AN Excel Arjun has been responsible for putting together his company's cash budget for the past three years. Initially, it was a frustrating task, as he had to dig into the underlying budgets and transactions to identify their effect on cash. But now he has mastered it. Consequently, his supervisor gives him a more challenging task: filling in a partially completed cash budget for the final quarter of the year, as follows. Additional information: - Loan withdrawals or repayments must be made in $1,000 increments. - Any loan withdrawal is considered outstanding on the first day of the month in which it is drawn. - Any loan payment is considered made on the last day of the month in which it is paid. Required a. Help Arjun by filling in the missing components of the cash budget. b. Identify the source documents and policies that would inform each component (row) of the cash budget. c. What is the company's minimum cash balance requirement? Provide evidence for your answer. d. What trend do you see in the cash receipts during this quarter? What could be the underlying reason(s) for that trend? e. What trend do you see in the cash payments for DM purchases this quarter? What could be the underlying reason(s) for that trend? Are your reasons for the DM purchases trend compatible with your reasons for the cash receipts trend in part (d)? Explain. P6.5 (LO 1, 2, 3, 4), AN Excel Arjun has been responsible for putting together his company's cash budget for the past three years. Initially, it was a frustrating task, as he had to dig into the underlying budgets and transactions to identify their effect on cash. But now he has mastered it. Consequently, his supervisor gives him a more challenging task: filling in a partially completed cash budget for the final quarter of the year, as follows. Additional information: - Loan withdrawals or repayments must be made in $1,000 increments. - Any loan withdrawal is considered outstanding on the first day of the month in which it is drawn. - Any loan payment is considered made on the last day of the month in which it is paid. Required a. Help Arjun by filling in the missing components of the cash budget. b. Identify the source documents and policies that would inform each component (row) of the cash budget. c. What is the company's minimum cash balance requirement? Provide evidence for your answer. d. What trend do you see in the cash receipts during this quarter? What could be the underlying reason(s) for that trend? e. What trend do you see in the cash payments for DM purchases this quarter? What could be the underlying reason(s) for that trend? Are your reasons for the DM purchases trend compatible with your reasons for the cash receipts trend in part (d)? Explain