Prepare a Budgeted Statement of Financial Position as at 31 December 2022 using the below information: Statement of comprehensive income for the year ended 31 December 2021 Sales                                                               10 000 000 Cost of sales                                                   (5 750 000) Gross profit                                                      4 250 000 Variable selling and administrative expenses (1 500 000) Fixed selling and administrative expenses     (500 000) Net profit                                                          2 250 000 Statement of financial position as at 31 December 2021 ASSETS Non-current assets                    800 000 Property, plant and equipment  800 000 Current assets                           3 400 000 Inventories                                 1 600 000 Accounts receivable                   600 000 Cash                                           1 200 000                                                     4 200 000 EQUITY AND LIABILITIES Equity                                         3 760 000 Current liabilities                        440 000 Accounts payable                      440 000                                                    4 200 000   Additional information: 1. The sales budget for 2022 is as follows: First quarter R2 625 000 Second quarter R2 750 000 Third quarter R2 875 000 Fourth quarter R2 750 000 2. 90% of the sales is collected in the quarter of the sale and 10% in the quarter following the sale. 3. The gross margin ratio for 2022 is expected to be the same as for 2021. 4. Inventory is purchased in the quarter of the expected sale. Eighty (80%) of inventory purchases is paid for in the quarter of purchase and twenty percent (20%) is paid for in the quarter following the purchase. 5. The inventories balance at the end of each quarter is expected to be the same as the end of the last quarter of 2021 viz. R1 600 000. 6. Variable selling and administrative expenses will vary in the same ratio to sales as for 2021. 7. Fixed selling and administrative expenses will be the same as for 2021 and will include annual depreciation of R160 000 on property, plant and equipment. 8. On 31 December 2022 an old vehicle with a cost price of R180 000 and accumulated depreciation of R150 000 will be traded-in for new vehicle. The new vehicle will cost R400 000 and the trade-in value of the old vehicle is expected to be R50 000. 9. The proprietor’s drawings for 2022 are estimated to be R1 527 000. 10. The cash balance must be calculated (balancing figure)

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

Prepare a Budgeted Statement of Financial Position as at 31 December 2022 using the below information:

Statement of comprehensive income for the year ended 31 December 2021

Sales                                                               10 000 000
Cost of sales                                                   (5 750 000)
Gross profit                                                      4 250 000
Variable selling and administrative expenses (1 500 000)
Fixed selling and administrative expenses     (500 000)
Net profit                                                          2 250 000

Statement of financial position as at 31 December 2021

ASSETS
Non-current assets                    800 000
Property, plant and equipment  800 000
Current assets                           3 400 000
Inventories                                 1 600 000
Accounts receivable                   600 000
Cash                                           1 200 000
                                                    4 200 000
EQUITY AND LIABILITIES
Equity                                         3 760 000
Current liabilities                        440 000
Accounts payable                      440 000
                                                   4 200 000

 

Additional information:
1. The sales budget for 2022 is as follows:
First quarter R2 625 000
Second quarter R2 750 000
Third quarter R2 875 000
Fourth quarter R2 750 000
2. 90% of the sales is collected in the quarter of the sale and 10% in the quarter following the sale.
3. The gross margin ratio for 2022 is expected to be the same as for 2021.
4. Inventory is purchased in the quarter of the expected sale. Eighty (80%) of inventory purchases is paid for in the
quarter of purchase and twenty percent (20%) is paid for in the quarter following the purchase.
5. The inventories balance at the end of each quarter is expected to be the same as the end of the last quarter of
2021 viz. R1 600 000.
6. Variable selling and administrative expenses will vary in the same ratio to sales as for 2021.
7. Fixed selling and administrative expenses will be the same as for 2021 and will include annual depreciation of
R160 000 on property, plant and equipment.
8. On 31 December 2022 an old vehicle with a cost price of R180 000 and accumulated depreciation of R150 000
will be traded-in for new vehicle. The new vehicle will cost R400 000 and the trade-in value of the old vehicle is
expected to be R50 000.
9. The proprietor’s drawings for 2022 are estimated to be R1 527 000.
10. The cash balance must be calculated (balancing figure)

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps

Blurred answer
Knowledge Booster
Budgeting
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.
Similar questions
  • SEE MORE QUESTIONS
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