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 .

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!