How large a credit line should hammarlund request

Assignment Help Finance Basics

Reference no: EM131245600

Part A: A quarterly Preferred Stock Dividend of $45,000 will be paid in December, as will a 25 cent per share Common Dividend.

A minimum cash balance of $1,500,000 is dictated by top management.

Ending cash in September is $100,000 (and, thus a notes payable balance of $1,900,000 is on the books at that time).

How large a credit line should Hammarlund request from its Bank?

Assumption for use in the 2016 Proforma Income Statement

Sales forecast for 2016: $70,000,000

What do you forecast Hammarlund's Earnings Per Share to be in 2016?

Assumptions for use in the 2016 Proforma Balance Sheet

A Minimum Cash & Marketable Securities Balance of $1.5 million is desired. Accounts Receivable will equal 45 days of forecasted sales.

Ending Inventory will increase to $20 million.

Net Fixed Assets will increase to $37 million.

Accounts Payable will shrink to $2.2 million as creditors demand faster payments.

Notes Payable will be the value you calculate for December bank borrowings in your Cash Budget.

Long-term debt, common and preferred stock will be unchanged from 2015.

Retained earnings will increase based upon the estimate in your proforma income statement for 2016 less a $1 per share common dividend.

What amount of external financing should be obtained? What securities should be issued to obtain the financing? (Please consider the analysis you did in Part A in answering this question).

Part B: In order to assess short-term and longer-term financing needs, the Board would like you to prepare a Quarterly Cash Budget for the 4^th quarter of 2016. They selected this quarter because it is expected to contain the largest bank borrowing needs of the year. Also, the Board would like you to prepare a proforma Income Statement for 2016 using the Percent of Sales method, and a proforma Balance Sheet for 2016 using the Judgmental Method. The Board Directed Mr. Hammarlund and Mr. Miller to make all relevant personnel and information available to you, and they have done so. While much of the information needed is provided below, you will also need to refer to the financial statements and other information previously provided with Part A of the project. With this information you can develop the necessary cash budget and proformas and answer the questions related to the Cash Budget, proforma Income Statement, and Proforma Balance Sheet.

Assumptions for use in the Cash Budget - Actual or forecast sales (000s):

August	September	October	November	December	January
$3,000,000	$4,000,000	$7,000,000	$7,000,000	$5,000,000	$10,000,000

All sales are on credit. Ten percent of the accounts receivable are collected in the month of sale, 50% are collected in the following month, and 40% are collected in the second month after the sale.

No additional receipts are expected.

Purchases are 35% of the NEXT month's forecast sales.

Additional production costs are expected to be $1,000,000, $700,000, and $1,500,000 in October, November, and December, respectively.

S, G & A expense is budgeted at $1,200,000 per month

Expenditures related to plant technology upgrades will be $500,000 each month

Income Taxes of $500,000 will be paid in December

A semi-annual interest payment of $420,000 will be paid in October.

Reference no: EM131245600

Questions Cloud

Why have the results often not lived up to expectations : Explain the theoretical and practical arguments in support of import substitution policies. What have been some of the weaknesses of these policies in practice, and why have the results often not lived up to expectations?

What are benefits and consequences for conducting training : Make a final decision on the content or skills to train your learners on. Choose a subject that will allow you to gauge their performance before and after the training you have completed. Why does this training need to be done? What are the benefi..

What will be the immediate effects on the earnings per share : What will be the immediate effects on the earnings per share of Jordan if it acquires Konrad or Loomis at their current market prices by the exchange of stock based on the current market prices of each of the companies?

What are the possibilities advantage of export promotion : What are the possibilities, advantages, and disadvantages of export promotion in developing nations with reference to specific types of commodities (e.g., primary food products, raw materials, fuels, minerals, manufactured goods)?

How large a credit line should hammarlund request : Ending cash in September is $100,000 (and, thus a notes payable balance of $1,900,000 is on the books at that time). How large a credit line should Hammarlund request from its Bank

What factors have limited the benefits : In what ways is the emergence of China as the "workshop of the world" an opportunity for other developing countries, and in what ways is it a threat?

Critics of international trade from developing countries : Critics of international trade from developing countries sometimes claim that present trading relationships between developed and underdeveloped countries can be a source of "antidevelopment" for the latter and merely serve to perpetuate their wea..

Why might china want to keep the price of the yuan low : Why might China want to keep the price of the yuan low? Who suffers from this policy? If another nation raises tariffs on U.S. products, should the United States retaliate with similar trade barriers?

Prepare a brief update on longer-term impacts of the 2008 : Prepare a brief update on longer-term impacts of the 2008 global financial crisis. Have any of the later developments proved unexpected (or previously considered unlikely)? Where problems have lessened, do you think they could return?

Reviews

len1245600

10/17/2016 6:53:56 AM

Here is the part that i asked to do the pro forma based on percent method sales on and what I’m asking to do based from the numbers sent from early today emails these see the attachment For The Assumption for use in the pro forma 2016!!

Write a Review

Required(*) Message

User Account

All Pages