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

Construct the market value balance sheet, Construct the Market Value Balanc...

Construct the Market Value Balance Sheet XYZ, Inc., another company founded by Larry Davidson in 2005, is currently entirely equity financed. That means the company carries no

Department accounting, In the spring of each year, Steinbrook College's the...

In the spring of each year, Steinbrook College's theater department puts on a contemporary play. Before the performance, the theater manager instructs student volunteers in their d

Temporary-timing differences-financial statement , Temporary or Timing diff...

Temporary or Timing differences Temporary/timing differences relate to those items that are adjusted in the current period and are again adjusted in subsequent financial period

TRADE AND PROFIT AND LOSS ACCOUNT, The following figures are taking from th...

The following figures are taking from the book of Sheen Compnay limited as on december 31,2009 DEBIT SIDE : opening stock Rs 75000 purchases 245000 wages 30000 c

Accounting policies-financial statement, Accounting policies Accounting...

Accounting policies Accounting policies are the specific assumptions, bases, principles and practices that are adopted by firms in preparing financial statements. The standard

Which product should harper tell its sales personnel, Harper Co. provided t...

Harper Co. provided the following information concerning two products: contribution margin per unit- product 12 $46 Contribution margin per unit-product 43 $30. Machine hours requi

Market risk premium , A company presently pays a dividend of $2 per share, ...

A company presently pays a dividend of $2 per share, D0 = 2. It is estimated that the company's dividend will enhance at a rate of 17% percent per year for the next 2 years, then t

Prepare the profit and loss account and balance sheet, MarmadukeMuffett onc...

MarmadukeMuffett once had a girlfriend who ran an antiques business in London'sKings Road. Ever since then, he has been hooked on the furniture trade and now runsMarmaduke'sMarvell

Illustration of head office records-branches, Illustration of Head office r...

Illustration of Head office records In order to provide a check that branch managers and staff deal properly with goods and cash passing through their hands, goods are normally

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