Prepare cash budget for the next six months

Assignment Help Cost Accounting
Reference no: EM132561115

New Vision Trading Company Ltd. is planning to arrange for a six monthly overdraft facility with a bank. However, before finalization of any arrangement it wants to know the estimated requirements of cash. For this purpose it has hired you as consultant to make an estimate of the foreseeable cash requirements.

The following is the basic data regarding various business cycles of the company:

1. Sales forecast for the six months are as under:

Months                Rs.

January           800,000

February          950,000

March            600,000

April               900,000

May                 1,100,000

June                 600,000

2. Purchases are made as and when required

3. No closing stock is maintained as the supplier has capability to supply any quantities at any time.

4. Gross profit ratio is maintained @ 20% of the sales price.

5. Various expenses for the six months are as under:

                                                 Rs.

Salaries and wages              390,000

Repair and maintenance        120,000

Insurance                             6,000

Stores and spares                270,000

Duties                                   360,000

Legal Charges                        24,000

6. Recoveries from the debtors are made as follows:

50% in the month of sale

30% in the month following the month of sale

20% in the second month after sales

7. Trade creditors are paid as under:

40% in the month of purchase

40% in the month following the month of purchase

20% in the second month after purchase

8. All other business expenses are paid in the month of expense. Expenses are evenly spread throughout the year.

9. The company commenced its business on 1.1.2000 with a cash balance of Rs.50,000.

Required:

Question 1: Prepare cash budget for the next six months

Reference no: EM132561115

Questions Cloud

How do you provide care for someone who is a criminal : Reviewing the Nursing as Caring Theory, we come to understand that humans are intrinsically motivated to care for others. Based on this theory.
How much of this loss can John deduct : In 2019, John is single and is the owner of a proprietorship with $650,000 of gross income and $975,000 of deductions, How much of this loss can John deduct
Instructional strategies applied to support learning : Discuss the definitions, characteristics, causes, identification and instructional strategies applied to support learning.
Despite its great potential to treat diseases : Despite its great potential to treat diseases, gene therapy still has many hurdles to overcome.
Prepare cash budget for the next six months : Prepare cash budget for the next six months. All other business expenses are paid in the month of expense. Expenses are evenly spread throughout the year.
What are the tax consequences to the shareholders : If the shareholders' average bases in their shares are $45 per share, what are the tax consequences to shareholders and the corporation from this distribution
What information should be included in the discussion : The nurse the nurse is reinforcing teaching regarding peptic ulcer disease health promotion and disease prevention
Describe the pathophysiology of crohn disease : Describe the pathophysiology of Crohn's disease. Describe the potential complications of an intestinal obstruction hat is not treated promptly.
Technological advances on medicine : 3D printed cast are being used to stabilize broken bones. But recently 3D printing has been used to design prosthetics

Reviews

Write a Review

Cost Accounting Questions & Answers

  Cost accounting assignment

Evaluate Method of measuring costs associated with production, budgeting process, normal job-order costing system , master budget, cycle time.

  Prepare the journal entries

Prepare the journal entries to record the bond issue and interest expense.

  Advise as to the liability of all the parties

Write a report on given case study and Advise as to the liability of ALL the parties both under common law and the Corporations Law.

  Prepare revenues budget

Prepare Revenues budget and Production budget in units

  Effect of exchange rate changes on cash and cash

Effect of exchange rate changes on cash and cash

  Corporate governance

You are to reflect on how this case of China Sky relates to what the arguments for and against allowing audit firm partners and/or employees to join audit committees.

  Cost-benefit analysis

A cost-benefit analysis of electronic medical records in primary care

  Non-annual interest rates and annuities

Theory of Interest- Non-annual interest rates and annuities

  Job costing in service organizations

How is job costing in service organizations different from job costing in manufacturing environments?

  Accounting for bad debt expense

Accounting for bad debt expense

  Accounting and partnership problems

Accounting and Partnership problems

  Development of relevant cash flows

Development of relevant cash flows - Cost estimating and financial analysis

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