Prepare a cash budget, Financial Accounting

Prepare a cash budget

The following information appeared on the balance sheet of XYZ Ltd at 30 June 2012:

                             Accounts receivable                                         80 000

                            Bank overdraft                                                 12 000

                            Accounts payable                                              100 000

                            Provision for income tax (payable in July)            10 000

                            Provision for dividends (payable in August)          20 000

                            Prepaid rent                                                       2 000

 

Estimated sales and purchases figures for July and August are as follows:

                                                   July                                     August

                            Sales               200 000                              150 000

                            Purchases        124 000                                96 000

 

Cash sales usually represent 50% of total sales, with 25% of credit sales collected in the same month as the sale, and the remainder in the following month.  Bad debts are so small that they can be ignored.

The company purchases inventory on credit, with all payments made in the month after purchase.

Other information:

  1. A new shareholder has been invited to join the company and will make a capital contribution of $50 000 in July.
  2. The company is planning to pay cash for new equipment costing $45 000 on 31 August. Depreciation expense is $1 000 per month until that purchase.
  3. The company rents its premises. The annual rental payment, due at the end of August, has not changed for a number of years.
  4. The only other expenses of XYZ Ltd, apart from the ones already noted, are freight and salaries. These expenses are paid as incurred. Freight is a variable expense, being 5% of sales for the month. Salaries are fixed at $6 000 per month.

Required

Prepare a cash budget for the months of July and August 2012 (you are not required to show a total column for the two month period).

Posted Date: 2/16/2013 5:01:36 AM | Location : United States







Related Discussions:- Prepare a cash budget, Assignment Help, Ask Question on Prepare a cash budget, Get Answer, Expert's Help, Prepare a cash budget Discussions

Write discussion on Prepare a cash budget
Your posts are moderated
Related Questions
Calculate the NPV and ARR The manager of XYZ Ltd has identified a market for a new product that she estimates can be sold for $12 per unit. Research indicates that the busines

Cherry Ltd has the following segment information from the consolidated financial statements for the years ended 31 December 2011 and 2012: Operating segments C V I N$ N$ N$ Sales

Q. Explain Final Location Survey? A final Location Survey is under taken on the completion of traffic survey to select the final rout of the line to be constructed, taking into

1.) Assume a $1000 face value bond has a coupon rate of 8.5 percent, pays interest semi-annually, and has an eight-year life. If investors are willing to accept a 10.25 percent rat

QUESTION 1: The Alpha Company Ltd was registered with Nominal Capital of 60,000 Equity shares of Rs.10 each. The following were the ledger balances on 31st March 2011.

Joe Shareholder owns 100 shares of Peach Company stock which is currently selling for $100 per share. Peach declares a 2-1 stock split. How much are Joe's shares worth after the st

Discuss the advantages and disadvantages of different types of financing: 1. Issuing bonds 2. Borrowing from Bank 3. Equity financing

Q. Define about financial gearing? As financial gearing raise the burden of interest payments increases and earnings become more volatile. Since interest payments should be met

Ocean Atlantic Co. is a merchandising business. the account balances for Ocean Atlantic co. as of July 1, 2012 (unless otherwise indicated), are as follows: 110 Cash 63,600 1

Natural Furniture Company manufactures three outdoor products, benches, chairs, and tables. Every product must pass by the following departments before it is shipped: sanding, sawi