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

Corporate accounting system, 1. This assignment is to be submitted as an in...

1. This assignment is to be submitted as an individual assignment.  2. Marks will be deducted for poor quality presentation. For guidance on the requirements for the presentatio

Maximize revenues from sales, You are a manager at the DaimlerChrysler. Dai...

You are a manager at the DaimlerChrysler. Daimler-Chrysler has lost money on the Smart car since the first model rolled off the assembly line in 1998. By bringing its little car in

It''s been two months since you took a position, It’s been two months since...

It’s been two months since you took a position as an assistant financial analyst at Caledonia Products. Although your boss has been pleased with your work, he is still a bit hesita

T-account, Received 10,000 contribution from bill london in exchange for co...

Received 10,000 contribution from bill london in exchange for common stock What 2 accounts are used

Personal representatives duties-executorship law, Personal representatives ...

Personal representatives duties Personal representation has the following duties; 1) To provide and pay out of the estate of the deceased, the expenses of a reasonable funeral

Process of abc analysis - inventory control, Process of ABC Analysis •...

Process of ABC Analysis • Classification:   On the origin of expected use, the items of inventory are categorized according to their categories and per unit Price of each item

Application for grant-executorship laws and acccounts, APPLICATION FOR GRAN...

APPLICATION FOR GRANT 1) An application for a grant of representation ("representation" means the probate of a will or the grant of letters of administration) is made in such a

Calculate the annual percentage rate, Your mother-in-law is fretting about ...

Your mother-in-law is fretting about paying her mortgage. She refinanced her mortgage loan a while back, and now is thinking about refinancing again. You are going to help her eval

Profits in subsidiary company-group accounts, Profits in subsidiary company...

Profits in subsidiary company The remaining profits that belong to the holding company should be split between pre-acquisition profits and post acquisition profits. The pre

What is the monthly rate - annual rate, Suppose that the annual rate of int...

Suppose that the annual rate of interest is 4%. (a) What is the monthly rate? (b) Consider a 3-year lease on a car that is worth $20,000 today. The first payment on the lease

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