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

What are the various strategies about bond, What are the various strategies...

What are the various strategies behind selected low (e.g., zero) or high coupon rates when issuing bonds?

What is permanent negotiating machinery, Q. What is Permanent Negotiating M...

Q. What is Permanent Negotiating Machinery? Two Federation of Union All Indian Railway men's federation (AIRF) & National Federation of Indian Railway (NFIR) men have been reco

Income statement, how should i treat items in the additional information

how should i treat items in the additional information

Assumption of the eoq model, The basic EOQ model is depends on the subseque...

The basic EOQ model is depends on the subsequent assumption: 1) The forecast usage or demand for a specified period, usually one year, is identified 2) The usage/demand is ev

What are the organization expenditures, Q. What are the Organization Expend...

Q. What are the Organization Expenditures? Organization Expenditures -Costs of organizing a business or trade or for profit activity before it begins active business. A taxpaye

Calculate the claim under insurance policy, Calculate the claim under insur...

Calculate the claim under insurance policy: 1) What do policy limits of 200/300/100 on an automobile insurance policy mean?Your automobile insurance policy contains policy lim

What is the present value index for each proposal, The net present value ha...

The net present value has been computed for Proposals A and B. proposal A proposal B invested amount 75000 125000 total present value of cash 84000 136250 net present value 9000 11

Formula of annuity, In common terms the present value of a regular annuity ...

In common terms the present value of a regular annuity may be shown as given below: PVNn = A/(1 + k) + A/(1 + k) 2 + ..................+ A/(1 + k) N = A (1/(1 + k) + 1/(

Normal values of accounting ratios, Comparison with Sector Averages Any...

Comparison with Sector Averages Any conclusion relating to the signs of overtrading needs to be put in the context of the normal values of accounting ratios indicated by the se

Modern techniques, what are five modern financialaccounting techniques

what are five modern financialaccounting techniques

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