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

Net streams of payments, Swap - Financial contract in which 2 parties agree...

Swap - Financial contract in which 2 parties agree to exchange net streams of payments over a specified period. Payments are normally determined by applying different indices (for

Prepare the statement of cash flows, The comparative balance sheets for 201...

The comparative balance sheets for 2013 and 2012 are given below for Surmise Company. Net income for 2013 was $80 million. SURMISE COMPANY Comparative Balance Sheets December 31, 2

Determine pension expense for the year ended december 31, Part A: The follo...

Part A: The following information relates to Company A's defined benefit pension plan during the current fiscal year: Plan assets (beginning of the year) $400 (all number are in $m

Difference between npv and irr, Function to return the phase of a complex n...

Function to return the phase of a complex number 1. What is Annuity kind of cash flow? 2. What do understand by Portfolio risk? 3. What do you understand by 'Loan Am

Survivorship policy, SURVIVORSHIP POLICY The partners may take out a su...

SURVIVORSHIP POLICY The partners may take out a survivorship policy to safeguard against future cashflow problems incase a partner dies or the business is dissolved. E.g. incas

Describe the internal revenue code, Exclusions - Income item that is exclud...

Exclusions - Income item that is excluded from a taxpayer's gross income by INTERNAL REVENUE CODE or an administrative action. Common exclusions comprise gifts, inheritances and de

What factors in preview company''s control environment, WILL SOMEONE PLEASE...

WILL SOMEONE PLEASE ASSIST ME WITH THIS ASSISGNMENT Preview Company, a diversified manufacturer, has five divisions that operate throughout the United States and Mexico. Preview ha

Reserve requirement , 2(i). If all depositors tried to convert their deposi...

2(i). If all depositors tried to convert their deposits into cash at once, they would find that there are not sufficient reserves in the system to permit all of them to do this at

Define constant working capital, Q. Define Constant working capital? Th...

Q. Define Constant working capital? The supposition of constant working capital should be investigated. Net working capital is probable to increase in line with sales and so ad

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