Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

From the following forecast of income and expenditure prepare a cash budget for the three months ending on June 2020. Month Sales (Rs.) Purchases(Rs) Wages(Rs)

From the following forecast of income and expenditure prepare a cash budget for the three months ending on June 2020.

Month Sales (Rs.) Purchases(Rs) Wages(Rs) Misc.(Rs)
Feb 1,20,000 84,000 10,000 7,000
March 1,30,000 1,00,000 12,000 8,000
April 80,000 1,04,000 8,000 6,000
May 1,16,000 1,06,000 10,000 12,000
June 88,000 80,000 8,000 6,000

Additional information:

  1. Sales: 25% realized in the month of sales, discount allowed 2% in cash on the sales realized in the month of sale; balance realized equally in two subsequent months.
  2. Purchases: These are paid in the month following the month of supply.
  3. Wages: 30% paid in the arrears following month. D
  4. Misc.Expenses: Paid a month in arrears.
  5. Rent: Rs1,000 per month paid quarterly in advance, due in April.
  6. Income tax: First installment of advance tax Rs. 25,000 due on or before 15th June to be paid within the month.
  7. Income from investment; Rs. 5,000 received quarterly in April, July, etc.
  8. Cashin hand Rs. 25,000 on April l.
  9. Depreciation: Rs 5000 for the month of April.
  10. Sale of old machinery at Rs. 50,000 in June.

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

Fundamental Financial Accounting Concepts

Authors: Thomas Edmonds, Christopher Edmonds

9th edition

9781259296802, 9781259296758, 78025907, 1259296806, 9781259296765, 978-0078025907

More Books

Students also viewed these Accounting questions

Question

Which of these seems to be a good idea?

Answered: 1 week ago

Question

Dana

Answered: 1 week ago