EBK FINANCIAL ANALYSIS WITH MICROSOFT E
8th Edition
ISBN: 9781337515528
Author: Mayes
Publisher: CENGAGE LEARNING - CONSIGNMENT
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 4, Problem 4P
a.
Summary Introduction
To create: Cash budget for the period of June to December showing closing cash balance if no borrowing made for maintaining the minimum balance.
b.
Summary Introduction
To state: Impact of borrowing from bank at 6 % Interest rate of shortage funds.
c.
Summary Introduction
To state: Impact of investing excess balance in
d.
Summary Introduction
To analyze: Impact of change in contractor policy by scenario analysis and viability of change in policy of the company.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Patricia Smith recently leased space in the Southside Mall and opened a new business, Smith's Coi Shop. Business has been good. but Smith frequently runs out of Cash. This has necessitated late payment on certain orders, which in turn is beginning to cause a problem with suppliers. Smith plans to borrow from the bank to have cash as needed. but first she needs a forecast of just how much she must 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. Smith's purchases must be paid for during the month following the purchase. Smith 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 Smith has agreed to maintain an average bank balance of $6,000 this is her target cash balance. (Disregard till cash, which is insignificant…
Your friend, Catherine Ross, owns Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces. She has contacted you for some assistance because the accounting clerk, George Forrest, recently won a sum of money and decided to resign immediately. Catherine knows that you are completing an accounting course at Cape Breton University and hopes you can prepare the cash budget for the upcoming quarter (April, May and June, 2021).
Catherine has provided you with the budgets completed by George. She has also provided you with additional information that will assist with the completion of the cash budget.
Completed Budgets (April, May, June, and Quarter Total, 2021)
please find the required numerical information from the images attached
REQUIRED:
Prepare a cash budget . Show the budget by month and in total.
What will be reported on the budgeted balance sheet at June 30, 2021 for accounts receivable? Supporting calculations required to earn available…
You are an assistant in the accounting department of Hasher Electronics, a small electronicsretailer. Hasher has a loan that requires the company to maintain a minimum cash balance of$125,000, as reported on its year-end balance sheet. Although Hasher has struggled in recent years,as of yesterday it looked as though Hasher would be able to meet this requirement. The cash balance in Hasher’s general ledger was $130,000 and the company’s credit manager was expecting toreceive a $30,000 electronic funds transfer that day on account from your biggest customer. Yourdepartment supervisor had been worried about meeting the loan requirement, so she had delayedmaking payments to Hasher’s suppliers for several days. But in anticipation of receiving the EFT,she decided yesterday to issue checks to suppliers totaling $15,000.It is now the last day of the fiscal year and your supervisor approaches you with a problem.Your big customer had backed out at the last minute, indicating it had “some…
Chapter 4 Solutions
EBK FINANCIAL ANALYSIS WITH MICROSOFT E
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
- 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,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. Prepare a cash budget for December, January, and February. 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.)arrow_forwardBTB (Pty) Limited is a distributor of PPE to rural health clinics in KZN. Turnover has been good and running expenses are under control, however the owner of the business, Mr Sam Jonas, is concerned that upcoming legal expenses and necessary vehicle repairs may negatively affect the business’ cash flow. He has hired you to prepare a cash budget for the next four months, from July to October 2022. All sales are made on credit and collected as follows: • 40% in the month of the sale; • 35% in the month after the sale; • 15% in the second month after the sale; • 10% will be written off as bad debts. All purchases are made on credit and paid for as follows: • 60% in the month of the purchase and • 40% in the month after the purchase. Total administration expenses (rent, rates stationary etc) will be R14 000 per month. The legal costs will be R34 000 in each of July and August 2022. Major repairs and maintenance to vehicles will cost R45 000 and this amount will be paid in three equal…arrow_forwardBTB (Pty) Limited is a distributor of PPE to rural health clinics in KZN. Turnover has been good and running expenses are under control, however the owner of the business, Mr Sam Jonas, is concerned that upcoming legal expenses and necessary vehicle repairs may negatively affect the business’ cash flow. He has hired you to prepare a cash budget for the next four months, from July to October 2022. All sales are made on credit and collected as follows: • 40% in the month of the sale; • 35% in the month after the sale; • 15% in the second month after the sale; • 10% will be written off as bad debts. All purchases are made on credit and paid for as follows: • 60% in the month of the purchase and • 40% in the month after the purchase. Total administration expenses (rent, rates stationary etc) will be R14 000 per month. The legal costs will be R34 000 in each of July and August 2022. Major repairs and maintenance to vehicles will cost R45 000 and this amount will be paid in three equal…arrow_forward
- Suppose that you have been given a summer job as an intern at Issac Aircams, a company that manufactures sophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which is privately owned, has approached a bank for a loan to help finance its growth. The bank requires financial statements before approving the loan. Required: Classify each cost listed below as either a product cost or a period cost for the purpose of preparing financial statements for the bank. 8 00-45-49 Costs Product Cost / Period Cost 1. Depreciation on salespersons' cars. 2. Rent on equipment used in the factory. 3 lubricants used for machine maintenance Salaries of personnel who work in the finished goods warehouse 5. Soap and paper towels used by factory workers at the end of a shift. 6. Factory supervisors' salaries. 7. Heat, water, and power consumed in the factory. 8. Materials used for boxing products for shipment overseas. (Units are not normally boxed.) 9. Advertising…arrow_forwardBTB (Pty) Limited is a distributor of PPE to rural health clinics in KZN. Turnover has been good and running expenses are under control, however the owner of the business, Mr Sam Jonas, is concerned that upcoming legal expenses and necessary vehicle repairs may negatively affect the business’ cash flow. He has hired you to prepare a cash budget for the next four months, from July to October 2022. All sales are made on credit and collected as follows: • 40% in the month of the sale; • 35% in the month after the sale; • 15% in the second month after the sale; • 10% will be written off as bad debts. All purchases are made on credit and paid for as follows: • 60% in the month of the purchase and • 40% in the month after the purchase. Total administration expenses (rent, rates stationary etc) will be R14 000 per month. The legal costs will be R34 000 in each of July and August 2022. Major repairs and maintenance to vehicles will cost R45 000 and this amount will be paid in three equal…arrow_forwardBTB (Pty) Limited is a distributor of PPE to rural health clinics in KZN. Turnover has been good and running expenses are under control, however the owner of the business, Mr Sam Jonas, is concerned that upcoming legal expenses and necessary vehicle repairs may negatively affect the business’ cash flow. He has hired you to prepare a cash budget for the next four months, from July to October 2022. All sales are made on credit and collected as follows: • 40% in the month of the sale; • 35% in the month after the sale; • 15% in the second month after the sale; • 10% will be written off as bad debts. All purchases are made on credit and paid for as follows: • 60% in the month of the purchase and • 40% in the month after the purchase. Total administration expenses (rent, rates stationary etc) will be R14 000 per month. The legal costs will be R34 000 in each of July and August 2022. Major repairs and maintenance to vehicles will cost R45 000 and this amount will be paid in three equal…arrow_forward
- Katie Murphy is preparing for a meeting with her banker. Her business is finishing its fourth year of operations. In the first year, it had negative cash flows from operations. In the second and third years, cash flows from operations were positive. However, inventory costs rose significantly in Year 4, and cash flows from operations will probably be down 25%. Murphy wants to secure a line of credit from her banker as a financing buffer. From experience, she knows the banker will scrutinize operating cash flows for Years 1 through 4 and will want a projected number for Year 5. Murphy knows that a steady progression upward in operating cash flows for Years 1 through 4 will help her case. She decides to use her discretion as owner and considers several business actions that will turn her operating cash flow in Year 4 from a decrease to an increase. Required 1. Identify two business actions Murphy might take to improve cash flows from operations. 2. Comment on the ethics and possible…arrow_forwardDavis Construction Company has not been doing very well lately. The controller is looking over the invoices for bills that need to be paid this week, and realizes the company is approximately $7,000 short. The only account with excess cash is mandated to be used only for cases of workers' compensation. Can the controller pull the money from that account? O No, that is a short-term investment account, and the money cannot be converted into cash that quickly. O Yes, it is a cash equivalent account, which can be used to supply the money for the bills as long as the money is replaced within the month. O No, that is restricted cash and the money cannot be taken out to cover other expenses. O Yes, it is restricted cash, but as long as the money is replaced within a month of being taken out, it will balance out fine.arrow_forwardYou are a financial adviser with a client in the wholesale produce business that just completed its first year of operations. Due to weather conditions, the cost of acquiring produce to resell has escalated during the latter part of this period. Your client, Javonte Gish, mentions that because her business sells perishable goods, she has striven to maintain a FIFO flow of goods. Although sales are good, the increasing cost of inventory has put the business in a tight cash position. Gish has expressed concern regarding the ability of the business to meet income tax obligations. Required Prepare a memorandum that identifies, explains, and justifies the inventory method you recommend that Ms. Gish adopt.arrow_forward
- Suppose that you have been given a summer job as an intern at Issac Aircams, a company that manufacturessophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which isprivately owned, has approached a bank for a loan to help it finance its growth. The bank requires financialstatements before approving such a loan. You have been asked to help prepare the financial statements andwere given the following list of costs:1. Depreciation on salespersons’ cars.2. Rent on equipment used in the factory.3. Lubricants used for machine maintenance.4. Salaries of personnel who work in the finished goods warehouse.5. Soap and paper towels used by factory workers at the end of a shift.6. Factory supervisors’ salaries.7. Heat, water, and power consumed in the factory.8. Materials used for boxing products for shipment overseas. (Units are not normally boxed.)9. Advertising costs.10. Workers’ compensation insurance for factory employees.11. Depreciation on chairs…arrow_forwardDorothy 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 $5,000 per month, and the rent is $1,700 per month. In addition, she must make a tax payment of $11,000 in December. The current cash on hand (on December 1) is $500, 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…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_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
Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
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