Question
Sri Watan has stringent sales policy where 70% of sales are for cash and the remaining credit sales will be collected evenly over the following
Sri Watan has stringent sales policy where 70% of sales are for cash and the remaining credit sales will be collected evenly over the following 2 months after sales. The following table shows the actual and forecasted sales up to September 2021.
Actual | January | $60,000 |
| February | $70,000 |
| March | $78,000 |
Forecasted | April | $89,000 |
| May | $95,500 |
| June | $100,000 |
| July | $100,000 |
| August | $114,000 |
| September | $120,000 |
Sri Watan estimated its monthly purchases to be 80% of the following months sales. Its supplier requests cash payment of 60% of the purchases, 30% of purchases to be settled one month after purchase and the remaining to be settled two months after purchases.
Sri Watan is not expecting any other cash receipts and the following are other expenses due: rent payment is $8,500 per month, salaries are $8,000 per month and tax payment of $10,500 is due in April.
- If Sri Watan has a beginning cash balance of $20,000 in April and wishes to maintain a minimum of $10,000 cash balance every month, determine its net cashflow and ending cashflow to establish if it needs any financing for the period between April to June.
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