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

Prepare the company''s closing entries for its revenues, Following are Nint...

Following are Nintendo's revenue and expense accounts for a recent calendar year. Net sales ¥2,008,622 Cost of sales 1,864,981 Advertising expense 118,908 Other expense, net 397

Compute basic and diluted earnings per share, The following information was...

The following information was taken from the books and records of Ludwick, Inc.: 1. Net income $ 280,000 2. Capital structure: a. Convertible 6% bonds. Each of the 300, $1,000 bond

Constructive trusts-trusts laws and accounts, CONSTRUCTIVE TRUSTS A con...

CONSTRUCTIVE TRUSTS A constructive trust is a trust imposed by equity regardless of the intention of the owner of the property: it arises by operation of law.  The concept has

Troubled debt restructuring, Troubled Debt Restructuring - Agreement betwee...

Troubled Debt Restructuring - Agreement between CREDITOR and DEBTOR which amends the terms of a DEBT which has little chance of being paid in accordance with its contractual terms.

Determine annual operating cash flow, A 4 year project has an initial asset...

A 4 year project has an initial asset investment of 306600, and initial net working capital investment of 29200, and an annual operating cash flow of -46720. The fixed asset is ful

consignment account, A of surat consigns goods to B of jaipur to be sold ...

A of surat consigns goods to B of jaipur to be sold at or above invoice price.B is entitled to get a commission of 8% on sales at invoice price plus 25% of any surplus price reali

Finance management, Establish a budget and allocate funds in accordance wit...

Establish a budget and allocate funds in accordance with statutory and organisational requirements

Advise the directors of the entity, An entity had the following transaction...

An entity had the following transactions during the year ended 31 December 2010: The entity invested in a convertible bond on its issue date. The bond matures four years aft

Flexibility in debt finance, Q. Flexibility in Debt finance? Debt finan...

Q. Flexibility in Debt finance? Debt finance is more elastic than equity in that various amounts can be borrowed at a fixed or floating interest rate and for a range of maturit

structural programming languages in industry today, Write  the advantages ...

Write  the advantages and drawbacks of both the structured and object-oriented (OO) paradigm in programming. Describe the perceived preference of OO languages over the more structu

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