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

Retained earnings for plant expansion, Foley Corporation has the following ...

Foley Corporation has the following capital structure at the beginning of the year: 6% Preferred stock, $50 par value, 20,000 shares authorized, 6,000 shares issued and outstanding

The adjusting entry, The company pays its employees at the end of the day F...

The company pays its employees at the end of the day Friday for work done during that five-day work-week. Total wages for a week are $16,000. In the current year, December 31 occur

Prepare an investment plan, Question: Mada Air Ltd is thinking of diver...

Question: Mada Air Ltd is thinking of diversifying its activities in order to cope with the financial crisis. After careful evaluation its research and development team has pro

Foreign currency translation, Foreign Currency Translation - Restating fore...

Foreign Currency Translation - Restating foreign currency in equivalent dollars; unrealized losses or gains are postponed and carried in Stockholder's Equity until foreign operatio

System one-the head office maintains all the accounts, SYSTEM ONE-THE HEAD ...

SYSTEM ONE-THE HEAD OFFICE MAINTAINS ALL THE ACCOUNTS This system is suitable for an enterprise that has small branches (possibly in another area of the town or city where the

Effect of disclaimer-bankruptcy and liquidation, Effect of disclaimer T...

Effect of disclaimer The trustee may disclaim onerous property consisting of: Land burdened with onerous covenants; Stocks and shares; Unprofitable contracts, or

Value of accounting information, Value of accounting information When a...

Value of accounting information When assessing value of accounting information we are confronted with similar problems. Provision of accounting information can be very expensiv

Project Assistance, How do you create an Excel document with several financ...

How do you create an Excel document with several financial statements, all linked together with specific financial data?

Compute gross income from sales, 1. Ben lost his job when his employer move...

1. Ben lost his job when his employer moved its plant. During the year, he collected unemployment benefits for three months, a total of $1,800. While he was waiting to hear from pr

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