PDA

View Full Version : Question and answers on preparing cash budget


usha7
Nov 27, 2009, 11:21 AM
2. From the following budgeted figures, prepare a cash budget for three
Sales (Rs.) Materials (Rs.) Salaries (Rs.) Wages(Rs.)
January 25,000 12,000 12,000 5,000
February 38,000 18,000 16,000 3,000
March 12,000 22,000 8,000 4,000
April 18,000 19,000 6,000 4,000
May 14,000 23,000 7,500 3,500
June 26,000 11,000 6,000 4,500
Expected cash balance on 1st April Rs.35, 000.Other information
a) Delay for payment of materials one month
b) Salaries and Wages to be paid in the month in which they are incurred.
c) 50% credit sales are realized in the month of following the sales and
Remaining 50%in second month following,
d) Dividend payable for share holders Rs.10, 000 during March.
e) Share call money Rs.10, 000 is due on 1st Jan and 1st March

morgaine300
Nov 27, 2009, 04:42 PM
Please review our guidelines on submitting homework:
https://www.askmehelpdesk.com/finance-accounting/announcement-font-color-ff0000-u-b-read-first-expectations-homework-help-board-b-u-font.html

pready
Nov 29, 2009, 02:51 PM
Frist you need to prepare a schedule of expected cash collections based on your sales figures (#2) and the collection rates (#c).

Next you need to prepare a schedule for your budgeted materials purchases, then you can prepare your cash budget.