### Calculate the net present value of each of the alternatives

Assignment Help Finance Basics
##### Reference no: EM13799236

As a financial analyst at Glencolin International (GI) you have been asked to evaluate two capital investment alternatives submitted by the production department of the firm. Before beginning your analysis, you note that company policy has set the cost of capital at 15 percent for all proposed projects. As a small business, GI pays corporate taxes at the rate of 35 percent. The proposed capital project calls for developing new computer software to facilitate partial automation of production in GI's plant. Alternative A has initial software development costs projected at \$185,000, while Alternative B would cost \$320,000. Software development costs would be capitalized and qualify for a capital cost allowance (CCA) rate of 30 percent. In addition, IT would hire a software consultant under either alternative to assist in making the decision whether to invest in the project for a fee of \$16,000 and this cost would be expensed when it is incurred. To recover its costs, GI's IT department would charge the production department for the use of computer time at the rate of \$375 per hour and estimates that it would take 182 hours of computer time per year to run the new software under either alternative. GI owns all its computers and does not currently operate them at capacity. The information technology (IT) plan calls for this excess capacity to continue in the future. For security reasons, it is company policy not to rent excess computing capacity to outside users. If the new partial automation of production is put in place, expected savings in production cost (before tax) are projected as follows: As the capital budgeting analyst, you are required to answer the following in your memo to the production department:

• Calculate the net present value of each of the alternatives. Which would you recommend?
• The CFO suspects that there is a high risk that new technology will render the production equipment and this automation software obsolete after only three years. Which alternative would you now recommend? (Cost savings for Years 1 to 3 would remain the same.)
• GI could use excess resources in its Engineering department to develop a way to eliminate this step of the manufacturing process by the end of year. The salvage value of the equipment (including any CCA and tax impact) would be \$50,000 at the end of Year 3, \$35,000 at the end of Year 4, and zero after five years. Should Engineering develop the solution and remove the equipment before the five years are up? Which alternative? When?

As a financial analyst at Glencolin International (GI) you have been asked to revisit your analysis of the two capital investment alternatives submitted by the production department of the firm. (Detailed discussion of these alternatives is in the Mini Case at the end of Chapter 10.) The CFO is concerned that the analysis to date has not really addressed the risk in this project. Your task is to employ scenario and sensitivity analysis to explore how your original recommendation might change when subjected to a number of "what-ifs." In your discussions with the CFO, the CIO and the head of the production department, you have pinpointed two key inputs to the capital budgeting decision: initial software development costs and expected savings in production costs (before tax). By properly designing the contract for software development, you are confident that initial software costs for each alternative can be kept in a range of plus or minus 15 percent of the original estimates. Savings in production costs are less certain because the software will involve new technology that has not been implemented before. An appropriate range for these costs is plus or minus 40 percent of the original estimates. As the capital budgeting analyst, you are required to answer the following in your memo to the CFO:

• Conduct sensitivity analysis to determine which of the two inputs has a greater input on the choice between the two projects.
• Conduct scenario analysis to assess the risks of each alternative in turn. What are your conclusions?

#### Assuming they are married and they select the best benefit a

Mandy and Michael Tombs are retiring soon. Their projected month Social Security benefits are \$800 and \$1,800, respectively. Assuming they are married and they select the best

#### How much will be contributed to wills plan in a year by both

Will works for Micro Lance Computer Company and participates in its thrift and savings plan. For every \$1.00 Will contributes to the plan, up to 5% of his salary, the company

#### Which of the following statements are correct

Which of the following statements are correct? If inflation is expected to increase in the future, and if the maturity risk premium is greater than zero, then the yield curve

#### Which of the following statements is correct

Which of the following statements is correct? A) all else equal, senior debt generally has a lower yield to maturity than subordinated b) an indenture is a bond that is less r

#### Which of the following is correct

Which of the following is correct? A) the cash flows of an ordinary annuity all occur at the beginning of the periods b) if a series of unequal cash flows occurs at regular

#### Determine the present value of replacing the fleet in comput

Adams County has 80 older model school buses that carry a present salvage value of \$15,000 each. The county officials are contemplating replacing all the buses with 70 new lar

#### How much could this loan be sold for to another bank if loan

Assume you are planning to invest \$5,000 each year for 6 years and will earn 10% per year. Determine the future value of the annuity if your first \$5,000 is invested at the en

#### What is the firms weighted average cost of capital wacc

The market risk premium is 7.2. The firm's required return is 11.2%. The risk-free rate is 5%. What is the firm's beta? Your portfolio has a beta of 1.4. The portfolio consist