Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on the following information, prepare a cash budget for Rimbunan Pepohon Bhd for the third quarter of year 2022. The company's projected sales for

image text in transcribedimage text in transcribedimage text in transcribed

Based on the following information, prepare a cash budget for Rimbunan Pepohon Bhd for the third quarter of year 2022. The company's projected sales for the month of May to October 2022 is provided in the table below. Month Sales (RM) May 100,000 June 105,000 July 110,000 August 115,000 September 120.000 The collection of sales is as follows: 40% is collected in the month of sales 60% is collected one month after sales October 125,000 y D) Purchases of raw materials are 55% of sales and are made one month in advance of sales. Payments are made on the following basis: 45% in the month of purchases 55% one month after purchases in The company will receive the monthly interest and rental worth RM1,500 and RM3,000 respectively. in) The information on the company's fixed monthly expenses are provided below: Selling and general expenses 1% of monthly sales Operating expenses: RM 20,500 Depreciation expenses RM 5,000 Insurance premium RM 7,000 V Interest on a borrowed RM120,000 loan at 15%interest per year is payable every month. vi) Cash balance on 30 June 2022 is RM 50,000 and the company maintains the minimum cash requirement of RM30,000

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

Valuation Workbook Step By Step Exercises And Tests To Help You Master Valuation

Authors: McKinsey & Company Inc.

7th Edition

1119611814, 978-1119611813

More Books

Students also viewed these Finance questions