Financial analysis, Financial Management

Assignment Help:
Task

I am sure you are aware that the corporate annual meeting is coming up soon. As part of the Treasurer''s presentation, I have been asked to propose a Special Capital Requirements Report for the following cash needs:

• Project Alpha -- capital required: $1,250,000, March 1, 2013
• Project Beta - capital required: $240,000 per month, Oct. 2012 through and including the end of 2014
• Pension funding through 2014 (our underwriters advise that an annual funding of $4,500,000, due at the end of December, will be needed for 2012, with increases thereafter of 7% per annum)
• Purchase of a Tesla Roadster for the Chairman of the Board (for his birthday in September at $101,500)
• Management retention bonuses for 2012 and 2013, payable, as usual, in March of the following year, not to exceed $10 million per year.

These are all special projects, requiring funding from sources other than operating revenues. I will handle scheduling the appropriate deposits into the Special Capital account at Penultimate National Bank and, except as specified below, you are not to concern yourselves with where funding may be obtained, only with how much will be needed.
Also, sinking fund requirements for the Series of 2025 Subordinated Debentures will be funded from the Special Capital account in single payments at the end of 2013 and 2014, only (that is, no more than two years of sinking fund payments need be funded - disregard any future payments). The indenture requires redemption of 2% of the $600 million issue per year. Retirement of the balance of the bonds will be funded elsewhere.

At the last meeting, the Board accepted the offer of Western Widgets for purchase of our widget winding facility in West Winona which will produce net proceeds in the amount of $16,500,000. This sale will be completed this month, and on the first of next month I will be depositing those funds in the Penultimate National Bank Special Capital account at 4.5% to provide at least a start on funding these projects. (This same 4.5% rate should be used for all discounting computations without regard to the company''s cost of capital).

In addition, it is possible, but not certain, that the Wilmer Widget Wrapping plant may also be sold for as much as $20 million (net) in June 2013. Since this is not certain, it should be treated as an alternative partial solution to the cash needs problem.
To assist me in putting together my report, please prepare the following for distribution to the Board Members, and attach them to your explanatory memo:

1. A cash requirements budget for the above expenditures.

2. A handout for the Board Members showing the present value of the total expenditures by item, how you calculated your results and why you did it the way you did. Some of the Members have no substantial financial training.
HINT: liberal use of appendices is recommended!!

3. Your estimate of the monthly deposits required to meet the above expenses, assuming the sale of the West Winona facility, with an explanation for the Board as to how you came up with that figure.

As usual, I am sure it is unnecessary to point out again that most of the members of the Board of Directors have no particular training in accounting and are interested only in a clear explanation of the amounts and application of the funds discussed in this memo. Accordingly, I do not expect you to use GAAP - I expect you to use common sense! Give me documents I can present to the members and that they can understand. In other words I do not expect you to use any standard financial statement forms. In addition, please disregard all tax issues.

I will be accompanying the Chairman on an important fact-finding mission to Tahiti next week, and, accordingly, will not be available to clarify any of the above details. If there are facts you feel need to be further developed, you will have to make appropriate assumptions (and specify any such assumptions made in your work product).
Don''t forget that salary reviews are scheduled for the week following the Meeting.

Related Discussions:- Financial analysis

Calculating investment statistics and graphing output, Step 1) Opportunity ...

Step 1) Opportunity Set Graph:Combine 2 of your stocks (Ignore the other 2 stocksfor this step only).  Construct an investment opportunity set (the curved set) between the two risk

Define some instances of restrictive covenants, What are some instances of ...

What are some instances of restrictive covenants that might be fixed in a bond's indenture? An indenture might involve limitations on future borrowings, restrictions on dividen

Cash outflows and income statement of a company, a. You only need to compl...

a. You only need to complete the 2012 column, leave the 2011 column as is. b. Base you net income and certain other information needed from the income statement you completed in

Define the pros and cons of commercial paper, What are the pros and cons of...

What are the pros and cons of commercial paper relative to bank loans for a company seeking short-term financing? Commercial paper is generally a cheaper source of short-term fin

Derivatives, Derivatives - Financial instruments whose value varies with va...

Derivatives - Financial instruments whose value varies with value of an underlying asset (like a stock, BOND, commodity or currency) or index like interest rates. Financial instrum

Walter''s Model, Explain the effect of different dividend policies on the v...

Explain the effect of different dividend policies on the value of share respectively as per the walter model in Case 1: Dividend payout ratio is 50% Case 2: Dividend payout ratio

Advanced Accounting, Balance Sheets Peony Ltd. Aster Ltd. ...

Balance Sheets Peony Ltd. Aster Ltd. Assets: Cash $ 62,500 $ 25,000 Accounts receivable 187,500 200,000 Inventori

Payback period, Payback Period It is an amount of time, mainly measured...

Payback Period It is an amount of time, mainly measured in years; it takes previously the undiscounted cash inflows from a project equal the cash outflow. It indicates the leng

#WALTOR''S MODEL., CAPITALISATION RATE=0.01 EARNINGS PER SHARE(E)=10 ASSUME...

CAPITALISATION RATE=0.01 EARNINGS PER SHARE(E)=10 ASSUME RATE OF RETURNS ON INVESTMENTS (R):15

Buy down loans, The buy down loan is similar to the PAM; however, it ...

The buy down loan is similar to the PAM; however, it is the seller of the property and not the buyer/borrower who places cash in a segregated account so that additional

Write Your Message!

Captcha
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