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

Illustrate individuals budget constraint, An individual is currently workin...

An individual is currently working 40 hours per week, earning $10 per hour.  He loses his job and successfully applies for unemployment insurance.  The insurance plan works as foll

Cost of capital calculation, Cost of capital calculation Cost of equit...

Cost of capital calculation Cost of equity (Ke) Using the dividend valuation model, Ke=D 1 /P 0 + g Pretentious that dividend growth over the last five years is a good

Example of capital recovery factor, Suppose you get a cash bonus of Rs.1, 0...

Suppose you get a cash bonus of Rs.1, 00,000 that you deposit in a bank that pays 10 % annual interest. How much can you withdraw yearly for a period of 10 years? Solution :

Calculated market capitalization, What have been the dividends per share? ...

What have been the dividends per share? What is the CAGR of dividends per share from 2008 to 2010? What was the retention ratio for 2008 to 2010? Calculate the DPS growth

Estimate a linear joint demand curve, Pinapple Inc. is deciding how to pric...

Pinapple Inc. is deciding how to price its two lines of laptops, one of which is a light one for travel (which is called Light) and the other is a powerful one (called Power). Thes

What is the pretax stock compensation, Refer to the Consolidated Statements...

Refer to the Consolidated Statements of Shareholders' Equity (pp. 62-63), Consolidated Statements of Cash Flow, including an abstract from Note 2, Cash Flow Information (pp. 61 and

Modern techniques, what are five modern financialaccounting techniques

what are five modern financialaccounting techniques

Prepare a cash budget, Question: The accountant of a company is prepari...

Question: The accountant of a company is preparing the cash budget for the first six months of 2011 and obtains the following information: Sales on credit, variable costs an

Revocation, Revocation, alteration and revival of a will 1. A will may ...

Revocation, alteration and revival of a will 1. A will may be revoked or altered by the maker of it at any time when he is competent to dispose of his free property by will.  (

Value of accounting information, Value of accounting information When a...

Value of accounting information When assessing value of accounting information we are confronted with similar problems. Provision of accounting information can be very expensiv

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