Question: please answer this question fast vary fast please please. From the following information given below, prepare a cash budget of MS Ram Ltd for the
please answer this question fast vary fast please please.


From the following information given below, prepare a cash budget of MS Ram Ltd for the first half of 2013, assuming that cost would remain unchanged: Sales are both on credit and for cash, the latter being 1/3 of the former. Realization from debtors is 25% in the month of sale. 60% in the month of following that and the balance in the month after. The company adopts a uniform pricing policy of the selling price being 25% over cost. Budgeted sales for each month are purchased and paid for in the preceding month. The company has outstanding debentures of Rs.200,000 on 1st Jan which carry interest at 15% per annum payable on the last date of each quarter on a calendar year basis. 20% of the debentures are due to redemption on 30 June 2013. Th company has to pay the last instalment of advanced tax, for the assessment year 2013- 2014, amounting to Rs.54000. Anticipated office costs for the six months are: Jan Feb Mar 25,000.00 20,000.00 40,000.00 Apr May Jun 35,000.00 30,000.00 45,000.00 The opening cash balance of Rs. 10,000 is the minimum cash balance to be maintained. Deficits have to be met by borrowers in multiples of Rs. 10,000 on which interest, on monthly basis, has to be paid on the first date of the subsequent month, at 12% p.a. calendar year basis. 20% of the debentures are due to redemption on 30 June 2013. The company has to pay the last instalment of advanced tax, for the assessment year 2013- 2014, amounting to Rs.54000. Anticipated office costs for the six months are: Jan Feb Mar 25,000.00 20,000.00 40,000.00 May Jun 35,000.00 30,000.00 45,000.00 The opening cash balance of Rs.10,000 is the minimum cash balance to be maintained. Deficits have to be met by borrowers in multiples of Rs. 10,000 on which interest, on monthly basis, has to be paid on the first date of the subsequent month, at 12% p.a. Interest is payable for a minimum period of a month. Rent payable is Rs.2,000 per month a Sales forecast are: Oct Nov Dec Jan Feb HHH 1,60,000.00 1,80,000.00 2,00,000.00 2,20,000.00 1,40,000.00 Mar Apr May Jun July 1,60,000.00 1,50,000.00 2,00,000.00 1,80,000.00 1,20,000.00 My Hy Hy Hy
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
