Chapter 11 Problem 18 Build a Model help

Chapter 11 Problem 18 Build a Model help - Ch 11-18 Build a...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Page 1 Ch 11-18 Build a Model a. Develop a spreadsheet model, and use it to find the project’s NPV, IRR, and payback. Key Output: NPV = Part 1. Input Data (in thousands of dollars) IRR = MIRR = Equipment cost $10,000 Net WC/Sales 10% Market value of equipment at Year 4 $500 First year sales (in units) 1,000 Tax rate 40% Sales price per unit $24.00 WACC 10% Variable cost per unit $17.50 Inflation 3.0% Nonvariable costs $1,000 Part 2. Depreciation and Amortization Schedule Years Accum'd Year Initial Cost 1 2 3 4 Depr'n Equipment Depr'n Rate 20.0% 32.0% 19.0% 12.0% Equipment Depr'n, Dollars Part 3. Net Salvage Values, in Year 4 Equipment Estimated Market Value in Year 4 Book Value in Year 4 Expected Gain or Loss Taxes paid or tax credit Net cash flow from salvage For this questions It would cost $10 million at Year 0 to buy the equipment necessary to manufacture the server. The project would require net working capital at the beginning of each year in an amount equal to 10% of the year's projected sales; for example, NWC 0 = 10%(Sales 1 ). The servers would sell for $24,000 per unit, and Webmasters believes that variable costs would amount to $17,500 per unit. After Year 1, the sales price and variable costs will increase at the inflation rate of 3%. The company’s nonvariable costs would be $1 million at Year 1 and would increase with inflation. The server project would have a life of 4 years.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

Chapter 11 Problem 18 Build a Model help - Ch 11-18 Build a...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online