Consider the following information for the month ending June 30,

Consider the following information for the month ending June 30, 2012, for the Johnson Company: 

The cash balance, May 31, 2012, is $15,000. Sales proceeds are collected as follows: 80 percent month of sale, 10 percent second month, 10 percent third month. 

Accounts receivable are $40,000 on May 31, 2012, consisting of $16,000 from April sales and $24,000 from May sales. 

Accounts payable on May 31, 2012, are $145,000. Johnson Company pays 25 percent of purchases during the month of purchase and the remainder during the following month. All operating expenses requiring cash are paid during the month of recognition. However, insurance and property taxes are paid annually in December. 

Johnson Company Budgeted Income Statement for the Month Ended June 30, 2012 (in thousands) 

$290 Sales $ 50 Inventory, May 31 Purchases 192 Available for sale 242 Inventory, June 30 Cost of goods sold Gross margi


Prepare a cash budget for June. Confine your analysis to the given data. Ignore income taxes and other possible items that might affect cash.



Cash Budget
A cash budget is an estimation of the cash flows for a business over a specific period of time. These cash inflows and outflows include revenues collected, expenses paid, and loans receipts and payment.  Its primary purpose is to provide the...

Members

  • Access to 2 Million+ Textbook solutions
  • Ask any question from 24/7 available
    Tutors
$9.99
VIEW SOLUTION

OR

Non-Members

Get help from Business Tutors
Ask questions directly from Qualified Online Business Tutors .
Best for online homework assistance.