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

Petition by creditor-bankruptcy, Petition by creditor Any creditor incl...

Petition by creditor Any creditor including an assignee of a debt, may petition, provided: The debt due to him amounts to at least Shs 1,000; The debt is certain and i

Describe what you understand by the term fund accounting, Question: (a)...

Question: (a) ‘Public accounting is often called fund accounting'. Describe what you understand by the term ‘fund accounting'. (b) "What's the difference between nation

Activity-based costing (abc), Activity-Based Costing (ABC) An accounti...

Activity-Based Costing (ABC) An accounting method that assigns identifiable costs and allocates common costs to definite product lines or business fragments Also known as pro

Calculate the present value, Compute the present value of Rs. 1000 receivab...

Compute the present value of Rs. 1000 receivable 6 years thus if the discount rate is 10 percent. Solution: The present value is computed as follows: PV kn = FV n . PVIF k,n

Expected net cash flows resulting from the digger, Sigma is thinking about ...

Sigma is thinking about purchasing a new clam digger for $14,000. The expected net cash flows resulting from the digger are $9,000 in year 1, $7,000 in year 2, $5,000 in year 3, an

Required: prepare journal entries for the above transactions, Sleek Ride, a...

Sleek Ride, a company providing limo services, has a December 31 year-end date. For Sleek Ride, the following transactions occurred during the ?rst 10 days of June: a. Purchased, o

Lease accounting, The following facts pertain to a noncancelable lease agre...

The following facts pertain to a noncancelable lease agreement between Lennox Leasing Company and Gill Company, a lessee. Inception date: May 1, 2012 Annual lease payment due at th

What are the organization expenditures, Q. What are the Organization Expend...

Q. What are the Organization Expenditures? Organization Expenditures -Costs of organizing a business or trade or for profit activity before it begins active business. A taxpaye

Define the term relevance - accounting information, Define the term Relevan...

Define the term Relevance - accounting information Accounting information should have the ability to influence decisions. Except this characteristic is present, there is ac

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