Question
Month Sales Cash disbursements February $500 $400 March 600 300 April 400 600 May 200 500 June 200 200 Jane McDonald, a financial analyst for
Month | Sales | Cash disbursements |
February | $500 | $400 |
March | 600 | 300 |
April | 400 | 600 |
May | 200 | 500 |
June | 200 | 200 |
Jane McDonald, a financial analyst for Carroll Company, has prepared the following sales and cash disbursement estimates for the period February-June of the current year.
McDonald notes that historically, 30% of sales have been for cash. Of credit sales, 70% are collected 1 month after sale, and the remaining 30% are collected 2 months after the sale. The firm wishes to maintain a minimum ending balance in its cash account of $25. Balances above this amount would be invested in short-term government securities (marketable securities), whereas any deficits would be financed through short-term bank borrowing (notes payable). The beginning cash balance at April 1 is $115. Prepare the cash budgets for April, May and June by filling in the blank areas below.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started