Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Finance & Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=411)
-   -   Cash budget example accounting (https://www.askmehelpdesk.com/showthread.php?t=652051)

  • Apr 18, 2012, 08:26 AM
    JessM1
    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.
  • Apr 18, 2012, 08:31 AM
    JessM1
    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.
  • Apr 18, 2012, 10:34 AM
    Curlyben
    Please refer to this announcement

    Quote:

    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.

  • All times are GMT -7. The time now is 11:52 AM.