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

Income statement, depreciation in question is given more and in adjustment ...

depreciation in question is given more and in adjustment is less. What would be in the profit and loss account?

Group accounts, Group Accounts A company can have investments in other co...

Group Accounts A company can have investments in other companies in the form of: ordinary shares, preference shares and loan stock. The investment in ordinary shares leads to own

Disclaimer of leases-bankruptcy and liquidation, Disclaimer of leases I...

Disclaimer of leases In principle where the bankrupt is a lessee the lease cannot be disclaimed without leave of the court; but such leave is not required in the following case

Determine the price of an asset paying - one period bond , Suppose the inte...

Suppose the interest rate for a one-period bond is 4%. (a) What is the price of an asset paying (1,1,1) which means 1 after 1 period, 1 after 2 periods, and 1 after 3 periods.

Calculate the return on investments based on cash flow, This project allows...

This project allows you to think critically and apply decision-making management techniques. In this project,  you need to solve a bond portfolio problem, a diversified portfolio p

Conclusion on overtrading, Q. Conclusion on Overtrading? The majority o...

Q. Conclusion on Overtrading? The majority of the evidence suggests that our company is moving into an overtrading situation, although the evidence is not conclusive. Current p

Calculate the amount of profit or loss, On 1 January 2009, a company, Yeti,...

On 1 January 2009, a company, Yeti, granted an employee the right to choose between (i) 30,000 Yeti shares or (ii) a cash-payment equivalent to the price of 24,000 Yeti shares on 3

Student, Open "Hoyle CPA: Earnings Per Share." Under "Free Questions" selec...

Open "Hoyle CPA: Earnings Per Share." Under "Free Questions" select "Financial Accounting & Reporting."

Calculate return on assets, Select two of the following firms: Dole Foods,...

Select two of the following firms: Dole Foods, Campbell Soup, Hershey and Dr. Pepper Snapple. Use the 10-K, annual report and other information to answer the following questions.

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