Question

In: Accounting

Mini Case – Cash budget and Short-term financial planning Middleton Manufacturing You have recently been hired...

Mini Case – Cash budget and Short-term financial planning Middleton Manufacturing

You have recently been hired by Middleton Manufacturing to work in the newly established treasury department. Middleton Manufacturing is a small company with disorganized systems and the finance area needs work.

The company currently has a beginning cash balance of $100,000 and plans to buy new machinery during the fourth quarter for $500,000, paying cash. The company maintains a minimum cash balance of $100,000 and invests any excess cash in a money market account.   The company borrows short-term from CIBC, paying 1.5 percent interest per quarter on all short-term borrowing, and receives 1% per quarter from any balances in its money market account. The company pays $110,000 of interest each quarter for its long-term debt.

All sales and purchases are made on credit. Credit sales for each of the next four quarters:

Q1 : $1,360,000 .... Q2 : $1,440,000 .... Q3 : $1,500,000 .... Q4 : $1,600,000

The forecasted credit sales for Q1 of next year is $1,420,000. Middleton currently has an average collection period of 45 days and beginning accounts receivable of $500,000. Twenty percent of the beginning balance of accounts receivable balance is from a company that has just entered bankruptcy. This account receivable will not be collected.

Purchases are done one quarter in advance and represent 50% of the next quarter’s sales (cost of inventory sold is 50% of sales). Suppliers are paid after 30 days. Wages, taxes, and other costs average 30 percent of gross sales and are paid in cash in same quarter when they occur.

Required: You have been asked to prepare a cash budget and short-term financial plan for the company under the current policies.

Solutions

Expert Solution

The Answer is attached herewith.


Related Solutions

You have recently been hired by Middleton Manufacturing to work in the newly established treasury department....
You have recently been hired by Middleton Manufacturing to work in the newly established treasury department. Middleton Manufacturing is a small company with disorganized systems and the finance area needs work. The company currently has a beginning cash balance of $100,000 and plans to buy new machinery during the fourth quarter for $500,000, paying cash. The company maintains a minimum cash balance of $100,000 and invests any excess cash in a money market account. The company borrows short-term from CIBC,...
Explain how the cash budget is used in short-term financial planning
Explain how the cash budget is used in short-term financial planning
CORP FIN Week 6 DQ #1 (Short-Term Financial Planning) Imagine you have just been hired as...
CORP FIN Week 6 DQ #1 (Short-Term Financial Planning) Imagine you have just been hired as the Treasurer and CFO of a new company which has customers in 50 states and is a spin-off from an existing larger company, and as a result of this separation, you need to build a cash management infrastructure from scratch. Based on what you've read this week and your other research (as well as business sense), what are your most significant concerns in this...
Case: You have recently been hired as an OR nurse at Community Hospital. Recently divorced and...
Case: You have recently been hired as an OR nurse at Community Hospital. Recently divorced and the mother of two very small children, you were thrilled and relieved to get a job with these hours at the only hospital in this small mid-western city. However, on your second day, you are confronted with an unusual situation. A 35-year-old woman is scheduled to undergo the surgical removal of a benign uterine tumor. While preparing for surgery, you discover that the two...
You have been hired by Patterson Planning Corp., an events planning company that recently had a...
You have been hired by Patterson Planning Corp., an events planning company that recently had a fire in which some of the accounting records were damaged. In reviewing the fixed asset records, you find three depreciation schedules that are not labeled. They are listed in the following table. One of the assets has a depreciation rate of $4.30 per hour. Year Schedule A Schedule B Schedule C 1 $8,000.00 $10,125.00 $8,600.00 2 4,800.00 13,500.00 6,450.00 3 2,880.00 13,500.00 7,310.00 4...
You have been hired by Patterson Planning Corp., an events planning company that recently had a...
You have been hired by Patterson Planning Corp., an events planning company that recently had a fire in which some of the accounting records were damaged. In reviewing the fixed asset records, you find three depreciation schedules that are not labeled. They are listed in the following table. One of the assets has a depreciation rate of $4.40 per hour. Year Schedule A Schedule B Schedule C 1 $6,000.00 $10,125.00 $8,800.00 2 3,600.00 13,500.00 6,600.00 3 2,160.00 13,500.00 7,480.00 4...
You have been hired by Patterson Planning Corp., an events planning company that recently had a...
You have been hired by Patterson Planning Corp., an events planning company that recently had a fire in which some of the accounting records were damaged. In reviewing the fixed asset records, you find three depreciation The systematic periodic transfer of the cost of a fixed asset to an expense account during its expected useful life. schedules that are not labeled. They are listed in the following table. One of the assets has a depreciation rate of $4.50 per hour....
Mini Case Assume you have just been hired as a business manager of PizzaPalace, a regional...
Mini Case Assume you have just been hired as a business manager of PizzaPalace, a regional pizza restaurant chain. The company’s EBIT was $120 million last year and is not expected to grow. PizzaPalace is in the 25% state-plus-federal tax bracket, the risk-free rate is 6 percent, and the market risk premium is 6 percent. The firm is currently financed with all equity, and it has 10 million shares outstanding. When you took your corporate finance course, your instructor stated...
You have been hired as an expert witness in a federal antitrust case. You are planning...
You have been hired as an expert witness in a federal antitrust case. You are planning your strategy for determining whether or not your client (the defendant in the case) has engaged in predatory pricing. How will you get started? In general what is your strategy? What must you do to successfully defend your client?
KEASER MANUFACTURING WORKING CAPITAL MANAGEMENT You have recently been hired by Keaser Manufacturing to work in...
KEASER MANUFACTURING WORKING CAPITAL MANAGEMENT You have recently been hired by Keaser Manufacturing to work in its established treasury department. Keaser Manufacturing is a small company that produces highly customized cardboard boxes in a variety of sizes for different purchasers. Adam Keaser, the owner of the company, works primarily in the sales and production areas of the company. Currently, the company basically puts all receivables in one pile and all payables in another, and a part-time bookkeeper periodically comes in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT