Question
AM is a trading entity. Purchases are on credit, with 70% paid in the month following the date of purchase and 30% paid in the
AM is a trading entity. Purchases are on credit, with 70% paid in the month following the date of purchase and 30% paid in the month after that.
Sales are partly on credit and partly for cash. Customers who receive credit are given 30 days to pay. On average 60% pay within 30 days, 30% pay between 30 and 60 days, and 5% pay between 60 and 90 days. The balance is written off as irrecoverable. Other overheads, including salaries, are paid within the month incurred.
AM plans to purchase new equipment at the end of June 2015, the expected cost of which is P250,000. The equipment will be purchased on 30 days credit, payable at the end of July. The cash balance on 1 May 2015 is P96,000.
The actual/budgeted figures for the six month to July 2015 were:
Actual | Budgeted | |||||
Feb P000 | March P000 | April P000 | May P000 | June P000 | July P000 | |
Credit sales | 100 | 100 | 110 | 110 | 120 | 120 |
Cash sales | 30 | 30 | 35 | 35 | 40 | 40 |
Credit purchases | 45 | 50 | 50 | 55 | 55 | 60 |
Other overhead expenses | 40 | 40 | 40 | 50 | 50 | 50 |
Required:
- Prepare a monthly cash budget for the period May to July 2015. (15 marks)
- Assess the likelihood of AM being able to pay for the equipment when it falls due. (3 marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started