All purchases of ANGEL Merchandising are made on account, Eighty percent of the purchases are paid on the month of purchase and the remaining are paid the following month. ANGEL avails itself of the 5% discount in full provided by the suppliers in all purchases         Sixty percent of the sales of ANGEL Merchandise are made on account. Eighty percent of the sales on account are made on the month of sale when the customers are granted 2% discount. Eighteen percent of the credit sales are collected the following month, but customers pay beyond the discount period of 10 days from the date of sale. The remaining sales on acoount is considered uncollectible.          The following data is provided by the company as follows:   Sales Purchases Operating Expenses December 2018 (actual) 250 000 160 000 45 000 January 2019 (estimated) 300 000 200 000 60 000 February 2019 (estimated) 380 000 240 000 70 000 March 2019 (estimated) 450 000 380 000 95 000         The cash balance of the business on January 1, 2019 is 80,000. The business also plans to buy additional equipment in February 2019 amounting to 150 000 and will make a down paymentof 60% on the month of purchase. The balance will be paid next month. TASK: Prepare the monthly cash budget of ANGEL Merchandising with supporting schedule for the 1st Quarter.            (You are required to prepare cash budget for Jan, Feb, and Mar)

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

All purchases of ANGEL Merchandising are made on account, Eighty percent of the purchases are paid on the month of purchase and the remaining are paid the following month. ANGEL avails itself of the 5% discount in full provided by the suppliers in all purchases

        Sixty percent of the sales of ANGEL Merchandise are made on account. Eighty percent of the sales on account are made on the month of sale when the customers are granted 2% discount. Eighteen percent of the credit sales are collected the following month, but customers pay beyond the discount period of 10 days from the date of sale. The remaining sales on acoount is considered uncollectible.
         The following data is provided by the company as follows:

  Sales Purchases

Operating Expenses

December 2018 (actual) 250 000 160 000 45 000
January 2019 (estimated) 300 000 200 000 60 000
February 2019 (estimated) 380 000 240 000 70 000
March 2019 (estimated) 450 000 380 000

95 000

        The cash balance of the business on January 1, 2019 is 80,000. The business also plans to buy additional equipment in February 2019 amounting to 150 000 and will make a down paymentof 60% on the month of purchase. The balance will be paid next month.

TASK: Prepare the monthly cash budget of ANGEL Merchandising with supporting schedule for the 1st Quarter.
           (You are required to prepare cash budget for Jan, Feb, and Mar)

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Knowledge Booster
Trade Credit
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
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