Prepare a cash budget, Financial Accounting

Assignment Help:

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


Related Discussions:- Prepare a cash budget

Inter-company transactions and balances, INTER-COMPANY TRANSACTIONS AND BAL...

INTER-COMPANY TRANSACTIONS AND BALANCES As the associate company is not consolidated, care should be taken when there are trading transactions and inter-company balances between

Capital budgeting, A project has a one-year life. It has an outlay of Rupee...

A project has a one-year life. It has an outlay of Rupee 1,500 million. At the end of Year 1, the net inflow is likely to be Rupee 2,200 million. The pretax cost of debt is 11%, th

What is the net present value of project, Red Lake Mines, Inc. is consideri...

Red Lake Mines, Inc. is considering adoption of a new project requiring a net investment of $10 million. The project is expected to generate 5 years of net cash inflows of $5 milli

Vegetable gowing, disscuss the applicability of a operating cycle in vegeta...

disscuss the applicability of a operating cycle in vegetable growing bussiness in uganda

Property in bankrupt''s reputed ownership, PROPERTY IN BANKRUPT'S REPUTED O...

PROPERTY IN BANKRUPT'S REPUTED OWNERSHIP The trustee may claim property owned by third parties which is in the bankrupt's possession at the commencement of the bankruptcy if:

Adjustment, A company does not need to record the receipt of a bill for uti...

A company does not need to record the receipt of a bill for utilities used during this year if they will not pay for it until next year. True or False

What is the minimal variance, Consider the expected return and standard dev...

Consider the expected return and standard deviation of the following two assets: Asset 1: E[r1]=0.1 und σ1=0.3 Asset 2: E[r2]=0.2 und σ2=0.4 (a) Draw (e.g. with Excel) the

Which statements is correct, In its first month in business, Jones, Inc. so...

In its first month in business, Jones, Inc. sold merchandise to customers on account for $119,800. It collected $72,000 on those sales during the first month and recorded Revenue f

Public debt, effects of public debt on production, d

effects of public debt on production, d

Illustration for preparing final accounts, Illustration for preparing final...

Illustration for preparing final accounts K Ltd established a branch in Arusha Tanzania on 1.1.X2, when Kshs 1 = TShs 15. PPE costing Kshs 800,000 were purchased on that day. I

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd