Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2020: Credit sales Credit purchases Cash disbursements 136,000 April May June $328,000 $308,000 $368,000 159,000 184,000 Wages, taxes, and 44,800 12,300 63,800 expenses Interest Equipment purchases 11,800 88,000 11,800 11,800 166,000 0 The company predicts that 5 percent of its credit sales will never be collected, 20 percent of its sales will be collected in the month of the sale, and the remaining 75 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2020, credit sales were $198,000, and credit purchases were $138,000. Using this information, complete the following cash budget. (Do not round intermediate calculations.) Beginning cash balance Cash receipts Cash collections from credit sales Total cash available Cash disbursements Purchases Wages, taxes, and expenses Interest Equipment purchases Total cash disbursements Ending cash balance April May June $ 131,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
Question

please step by step solution.

 

 

Here are some important figures from the budget of Cornell, Inc., for the second quarter
of 2020:
Credit sales
Credit purchases
Cash disbursements
136,000
April
May
June
$328,000 $308,000 $368,000
159,000
184,000
Wages, taxes, and
44,800 12,300
63,800
expenses
Interest
Equipment purchases
11,800
88,000
11,800
11,800
166,000
0
The company predicts that 5 percent of its credit sales will never be collected, 20
percent of its sales will be collected in the month of the sale, and the remaining 75
percent will be collected in the following month. Credit purchases will be paid in the
month following the purchase.
In March 2020, credit sales were $198,000, and credit purchases were $138,000. Using
this information, complete the following cash budget. (Do not round intermediate
calculations.)
Beginning cash balance
Cash receipts
Cash collections from credit sales
Total cash available
Cash disbursements
Purchases
Wages, taxes, and expenses
Interest
Equipment purchases
Total cash disbursements
Ending cash balance
April
May
June
$
131,000
Transcribed Image Text:Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2020: Credit sales Credit purchases Cash disbursements 136,000 April May June $328,000 $308,000 $368,000 159,000 184,000 Wages, taxes, and 44,800 12,300 63,800 expenses Interest Equipment purchases 11,800 88,000 11,800 11,800 166,000 0 The company predicts that 5 percent of its credit sales will never be collected, 20 percent of its sales will be collected in the month of the sale, and the remaining 75 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2020, credit sales were $198,000, and credit purchases were $138,000. Using this information, complete the following cash budget. (Do not round intermediate calculations.) Beginning cash balance Cash receipts Cash collections from credit sales Total cash available Cash disbursements Purchases Wages, taxes, and expenses Interest Equipment purchases Total cash disbursements Ending cash balance April May June $ 131,000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

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