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

Example of equalancy the price ratio, Natasha's income is $300 per month. S...

Natasha's income is $300 per month. She spends all of it on tickets to concerts and films. A concert ticket costs $15 and a fi lm ticket costs $10. Her marginal rate of substitutio

Temporary-timing differences-financial statement , Temporary or Timing diff...

Temporary or Timing differences Temporary/timing differences relate to those items that are adjusted in the current period and are again adjusted in subsequent financial period

Premium coupons , premium coupons that already have been expired should be ...

premium coupons that already have been expired should be or shouldn''t be estimated as liability?

Analyse the main sources of finance , Consider a multinational listed compa...

Consider a multinational listed company that has recently carried out an acquisition. You may also select a company that carried out an acquisition long ago as long as there is inf

Writing a dissertation, I want to do a custom dissertation on IAS 40 invest...

I want to do a custom dissertation on IAS 40 investment property which needs to include a brief outline, positive as well as negative international critique with respect to the sta

Explain your findings and conclusion, When the stock market is going up ove...

When the stock market is going up over a long period of time, investors can become complacent about the risks of being a stockholder. After the significant decline of the stock mar

A realized gross profit, On December 15, 2011 Risby Sales Co. sold a track ...

On December 15, 2011 Risby Sales Co. sold a track of land that cost $3,600,000 for $4,500,000. Rigsby appropriately uses the installment sale method of accounting for this transact

What is reporting currency, 1. What accounting firm performed the audit of ...

1. What accounting firm performed the audit of Zetar's financial statement? 2. What is the address of the company's corporate headquarters? 3. What is the company's reporting

Computations, This is a comprehensive assessment of the material related to...

This is a comprehensive assessment of the material related to our first two class meetings.  You are NOT being tested on material related to capital budgeting (NPV, IRR, etc.). Tha

Prepare partial income statement through fifo and lifo , Prepare Partial In...

Prepare Partial Income Statement through FIFO, And LIFO Methods The records of XYZ Restaurant Supply include the following accounts for cases of coffee cups at December 31 of t

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