- 20 Marks
MI – Nov 2020 – L1 – SB – Q1 – Budgeting
Prepare the cash budget for the first three months of the year based on provided sales, expenses, and additional company details.
Question
WXYZ is preparing for the first half of the next year. The following information was available:
a. Sales – 15% of monthly sales are in cash, while the balance is sold on credit. Collections from receivables are 50% in the first month after sales, 30% in the second month, and the balance in the third month after sales.
b. Purchases are usually 55% of sales and paid in the month of purchase.
c. Insurance company is expected to pay the sum of N525,000 in February based on the company’s accidented vehicles.
d. Salary deductions are paid on a preceding-month basis.
e. Company income tax of N475,550 will be paid in March.
f. Cash and cash equivalent balance as at December is N502,760.
g. Bank charges are 1% of total payments for the month.
h. Additional Information:
Month | October (N) | November (N) | December (N) | January (N) | February (N) | March (N) |
---|---|---|---|---|---|---|
Sales | 750,000 | 600,000 | 850,000 | 520,000 | 670,000 | 800,000 |
Net Salaries | 230,000 | 200,000 | 250,000 | 210,000 | 240,000 | 270,000 |
Other Expenses | 200,700 | 187,500 | 197,500 | 177,200 | 187,500 | 192,700 |
Salaries Deductions | 29,400 | 28,400 | 39,400 | 28,700 | 32,750 | 27,650 |
Required:
Prepare the cash budget for the first three months of the year. (Total 20 Marks)
Find Related Questions by Tags, levels, etc.