Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 yearStep 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