Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

Background:

You have been provided the Balance Sheet and Income Statement for Winnebago as of August 25, 2006. The value of the stock of a company can be recognized by computing the present value of the cash flows produced by the company and available to stock holders. Winnebago has historically repurchased big amounts of stock with their excess cash flow. Such stock repurchases have similar impact as dividends so we will suppose that Winnebago will pay out all available cash flows above some minimum level required for Net Working Capital in dividends in the future. As we have shown earlier in the semester if Winnebago reinvests such cash flows in projects that earn the return the market requires for Winnebago, the value of the stock will not change, so this supposition is proper.

The spreadsheet “projection template WGO” contains a summarized income statement and a projection for 2007. You must use this as the start of a valuation template you will need to create to find out the cash flow projections required to value the common stock of Winnebago Corporation as of 8/25/2006.  Use this spreadsheet to answer the given problems. Print your valuation spreadsheet and comment on the whether or not you agree with the financial assumptions you were given for this valuation.

1) Use the excel spreadsheet to project the total income for Winnebago from assumptions regarding key revenue and expense items. Use the given assumptions to compute the projected net income, operating cash flow and investment cash flow for Winnebago for 2007 through 2011.

Sales Growth through 2011                 14.0%
Sales Growth after 2011                     7.0% forever
Variable Costs as a % of Sales             84.0%
Fixed Costs as a % of Sales                 4.0%

Depreciation Expense and Investment in Property Plant and Equipment will grow at similar rate as Sales.

As we suppose they pay out all excess cash Financial Income will be zero in the future.

Tax Rate: 35.0%

2) Compute the Operating Cash flows from 2007 – 2011 by using the indirect technique to add back depreciation. Suppose that depreciation will grow at similar rate as sales.

3) Suppose you can reduce the cash on hand and the company will require holding Net Working Capital (comprising cash) equivalent to 4% of the next year’s sales going forward. This will result in a very large reduction in NWC in 2007. You will as well need to project 2012 Sales to compute the NWC in 2011.

4) Compute the Total Cashflows from 2007 – 2011. Suppose that the company will require increasing their annual investment in fixed assets (representing new equipment) at similar rate as sales.

5) Compute the price of Winnebago stock (Winnebago has no debt so this is the market value of the firm divided by the number of common shares outstanding.) from the cash flows you find outd above. Assume Winnebago has a Beta of 2.01 the Market Return is expected to be 10.5% and the Risk Free rate is 3.5%. Assume there are 31,143,000 shares outstanding.

6) Go to the internet (Try Smartmoney.com) and compare your price to the market price of Winnebago stock on August 25, 2006. If your price per share is not close to this value, check your projection.

7) Comment on the reasonableness of the suppositions used in this analysis.

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M91172

Have any Question? 


Related Questions in Basic Finance

1 what are some ways in which scientists get ideas for

1. What are some ways in which scientists get ideas for their research? 2. Why can theories not be proved or disproved by research? 3. Given that proof and disproof are impossible in science, how does scientific knowledg ...

Question 1 - bondsyou have just purchased 5 million par

Q UESTION 1 - B ONDS You have just purchased $5 million par amount of the 5yr and 30yr US Treasury bonds shown below, at the prices shown. (Assume all bonds are semi-annual compounding.)   Par Amt            Coupon       ...

1 distinguish between the four types of relational

1. Distinguish between the four types of relational collaborative arrangements. Provide an example of each. 2. What do you believe will be the impact of the Internet on market distribution by 2010? 3. What is a shippers ...

The wealth transfer decisionnbspplease respond to the

"The Wealth Transfer Decision" Please respond to the following: Imagine that you are an estate planner and a friend is seeking advice regarding leaving property to his children. He has accumulated approximately $1 millio ...

Assume that european call and put options exist on a stock

Assume that European call and put options exist on a stock. That stock, however, is the target of a takeover in which an acquiring firm offers a fixed price for the stock. The takeover is almost certain to occur shortly ...

Personnel tests are designed to test a jobapplicants

Personnel tests are designed to test a jobapplicant's cognitiveand/or physical abilities. A particular dexterity test is administered nationwide by a private testing service. It is known that for all tests administered l ...

What is the current state of illicit financewhat are some

What is the current state of illicit finance? What are some examples of ways that we should consider how we define illicit finance? Both answers should be tied together with examples cited. Please contribute roughly 350- ...

Evaluate the expression uwxyz exactly as parenthesized ie

Evaluate the expression (u+)+(w+x)+(y+z) exactly as parenthesized (i.e., do not use the commutative or associative laws to reorder the additions). Give register-level machine code to provide the maximum possible parallel ...

A convertible bond is a bond that permits the holder to

A convertible bond is a bond that permits the holder to turn in the bond and convert it into a certain number of shares of stock. Conversion would, thus, occur only when the stock does well. As a result of the option to ...

Comet pasta company stock currenly sells for 13750 per

Comet Pasta Company stock currenly sells for $137.50 per share. The Company JUST PAID a dividend and that dividend is not expected to grow at all for the next two years, and then it will grow at a constant rate of 10 per ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro