Desa Cemerlang Sdn Bhd has been engaged in the process of forecasting its financing needs over...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) 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)
Expert Answer:
Answer rating: 100% (QA)
Answer Month Cash Cash Net Beginning Ending Short Term ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Sakura Group has been engaged in the process of forecasting its financing needs over the next years. The following is a forecast revenue: Sakuras cost is equal to 52 percent of revenue. Every year,...
-
In several instances, Neibler Corporation has been engaged in transactions that were denominated or settled in foreign currencies (FC). Given recent volatility in exchange rates between the U.S....
-
Are surveys or focus groups used in the process of organizational development the same as research? When conducting a survey within an organization, are employees the same as research participants?...
-
Find f x (x, y) and f y (x, y). f(x, y) = 2x + 5y 3x + y
-
The following are a number of values taken from compound interest tables involving the same number of periods and the same rate of interest. Indicate what each of these four values represents. (a)...
-
In Problems 3142, determine whether the equation defines y as a function of x. y = |x|
-
Electron 1 , initially traveling to the right at \(1.5 \times 10^{6} \mathrm{~m} / \mathrm{s}\), is accelerated upward at \(900 \mathrm{~m} / \mathrm{s}^{2}\) by the electromagnetic force exerted by...
-
Beaufort Vaults Corporation produces and sells burial vaults. On July 1, 2012, Beaufort Vaults Corporation issued $25,000,000 of 10-year, 8% bonds at par. Interest on the bonds is payable...
-
2. 42. 33 43 A. B. Which of the above atoms belong to inert element R S C. T D. U A. If atom R belong to element R ant atom V belong to element V, what would be the formula of the compound formed...
-
In early 2016, Doc and Lyn McGee formed the McGee Cake Company. The company produced a full line of cakes, and its specialties included chess cake,* lemon pound cake, and double-iced, double...
-
Approximate the volume of the solid in the first.octant bounded by the sphere z y? + 22= 64, the planes z= 3. y =3, and the three coordinate planes. To find an approximate value of the double...
-
Use the Principle of Induction to prove the formula for all natural numbers \(n\). \(1+x+x^{2}+\cdots+x^{n}=\frac{1-x^{n+1}}{1-x}\) for any \(x eq 1\)
-
On 1 January 2008, an entity issued EUR 4m of 7 per cent convertible loan stock. The holders of this stock may choose to convert the stock to ordinary shares on 1 January 2012, 2013 or 2014. The...
-
Assume that entity Es beginning inventory on 1 March 2010 is nil. All inventory is finished goods and is of the same type. Details of the inventory received and sent out by entity E are shown below:...
-
The opening balance sheet at 1 January 2009 of an Italian company, which accounts in euro consists of cash of EUR 200,000 and share capital of EUR 200,000. The company takes out a long-term loan on...
-
Consider the following theorem: Let \(f\) be a quadratic polynomial with a positive leading coefficient. Then \(f\) has a minimum value. (a) What are the hypotheses? (b) What is the contrapositive?...
-
What are the uses of leftover antiparticles and antigrams after annihilating all of the antimatter in the universe?
-
Describe a group you belong or have belonged discuss the stages of group development and suggest how to improve the group effectiveness by using the group development model.
-
Use contracting theory to explain why firms (i, e., Boards of Directors acting on sharedholders behalf) would prefer to allow managers have no flexibility to choose policies. Use contracting theory...
-
Below is a portion of a 2013 proxy form sent to shareholders of Miracle- J Corporation. It reveals that Miracle- J has a bonus plan for its three senior executives that allocates them 10% of before-...
-
What will be the impact on relevance, reliability, and decision usefulness of financial statement information resulting from accountants adoption of a measurement approach?
-
Let us consider a call option with maturity \(T=1\) year and strike price \(\$ 11\). The current price of the stock share is \(\$ 10\), and the riskfree interest rate is \(10 \%\). The two possible...
-
Let us consider the PDE with terminal condition In order to apply the representation theorem, we observe that \(r=0\), \((x t)=\), and , so that the underlying stochastic process boils down to a...
-
Let us consider the same setting as Example 13.4: \(S_{0}=K=50\), \(r=01, \quad=04\), and time-to-maturity is \(T=5/12\) (here we take \(t=0)\). The calculation is as follows: This exact result may...
Study smarter with the SolutionInn App