Ask Experts Questions for FREE Help !
Ask
    cheyluvmom's Avatar
    cheyluvmom Posts: 4, Reputation: 1
    New Member
    		  
    #1

    Nov 25, 2013, 07:37 PM
    Preparing cash budget help
    SABA Enterprises needs a cash budget for the month of June. The following information is available:
    A. The cash balance on June 1 is $4,000.
    B Sales for May and June are $50,000 and $40,000, respectively. Cash collections on sales are 40 percent in the month of sale and 50 percent in the month after the sale; 10 percent of sales are uncollectible.
    C. General expenses budgeted for June are $20,000 (depreciation represents $1,000 of this amount).
    D. Inventory purchases will total $40,000 in May and $30,000 in June. The company pays for half of its inventory purchases in the month of purchase and for the other half the month after purchase.
    E. The company will pay $5,000 in cash for office furniture in June. Sales commissions for June are budgeted at $6,000.
    F. The company maintains a minimum ending cash balance of $4,000 and can borrow from the bank in multiples of $100. All loans are repaid after 60 days.

    Prepare a cash budget for SABA Enterprises for the month of June. Enter all amounts positive numbers. If an amount is zero, enter "0".
    Fidget1's Avatar
    Fidget1 Posts: 105, Reputation: 4
    Junior Member
    		  
    #2

    Nov 30, 2013, 05:58 AM
    These are a gift in accountancy. If you really can't do it yourself, probably best give it up now.
    pready's Avatar
    pready Posts: 3,197, Reputation: 207
    Ultra Member
    		  
    #3

    Nov 30, 2013, 09:51 AM
    Start with a sales budget, then a cash collections schedule, then a purchases budget, then a cash disbursements schedule, and finally the Cash budget.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Preparing a cash collections and cash budget - I need advice - thank you! [ 0 Answers ]

I am having difficulty figuring this out. Any help would be appreciated to answer the 3 requirements. I am not certain how to set up these budgets. Thank you. Problem 4-3: You will be required to prepare a December cash budget. You are provided with the following information: a] Cash...

Preparing a cash budget [ 1 Answers ]

The Sharpe Corporation: Detailed cash flow budget for the first seven months of 2004 The Sharpe Corporation's projected sales for the first eight months of 2004 are as follows: January $90,000 February 120,000 March 135,000 April ...

Preparing a Cash Budget [ 3 Answers ]

I have a question about preparing a cash budget. Here's the question: January February March Cash receipts $98,000 $108,000 $124,000 Cash payments: For...

View more questions Search