Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Desa Cemerlang Sdn Bhd has been engaged in the process of forecasting its financing needs over the next quarter and has made the following

Desa Cemerlang Sdn Bhd has been engaged in the process of forecasting its financing needs over the next quarter and has made the following forecasts of planned cash receipts and disbursements: The monthly sales for the year of 2021: RM 550,00 0 April August RM 690,00 0 May June July 600,00 Septembe 575,00 0 0 c) f) 580,00 0 530,00 October November 600,00 0 620,00 0 a) The firm's sales of 60% is collected in the month of sale and the remaining balance will be collected equally in the following two months after sales. b) The raw materials are 70% of sales purchased two (2) months before the sales month. The supplier is paid one month after the purchases on the cash payment basis. c) The wages and salaries is paid based on 10% of sales in the month. The utilities for the firm is 5% of sales in the month of their incurrence. d) Furthermore, the monthly rent expenses is RM7,000 and RM5,000 tax payments are to be made in the second month of each quarter. A 5% annual interest on a RM500,000 term loan will be paid monthly. Beginning cash balance for the budget period is RM70,000 with a minimum cash balance of RM45,000 and an increase to RM90,000 in August and RM135,000 in September. g) Any short term financing needed to maintain the minimum cash balance should be paid off the month after the financing month with an annual interest rate of 15% per annum. Prepare a monthly cash budget for the three-month period ended 30th September. (30 marks)

Step by Step Solution

3.42 Rating (155 Votes )

There are 3 Steps involved in it

Step: 1

Answer Month Cash Cash Net Beginning Ending Short Term ... 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

Financial Accounting Theory

Authors: William R. Scott

7th edition

132984660, 978-0132984669

More Books

Students also viewed these Finance questions

Question

Find f x (x, y) and f y (x, y). f(x, y) = 2x + 5y 3x + y

Answered: 1 week ago