Prepare a cash budget for the XYZ Manufacturing Company, indicating receipts and disbursements for May, June, and July. The firm wishes to maintain at all times a minimum cash balance of $50,000. Determine whether or not borrowing will be necessary during the period, and if it is, when and how much. As of April 30, the firm had a balance of $50,000 in cash. Actual Sales Forecasted Sales January $120,000 May $80,000 February 110,000 June 95,000 March 100,000 July 105,000 April 90,000 August 115,000 Accounts receivable: 20% of total sales are for cash. The remaining 80% will be collected 60% during the following months, 30% one more month later, and 10% two more months later (the firm incurs a negligible bad-debt loss.) Cost of goods manufactured: 65% of sales: 80% of this cost is paid the following month and the remaining 20% one more month later. Selling, general, and administrative expenses: $15,000 per month plus 5% of sales. All of these expenses are paid during the month of incurrence. Interest payment: A semiannual interest payment on $1,500,000 of bonds outstanding (10% coupon) is paid during July. An annual $80,000 sinking-fund payment is also made at that time. Dividends: A $20,000 dividend payment will be declared and made in August. Capital expenditures: $60,000 will be invested in plant and equipment in June. Taxes: Income tax payments of $25,000 will be made in July. (Questions 6-10) In order to maintain the minimum cash balance of $50,000, how much (in cumulative amount) would have to be borrowed at the end of August? Group of answer choices $437,750.00 $508,950.00 None of them $205,000.00 $0.00 $235,400.00

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
Prepare a cash budget for the XYZ Manufacturing Company, indicating receipts and disbursements for May, June, and July. The firm wishes to maintain at all times a minimum cash balance of $50,000. Determine whether or not borrowing will be necessary during the period, and if it is, when and how much. As of April 30, the firm had a balance of $50,000 in cash. Actual Sales Forecasted Sales January $120,000 May $80,000 February 110,000 June 95,000 March 100,000 July 105,000 April 90,000 August 115,000 Accounts receivable: 20% of total sales are for cash. The remaining 80% will be collected 60% during the following months, 30% one more month later, and 10% two more months later (the firm incurs a negligible bad-debt loss.) Cost of goods manufactured: 65% of sales: 80% of this cost is paid the following month and the remaining 20% one more month later. Selling, general, and administrative expenses: $15,000 per month plus 5% of sales. All of these expenses are paid during the month of incurrence. Interest payment: A semiannual interest payment on $1,500,000 of bonds outstanding (10% coupon) is paid during July. An annual $80,000 sinking-fund payment is also made at that time. Dividends: A $20,000 dividend payment will be declared and made in August. Capital expenditures: $60,000 will be invested in plant and equipment in June. Taxes: Income tax payments of $25,000 will be made in July. (Questions 6-10) In order to maintain the minimum cash balance of $50,000, how much (in cumulative amount) would have to be borrowed at the end of August? Group of answer choices $437,750.00 $508,950.00 None of them $205,000.00 $0.00 $235,400.00
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
Budgeting
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
  • 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