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

Calculate the cash flow-agency costs, Tom Scott is the owner, president, an...

Tom Scott is the owner, president, and primary salesperson for Scott Manufacturing. Because of this, the company's profits are driven by the amount of work Tom does. If he works 40

RETAINED PROFITS BROUGHT FORWARD-group accounts, RETAINED PROFITS BROUGHT F...

RETAINED PROFITS BROUGHT FORWARD If we recall from the consolidated balance sheet, the group-retained profits should be made up of the holding companies retained profit plus the

Stock rights, Stock Rights - Stock rights are rights issued to stockholders...

Stock Rights - Stock rights are rights issued to stockholders of a CORPORATION which entitle them to purchase new shares of stock in the corporation for a stated price that is freq

Calculate interest rate , As a borrower, which of the following two 30 year...

As a borrower, which of the following two 30 year, monthly payment loans would you choose (and why) if you had a 10 year expected payment horizon: 5% interest rate with 3.5 points,

Promissory note - evidence of a debt, Promissory Note - Evidence of a DEBT ...

Promissory Note - Evidence of a DEBT with specific amount due and interest rate. Note may specify a maturity date or it may be payable on demand. Promissory note may or may not acc

What do you mean by re - organization, Q. What do you mean by Re - organiza...

Q. What do you mean by Re - organization? Reorganization - This is a change in businesses capital arrangements. If for a CORPORATION there are 7 statutory options for reorganiz

What is basic defination of fca, Q. What is basic defination of FCA? Ye...

Q. What is basic defination of FCA? Yes. FCA is a method of accounting for all financial costs of funds used or committed for municipal solid waste (MSW) services. FCA suggests

Stockholders equity changed, On May 1, 2010, Ziek Corp. declared and issued...

On May 1, 2010, Ziek Corp. declared and issued a 10% common stock dividend. Prior to this dividend, Ziek had 100,000 shares of $1 par value common stock issued and outstanding. The

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