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

    Oct 3, 2011, 12:54 PM
    Given the following information, prepare a cash budget:?
    Given the following information, prepare a cash budget:
    Month
    Sales
    Purchases
    Wages
    Production overheads
    Selling overheads
    Jan
    100000
    40000
    10000
    6000
    6000
    Feb
    120000
    45000
    15000
    6500
    6500
    March
    150000
    35000
    18000
    7000
    6600
    April
    160000
    30000
    20000
    7700
    6800
    May
    175000
    25000
    22000
    8000
    6200
    June
    200000
    20000
    24000
    8500
    6300
    The company has a policy of selling its goods at 50% cash and the balance on credit. On credit sales, 50% is paid in the following month and balance 50% two months from the sale. Purchases are paid one month from the month of purchase. Wages are paid in the following month and overheads are also paid in the following month. The company plans a capital expenditure, in the month of April, for Rs. 25,000.
    The company has a opening balance of cash of Rs. 40,000 on 1st Jan 2010. Prepare a cash budget for Jan to June.
    Curlyben's Avatar
    Curlyben Posts: 18,514, Reputation: 1860
    BossMan
     
    #2

    Oct 3, 2011, 12:56 PM
    Please refer to this announcement:
    Do not simply retype or paste a question from your book or study material

    We won't do your homework questions for you.
    You were given the assignment for you to learn.

    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, so show us you have at least attempted to complete it on your own.

    Thank you.

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!

Prepare a cash budget [ 2 Answers ]

Prepare a monthly cash budget for the next three months. You are presented with the following budget information: August September October Sales $630,000 $715,000 $845,000 ...

How to prepare a cash budget with an example? [ 1 Answers ]

Byron ltd estimated sales for the forthcoming months are: Nov:[email protected] Dec [email protected] Jan [email protected] Feb [email protected] Past experience has shown that colletions from sales average: 25%cash recevied in the month of the sales 55%in the month following tha sale 20%two months following tha...

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

How to prepare cash budget [ 2 Answers ]

Cash budget for April may June , July


View more questions Search