Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sales revenue projection for Senja Nan Merah Sdn. Bhd. for the last 6 months of 2022 are as follows: Month July Sales (RM) 85'000 August

Sales revenue projection for Senja Nan Merah Sdn. Bhd. for the last 6 months of 2022 are as follows: Month July Sales (RM) 85'000 August 125'000 September 115'000 October 235'000 November December 295'000 265'000 Of the total monthly sales revenue, 10% is comprised of cash sales. 50% of the monthly sales volume is collected in the first month after the sale is made while the remaining 40% is collected in the second month after the sale is made. Total sales for May and June 2022 were RM95,000 and 102,000 respectively. The purchase of the monthly Senja Nan Merah merchandise inventory is scheduled as follows: Month Sales (RM) July 72'500 August 82'400 September 142'300 October 175'000 November 163'200 December 138'300 Payment for the purchase of inventory of such merchandise is made in the month in which the purchase is made. Senja Nan Merah pays RM9,000 per month for business premises rental expenses and another RM22,000 for various other related expenses. The tax payment amounts to RM19,500 and is paid by Senja Nan Merah on a quarterly basis, starting in March. The final cash balance of Senja Nan Merah on 30 June 2022 is RM22,400. The Company has a financial policy that stipulates to maintain a minimum cash balance of RM25,000 at all times. If the minimum cash balance requirement cannot be met, the company can obtain a short-term cash financing facility at a rate of 12% per annum. These interest expenses are paid on a monthly basis. Part or all of this financing amount will be repaid in the following month if the company has a cash surplus in that month. Therefore, if the company expects to need additional short-term financing amounting to RM60,500 in February, the loan will be made in early February with interest of RM605 (12% x 1/12 x RM60,500). This interest will be paid in early March. QUESTION Based on the information provided, prepare a cash budget for Senja Nan Merah for the last 6 months of 2022

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

Managerial Accounting An Introduction To Concepts Methods And Uses

Authors: Arnold I. Davidson

2nd Edition

0030597269, 978-0030597268

More Books

Students also viewed these Accounting questions