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

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

Cashflows from investing activities-group accounts, Cashflows from investin...

Cashflows from investing activities Involving activities involve the acquisition and disposal of non-current assets such as; property, plant and equipment, intangible assets, a

Various types of accounting changes can affect the financial, Various types...

Various types of accounting changes can affect the financial statements of a business enterprise differently. Assume that the following list describes changes that have a material

Accounts relate to keenal real estate, Prepare a financial statement from a...

Prepare a financial statement from alphabetic listing of accounts: A number of accounts balances are listed below these accounts relate to Keenal Real Estate. During the year just

How much did additional paid in capital increase?, GHH, Inc. has two classe...

GHH, Inc. has two classes of stock authorized: $100,000 par preferred and $1.00 par value common. As the begining of 20C, 200 shares of preffered stock and 300,000 shares of common

Characteristics of accounting information?, According to the FASB, the usef...

According to the FASB, the usefulness of accounting is judged by which of the following two qualitative characteristics of accounting information? Comparability and neutrality Unde

Determine arbitrage-free rate of interest, The government of a country has ...

The government of a country has just issued a series of zero-coupon bonds maturing at the end of years 1, 2, 3 and 4. Suppose the spot rates (or continuously compounded yields per

What role does accounting play in the planning, What role does accounting p...

What role does accounting play in the planning, implementation, analysis of CSR in particular and organizational strategies in general?

Prepare a balance sheet and trial balance, Requirements: a.   Record the...

Requirements: a.   Record the following transactions in the journal of Howell Consulting. Explanations are not required. b.   Create T accounts for each transaction (Use the

FASB and IASB - Revenue recognition, Q1. what are the roles and objective o...

Q1. what are the roles and objective of FASB and IASB? Q2.what are the main reason for the joint project undertaken by the FASB and IASB? Q3.state some critics by individual and th

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