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

Calculation of liquidity ratios current ratio and acid-test, Calculation of...

Calculation of Liquidity ratios Current Ratio and Acid-Test Ratio -               2008 2009 2010 A

#title.Current Issue in financial Accounting, 2 Individual Research Assignm...

2 Individual Research Assignment This assignment is an individual assessment. The research and written submission should therefore be your own work. You will need to submit this as

Types of gift by way of a will-executorship laws and account, TYPES OF GIFT...

TYPES OF GIFT BY WAY OF A WILL (a) A special (or specific) legacy is a testamentary gift of a particular part of the property of the testator, which identifies that part by a s

Kannan, ACC2200 Financial Accounting Assignment Trimester 2, 2013 DUE DATE...

ACC2200 Financial Accounting Assignment Trimester 2, 2013 DUE DATE: Monday, 9th September 2013 VALUE: 15% of OVERALL ASSESSMENT REQUIRED: (1) This research question consists of a

Money, if you inherited 45,000 today and invested all of it in a security t...

if you inherited 45,000 today and invested all of it in a security that paid a 7 percent rate of return how much would you have in 25 years

#1, #1. Quarter Corporation had the following transactions during the quart...

#1. Quarter Corporation had the following transactions during the quarter ended June 30, 2010: Loss from tsunami damage (extraordinary) $985,000 Payment of fire insurance premium f

What is inheritance in gross income, Q. What is Inheritance in Gross income...

Q. What is Inheritance in Gross income? Inheritance - As distinguished from a BEQUEST or devise, an inheritance is property attained through laws of descent and distribution fr

Trustees duties in administering the d of a, Trustee's duties in administer...

Trustee's duties in administering the D of A 1) To carry out the trusts of the D of A and to distribute the property assigned to him in accordance with the provisions of the D of

Acc 400, d. Prepare the summary journal entry required to transfer finished...

d. Prepare the summary journal entry required to transfer finished component kits from the Cutting Department to the Finishing Department in January. e. Compute the total cost assi

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