Purchase Solution

Calculating Payback and NPV of an investment proposal

Not what you're looking for?

Ask Custom Question

Company A plan considering adopting new equipment

Initial software support total cost : $30,000,000

One time internal cost for implementing new Tech(including operating and maintenance personnel cost: $10,000,000

Internal cost will be capitalized along with the $30,000,000 purchases price when determining investment required for new proposal. In addition, $10,000,000 internal costs will be amortized over the life of the project.

Anuual maintance contract (for computer equipment): $1,500,000
Equipment useful life: 10 year

Anuual maintance contract (for upgrading software): $2,500,000

Annual cost of savings may occur after implementing new system(cash inflow) :
1. reduction in occupancy cost : $2Mil
2. Lower maintenance and repair cost $4Mil
3. Reduced labor cost, fringe benefits, and associated overhead $7Mil
4. reduction in inventory and accounts receivable: $5,000,000

disposal price of equipment and software program: 5,000,000 (at the end of 5 years, discount rate : 16% ) . company A does it investment evaluation on a pretax basis.

Required:

1. What is the payback period for the proposal?

2. Calculate the net present value of the proposal assuming Company A's normal assumptions of a 16% cost of capital and five year life. Should company A adopt the new equipment given its existing investment criteria?

3. Scott White(manager ) has read an article that argues that many companies are rejecting proposals because either the discount rate is too high or the time period over which the benefits are considered is too short. He believes that Acme should use a 10% discount rate and evaluate benefits over a 10-year period (n=10, i=10%). Prepare some comments for White on the effect of making these changes in the net present value calculations.

Purchase this Solution

Solution Summary

The solution explains how the payback period and the NPV should be calculated. It also explains how the discount rate should be determined and the impact on the decision of changing the discount rate

Solution Preview

The attached excel file has the calculations. Let me know if you have any questions.

1. What is the payback period for the proposal?

We make the cash flow statement (this is in the attached file). Payback period is the time taken to recover the initial investment. The initial investment is $35 million. From the cumulative cash flows we see that at the end of three years $8 million is still to be recovered. In year 4 the cash flow is $9 million. The fraction of year needed to recover 8 million in year 4 is 8/9=0.89.
The payback period is 3.89 years

2. Calculate the net present ...

Purchase this Solution


Free BrainMass Quizzes
Introduction to Finance

This quiz test introductory finance topics.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.