Intermediate Financial Management (MindTap Course List)
13th Edition
ISBN: 9781337395083
Author: Eugene F. Brigham, Phillip R. Daves
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 21, Problem 14P
Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl’s Doll Shop. Business has been good, but Koehl frequently runs out of cash. This has necessitated late payment on certain orders, which is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank to have cash ready as needed, but first she needs a
Sales are made on a cash basis only. Koehl’s purchases must be paid for during the following month. Koehl pays herself a salary of $4,800 per month, and the rent is $2,000 per month. In addition, she must make a tax payment of $12,000 in December. The current cash on hand (on December 1) is $400, but Koehl has agreed to maintain an average bank balance of $6,000—this is her target cash balance. (Disregard the amount in the cash register, which is insignificant because Koehl keeps only a small amount on hand in order to lessen the chances of robbery.)
The estimated sales and purchases for December, January, and February are shown in the following table. Purchases during November amounted to $140,000.
- a. Prepare a cash budget for December, January, and February.
- b. Suppose that Koehl starts selling on a credit basis on December 1, giving customers 30 days to pay. All customers accept these terms, and all other facts in the problem are unchanged. What would the company’s loan requirements be at the end of December in this case? (Hint: The calculations required to answer this part are minimal.)
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop. Business has been good, but Koehl frequently runs out of cash. This has necessitated late payment on certain orders, which is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank
to have cash ready as needed, but first she needs a forecast of how much she should borrow. Accordingly, she has asked you to prepare a cash budget for the critical period around Christmas, when needs will be especially high.
Sales are made on a cash basis only. Koehl's purchases must be paid for during the following month. Koehl pays herself a salary of $4,500 per month, and the rent is $2,600 per month. In addition, she must make a tax payment of $10,000 in December. The current cash on hand (on December 1) is $400, but
Koehl has agreed to maintain an average bank balance of $4,500 - this is her target cash balance. (Disregard the amount in the cash register, which is…
Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop. Business has been good, but Koehl frequently runs out of cash. This has necessitated late payment on certain orders, which is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank to have cash ready as needed, but first she needs a forecast of how much she should borrow. Accordingly, she has asked you to prepare a cash budget for the critical period around Christmas, when needs will be especially high.
Sales are made on a cash basis only. Koehl's purchases must be paid for during the following month. Koehl pays herself a salary of $4,000 per month, and the rent is $2,900 per month. In addition, she must make a tax payment of $14,000 in December. The current cash on hand (on December 1) is $350, but Koehl has agreed to maintain an average bank balance of $6,500 - this is her target cash balance. (Disregard the amount in the cash register, which is…
Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop. Business has been good, but Koehl frequently runs out of cash.
This has necessitated late payment on certain orders, which is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank to have cash ready as
needed, but first she needs a forecast of how much she should borrow. Accordingly, she has asked you to prepare a cash budget for the critical period around Christmas,
when needs will be especially high.
Sales are made on a cash basis only. Koehl's purchases must be paid for during the following month. Koehl pays herself a salary of $4,100 per month, and the rent is
$1,800 per month. In addition, she must make a tax payment of $14,000 in December. The current cash on hand (on December 1) is $800, but Koehl has agreed to
maintain an average bank balance of $5,500 - this is her target cash balance. (Disregard the amount in the cash register, which is…
Chapter 21 Solutions
Intermediate Financial Management (MindTap Course List)
Ch. 21 - a. Working capital; net working capital; net...Ch. 21 - Prob. 2QCh. 21 - Is it true that, when one firm sells to another on...Ch. 21 - What are the four elements of a firm’s credit...Ch. 21 - Prob. 5QCh. 21 - Prob. 6QCh. 21 - Prob. 7QCh. 21 - Is it true that most firms are able to obtain some...Ch. 21 - What kinds of firms use commercial paper?Ch. 21 - Prob. 1P
Ch. 21 - Medwig Corporation has a DSO of 17 days. The...Ch. 21 - What are the nominal and effective costs of trade...Ch. 21 - A large retailer obtains merchandise under the...Ch. 21 - A chain of appliance stores, APP Corporation,...Ch. 21 - Prob. 6PCh. 21 - Calculate the nominal annual cost of nonfree trade...Ch. 21 - If a firm buys on terms of 3/15, net 45, but...Ch. 21 - Grunewald Industries sells on terms of 2/10, net...Ch. 21 - The D.J. Masson Corporation needs to raise...Ch. 21 - Negus Enterprises has an inventory conversion...Ch. 21 - Strickler Technology is considering changes in its...Ch. 21 - Payne Products had $1.6 million in sales revenues...Ch. 21 - Dorothy Koehl recently leased space in the...Ch. 21 - Suppose a firm makes purchases of $3.65 million...Ch. 21 - The Thompson Corporation projects an increase in...Ch. 21 - The Raattama Corporation had sales of $3.5 million...Ch. 21 - Karen Johnson, CFO for Raucous Roasters (RR), a...Ch. 21 - Prob. 2MCCh. 21 - Prob. 3MCCh. 21 - Prob. 4MCCh. 21 - Prob. 5MCCh. 21 - Prob. 6MCCh. 21 - Prob. 7MCCh. 21 - Prob. 8MCCh. 21 - What is the impact of higher levels of accruals,...Ch. 21 - Prob. 10MCCh. 21 - Prob. 11MCCh. 21 - Prob. 12MCCh. 21 - Prob. 13MCCh. 21 - Prob. 14MCCh. 21 - Prob. 15MCCh. 21 - Prob. 16MC
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- You are working as a summer intern at a rapidly growing orgainc food distribution. Part of your responsibility is to assist in the accounts payable department. You notice that most of the bills are not paid with in discount period. The manager of the accounts payable sees the bills are organized by vendor, like the accounts payable ledger, and she is too busy to keep track of the discounts period. Besides, the owner has told her that The 1% and 2% discount available or not worth worrying about. 1. Explain to the owner why it is expensive not to take it advantage to cash discounts on credit purchases. suggest a way to file (organize) suppliers invoices so that they are paid with in the discount period.arrow_forwardYou are working as a summer intern at a rapidly growing organic food distributor. Part of your responsibility is to assist in the accounts payable department. You notice that most bills from suppliers are not paid within the discount period. The manager of accounts payable says the bills are organized by vendor, like the accounts payable ledger, and she is too busy to keep track of the discount periods. Besides, the owner has told her that the 1% and 2% discounts available are not worth worrying about.arrow_forwardNatalie decides that she cannot afford to hire John to do her accounting. One way that she can ensure that her cash account does not have any errors and is accurate and up-to-date is to prepare a bank reconciliation at the end of each month. Natalie would like you to help her. She asks you to prepare a bank reconciliation for June 2020 using the information below.Please refer to the image attached Additionally, take the following information into account. On June 30th, there were two outstanding checks: #595 for $238 and #604 for $297. Premier Bank made a posting error to the bank statement: Check #603 was issued for $425, not $452. The deposit made on June 20 was for $125, which Natalie received for teaching a class. Natalie made an error in recording this transaction. The electronic funds transfer (EFT) was for Natalie’s cell phone use. Remember that she uses this phone only for business. The NSF check was from Ron Black. Natalie received this check for teaching a class to Ron’s…arrow_forward
- Case Study: Hassam runs a fruit stall at the local market and at the end of each day he banks the cash in the cash register. the cash register records each sale and can provide a total for each day but Hassam believes that often the staffs are too busy and do not always enter the sales in the cash register but simply put the cash in the till. the total from the cash register is produced each month for the budiness's accountant to prepare financial statements. Recently, Hassam employed a university student to work on weekends and he is concerned that after this the daily amount banked seems to have decreased even though Hassam feels that sales have not really changed. the student often talks about how he spends his evenings at the casino in the hope of winning enough to pay for his university studies so that he doesn't have to work every weekend. reqiured: please answer this question by listing to Hassam 5 controls he could put in place to minimize the risk of one of his employees…arrow_forwardSal Shirey is an owner of a small business. His company has recently borrowed a large amount of funds to finance the construction of a large building addition, as well as, the purchase of equipment and machinery. Shirey's banker requires him to submit quarterly financial statements so that he can monitor the financial health of his business. The bank has warned that if profit margins decline, the interest rate on the loan may need to be increased in order to reflect additional risk. Shirey knows that profit may decline this year. As he is preparing the year-end adjusting entries, Sal decides, for depreciation purposes, to treat all long-term asset purchases as though they occurr on the first day of the month following the month of purchase. 1. Is there an ethical issue with the implementation of this rule? If so, what is it?2. When should depreciation first be recorded?3. What impact will Shirey's approach to recording depreciation have on the financial statements?arrow_forwardSecond Republic Bank is a lending company that operates in the Southeastern United States. Current economic conditions have kept lending rates low, which limits the revenue potential for Second Republic. The bank manager, Vivian Caldwell is concerned about understanding and then controlling costs, and she decided to try out time-driven ABC. As a pilot, she decided to focus on understanding the cost of taking a customer's loan application. Vivian knew that it took longer to collect applicant information for a mortgage than it did for other types of loans, like auto loans or unsecured loans, but did not know the cost differences, so she collected the following information from a regional branch office. There are two loan application specialists, each earning $55,000 per year. Vivian determined that fringe benefits average 30% of salary and that the office support costs for an employee (computer, office space, etc.) in that regional branch averaged $5,300 per employee. Factoring in time…arrow_forward
- Your friend, Wendy Geiger, owns a small retail store that sells candies and nuts. Geiger acquires her goods from a few select vendors. She generally makes purchase orders by phone and on credit. Sales are primarily for cash. Geiger keeps her own manual accounting system using a general journal and a general ledger. At the end of each business day, she records one summary entry for cash sales. Geiger recently began offering items in creative gift packages. This has increased sales substantially, and she is now receiving orders from corporate and other clients who order large quantities and prefer to buy on credit. As a result of increased credit transactions in both purchases and sales, keeping the accounting records has become extremely time- consuming. Geiger wants to continue to maintain her own manual system and calls you for advice. Write a memo to her advising how she might modify her current manual accounting system to accommodate the expanded business activities. Geiger is…arrow_forward(Receivables Management) As the manager of the accounts receivable department for Beavis Leather Goods, Ltd., you recently noticed that Kelly Collins, your accounts receivable clerk who is paid $1,200 per month, has been wearing unusually tasteful and expensive clothing. (This is Beavis’s first year in business.) This morning, Collins drove up to work in abrand new Lexus.Naturally suspicious by nature, you decide to test the accuracy of the accounts receivable balance of $192,000 as shown in the ledger. The following information is available for your first year (precisely 9 months ended September 30, 2017) in business.(1) Collections from customers $188,000(2) Merchandise purchased 360,000(3) Ending merchandise inventory 90,000(4) Goods are marked to sell at 40% above cost.InstructionsAssuming all sales were made on account, compute the ending accounts receivable balance that should appear in the ledger, noting any apparent shortage. Then, draft a memo dated October 3, 2017, to Mark…arrow_forwardNatalie decides that she cannot afford to hire John to do her accounting. One way thatshe can ensure that her cash account does not have any errors and is accurate and upto-date is to prepare a bank reconciliation at the end of each month.Natalie would like you to help her. She asks you to prepare a bank reconciliation forJune 2020 using the following information.arrow_forward
- Assume that you are a cashier, and your manager requires that you immediatelyenter each sale when it occurs. Recently, lunch hour traffic has increased, and theassistant manager asks you to avoid delays by taking customers’ cash and makingchange without entering sales. The assistant manager says she will add up cash andenter sales after lunch. She says that, in this way, customers will be happy to, andthe register record will always match the cash amount when the manager arrives atthree o’clock.The advantages to the process proposed by the assistant manager include improvedcustomer service, fewer delays, and less work for you. The disadvantage is that the assistant manager could steal cash by simply recording less sales than the cashreceived and them pocketing the excess cash. You decide to reject her suggestionwithout the manager’s approval and to confront her on the ethics of her suggestion.Propose and evaluate two other courses of action you might consider and explainwhyarrow_forwardAssume that you are a cashier and your manager requires that you, as cashier, immediately enter each sale when it occurs. Recently, lunch hour traffic has increased and the assistant manager asks you to avoid delays by taking customers’ cash and making change without entering sales. The assistant manager says she will add up cash and enter sales after lunch. She says that, in this way, the customers will be happy and the register record will always match the cash amount when the manager arrives at three o’clock. The advantage of the process proposed by the assistant manager includes improved customer service, fewer delays, and less work for you. The disadvantage is that the assistant manager could steal cash by simply recording less sales than the cash received and pocketing the excess cash. You decide to reject her suggestion without the manger's approval and to confront her on the ethics of her suggestion. Required: Propose and evaluate two other courses of action you might…arrow_forwardSecond Republic Bank is a lending company that operates in the Southeastern United States. Current economic conditions have kept lending rates low, whichlimits the revenue potential for Second Republic. The bank manager, Vivian Caldwell is concerned about understanding and then controlling costs, and shedecided to try out time-driven ABC. As a pilot, she decided to focus on understanding the cost of taking a customer’s loan application. Vivian knew that it tooklonger to collect applicant information for a mortgage than it did for other types of loans, like auto loans or unsecured loans, but did not know the cost differences,so she collected the following information from a regional branch office.There are two loan application specialists, each earning $112,320 per year. Vivian determined that fringe benefits average 10% of salary and that the officesupport costs for an employee (computer, office space, etc.) in that regional branch averaged $16,848 per employee. Factoring in time off…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY