Survey Of Accounting
5th Edition
ISBN: 9781259631122
Author: Edmonds, Thomas P.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 14, Problem 20P
Problem 7-21A Preparing a
Fayette Medical Clinic has budgeted the following
Fayette Medical had a cash balance of $16,000 on January 1. The company desires to maintain a cash cushion of $10,000. Funds are assumed to be borrowed, in increments of $2,000, and repaid on the last day of each month; the interest rate is 1 percent per month. Repayments may be made in any amount available. Fayette pays its vendors on the last day of the month also. The company had a monthly $80,000 beginning balance in its line of credit liability account from this year’s quarterly results.
Required
Prepare a cash budget. (Round all computations to the nearest whole dollar.)
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Problem 6
Tomtom store seeks your assistance to develop cash and other budget information
for May, June, and July 2009. On April 30, 2009, the company had cash balance of
Php5,500.
The budget is based on the following assumptions:
A. Sales
1. Each month's sales are billed on the last day of the month
2. Customers are allowed 3% discount if payment is made within 10 days
after the billing date.
Accounts receivable are booked gross.
3. Sixty percent of the billings are collected within the discount period, 25%
are collected by the end of the month where discount period is allowed,
9% are collected by the end of the end second month, and 6% prove
uncollectible.
B. Purchases
1. 54% of all purchases of materials and selling, general and administrative
expenses are paid at the month purchased and the remainder in the
following month.
2. Each month's unit of ending inventory is equal to 130% of the month's
units of sales.
3. The cost of each unit of inventory is P20.
4. Selling, general and…
10-28 Cash Budget-financing effects
You are a relatively recent hire to Hartz & Co., a local manufacturer of plumbing supply products.
You have been asked to prepare a condensed statement of cash flows for the months of
November and December of the current year for presentation to the company's management.
Assume the cash balance at November 1 will be $75,000. It is the company's policy to maintain
a minimum cash balance of $60,000 at the end of each month. Cash receipts (from cash sales
and collection of accounts receivable) are projected to be $516,000 for November and $462,600
for December. Cash disbursements (sales commissions, advertising, delivery expense, etc.)
prior to financing activity are scheduled to be $430,000 in November and $548,000 in December.
Short-term borrowing, when needed, is done at the beginning of the month in increments
of $1,000. The annual interest rate on any such loans is estimated to be 12%. Interest on any
outstanding short-term loans is paid in cash at…
Book
Hint
Print
Exer
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding
cash payments for loan principal and interest payments) for the first three months of next year.
January
February
March
Cash Receipts Cash payments
$ 521,000
$ 465,600
405,000
478,000
349,600
522,000
Kayak requires a minimum cash balance of $40,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per
month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary
cash balance above $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance
of $80,000 at January 1.
Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should
be indicated with minus sign.)
Chapter 14 Solutions
Survey Of Accounting
Ch. 14 - Prob. 1QCh. 14 - Prob. 2QCh. 14 - 3.What are the three levels of planning? Explain...Ch. 14 - 4.What is the primary factor that distinguishes...Ch. 14 - 5.What is the advantage of using a perpetual...Ch. 14 - Prob. 6QCh. 14 - Prob. 7QCh. 14 - 8. Ken Shilov, manager of the marketing...Ch. 14 - Prob. 9QCh. 14 - 10.What is the normal starting point in developing...
Ch. 14 - 11. How does the level of inventory affect the...Ch. 14 - 12.What are the components of the cash budget?...Ch. 14 - 13.The primary reason for preparing a cash budget...Ch. 14 - 14.What information does the pro forma income...Ch. 14 - 15.How does the pro forma statement of cash flows...Ch. 14 - Exercise 7-1A Budget responsibility Teresa...Ch. 14 - Exercise 7-2A Preparing a sales budget Parliament...Ch. 14 - Prob. 3ECh. 14 - Exercise 7-4A Preparing sales budgets with...Ch. 14 - Exercise 7-5A Determining cash receipts from...Ch. 14 - Exercise 7-6A Using judgment in making a sales...Ch. 14 - Exercise 7-7A Preparing an inventory purchases...Ch. 14 - Exercise 7-8A Preparing a schedule of cash...Ch. 14 - Exercise 7-9A Determining the amount of expected...Ch. 14 - Exercise 7-10A Preparing inventory purchases...Ch. 14 - Exercise 7-11A Preparing a schedule of cash...Ch. 14 - Prob. 12ECh. 14 - Exercise 7-13A Preparing a cash budget The...Ch. 14 - Exercise 7-14A Determining amount to borrow and...Ch. 14 - Prob. 15ECh. 14 - Problem 7-16A Behavioral impact of budgeting...Ch. 14 - Prob. 17PCh. 14 - Problem 7-18A Preparing an inventory purchases...Ch. 14 - Prob. 19PCh. 14 - Problem 7-21A Preparing a cash budget Fayette...Ch. 14 - Prob. 21PCh. 14 - Problem 7-22A Preparing budgets with multiple...Ch. 14 - Problem 7-23A Preparing a master budget for retail...Ch. 14 - ATC 7-1 Business Applications Case Preparing and...Ch. 14 - ATC7-2 Group Assignment Master budget and pro...Ch. 14 - ATC 7-4 Writing Assignment Continuous budgeting...Ch. 14 - Ethical Dilemma Bad budget system or unethical...
Knowledge Booster
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
- Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?arrow_forwardCash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent 12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of June 1 include cash of 42,000, marketable securities of 25,000, and accounts receivable of 198,000 (150,000 from May sales and 48,000 from April sales). Sales on account in April and May were 120,000 and 150,000, respectively. Current liabilities as of June 1 include 13,000 of accounts payable incurred in May for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 24,000 will be made in July. Mercury Shoes regular quarterly dividend of 15,000 is expected to be declared in July and paid in August. Management desires to maintain a minimum cash balance of 40,000. Instructions Prepare a monthly cash budget and supporting schedules for June, July, and August. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?arrow_forwarda. Discuss the purpose of the cash budget. b. If the cash for the first quarter of the fiscal year indicates excess cash at the end of each of the first two months, how might the excess cash be used?arrow_forward
- A. Discuss the purpose of the cash budget. B. If the cash for the first quarter of the fiscal year indicates excess cash at the end of each of the first two months, how might the excess cash be used?arrow_forwardRelevant data from the Poster Companys operating budgets are: Additional data: Capital assets were sold in January for $10,000 and $4,500 in May. Dividends of $4,500 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the yeararrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Financial & Managerial AccountingAccountingISBN:9781337119207Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Financial & Managerial Accounting
Accounting
ISBN:9781337119207
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
What is variance analysis?; Author: Corporate finance institute;https://www.youtube.com/watch?v=SMTa1lZu7Qw;License: Standard YouTube License, CC-BY