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

  The saunders investment bank

The Saunders Investment Bank has the following financing outstanding.  Debt:  120,000 bonds with a coupon rate of 8 percent and a current price quote of 110; the bonds have 20 years to maturity. 290,000 zero coupon bonds with a price quote of 17.5 a..

  Portion of ethics training for new employees

A new group of employees has just started at your company. Your boss has asked you to assist in a portion of the ethics training for the new employees.

  Calculate its per share value using the ddm

Calculate its per share value using the DDM or another method discussed in Chapter 9. Then find the current market value of a share of the stock. Compare that two. Can you explain the similarity or difference?

  How much do you need to put away each month

13. You want to retire as a millionaire. How much do you need to put away each month if:

  Given the following information determine a accounts

given the following information find a accounts receivable b marketable securities c fixed assets d long term debt.

  Aggressive approach to financing working capital

Which of the following would be consistent with a more aggressive approach to financing working capital?

  Select a current product with which you are familiar and

select a current product with which you are familiar and pitch a new integrated marketing communication plan imc to

  A financial analyst at buckco ltd wants to compute the

a financial analyst at buckco ltd. wants to compute the companys weighted average cost of capital wacc using the

  Suppose you are buying your first condo for 145000 and you

suppose you are buying your first condo for 145000 and you will make a 15000 down payment. you have arranged to finance

  Capital budgeting and capital structure

Capital Budgeting and Capital Structure

  Analyze marks budget as a financial planning tool for

analyze marks budget as a financial planning tool for making decisions in the following situations. in each case how

  It will reach maturity in 12 years at which time it will

you buy a bond for 1154 that pays 40 interest every 6 months. it will reach maturity in 12 years at which time it will

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