Prepare the following three-months (January to March 2021) budget as required by the bankers. (a) The Cash Collection Schedule for sales (b) The Cash Payment Schedule for purchases (c) The budgeted income statement

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%

hello. how to answer following questions

Prepare the following three-months (January to March 2021) budget as required by
the bankers.
(a) The Cash Collection Schedule for sales
(b) The Cash Payment Schedule for purchases
The budgeted income statement
(c)
(d) The budgeted statement of financial position/ Balance Sheet
(e) The cash budget
Transcribed Image Text:Prepare the following three-months (January to March 2021) budget as required by the bankers. (a) The Cash Collection Schedule for sales (b) The Cash Payment Schedule for purchases The budgeted income statement (c) (d) The budgeted statement of financial position/ Balance Sheet (e) The cash budget
Question
BioGrow Sdn. Bhd is a retail fertilizer to farmers in Jitra. The company has approached
its Bankers to provide funding for next year's operations. In considering their funding
application, a three - month master budget has been requested for review by the
bankers.
As a freelance accounting service provider, you have been approached by the
management as a consultant to prepare the 1st quarter budget for the banker's
consideration for its next year's (2021) operations.
Below is the information as at the end of accounting year of December 2020:
Details
RM
Debtors
23,000
55,000
Bank
Fixed asset at cost
698,000
98,000
48,000
60,000
Accumulated depreciation
Creditors
Operating expenses for December
Sales for December
Ending inventory
Retained earnings
400,000
20,000
120,000
The following additional information was also provided to assist your work.
(i) Depreciation is provided at the rate of 5% on cost of non-current assets per
month.
(i) Closing inventory is expected to increase by RM2000 in January from December
levels. This is expected to increase by the same figure in February from the
projected figure in January. It is expected that in March closing inventory is
desired to be RM26,000
The company makes a profit of 25% on its sales.
(iv) Operating expenses is expected to increase by 10% from that of December in
January and this is projected to increase at the same growth rate until March.
(v) Sales is projected to grow by 15% per month from December until March.
(vi) Debtors figure at the end of the month is desired to be proportional to the sales
values.
(vii) Creditors value for the three months are expected to be as follows:
January - RM50 000; February - RM46,000; March - RM52,000
1
Transcribed Image Text:Question BioGrow Sdn. Bhd is a retail fertilizer to farmers in Jitra. The company has approached its Bankers to provide funding for next year's operations. In considering their funding application, a three - month master budget has been requested for review by the bankers. As a freelance accounting service provider, you have been approached by the management as a consultant to prepare the 1st quarter budget for the banker's consideration for its next year's (2021) operations. Below is the information as at the end of accounting year of December 2020: Details RM Debtors 23,000 55,000 Bank Fixed asset at cost 698,000 98,000 48,000 60,000 Accumulated depreciation Creditors Operating expenses for December Sales for December Ending inventory Retained earnings 400,000 20,000 120,000 The following additional information was also provided to assist your work. (i) Depreciation is provided at the rate of 5% on cost of non-current assets per month. (i) Closing inventory is expected to increase by RM2000 in January from December levels. This is expected to increase by the same figure in February from the projected figure in January. It is expected that in March closing inventory is desired to be RM26,000 The company makes a profit of 25% on its sales. (iv) Operating expenses is expected to increase by 10% from that of December in January and this is projected to increase at the same growth rate until March. (v) Sales is projected to grow by 15% per month from December until March. (vi) Debtors figure at the end of the month is desired to be proportional to the sales values. (vii) Creditors value for the three months are expected to be as follows: January - RM50 000; February - RM46,000; March - RM52,000 1
Expert Solution
Step 1

Since you have posted a question with multiple sub-parts, we will solve the first three subparts for you. To get the remaining sub-parts solved please repost the complete question and mention the sub-parts to be solved.

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Stock Indices
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education