Solve all problems in the Excel file provided.

Problem 1 . Regency Integrated Chips (RIC), a large Nashville-based technology company is evaluating a new project to manufacture a new chip. a. The projects estimated economic life is 5 years. b. RICs marketing vice-president believes that annual sales would be 30,000 units if the units were priced at $6,000 each. RIC expects no growth in unit sales, and it believes that the unit price will rise by 2 percent each year. c. The engineering department has reported that the project will require additional manufacturing space, and RIC currently has an option to purchase an existing building, at a cost of $20 million, which would meet this need. The building would be bought and paid for on December 31, 2008, and for depreciation purposes, it would fall into the MACRS 39- year class. The annual depreciation rate for the five years of economic life of the project would be: Year 1 Year 2 Year 3 Year 4 Year 5 1.3% 2.6% 2.6% 2.6% 2.6%

d. The necessary equipment would be purchased, installed, and paid for on December 31 of Year 0. The equipment would fall into the MACRS 5-year class, and it would cost $10 million, including transportation and installation. The annual depreciation rate for the five years of economic life of the project would be: Year 1 Year 2 Year 3 Year 4 Year 5 20% 32% 19% 12% 11%

e. At the end of the project, the building is expected to have a market value of $10 million and the equipment is expected to have a market value of $2 million. f. The production department has estimated that variable manufacturing costs would be $4000 per unit, and that fixed overhead costs, excluding depreciation would be $20 million a year. They expect variable costs to rise by 2 percent per year, and fixed costs to rise by 1 percent per year. Depreciation expense would be determined in accordance with MACRS rates. g. RIC must have an amount of NOWC on hand equal to 10 percent of the upcoming years sales. h. RICs marginal tax rate is 40 percent, its cost of capital is 12 percent, and it assumes that all operating cash flows occur at the end of the year. Evaluate the project using the NPV rule and the IRR rule.

Problem 2 You have been asked by the president of the Farr Construction Company to evaluate the proposed acquisition of a new earth mover. The movers basic price is $200,000, and it would cost another $30,000 to modify it for special use. Assume that the mover falls into the MACRS 5-year class, it would be sold after 4 years for $60,000, and it would require an increase in net operating working capital (spare parts inventory) of $10,000. The earth mover would have no effect on revenues, but it is expected to save the firm $50,000 per year in before-tax operating costs, mainly labor. The firms marginal federal-plus-state tax rate is 40 percent and the projects cost of capital is 10 percent. Evaluate the project using the NPV rule and the IRR rule.

Problem 3 ABC Inc. wishes to buy new machinery that would cost $160,000, but it would lead to increased output, higher sales, and higher costs. Moreover, the firm would receive $100,000 after taxes for the old machine. The new machine would result in sales of $120,000 per year versus old sales of $70,000, and the new costs would be $40,000 versus old costs of $20,000. Finally, the old machine was being

depreciated at the rate of $10,000 per year, but the new machine would have $30,000 of annual depreciation. The marginal tax rate is 40 percent and WACC is 10 percent. Based on these figures, and assuming the new and old machines both have a life of four years, find the incremental cash flows.

Problem 1 - Evaluating a New Project Year 0 Project- 5 Year Life Building Purchase ?? Equipment Purchase ?? Total Initial Investment $ Year 1 Year 2 Year 3 Year 4 Year 5 - Unit Sales Price per Unit Total Sales ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? Variable Cost per Unit Total Variable Costs ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? Total Fixed Costs ?? ?? ?? ?? ?? Depreciation Rate (39 Year) Building Depreciation Depreciation Rate (5 Year) Equipment Depreciation Total Depreciation Costs ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? Earnings Before Income Tax (EBIT) ?? ?? ?? ?? ?? Tax Rate Total Taxes ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? Net Operating Profits (NOPAT) ?? ?? ?? ?? ?? Add Back Depreciation Operating Cash Flow ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? NOWC Percentage Required ?? Net Operating Working Capital ?? Increase in NOWC ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? Total Annual Project Cash Flow ?? ?? ?? ?? ?? ?? Terminal Year Cash Flow Building Sale (MV) Less: Book Value of Building Profit on Sale Tax on Loss (40%) Net Salvage Value on Building ?? ?? ?? ?? ?? Equipment Sale (MV) Less: Book Value of Equipment Profit on Sale Tax on Profit (40%) Net Salvage Value on Equipment ?? ?? ?? ?? ?? Total Net Salvage Value ?? Free Cash Flow ?? Required Rate of Return (WACC) ?? NPV ?? IRR ?? ?? ?? ?? ?? ?? Problem 2 - Evaluating a Cost Saving Project Year 0 Acquisition - 5 Year Life Earth Mover ?? Installation Costs ?? Total Initial Investment $ Year 1 Year 2 Year 3 Year 4 - Savings in Costs ?? ?? ?? ?? Depreciation Rate (5 Year) Total Depreciation Costs ?? ?? ?? ?? ?? ?? ?? ?? Earnings Before Income Tax (EBIT) ?? ?? ?? ?? Tax Rate Total Taxes ?? ?? ?? ?? ?? ?? ?? ?? Net Operating Profits (NOPAT) ?? ?? ?? ?? Add Back Depreciation Operating Cash Flow ?? ?? ?? ?? ?? ?? ?? ?? Net Operating Working Capital ?? Increase in NOWC ?? ?? ?? ?? ?? ?? ?? ?? ?? Total Annual Project Cash Flow ?? ?? ?? ?? ?? Terminal Year Cash Flow Machine Sale Less: Book Value of Machine Profit on Sale Tax on Profit (40%) Net Salvage Value on Equipment Free Cash Flow ?? ?? ?? ?? ?? ?? Required Rate of Return (WACC) ?? NPV ?? IRR ?? ?? ?? ?? ?? Problem 3 - Evaluating a Replacement Project Year 0 Year 1 Year 2 Year 3 Year 4 Acquisition - 5 Year Life New Machinery ?? Sale - Old Machine ?? Total Initial Investment ?? New Sales Old Sales Change in Sales ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? New Costs Old Costs Change in Costs ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? New Depreciation Old Depreciation Change in Depreciation ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? Earnings Before Income Tax (EBIT) ?? ?? ?? ?? Tax Rate Total Taxes ?? ?? ?? ?? Net Operating Profits (NOPAT) ?? ?? ?? ?? Add Back Depreciation Operating Cash Flow ?? ?? ?? ?? ?? ?? ?? ?? Net Operating Working Capital ?? Increase in NOWC ?? ?? ?? ?? ?? ?? ?? ?? ?? Total Annual Project Cash Flow ?? ?? ?? ?? ?? ?? ?? ?? ?? Free Cash Flow 40.00% ?? Required Rate of Return (WACC) ?? NPV ?? IRR ?? 40.00% 40.00% 40.00% NOT NEEDED NOT NEEDED NOT NEEDED NOT NEEDED