Q No.1 A company has a cash balance of Rs.27000 at the beginning of March and you are required to prepare a cash budget for March, April and May having regard to the following information.   Creditors give 1 month credit Salaries are paid in the current month Fixed costs are paid one month in arrears and include a charge for depreciation of Rs.5000 per month. Credit sales are settled as follows: 40% in month of sales 45% in next month and 12% in the following month. The balance represents bad debts.   MONTH CASH SALES CREDIT SALES PURCHASES SALARIES FIXED EXPENSE Jan   74,000 55,200 9,000                   30,000 Feb   82,000 61,200 9,000                   30,000 March 20,000 80,000 60,000 9,500                   30,000 April 22,000 90,000 69,000 9,500                   32,000 May 25,000          100,000 75,000 10,000                   32,000

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

Q No.1 A company has a cash balance of Rs.27000 at the beginning of March and you are required to prepare a cash budget for March, April and May having regard to the following information.

 

Creditors give 1 month credit

Salaries are paid in the current month

Fixed costs are paid one month in arrears and include a charge for depreciation of Rs.5000 per month.

Credit sales are settled as follows:

40% in month of sales

45% in next month and 12% in the following month. The balance represents bad debts.

 

MONTH

CASH SALES

CREDIT SALES

PURCHASES

SALARIES

FIXED EXPENSE

Jan

 

74,000

55,200

9,000

                  30,000

Feb

 

82,000

61,200

9,000

                  30,000

March

20,000

80,000

60,000

9,500

                  30,000

April

22,000

90,000

69,000

9,500

                  32,000

May

25,000

         100,000

75,000

10,000

                  32,000

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Performance measurements
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