Answered step by step
Verified Expert Solution
Link Copied!

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 .

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sound Investing, Chapter 1 - The Financial Pressure

Authors: Kate Mooney

2nd Edition

0071719237, 9780071719230

More Books

Students also viewed these Accounting questions

Question

How to Construct a Stem and Leaf Plot

Answered: 1 week ago