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

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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