R&L had the following bank recon on Nov 30 Balance per bank, Nov 30 1,350,000 Deposit in transit 500,000 Outstanding checks (600,000) Balance per book, Nov 30 1,250,000

The bank statement for the month of Dec showed the following Deposits, including P100,000 note collected for R&L 3,000,000 Disbursements, including P70,000 NSF customer check and P10,000 service charge 2,500,000

All reconciling items on Nov 30 cleared through the bank in Dec The outstanding checks totaled P600,000 and the deposit in transit amounted to P500,000 on Dec 31.

What is the adjusted cash in the bank on Dec 31?

What is the cash balance per book on Dec 31?

What is the amount of cash receipts per book in December?

What is the amount of cash disbursements per book in December?

(please do in excel)