Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sendayu Mahal Distributor Sdn Bhd (SMDSB), a distributor of cosmetics throughout Malaysia, is in the process of assembling a cash budget for the last quarter

Sendayu Mahal Distributor Sdn Bhd (SMDSB), a distributor of cosmetics throughout Malaysia, is in the process of assembling a cash budget for the last quarter of 2020. The following information has been extracted from SMDSBs accounting records:

  1. All sales are on accounts. 60% of customer accounts are collected in the month of sale; 35% are collected in the following month. Uncollectible amounting to 5% of sales is anticipated and the management believes that only 20% of the accounts outstanding on 30 September 2020, will be recovered and the recovery will be in October 2020.

  1. 70% of the merchandise purchases are paid for the month of purchase, the remaining 30% are paid for in the month after acquisition.

  1. As at 30 September 2020, SOFP disclosed the following selected figures: cash RM30,000, Trade receivables RM65,000 and trade payables RM30,000.

  1. SMDSB maintains a RM30,000 cash balance at all times. Financing is available (and retired) in RM1,000 multiples at an 8% interest rate, with borrowings taking place at the beginning of the month and repayments occurring at the end of the month. Interest is paid at the time of repaying principal and computed on the portion of principle repaid at that time.

  1. Additional data:

Oct 20 RM000

Nov 20 RM000

Dec 20 RM000

Sales Revenue

200

250

300

Merchandize Purchases

100

110

120

Cash operating costs

25

30

45

Proceeds from sale of equipment

6

Purchase of machinery

7

Received of Dividend

15

Required:

  1. Prepare SMDSBs Schedule of Cash Collections from October through December 2020.

  1. Prepare SMDSBs Schedule of Cash Disbursements from October through December 2020.

  1. Prepare SMDSBs Schedule of Cash Balances for October through December 2020.

(16 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

Computers Electronics And High Tech Industry Irs Audit Techniques Guide

Authors: Internal Revenue Service

1st Edition

1304133834, 978-1304133830

More Books

Students also viewed these Accounting questions