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

Determine the evidence on the usefulness of accounting, Evidence on the use...

Evidence on the usefulness of accounting There are convincing evidence and arguments that accounting information is at least perceived as being useful to users. Various researc

Communication and leadership, hi could you please help me in my assignment ...

hi could you please help me in my assignment i need it by 11/1/2017

Liberal credit standards, In order to enhance sales from their present annu...

In order to enhance sales from their present annual $35 million, ABC Company, a retailer, is considering more liberal credit standards. Presently, the firm has an average collectio

Dividend, Between 1986 and 2000 Textron dividend changes were described by ...

Between 1986 and 2000 Textron dividend changes were described by the following equation: DIVt " DIVt"1 ! .36(.26 EPSt " DIVt"1) What do you think were (a) Textron’s target payout r

What is the number of shares, Terry Corporation had 300,000 shares of commo...

Terry Corporation had 300,000 shares of common stock outstanding at December 31, 2010. In addition, it had 90,000 stock options outstanding, which had been granted to certain execu

Case study, Q. If a corporation declares a 10% stock dividend on its common...

Q. If a corporation declares a 10% stock dividend on its common stock, the account to be debited on the date of declaration is a. Common Stock Dividends Distributable. b. Common St

Principles of banking and finance, Q. Principles of banking and finance? ...

Q. Principles of banking and finance? An introduction to the principles of banking and finance. It covers a broad variety of topics using an economic perspective and aims to gi

What are the ethical issues involved, Charlie Brown, controller for the Kel...

Charlie Brown, controller for the Kelly Corporation, is preparing the company's income statement at year-end. He notes that the company lost a considerable sum on the sale of some

What do you mean by reasonable assurance, Q. What do you mean by Reasonable...

Q. What do you mean by Reasonable Assurance? Reasonable Assurance - Management's assessment of effectiveness of internal control over financial reporting is expressed at the le

Resolution for voluntary winding up-liquidation of companies, Resolution Fo...

Resolution For Voluntary Winding Up A company may be put into voluntary liquidation: 1) By ordinary resolution: where any period fixed for the duration of the company has ex

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