View the step-by-step solution to:

Since Rockwell's sales are only to new housing construction, you decide to a) estimate national housing starts and b) use that forecast to estimate...

Please solve the problems

TAKE HOME PART FINAL EXAM FALL SEMESTER 2012 Due December 14, 2012 in room 640 TNRB Before 5 PM *This is an individual assignment - Consult TA or professor with questions You have been hired to help Rockwell plan (budget) sales for the next several years. Since Rockwell's sales are only to new housing construction, you decide to a) estimate national housing starts and b) use that forecast to estimate Rockwell's sales. Step 1: Forecast housing starts annually for 2013 and 2014 Procedure: a) Fill in the attached table using the data from www.economagic.com Remember that SAAR data is to be averaged (not summed) to get annual data. Include the table with your submission. b) Using the time from 2002 to 2012, run a correlation matrix using annual housing starts, the annual unemploymnet rate, real GDP and the Federal Funds interest rate. Also include in the correlation matrix the idea that starts may lag those three macro- variables by one year, using the values for the NEXT YEAR of the three marco-variables - the first year of housing starts will be 2002, use the 2003 unemployment rate, GDP and Fed Funds as the first observation of the series. In addition, since the banking sector was broken in 2008, include the Proxy variable for financing in the matrix. Include the matrix with your submission. c) Pick the two highest correlated variables with housing starts and run a regression with those two independent variables with housing starts as the dependent (y) variable. 1) Show the regression results 2) Give the regression equation with t-statistics 3) Fill in the table with your model housing start forecast. The 2013 and 2014 estimates will be in thousands rounded to the nearest whole number Step 2: Using the outlook for housing, suggest a sales forecast for Rockwell. Estimate sales by arriving at the Rockwell's sales per housing start for 2012 and apply the same percentage to 2013 and 2014. Estimate pre-tax profit for 2013 and 2014 by assuming those years have the same pre-tax percentage of sales as the year 2011. Sales forecast Pre-tax Profit (in 000's, rounded to whole number) 2011 Actual = 2,498 279 2012 Forecast = 3,200 185 2013 Forecast = 2014 Forecast = Step 3: Mr. Cook asks you to estimate Rockwell's equity value on 12/31/14 so that he might approach potential buyers of the company. Use 2 valuation methods (averaged) to arrive at your answer. Apply the income statement line item % of sale from 2011 to the 2014 sales estimate for any additional information you require. For cash and debt items use the 2011 balance sheet as is for 2014. Assumptions: All line items on the 2014 income statement remain the same percentage of sales as in 2011 Assume income taxes are paid by the LLC owners instead of the corporation Rockwell has 1.9 million share outstanding Questions: What price do you recommend Mr. Cook ask for? Is this an equity or enterprise valuation? What dollar value would go to the shareholders NOTE : Rockwell is an LLC and income taxes are passed through to owners.
Background image of page 1
Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 Column 7 Column 8 Column 1 1 Column 2 -0.64497 1 Column 3 -0.596884 0.9307474 1 Column 4 0.6026224 0.0232084 -0.085638 1 Column 5 0.8134702 -0.205378 -0.115913 0.7242931 1 Column 6 -0.846456 0.3347282 0.4545705 -0.834707 -0.719241 1 Column 7 -0.931822 0.4543003 0.3436361 -0.64611 -0.849436 0.7940248 1 Column 8 0.9422102 -0.460939 -0.505109 0.7964971 0.8217797 -0.967685 -0.894863 1
Background image of page 2
Show entire document
Sign up to view the entire interaction

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question