Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

C. Prepare cash budgets for first quarter of 2017, by months and in total. D. If a company prepares budgeted statement of profit or loss

image text in transcribed

C. Prepare cash budgets for first quarter of 2017, by months and in total.

D. If a company prepares budgeted statement of profit or loss and statement of financial position, why is a cash budget still necessary? Briefly explain.

SECTION B: PROBLEM QUESTIONS Instruction: Please answer ALL the problem questions. QUESTION 1 MLK Industrial Gas Corporation supplies acetylene and other compressed gases to industry Below is the Statement of Financial Position for the month of December 2016. MLK Corporation Statement of Financial Position December 2016 ASSETS Cash Accounts receivable (net of allowance for uncollectible accounts) Merchandise inventory RM 22,000 82,000 166,400 Property, plant and equipment (net of RM658,000 accumulated depreciation)1,170,000 TOTAL ASSETS 1,440,400 LIABILITIES AND STOCKHOLDERS' EQUITY Accounts payable Common stock Retained earnings TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY 199,000 840,000 401,400 1,440,400 Other data regarding the store's operations are as follow (i) Sales are budgeted at RM320,000 for January, RM340,000 for February, RM330,000 for March and RM360,000 for April 2017 Collections are expected to be 75% in the month of sale, 20% in the month following the sale, and 5% uncollectible The cost of goods sold is 65% of sales. The company desires ending merchandise inventory to equal 80% of the following month's cost of goods sold. (ii) (iii) (iv) (v) Payment for merchandise purchases is made in the month following the purchase. (vi) Other monthly expenses to be paid in cash are RM21,000. (vii) Monthly depreciation is RM16,000. (V???) A payment of RM70,000 for purchase of equipment and a dividend of RM 100,000 are to be paid in January (ix) The management would like to maintain a minimum cash balance of RM20,000 at the end of each month. The company has an agreement with a local bank that allows the company to borro total loan balance of RM100,000. Repayment is made at the end of each month interest rate of these loans is 2% per month. w in increments of RM5,000 at the beginning of each month, up to a Required: a. Prepare a Schedule of Expected Cash Collections for the first Quarter of 2017, by months and in total (5 marks) b. Prepare a Merchandise Purchases Budget for the first quarter of 2017, by months and in total

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

Unofficial Guide To Medical Research Audit And Teaching

Authors: Ceen-Ming Tang BA BM BCh MRCGP, Colin Fischbacher, Zeshan Qureshi BM BSc MSc MRCPCH FAcadMEd MRCPS

1st Edition

0957149980, 978-0957149984

More Books

Students also viewed these Accounting questions