Reference no: EM131368413
You were recently hired to improve the financial condition of Idaho Springs Hardware, a small chain of three hardware stores in Colorado. On your first day the owner, Chuck Vitaska, told you that the biggest problem facing the firm has been periodic unexpected cash shortages that have made it necessary for him to delay wage payments to his employees. Having recently received a degree in finance, you immediately realize that your first priority is to develop a cash budget and to arrange for a shortterm borrowing agreement with the firm's bank. After looking at the firm's past financial records, you developed a sales forecast for the remainder of the year, as is presented in the following table.
In addition to the seasonality of sales, you have observed several other patterns. Individuals account for 40% of the firm's sales, and they pay in cash. The other 60% of sales are to contractors with credit accounts, and they have up to 60 days to pay. As a result, about 20% of sales to contractors are paid one month after the sale, and the other 80% is paid two months after the sale. Each month the firm purchases inventory equal to about 45% of the following month's sales. About 30% of this inventory is paid for in the month of delivery, while the remaining 70% is paid one month later.
Each month the company pays its hourly employees a total of $9,000, including benefits. Its salaried employees are paid $12,000, also including benefits. In the past, the company had to borrow to build its stores and for the initial inventories. This debt has resulted in monthly interest payments of $4,000 and monthly principal payments of $221. On average, maintenance at the stores is expected to cost about $700 per month, except October to December when snow removal costs will add about $200 per month. Sales taxes are 7% of quarterly sales and must be paid in June, September, and December. Other taxes are also paid during those months and are expected to be about 4% of quarterly sales in each of those months. The owner wishes to maintain a cash balance of at least $12,000 to limit the risk of cash shortages. The cash balance at the end of May is expected to be $15,000 (before any borrowing or investing).
a. Create a simple cash budget for Idaho Springs Hardware for June to December. Note that your records indicate that sales in April and May were $51,000 and $57,000, respectively. January 2013 sales are expected to be $36,000. What would be the ending cash balances if the firm does not borrow to maintain its $12,000 minimum?
b. Now assume that the firm can borrow from the bank at a rate of 9% per annum to maintain its liquidity and meet its required minimum cash balance. In addition, if the firm has funds in excess of the minimum, it will use the excess to pay off any previous balance.
c. While negotiating a line of credit, the firm's bank offered to sweep any cash in excess of the minimum into a money market fund that will return an average of 4% per year after expenses. If you accept this offer, how will it affect the firm's ending cash balances and need to borrow in each month? Note that the firm must have paid off all shortterm loans before any excess cash can be invested, and invested funds will be used instead of borrowing when needed.
d. After completing the cash budget, you begin to think of ways to further reduce the firm's borrowing needs. One idea that comes to mind is changing the firm's credit policy with contractors because they seem to always pay at the last minute. Three scenarios come to mind:
(1) In the best case, contractors are required to pay for 100% of their purchases during the month after the sale. You believe that this would cause a 5% decline in sales.
(2) In the base case, everything remains as already outlined.
(3) In the worst case, contractors would be required to pay for 100% of their purchases during the month after the sale, and you believe that this would cause a 20% drop in sales. You decide to use the Scenario Manager to evaluate these scenarios. To summarize the impact of the change, you will examine the impact on the firm's maximum borrowing needs and cumulative net interest cost (after accounting for investment earnings). In your opinion, should the firm change its credit policy?
|
Create your own inductive argument
: Create your own inductive argument. It needs to have more than one premise, and must have a conclusion that follows from those premises.
|
|
Understanding about the attacker and the work environment
: What about employee awareness and/or mindset may have led to the breach? What steps might management have taken to prepare for or prevent this breach? Based on your understanding about the attacker and the work environment, how might the company ward..
|
|
What is the purpose of opt-in email
: What methods does Dell use to leverage Internet marketing? What is the purpose of opt-in email? What are some ways Amazon takes advantage of Internet advertising?
|
|
Analyze the key driving forces to increase interdependence
: PAD 540-Analyze the key driving forces to increase interdependence. Recommend two actions that states can take in order to increase capacity to respond to the challenges of globalization. Justify your response.
|
|
Create a simple cash budget for idaho springs hardware
: In the best case, contractors are required to pay for 100% of their purchases during the month after the sale. You believe that this would cause a 5% decline in sales.
|
|
State a theme in the first or second paragraph
: Give a brief plot summary of the film. Mention major actors/actress with their characters' names.- State a "theme" in the first or second paragraph.
|
|
Assessment of the case study
: Write 2-3 page explaining the laws of the internet has benefit or limited E-commerce. Provide specific examples. You may use additional data sources to supplement your assessment of the case study. Use APA standards in citing your data sources.
|
|
What are some of things lockheed does to make the training
: Discuss the importance of ethics training and employee involvement. What are some of the things Lockheed does to make the training process interesting and worthwhile?
|
|
How much would this change cost
: How easy (difficult) is it to change wiring from twisted pair to fiber optic? Can we use the same network cards in the PCs, or do we need to change them? How much would this change cost?
|