Prepare a cash budget, Financial Accounting

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.


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).

Posted Date: 2/16/2013 5:01:36 AM | Location : United States

Related Discussions:- Prepare a cash budget, Assignment Help, Ask Question on Prepare a cash budget, Get Answer, Expert's Help, Prepare a cash budget Discussions

Write discussion on Prepare a cash budget
Your posts are moderated
Related Questions
FINAL ACCOUNTS As pension funds are set up for a specific purpose, and not for trading, we do not prepare the normal trading profit and loss account or the balance sheet. The p

The opening entries 1. Assets of the estate or trust In both cases the various assets of the estate or trust are debited to appropriate accounts and credited to the Estate Ca

Suppose the interest rate for a one-period bond is 4% between the current period and the next. Then the rate becomes 5% for ever. (a) What is the price of an asset paying (1,1,1

I have one assignment of this course (diploma Financial Planning), can you help me in doing my assignment

How do you create an Excel document with several financial statements, all linked together with specific financial data?

On November 1, 2011, Leetch Ltd. borrows $400,000 cash from a bank by signing a five-year installment note bearing 8% interest. The note needs equal total payments every year on Oc

How to prepare a bond amortization sheet

On May 15, 2010, Your Corporation acquired an airplane (5 year recovery period, 6 year class life) for $1,450,000. Its qualified business use is 54%. Determine the maximum cost rec

Profit for the period The profit for the period has been arrived at after charging the following expenses: Normal 0 false false false EN-US X-NONE

A Treasury bond that matures in 10 years has a yield of 3%. A 10-year corporate bond has a yield of 9%. Suppose that the liquidity premium on the corporate bond is 0.8%. What is th