Daniel Merrill is the manager of an airport gift shop, Merrill News and Gifts. From the following d Mr. Merrill wants a cash budget showing expected cash receipts and disbursements for the mont April, and the cash balance expected as of April 30, 20X7. • Planned cash balance, March 31, 20X7: $100,000 • Customer receivables as of March 31: $530,000 total, $80,000 from February sales, $450,000 from March sales • Accounts payable, March 31: $460,000 • Merciindise purchases for April: $450,000, 40% paid in month of purchase, 60% paid in next month • Payrolls due in April: $90,000 • Other expenses for April, payable in April: $45,000 • Accrued taxes for April, payable in June: $7,500 • Bank note due April 10: $90,000 plus $7,200 interest • Depreciation for April: $2,100 • Two-year insurance policy due April 14 for renewal: $1,500, to be paid in cash • Sales for April: $1,000,000, half collected in month of sale, 40% in next month, 10% in third month Prepare the cash budget for the month ending April 30 20

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

Please see attached image.

7-36 Cash Budget
Daniel Merrill is the manager of an airport gift shop, Merrill News and Gifts. From the following de
Mr. Merrill wants a cash budget showing expected cash receipts and disbursements for the mons
April, and the cash balance expected as of April 30, 20X7.
• Planned cash balance, March 31, 20X7: $100,000
• Customer receivables as of March 31: $530,000 total, $80,000 from February sales,
$450,000 from March sales
• Accounts payable, March 31: $460,000
• Merciindise purchases for April: $450,000, 40% paid in month of purchase, 60% paid
in next month
• Payrolls due in April: $90,000
• Other expenses for April, payable in April: $45,000
• Accrued taxes for April, payable in June: $7,500
• Bank note due April 10: $90,000 plus $7,200 interest
• Depreciation for April: $2,100
• Two-year insurance policy due April 14 for renewal: $1,500, to be paid in cash
• Sales for April: $1,000,000, half collected in month of sale, 40% in next month, 10%
in third month
Prepare the cash budget for the month ending April 30 20x7
Transcribed Image Text:7-36 Cash Budget Daniel Merrill is the manager of an airport gift shop, Merrill News and Gifts. From the following de Mr. Merrill wants a cash budget showing expected cash receipts and disbursements for the mons April, and the cash balance expected as of April 30, 20X7. • Planned cash balance, March 31, 20X7: $100,000 • Customer receivables as of March 31: $530,000 total, $80,000 from February sales, $450,000 from March sales • Accounts payable, March 31: $460,000 • Merciindise purchases for April: $450,000, 40% paid in month of purchase, 60% paid in next month • Payrolls due in April: $90,000 • Other expenses for April, payable in April: $45,000 • Accrued taxes for April, payable in June: $7,500 • Bank note due April 10: $90,000 plus $7,200 interest • Depreciation for April: $2,100 • Two-year insurance policy due April 14 for renewal: $1,500, to be paid in cash • Sales for April: $1,000,000, half collected in month of sale, 40% in next month, 10% in third month Prepare the cash budget for the month ending April 30 20x7
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
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.
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