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

Monte carlo simulation model, Monte Carlo Simulation Model Monte Carlo...

Monte Carlo Simulation Model Monte Carlo simulation is used to analyse to what extent the valuation of the chosen company is dependent on the assumptions. Monte Carlo simulati

Define condition for fixed-for-floating interest rate swap, What is the ess...

What is the essential condition for a fixed-for-floating interest rate swap to be possible? For a fixed-for-floating interest rate swap to be feasible it is essential for a quali

Non-agency mortgage backed securities, The mortgage-backed securiti...

The mortgage-backed securities dealt with till now are agency mortgage backed securities. There are other MBS which can be for any kind of real estate property.

Net present value of the Lease, how to calculate the net present value when...

how to calculate the net present value when there is company tax rate and rate of return assume that lease is for 2 years payable at the begining of the yr, at the end of two yrs t

Gordon`s dividend capitalisation model , Considering the following informat...

Considering the following information, what is the price of the share as per Gordon’s Model? Details of the Company Net sales Rs.120 lakhs Net profit margin 12.5% Outstandin

White knight, A friendly potential acquirer sought through a goal organizat...

A friendly potential acquirer sought through a goal organization threatened by a less welcome suitor.

Calculate the new interest rate and excel function pv, Continuing growth of...

Continuing growth of the company has required that we issue the company''s corporate debt soon. As you know, in 6 months we plan to issue $10 million worth of 20-year corporate bon

Explain the asset substitution effect, Question: a. Explain what the de...

Question: a. Explain what the debt overhang problem is (following the lines of Myers 1977) make sure that you specify what the relevant conflict of interest is and what are the

Define the types of shareholder, Tactics can be used by company to protect...

Tactics can be used by company to protect itself. Before the bid Types of Shareholder Having the right shareholders on board who can be

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