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

Geotechnical instrumentation is frequently employed for

Geotechnical Instrumentation is frequently employed for monitoring the condition of reclamation. Sometimes two piezometers are installed inside the same borehole. What is the reason behind this?

Investmentsinstructions for asset returns paperstep 1

Investments Instructions for Asset Returns Paper Step 1 Extending Siegel (1992) graphs to 2014 This section uses the file "AssetHistoricalReturns" to replicate and extend Siegel (1992) results to 2014. 1. Create a chart ...

Hughes co is growing quickly dividends are expected to grow

Hughes Co. is growing quickly. Dividends are expected to grow at a 24.1 % rate for the next three years, with the growth rate falling off to a constant 5 % thereafter. If the required return is 10.9 % and the company jus ...

Question 1jessica opened a bank account with an initial

Question 1: Jessica opened a bank account with an initial deposit of $10,000. The bank account pays monthly interests at 6% p.a. convertible monthly. (a) How much will Jessica accumulate in 5 years if she is not going to ...

For decades 1 british pound has been worth more than 1 us

For decades, 1 British pound has been worth more than 1 U.S. dollar. One Japanese yen has been worth less than 0.01 U.S. dollars (1 cent). So a pound is more than 100 times as valuable as a yen. Does this difference matt ...

The wall street journal reports that the rate on 8-year

The Wall Street Journal reports that the rate on 8-year Treasury securities is 1.20 percent and the rate on 9-year Treasury securities is 1.75 percent. According to the unbiased expectations theories, what does the marke ...

Business financequestion oneif you invest 10525 today at an

BUSINESS FINANCE QUESTION ONE If you invest $10,525 today at an interest rate of 7.35% compounded daily, how much money will you have on your saving account in 15 years? QUESTION 2 Stephen plans to purchase a car in 5 ye ...

Assignment-investmentsa general bond and investor

Assignment- INVESTMENTS A. GENERAL BOND AND INVESTOR INFORMATION 1. Briefly discuss the general characteristics of the bond touching on: a. A brief description of the company that issued the bond. b. A brief description ...

Essay questionsmust include references1 the time value of

Essay questions,must include references 1. THE TIME VALUE OF MONEY Some financial advisors recommend you increase the amount of federal income taxes withheld from your paycheck each month so that you will get a larger re ...

Financial forecasting assignment-the historical financial

Financial Forecasting Assignment- The historical financial statements of HWO Incorporated are on the accompanying EXCEL file. Enter your assigned number in cell l1 (eye one). This is your individual data set. Print the p ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate