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

    Apr 18, 2012, 08:26 AM
    Cash budget example accounting
    1. On April 1, the start of the loan period, the cash balance is $26,000. Accounts Receivable on April 1 will total $151,500, of which, $141,000 will be collected durin April and $72,000 will be collected in May with the balance uncollectible.
    2. Past experience shows that 20% of a months sales are collected in the month of sale, 75% in the next month and 4% in the second month following the sale. The balance is considered uncollectible. Budgeted sales and expenses are:
    April May June
    Sales in Units sold for $10.00 20,000 30,000 25,000
    Sales 200,000 300,000 250,000
    Merchandise Purchases 120,000 180,000 150,000
    Payroll 9,000 9,000 8,000
    Lease Payments 15,000 15,000 15,000
    Advertising 70,000 80,000 60,000
    Equipment 8,000 0 0
    Depreciation 10,000 10,000 10,000

    3. Merchandise purchases are paid in full during the month following the purchase. Accounts Payable for merchandise on April 1, which will be paid in April is $108,000.

    4. In preparing the budget, assume the $30,000 will be made in April and repaid in June. Interest on the note is 16% and is paid at maturity date.
    JessM1's Avatar
    JessM1 Posts: 2, Reputation: 1
    New Member
     
    #2

    Apr 18, 2012, 08:31 AM
    Ask me desk
    1. On April 1, the start of the loan period, the cash balance is $26,000. Accounts Receivable on April 1 will total $151,500, of which, $141,000 will be collected durin April and $72,000 will be collected in May with the balance uncollectible.
    2. Past experience shows that 20% of a months sales are collected in the month of sale, 75% in the next month and 4% in the second month following the sale. The balance is considered uncollectible. Budgeted sales and expenses are:
    April May June
    Sales in Units sold for $10.00 20,000 30,000 25,000
    Sales 200,000 300,000 250,000
    Merchandise Purchases 120,000 180,000 150,000
    Payroll 9,000 9,000 8,000
    Lease Payments 15,000 15,000 15,000
    Advertising 70,000 80,000 60,000
    Equipment 8,000 0 0
    Depreciation 10,000 10,000 10,000

    3. Merchandise purchases are paid in full during the month following the purchase. Accounts Payable for merchandise on April 1, which will be paid in April is $108,000.

    4. In preparing the budget, assume the $30,000 will be made in April and repaid in June. Interest on the note is 16% and is paid at maturity date.
    Curlyben's Avatar
    Curlyben Posts: 18,514, Reputation: 1860
    BossMan
     
    #3

    Apr 18, 2012, 10:34 AM
    Please refer to this announcement

    We won't do your homework questions for you.
    You were given the assignment for you to learn.
    There are plenty of resources on the web for you to research this.

    If you come up with your own answer and post it for us to critique that is within reason.
    If you have some SPECIFIC questions that you couldn't find or didn't understand, we may help with that.
    But this is your assignment, show us you have at least attempted to complete it on your own.

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...

Prepare a Budgeted Income Statement, Cash Budget, Sales Budget/Cash Collections, Purc [ 1 Answers ]

The CEO of Kingston Cart Inc. asked the Chief Financial Officer to prepare a Master Budget for the next three months, beginning July 1, 2010. The company's policy is to maintain a minimum cash balance of $6,000 at each month end. Sales are forecasted at an average selling price of $70 per cart....

Accounting cash budget [ 1 Answers ]

Ok I'm not wanting someone to do my homework for me I just really don't understand this or how I am suppose to put the budget together. To me it seems like there isn't enough information. Ive been stuck on two problems for the past 4 hours. I have an online class so I can't really get much feed...

Preparing a cash budget example for accounting [ 1 Answers ]

How do you prepare a cash budget? I need to work out a problem in my accounting class and I don't know how to set up the problem? Can anyone help me? This is the question: Schafer Company expects to have a cash balance of 46,000 dollars on Jan. 1, 2007... These are the relevant monthly budget...


View more questions Search