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

Receiver appointed by court-bankruptcy and liquidation, Receiver appointed ...

Receiver appointed by court If appointed by the court, the receiver must give security as directed by the court. The following notification must be given: (a) The debenture h

Illustration of pension funds, Normal 0 false false false ...

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Potential sources of finance for very new businesses, Potential sources of ...

Potential sources of finance for very new businesses Initial owner finance is almost always the first source of finance for a business, whether from the owner or from family co

What would be the balance in the paid-in capital, Horton Co. was organized ...

Horton Co. was organized on January 2, 2010, with 500,000 authorized shares of $10 par value common stock. During 2010, Horton had the following capital transactions: January 5-iss

concept of financial accounting, Concept of  financial Accounting Ac...

Concept of  financial Accounting Accounting is the art of recording, classifying and summarizing the business transactions and events. Double Entry System is the base for reco

How do you react to the investment banker?, You are the CFO of Diversi?ed I...

You are the CFO of Diversi?ed Industries. Diversi?ed has suffered through 4 or 5 tough years. This has deteriorated its ? financial condition to the point that Diversi?ed is in dan

Decisions about managerial remuneration packages, Q. Decisions about manage...

Q. Decisions about managerial remuneration packages? In recent years there has been an improved emphasis on decisions about managerial remuneration packages being removed from

What amount does eggers stand to lose, Q. Andy Eggers has invested $150,000...

Q. Andy Eggers has invested $150,000 in a privately held family corporation. The corporation does not do well and must declare bankruptcy. What amount does Eggers stand to lose? a.

Financial Management, QUESTION 4: Spanking Clean (Ltd) operate a number of...

QUESTION 4: Spanking Clean (Ltd) operate a number of car washes and auto valet services. The company has experienced a reasonable trading year. They are deciding whether to pay ou

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