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 is process synchronization, Consider an MBA program as a processing ne...

Consider an MBA program as a processing network where the flow unit consists of a student in the program.  Suppose the organizations that hire and promote MBAs are considered to be

Financial decision making, how do i write an assignment about financial dec...

how do i write an assignment about financial decision making

Powerpoint presentation, I have a presentation on an article (around 20 pag...

I have a presentation on an article (around 20 pages). I also need 2 current real life examples (2 companies) to support the presentation. Can you do that? How long it will take yo

Accounts, the salaries paid in 2004 is rs. 500000 salaries outstanding is r...

the salaries paid in 2004 is rs. 500000 salaries outstanding is rs.20000 salaries paid in advance for 2004 is rs 30000 what is the actual salary expenditure for 2004?

Investment, compute the arithmetic mean rate of return and standard deviati...

compute the arithmetic mean rate of return and standard deviation of rates of return for the two series

What is bequest, Q. What is Bequest? Bequest - A gift by will of person...

Q. What is Bequest? Bequest - A gift by will of personal property. If bequest is money to the extent it's paid out ofincome from property it is taxable to the recipient. Normal

How many shares remain after the repurchase, 3:Barnes Baskets, Inc. (BB) cu...

3:Barnes Baskets, Inc. (BB) currently has zero debt. Its earnings before interest and taxes (EBIT) are $100,000, and it is a zero growth company. BB's current cost of equity is

Prepare consolidated financial statements, Chambers plc imports household e...

Chambers plc imports household equipment from Germany. On 1 July 2011, the company acquired 60% of the ordinary shares of Court Ltd, which owns a chain of retail shops selling hous

Prepare the contract account, During its financial year ended 30 June 20x7 ...

During its financial year ended 30 June 20x7 Beavers Ltd, an engineering company, has worked on several contracts. Information relating to one of them is given below.

Inter company balances-group accounts, Inter Company balances One of th...

Inter Company balances One of the companies may appear as receivable (debtor) or payable (creditor) in the other company’s books. Just like in accounting four branches, such in

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