Evaluation project -finance | Business & Finance homework help

Don't use plagiarized sources. Get Your Assignment on
Evaluation project -finance | Business & Finance homework help
Just from $13/Page
Order Now

Voluntary, 5% of the final grade

Background You have been given the Balance Sheet and Income Statement for Winnebago as of August 25, 2006. The value of the stock of a company can be determined by calculating the present value of the cashflows generated by the company and available to stock holders. Winnebago has historically repurchased large amounts of stock with their excess cash flow. These stock repurchases have the same impact as dividends so we will assume 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 these cash flows in projects that earn the return the market requires for Winnebago, the value of the stock will not change, so this assumption is appropriate.

The spreadsheet “projection template WGO” contains a summarized income statement and a projection for 2007. You should use this as the start of a valuation template you will need to create to calculate the cashflow projections needed to value the common stock of Winnebago Corporation as of 8/25/2006. Use this spreadsheet to answer the following questions. Print your valuation spreadsheet and comment on the whether or not you agree with the financial assumptions you were given for this valuation. Your spreadsheet and comments will be due before the final exam on May 3.

1. Use the excel spreadsheet to project the net income for Winnebago from assumptions about key revenue and expense items. Use the following assumptions to calculate 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 the same rate as Sales.
Because we assume they pay out all excess cash Financial Income will be zero in the future.
Tax Rate 35.0%

2. Calculate the Operating Cashflows from 2007 – 2011 using the indirect method to add back depreciation. Assume that depreciation will grow at the same rate as sales.

3. Assume you can reduce the cash on hand and the company will need to hold Net Working Capital (including cash) equal to 4% of the next year’s sales going forward. This will result in a very large reduction in NWC in 2007. You will also need to project 2012 Sales to calculate the NWC in 2011.

4. Calculate the Total Cashflows from 2007 – 2011. Assume that the company will need to increase their annual investment in fixed assets (representing new equipment) at the same rate as sales.

5. Calculate 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 cashflows you calculated 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 assumptions used in this analysis.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
poor service
Customer 453627, January 24th, 2020
Good job.
Customer 453707, May 8th, 2022
Good work.
Customer 462257, April 8th, 2022
Interior Decoration
Few edits needed
Customer 463337, November 9th, 2022
Healthcare & Medical
Good work!
Customer 452441, August 6th, 2022
Thanks so much, excellent work as always.
Customer 453939, May 23rd, 2020
Good work. Looking foward to future contributions.
Customer 463463, October 29th, 2022
Awesome job, thanks for the quality work!!!
Customer 453939, February 15th, 2020
Business and administrative studies
Great effort.
Customer 452615, May 19th, 2022
Good work.
Customer 456821, May 11th, 2022
good job
Customer 456821, April 4th, 2022
Business and administrative studies
Good work.
Customer 458115, April 27th, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat