Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

that's the whole info about the question (Question 1) Coco Melon Corporation currently doing forecasting on company's fund requirement for the last quarter of 2021.

image text in transcribed
that's the whole info about the question
(Question 1) Coco Melon Corporation currently doing forecasting on company's fund requirement for the last quarter of 2021. Below are the company's actual and forecast sales. RM RM Actual sales July 2021 August 2021 Forecasted sales October 2021 300,000 360,000 350,000 November 2021 380,000 September 2021 370,000 December 2021 300,000 January 2022 320,000 Additional information: i. From total sales, 60 percent will be collected by cash and 40 percent will be collected in the following month. ii. Purchase of material will be 50 percent of the month sales and paid in the following month. iii. Wages of company's worker estimated to be 8 percent of the month sales. iv. Interest on company's long-term loan, RM40,000 will be paid in two equal payment in October and December. v. Monthly payment of rent and insurance amount RM16,000 and RM6,000 respectively. vi. Coco Melon Corporation plan to buy a new machine to improve the operation in November cost about RM35,000. vii. Interest on short term loan is at 6 percent annually and paid in the following month viii. The company has ending cash balance from December amount RM10,000 and the company wishes to have minimum cash requirement of RM18,000 per month. Prepare the cash budget for the company for the last quarter 2021. (25 marks) 25 marks

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_2

Step: 3

blur-text-image_3

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

European Financial Reporting Adapting To A Changing World

Authors: J. Flower

2nd Edition

0333685180, 9780333685181

More Books

Students also viewed these Accounting questions

Question

Briefly explain working capital management as used in finance

Answered: 1 week ago

Question

Discuss how technology impacts HRD evaluation

Answered: 1 week ago