412 Words2 Pages

Worldwide Paper Co |
ANALYSIS
Bob Prescott was considering the purchase of a new machine for WPC that would make it easier to process longwoods. He hoped the purchase would allow WPC to no longer buy shortwood from other mills and allow them to sell excess shortwood on the open market. This would help WPC to reduce operating costs and increase revenues. The total cost for the new technology was $18 million and Prescott wanted to know if this would be a sound investment.
The first step in helping Prescott was to calculate a new cost of capital—as the one used by WPC was 10 years old. I used the weighted average cost of capital equation to calculate a new WACC of 9.97%. My calculations are and assumptions are shown in further detail in the attached sheets.
Next, I had to generate the free cash flows for years 2007-2013 using Prescott’s given assumptions. * $18 M purchase price * $1.8 M selling price * Investment in PPE (2007) was $16 M * Investment in PPE (2008) was $2 M * $4 M in Sales (2008) * $10 M in Sales (2009-2013) * COGS: 75% of Sales * SG&A: 5% of Sales * $2 M Operating Savings (2008) * $3.5 M Operating Savings (2009-2013) * Depreciation was on a straight-line basis for 6 years beginning in 2008 * $18 M / 6 years = $3 M * 40% tax rate * NWC: 10% of Sales * Salvage value was zero * The FCF per year was determined using the following: * Net Income + Depreciation Expense - ∆ Net Working Capital + Investment in PPE
After generating the FCF for each year, I had to solve for NPV and IRR to value the investment. I calculated 2 NPVs—one using Excel’s NPV equation and the other by discounting each year’s FCF using the WACC I calculated earlier. Both methods gave me negative NPVs. * Excel NPV: ($489,344.33) * Discounted FCF NPV: ($538,153.89)
Lastly, I used Excel to

Related

## Fin 571 Week 4 Connect Problems

1258 Words | 6 Pages11 percent $ _____ c. 7 percent $ _____ 2. Watters Umbrella Corp. issued 20-year bonds 2 years ago at a coupon rate of 8.4 percent. The bonds make semiannual payments. If these bonds currently sell for 90 percent of par value, what is the YTM? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

## Advantages And Disadvantages Of Graded Unit 2 Management Accounting

2633 Words | 11 PagesThe net cash inflow and cash outflow are calculated using sales and production figures for the next 8 years. The unit cost from the first year is £0.89 which is the cost per mashing without depreciation and divided by 13,000 bottles. From this information provided, the cost will increase by 3.5% and also the selling price will increase by 4% every year (reference 4). These figures are based on the current rate inflation of 4% which is shown in appendix 9 The capital allowances are worked out on cased of 20% (Reference 5) and the annual investment allowance is £100,000 is available (Reference 6) in the first year which is restricted to £87,359. This figure is substrated from the acquisition giving a result of £332,641 which is the written down value.

## Lockit Company Essay

341 Words | 2 PagesHusky used annual observations from 20 prior years to estimate each of the four equations. Following are a definition of the variables used in the four equations and a statistical summary of these equations: St = Forecasted sales in dollars for Lockit in period t St–1 = Actual sales in dollars for Lockit in period t – 1 Gt = Forecasted U.S. gross domestic product in period t Gt–1 = Actual U.S. gross domestic product in period t – 1 Nt–1 = Lockit’s net income in period t – 1 Required: 1. Write Equations 2 and 4 in the form Y = a + bx. 2. If actual sales are $1,500,000 in 2009, what would be the forecasted sales for Lockit in 2010?

## Busn602

910 Words | 4 PagesBUSN602 Midterm Exam Set 2 Click Link Below To Buy: http://hwcampus.com/shop/busn602-midterm-exam-2/ Return to Assessment List Part 1 of 1 - 100.0 Points Question 1 of 20 5.0 Points Jill Clinton puts $1,000 in a savings passbook that pays 4% compounded quarterly. How much will she have in her account after five years? A.$1,200.50 B.$1,220.20 C.$1,174.80 D.$1,217.50 Question 2 of 20 5.0 Points An increase in inflation should: A.increase the demand for loanable funds B.decrease the interest rate on loans C.increase the interest rate on loans D.none of the above Question 3 of 20 5.0 Points Economists use a ___________________ framework to explain

## Accounting 303

2013 Words | 9 PagesFootwear's operating income was a pre-tax loss of $10 million in 2011. Foxtrot's income tax rate is 40%. 3. In the 2011 income statement for Foxtrot Co., it would report income from discontinued operations of: a. $9.2 million.

## FIN 422: Assignment

956 Words | 4 Pages[4] Fifth edition of RWJR, #4.5, page 93 Further question: (d) If Ms. Fawn wishes to consume the same quantity in each period, should she borrow or lend in the current period? By how much? 2. A capital investment project is expected to produce an after-tax net cash flow of $1,200 in one year. After-tax net cash flows are then expected to grow at a rate of 4% per year for 7 years, ending 8 years from today.

## Acct 311 Case Study

2449 Words | 10 PagesThe present value of a four-year annuity due of $10,000 at a 6 percent annual rate is $36,700. The present value of a four-year annuity due of $10,000 at an 8 percent annual rate is $35,770. What liability should Ace report on its December 31, Year One, balance sheet? 1. $0 2.

## Acc 552 Week 2 Mini Case

708 Words | 3 PagesThe depreciation is based on the car’s life not of the lease agreement. Question # 2 In item #4 we assumed that the $100,000 bond with a 5% rate involves a 15 year-end annual interest payments of $5,000 (100,000*.05). The payments is assumed to be annual, at year end. In appendix B the value of 8% for 15 years is 8.559. so the present value of $5,000 is $42,795, for interest payments $100,000*.315 which is $31,500. In total it will be $74,295; since the investors paid $80,000 the yield rate is less than 8%.

## Myer Case Study

8978 Words | 36 PagesASX & Media Release Thursday 12 September 2013 Myer Full Year Results ending 27 July 2013 Full year total sales up 0.8 percent to $3,145 million Operating gross profit up 1.8 percent to $1,312 million Operating gross margin up 40 basis points to 41.7 percent Net profit after tax down 8.7 percent to $127 million Full year dividend of 18 cents, fully franked FY2013 Financial Highlights Sales Total sales up 0.8% to $3,145 million, up 0.4% on a comparable store sales basis Myer Exclusive Brands sales up $40 million to 20.0% of sales, Concessions up $18 million to 15.4% of sales Operating gross profit Operating gross profit up 1.8% to $1,312 million Operating gross profit margin up 40 basis points (bps) to 41.7% Earnings Cost of doing

## Case Study

505 Words | 3 PagesFair value = 4.0 million x 3.3 = 13,200,000 P = A/ (1+nr) =4 million / (1 + 4 x .05) = 4 million / 1.2 = 3.3 Impairment value = fair value minus book value = 13,200,000 - -4,000,000 = 17,200,000 B) Repeat part A but instead assume that (1) the estimated remaining useful life is 10 years, (2) the estimated annual cash flows $2,720,000 per year, and (3) the appropriate discount rate is 6%. The impairment loss value that should be reported for the five stores at the end of fiscal 2011 is $4,624,064,000,000 Carrying amount = 36 million – (10 x 10 million) = (-64 million) - book value Undiscounted expected cash flow = 10 x 2,720,000 = 27,200,000 for all years. Fair value = 2,720,000 x 1,700,000 = 4,624,000,000,000 P= A / (1 + nr) =2,720,000 / (1 + 10 x .06) = 2,720,000 / 1.6 = 1,700,000 Impairment value = fair value – book value = 4,624,000,000,000 - -64 million = 4,624,064,000,000 Analysis Assume that you are a financial analyst and you participate in a conference call with Electroboy management in early 2012 (before Electroboy closes the books on fiscal 2011). During the conference call, you learn that management is considering selling the five stores, but the sale won’t likely be completed until the second quarter of fiscal 2012.

### Fin 571 Week 4 Connect Problems

1258 Words | 6 Pages### Advantages And Disadvantages Of Graded Unit 2 Management Accounting

2633 Words | 11 Pages### Lockit Company Essay

341 Words | 2 Pages### Busn602

910 Words | 4 Pages### Accounting 303

2013 Words | 9 Pages### FIN 422: Assignment

956 Words | 4 Pages### Acct 311 Case Study

2449 Words | 10 Pages### Acc 552 Week 2 Mini Case

708 Words | 3 Pages### Myer Case Study

8978 Words | 36 Pages### Case Study

505 Words | 3 Pages