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

Periodic inventory system, Analyse the limitations of using a periodic inve...

Analyse the limitations of using a periodic inventory system and provide examples to support your view. essay type

Straight-line depreciation, Straight-Line Depreciation - ACCOUNTING method ...

Straight-Line Depreciation - ACCOUNTING method which reflects an equal amount of wear and tear during every period of an ASSET'S useful life. For example annual STRAIGHT-LINE DEPRE

The accounting equation., Indicate how each of the following transactions a...

Indicate how each of the following transactions affects the accounting equation. a.Purchase of supplies on account. b.Payment of wages. c.Cash sale of goods for more than their cos

Looking for income statement and balance sheet, Looking for Income Statemen...

Looking for Income Statement and Balance Sheet for the Better USA, Inc. company for 2010 and 2011 Facts: Sales 11,573 (2010) and 12,936 (2011) - Depreciation 1,661 and 1,736 - Cost

What is depreciation reserve fund, Q. What is Depreciation Reserve Fund ? ...

Q. What is Depreciation Reserve Fund ? Depreciation Reserve Fund is the fund specially reserved for replacement of assets. Once the assets are purchased from the capital money

Order point formula, Order Point Formula The analysis discussed above t...

Order Point Formula The analysis discussed above tends to be somewhat cumbersome when probability distributions are most complex and dependent and multi-period cases are involv

Scarce - difficult and easy analysis, SED Analysis SDE i.e. Scarce, Dif...

SED Analysis SDE i.e. Scarce, Difficult and Easy analysis estimates the significance of inventory items on the basis of their availability. According to SDE analysis the invent

Prepare a post-closing trial balance, As a recently hired accountant for a ...

As a recently hired accountant for a small business, Bearing, Inc., you are provided with last year's balance sheet, income statement, and post-closing trial balance to familiarize

Default risk premium on the corporate bond, a) A Treasury bond that matures...

a) A Treasury bond that matures in 10 years has a yield of 6%. A 10-year corporate bond has a yield of 8%. Suppose that the liquidity premium on the corporate bond is 0.4%. What is

Legal practice, Trust - Ancient legal practice where one person (GRANTOR) ...

Trust - Ancient legal practice where one person (GRANTOR) transfers the legal title to an ASSET, known as principal or corpus, to another person (the TRUSTEE), with specific instr

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