QUESTION 2 Xhana Ltd.is a dealer in motor vehicle parts. The information in the table below and the additional information relate to the business. Forecast income and expenditure for June-September Details                               June     July             August September Cash sales                        6,400      7,800             6,700      7,300 Credit sales                       6,700      9,100            4,600       5,700 Expenditure Salaries                             2,100      2,100           2,100        2,100 Inventories purchases      5,500      6,100           8,400         7,500   Additional information i. The bank balance at the beginning of July was P2,200 ii. Credit sales receipts are 60% in the month of sales and 40% in the following month. iii. Other expenses are paid for in the month in which they are incurred iv. Inventories purchases are paid for 40% in the month of purchase and 60% in the following month. v. A staff canteen kitchen equipment is to be purchased in July and paid for in three months with a deposit of P2,000 in July and installments of P4,000 in August and P2,000 in September   Required: Prepare a cash budget for the company for the months July, August and September

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
Topic Video
Question

QUESTION 2
Xhana Ltd.is a dealer in motor vehicle parts. The information in the table below and the
additional information relate to the business.
Forecast income and expenditure for June-September
Details                               June     July             August September

Cash sales                        6,400      7,800             6,700      7,300


Credit sales                       6,700      9,100            4,600       5,700

Expenditure
Salaries                             2,100      2,100           2,100        2,100
Inventories purchases      5,500      6,100           8,400         7,500

 

Additional information

i. The bank balance at the beginning of July was P2,200
ii. Credit sales receipts are 60% in the month of sales and 40% in the following month.
iii. Other expenses are paid for in the month in which they are incurred
iv. Inventories purchases are paid for 40% in the month of purchase and 60% in the following
month.
v. A staff canteen kitchen equipment is to be purchased in July and paid for in three months
with a deposit of P2,000 in July and installments of P4,000 in August and P2,000 in September

 

Required:
Prepare a cash budget for the company for the months July, August and September.

Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Financial Statements
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