Procter & Gamble Co. needs to prepare a cash budget for the month of July 2026. The following information is available:

• Beginning Cash Balance: $200,000
• Expected Cash Collections:
  • Sales Revenue: $1,000,000
  • Accounts Receivable: $500,000
• Cash Payments:
  • Purchases: $600,000
  • Operating Expenses: $300,000
  • Salaries: $150,000
• Other Cash Payments: $100,000

Prepare a cash budget, calculate the ending cash balance, and identify any potential cash shortfalls or excess.