he following information for ABCs Projects is available:   MARCH APRIL MAY JUNE JULY AUGUS T Cash revenue 180 000 200 000 250 000 290 000 320 000 350 000 Credit revenue 380 000 410 000 500 000 560 000 560 000 600 000 Total purchases 320 000 340 000 385 000 432 000 445 000 460 000 Salaries and wages 63 000 63 000 63 000 63 000 63 000 63 000 Other expenses 12 000 12 500 12 500 14 500 54 800 59 000 Additional information: Credit revenues are collected as follows: 50% within 30 days (the next month) 25% within 60 days

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

Accounting

The following information for ABCs Projects is available:

 

MARCH

APRIL

MAY

JUNE

JULY

AUGUS

T

Cash revenue

180 000

200 000

250 000

290 000

320 000

350 000

Credit revenue

380 000

410 000

500 000

560 000

560 000

600 000

Total purchases

320 000

340 000

385 000

432 000

445 000

460 000

Salaries and wages

63 000

63 000

63 000

63 000

63 000

63 000

Other expenses

12 000

12 500

12 500

14 500

54 800

59 000

Additional information:

    1. Credit revenues are collected as follows:
      • 50% within 30 days (the next month)
      • 25% within 60 days
      • 15% within 30 days
      • 10% uncollectible (bad debt)
    2. The following discount is given on revenues:
      • 10% on all cash revenue
      • 5% on credit revenue paid within 30 days
    3. Salaries, wages and other expenses are paid in cash.
    4. Other expenses include depreciation of $4 000 per month.
    1. 55% of all purchases are on credit and are paid for in the following month. The rest represents cash purchases.
    2. The bank balance of ABCs Projects on 1 June is $200 000.
    3. A dividend of $3 000 will be declared on 31 August.

Required:

Prepare the cash budget for the months June, July and August (Use separate columns for June, July and August).

Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
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