Homework Help is Here – Start Your Trial Now!
Business
Accounting
Prepare the cash budget.

Prepare the cash budget.

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

Must show full work (procedure). Thank you!

Ejercicio de Cash Budget The actual sales and purchases for Xenocore, Inc., for September and October 2012, along with its forecast sales and purchases for the period November 2012 through April 2013, follow. The firm makes 20% of all sales for cash and collects on 40% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be$12,000 in September and April, $15,000 in January and March, and $27,000 in February. The firm pays cash for 10% of its purchases. It pays for 50% of its purchases in the following month and for 40% of its purchases 2 months later. Year Month Sales Purchases 2012 September $210,000 $120,000 2012 October 250,000 150,000 2012 November 170,000 140,000 2012 December 160,000 100,000 January February 2013 140,000 80,000 2013 180,000 110,000 2013 March 200,000 100,000 2013 April 250,000 90,000 Wages and salaries amount to 20% of the preceding month's sales. Rent of $20,000 per month must be paid. Interest payments of $10,000 are due in January and April. A principal payment of $30,000 is also due in April. The firm expects to pay cash dividends of $20,000 in January and April. Taxes of $80,000 are due in April. The firm also intends to make a $25,000 cash purchase of fixed assets in December. The firm has a cash balance of $22,000 at the beginning of November. The firm wishes to maintain a $15,000 minimum cash balance. Prepare the cash budget.
Transcribed Image Text:Ejercicio de Cash Budget The actual sales and purchases for Xenocore, Inc., for September and October 2012, along with its forecast sales and purchases for the period November 2012 through April 2013, follow. The firm makes 20% of all sales for cash and collects on 40% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be$12,000 in September and April, $15,000 in January and March, and $27,000 in February. The firm pays cash for 10% of its purchases. It pays for 50% of its purchases in the following month and for 40% of its purchases 2 months later. Year Month Sales Purchases 2012 September $210,000 $120,000 2012 October 250,000 150,000 2012 November 170,000 140,000 2012 December 160,000 100,000 January February 2013 140,000 80,000 2013 180,000 110,000 2013 March 200,000 100,000 2013 April 250,000 90,000 Wages and salaries amount to 20% of the preceding month's sales. Rent of $20,000 per month must be paid. Interest payments of $10,000 are due in January and April. A principal payment of $30,000 is also due in April. The firm expects to pay cash dividends of $20,000 in January and April. Taxes of $80,000 are due in April. The firm also intends to make a $25,000 cash purchase of fixed assets in December. The firm has a cash balance of $22,000 at the beginning of November. The firm wishes to maintain a $15,000 minimum cash balance. Prepare the cash budget.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
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
SEE MORE TEXTBOOKS