Question: Please help , please help . please hep ..I will give upvote . There are TWELVE (12) - month cash flow forecast (from March) for
Please help , please help . please hep ..I will give upvote .

There are TWELVE (12) - month cash flow forecast (from March) for Jill Sdn. Bhd. The forecast data are: - Sales are: March (RM35,000), April (RM 40,000), May (RM36,000), June (RM 42,000). After May, sales will increase 20% from month before. -Debt collections every month based on 30% from the sales amount. - Purchases are made in the month of sale and are all for cash. The value of purchases is 40% of sales value. - Purchases are: March (RM20,000), April (RM10,000), May (RM 8,000), June (RM 11,000) and the following months will be 20% from sales amount. - Capital RM 40,000 - Renovation RM 25,000 - Loan RM 120,000 for 10 years and the interest is 3%. - Marketing expenses every two months in a year RM 4,500 -Salary RM 12,000 per month -Wages for Account Executive fixed for every two (2) months RM 5,000. Required 1) From this data, please analyze the cash based on cash flow analysis format. 2) Based on the cash flow forecast, what action would you advise the manager of this business to take arises for the next coming year? There are TWELVE (12) - month cash flow forecast (from March) for Jill Sdn. Bhd. The forecast data are: - Sales are: March (RM35,000), April (RM 40,000), May (RM36,000), June (RM 42,000). After May, sales will increase 20% from month before. -Debt collections every month based on 30% from the sales amount. - Purchases are made in the month of sale and are all for cash. The value of purchases is 40% of sales value. - Purchases are: March (RM20,000), April (RM10,000), May (RM 8,000), June (RM 11,000) and the following months will be 20% from sales amount. - Capital RM 40,000 - Renovation RM 25,000 - Loan RM 120,000 for 10 years and the interest is 3%. - Marketing expenses every two months in a year RM 4,500 -Salary RM 12,000 per month -Wages for Account Executive fixed for every two (2) months RM 5,000. Required 1) From this data, please analyze the cash based on cash flow analysis format. 2) Based on the cash flow forecast, what action would you advise the manager of this business to take arises for the next coming year
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
