Homework 2: Ch 4-5 0 Saved Save & Exit Submit Help Check my work 3 Also assume Graham's cash payments for November and December are $21,500 and $14,000, respectively. The beginning cash balance in November is $5,000, which is the desired minimum balance. a. Prepare a cash receipts schedule for November and December. 20 points Graham Potato Company Cash Receipts Schedule eBook October September November December 15,600 s 18,000S Hint Sales Credit sales 25,600 21,600 11,700 13,500 19,20 16.200 Print 6,400 s Cash sales 5,400 References One month after sale Two months after sale Total cash receipts 6,400 $ 5,400 Homework 2: Ch 4-5 A Save & Exit Saved Help Submit Check my work b. Prepare a cash budget with borrowing needed or repayments for November and December. (Negative amounts should be indicated by a minus sign. Assume the November beginning loan balance is $0.) 20 points Graham Potato Company Cash Budget eBook |November December Hint Total cash receipts Print Total cash payments References Net cash flow Beginning cash balance Cumulative cash balance Monthly borrowing (repayment) Ending cash balance Cumulative loan balance Homework 2: Ch 4-5 0 Saved Save & Exit Submit Help Check my work 3 Also assume Graham's cash payments for November and December are $21,500 and $14,000, respectively. The beginning cash balance in November is $5,000, which is the desired minimum balance. a. Prepare a cash receipts schedule for November and December. 20 points Graham Potato Company Cash Receipts Schedule eBook October September November December 15,600 s 18,000S Hint Sales Credit sales 25,600 21,600 11,700 13,500 19,20 16.200 Print 6,400 s Cash sales 5,400 References One month after sale Two months after sale Total cash receipts 6,400 $ 5,400 Homework 2: Ch 4-5 A Save & Exit Saved Help Submit Check my work b. Prepare a cash budget with borrowing needed or repayments for November and December. (Negative amounts should be indicated by a minus sign. Assume the November beginning loan balance is $0.) 20 points Graham Potato Company Cash Budget eBook |November December Hint Total cash receipts Print Total cash payments References Net cash flow Beginning cash balance Cumulative cash balance Monthly borrowing (repayment) Ending cash balance Cumulative loan balance