Shows a strong seasonal pattern

Assignment Help Finance Basics
Reference no: EM131086425

Case Study

The sales forecast for your firm for 2014 is $9.1 million.  The cost of processing (production) is 50% of sales.  Sales and administrative expenses are $100,000 per month.  A close look at the sales forecast shows a strong seasonal pattern.  The strongest sales months are February, March, April, and May.

January              $600,000                             July                     $80,000

February            $1,000,000                          August                  $70,000

March                $2,000,000                         September             $60,000

April                  $3,000,000                         October                  $60,000

May                   $2,000,000                         November              $60,000

June                  $100,000                            December              $70,000

Sales are 50% cash sales and 50% credit sales; 80% of the monthly credit sales is received as cash one month following the month of sale.  The remaining 20% of credit sales is received as cash the second month following the month of sale.  

As a result of computer processing equipment operating lease obligations, the firm's processing costs are uniform throughout the year (annual processing costs are uniformly spread over twelve months).  The firm's cash management policy requires the firm to maintain a minimum cash balance of $200,000.  The firm's board of directors decided that in November 2014 it would pay-out a dividend of $ 500,000.  Taxes of $ 200,000 will be paid per quarter (in March, June, September, and December).  A capital outlay of $750,000 will be made in both March and April.

You have had a running discussion with the Chief Financial Officer (CFO) as to the best way meet anticipated monthly cash shortfalls.  The CFO believes in conservative cash management it opts for long-term financing.  This entails financing the firm's cash requirements with an annual long-term loan at 10%, which is based on covering the highest monthly cash shortfall.  The unused portion of acquired funds will be fully invested on a monthly basis at a 6% (annual) interest rate. 

You believe a more cost effective approach would be to finance the firm's cash requirements through a revolving credit agreement at a cost of .5% (annual rate) of the monthly-unused portion of the credit line. The used portion of the credit line will cost 5% (annual rate).  Determine who is right. Provide all supporting calculations including the preparation of an annual cash budget.  In addition, provide a detailed explanation of the advantages and disadvantages of each scenario.  Finally, consider additional alternatives not discussed with/by the CEO. Explain in detail why these alternatives should be considered.  This assignment should be 700 words in length and in APA format.

Reference no: EM131086425

Questions Cloud

Separate commercial and investment banking : Should banks be too big to fail? Should big banks be broken up? Should the Glass-Steagall Act be restored to separate commercial and investment banking operations? Can the U.S. economy function successfully without big banks?
Draw a box which represents factor endowments : Draw (a possible set of) isoquants for the production of the two goods given price. Draw a box which represents factor endowments for each country
Calculating the company debt-to-equity ratio : Boulder Mountain Ski Company has total assets of $417,000,000 and a debt ratio of 0.26. Calculate the company's debt-to-equity ratio.
What are your thoughts about the strategic planning process : How do you utilize the strategic plan? Please describe this plan. (For example, how detailed is it? Is it a long-range plan?) What are your thoughts about the strategic planning process?
Shows a strong seasonal pattern : The sales forecast for your firm for 2014 is $9.1 million.  The cost of processing (production) is 50% of sales.  Sales and administrative expenses are $100,000 per month.  A close look at the sales forecast shows a strong seasonal pattern.  The s..
Discuss the history of your social issue as expressed : Discuss the history of your social issue as expressed in popular culture in general. Define the audience for each of your artifact categories and explore whether this audience has changed in any way. Consider whether this audience is local, global..
Prediction prove correct : At the end of the year, it had a market value of $6 million even though it experienced a loss, or negative net income, of $2.5 million. Did the analyst's prediction prove correct? Explain using the values for total annual return.
Explain how roles of forensic psychology professionals : Describe the two subspecialties to which the roles belong and contribute. Explain how each role contributes to the subspecialty you selected and why.
Shares of cumulative preferred stock outstanding : Figurate Industries has 720,000 shares of cumulative preferred stock outstanding. It has passed the last three quarterly dividends of 2.80 per share and now at the end of the current quarter wishes to distribute a total of 12 million to its shareh..

Reviews

Write a Review

Finance Basics Questions & Answers

  Pass diary passages

Pass diary passages on revaluation of these advantages and liabilities.

  What interest rate expressed as an annual rate

What interest rate, expressed as an annual rate, would your father earn by paying off the loan now rather than making the monthly payments for twenty years? If your father is currently earning 9 percent on his investments, should he pay off the lo..

  Most recent annual reporting period

What are the company's total current liabilities at the end of the previous annual reporting period?

  Prepare a multi-step income statement

Prepare a multi-step income statement and a classified balance sheet in proper form using accrual accounting.

  Find an appropriate solution

You have been hired by Nobody State University (NSU) as a consultant to help the university with how to increase their total revenue. The university has been struggling in recent years, so they have hired you to help them in their last attempt to ..

  Important determinant of an investment

Question 1. The most important determinant of an investment's portfolio risk is which of the following?

  The risk-free rate of interest

The risk-free rate of interest is 3% and the market risk premium is 5%.

  What is the yield to maturity

A $1000 face value bond with six years to maturity and a twelve percent semiannual coupon currently sells for $950. What is the yield to maturity?

  Genaro needs to capture a return of 40 percent for his

1.genaro needs to capture a return of 40 percent for his one-year investment in a property. he believes that he can

  Consider how economic conditions affect the default risk

how the yield curve may respond to prevailing conditions.consider how economic conditions affect the default risk

  What amount of the payroll department costs

What amount of the payroll department costs will be allocated to the molding department?

  Why does the us government collect data on inventory levels

Why does the US government collect data on inventory levels? Why do inventories matter?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd