Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

March April May June Sales 38,450 41,200 43,830 46,520 Purchases 15,190 16,250 14,280 17,160 Wages 8,700 9,100 9,700 10,000 Overheads 17,300 19,500 19,900 21,600 Other

March

April

May

June

Sales

38,450

41,200

43,830

46,520

Purchases

15,190

16,250

14,280

17,160

Wages

8,700

9,100

9,700

10,000

Overheads

17,300

19,500

19,900

21,600

Other information:

  • Marty Ltd sells 25% of its goods for cash. The remainder of customers take one months credit
  • Purchases are paid the month after they are incurred
  • Wages are paid the month they are incurred
  • Sales staff commissions which are not included in the table above are paid one month in arrears and are calculated on a basis of 5% of the monthly sales revenue, rounded up to the nearest .
  • Overheads are paid the month after they are incurred and the numbers above include 5,000 per month of depreciation
  • Marty Limited intends to buy a new machine for a cost of 28,000 on 1stMarch. The machine will be classified as a non-current asset and depreciated over five years on a straight-line basis. Payment will be in the form of an initial deposit of 4,000 paid on 1st March followed by 12 equal monthly instalments starting 1st April.
  • The cash balance forecast at the beginning of April is 6,950

Given the above information prepare a cash budget for Marty Ltd for the 3 months April to 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

The Design Implementation And Audit Of Occupational Health And Safety Management Systems

Authors: Ron C. McKinnon

1st Edition

1032571039, 978-1032571034

More Books

Students also viewed these Accounting questions

Question

d. Who are important leaders and heroes of the group?

Answered: 1 week ago