Reference no: EM131148409
Assignment
"Keith Clarkson, sole owner and president of the Clarkson Lumber Company, has received a number of informal inquiries from large, nationally-recognized building materials distributors about purchasing his company. Although Clarkson relishes operating his own business the would be interested if an attractive offer were received. Unfortunately, Mr. Clarkson is unsure how much his company is worth so he turns to you for guidance.
Your end goal is to value Clarkson Lumber operations at the beginning of 1996 (i.e. at the end of 1995) assuming the firm will obtain a credit line at Northwestern National Bank sufficiently large to take advantage of discounts on purchases for paying within 10 days of invoice, thus increasing operating profit margins.
With higher mark-ups and continued operating expense controls, Clarkson projects a steady operating profit margin of 6% by 2000. Margins and investment requirements will also stabilize in relation to sales growth. Relevant projection inputs are in the table below and the discount rate is 11.5%.
Note that the forecast ratios already include the benefit the of the 2% trade discounts.
For simplicity, use a tax rate of 35% throughout the projections.
Make whatever other reasonable assumptions are necessary to complete your analysis and explain the rationale for each."
| Projection Assumptions |
avg 93-95 |
1996 |
1997 |
1998 |
1999 |
2000 |
| Sales |
|
5,500 |
|
|
|
|
| Sales growth rate |
24.5% |
21.7% |
20% |
15% |
10% |
5% |
| CGS/Sales |
75.6% |
75.0% |
74.0% |
74.0% |
74.0% |
74.0% |
| Op Exp/Sales |
20.9% |
20.4% |
20.0% |
20.0% |
20.0% |
20.0% |
| OPM |
3.5% |
4.6% |
6.0% |
6.0% |
6.0% |
6.0% |
| Tax rate |
20.5% |
35% |
35% |
35% |
35% |
35% |
| |
|
|
|
|
|
|
| AR DOH (= AR/daily sales) |
43.4 |
43.4 |
43.4 |
43.4 |
43.4 |
43.4 |
| Inv DOH (=inventory/daily COGS) |
59.4 |
59.4 |
59.4 |
59.4 |
59.4 |
59.4 |
| NFATO (@Sales) (= sales/NFA) |
12.5 |
12.5 |
12.5 |
12.5 |
12.5 |
12.5 |
| AP DOH (AP/daily purchases) |
39.7 |
10 |
10 |
10 |
10 |
10 |
| Acc Exp/Sales |
1.46% |
1.46% |
1.46% |
1.46% |
1.46% |
1.46% |
1 - Project free cash flows for the next five years, 1996 to 2000 (please refer to video 25 to get the FCF in 1996)
2 - Use the same assumptions as in 2000 in order to compute the FCF of 2001, 2002 and 2003. Then, see if they follow a constant growth pattern.
3 - Compute the present value of the cash flows from 1996 to 2000, at the end of 1995.
4 - Compute the present value of all the cash flows starting in 2001, at the end of 1995.
5 - Compute the value of the firm operations.
|
Write a persuasive email in a microsoft word document
: Write a persuasive e-mail in a Microsoft® Word document to a manager or coworker requesting a change to the workplace.
|
|
Identify various categories of art on exhibit at the museum
: Based on your reading of "Introduction: What Is Art History?" from your textbook, identify the various categories of art on exhibit at this museum.
|
|
Does kraft foods portfolio exhibit good strategic fit
: What is Kraft Foods Inc.'s corporate strategy? How has its corporate strategy evolved since its independence in 2007? What is your assessment of the long-term attractiveness and competitive strength of the industries represented in Kraft Foods' bus..
|
|
Write a narrative analysis of the primary source
: create a separate entry that includes all of the following information:- The type of primary source (e.g. written document, cartoon, photograph, and so on).- Complete the worksheet in detail.
|
|
Compute the value of the firm operations
: Compute the present value of the cash flows from 1996 to 2000, at the end of 199 and compute the value of the firm operations.
|
|
What were some details shared regarding the method and tools
: What were some details shared regarding the method, tools, subjects, and social implications of the work of art? What was one example of symbolism identified in the work of art?
|
|
Development of any marketing mix depends on positioning
: The development of any marketing mix depends on positioning, a process that influences potential customers' overall perception of a brand, product line, or organization in general. Position is the place a product, brand, or group of products occupies..
|
|
Affect your selection of data and measurement strategies
: Activity Instruction Deming (1987) states that one of the seven deadly diseases is using only visible figures as an input to management. How do you think this concept could affect your selection of data and measurement strategies? When historical dat..
|
|
Describe three strategies for expanding capacity
: Describe three strategies for expanding capacity. What are the advantages and disadvantages of incremental versus one-step expansion? eview the case study Southwest Airlines 2011 (2011). Describe Southwest Airlines' strategy and process, and then res..
|