# Net Present Value Analysis

L&M Power

In the next two years, a large municipal gas company must begin constructing new gas storage facilities to accommodate the Federal Energy Regulatory Commission's Order 636 deregulating the gas industry. The vice-president in charge of the new project believes there are two options. One option is an underground deep storage facility (UDSF) and the other is a liquified natural gas facility (LNGF). The vice-president has developed a project selection model and will use it in presenting the project to the president. For the models she has gathered the following information:

Initial Cost Operating Cost/Cu. Ft. Expected Life Salvage Value

UDSF $10,000,000 $0.004 20 years 10%

LNGF 25,000,000 0.002 15 5

Since the vice-president's background is in finance, she believes the best model to use is a financial one, net present value analysis.

Questions: Would you use this model? Why or why not?

© BrainMass Inc. brainmass.com October 16, 2018, 8:23 pm ad1c9bdddfhttps://brainmass.com/business/capital-budgeting/net-present-value-analysis-147853

#### Solution Preview

The response addresses the queries posted in 427 words with references.

//Before writing about the Net present Value Method, it is necessary to have knowledge about the method of Net present Value Analysis. One should know about the process of this analysis, which further will assist in analysis of Net present Value, in an effective manner//

Net present Value Method

The Net present Value Analysis is the best method in taking the decisions for selecting the project. Yes, I would use this model as it is a discounted cash flow technique that explicitly recognizes the time value of money. It correctly postulates that cash flows arising at different time periods differ in value and are comparable only when their ...

#### Solution Summary

333 words report and excel file.

Capital Budgeting Decisions - Net Present Value Analysis of Competing Projects

Please see the attached file for complete description of the questions.

EXERCISE 12-11 Net Present Value Analysis of Competing Projects (LO2)

Wriston Legacies, a retailer of fine estate jewelry, has $300,000 to invest. The company is trying to decide between two alternative uses of the funds. The alternatives are:

Project A Project B

Cost of equipment required $300,000 $0

Working capital investment required $0 $300,000

Annual cash inflows $80,000 $60,000

Salvage value of equipment in seven years $20,000 $0

Life of the project 7 years 7 years

The working capital needed for project B will be released for investment elsewhere at the end of seven years. Wriston Legacies uses a 20% discount rate.

1. Which investment alternative (if either) would you recommend that the company accept? Show all computations using the net present value method. Prepare separate computations for each project.

PROBLEM 12-13A Ranking of Projects (LO2)

Oxford Company has limited funds available for investment and must ration the funds among four competing projects. Selected information on the four projects follows:

Project Investment Required Net Present Value Life of the Project (years)

A $140,000 $42,000 8

B $190,000 $49,400 14

C $175,000 $49,000 9

D $138,000 $31,740 3

The company wants your assistance in ranking the desirability of the projects.

1. Compute the project profitability index for each project.

2. In order of preference, rank the four projects in terms of:

a. Net present value

b. Project profitability index

3. Which ranking do you prefer? Why?

PROBLEM 12-16A Simple Rate of Return and Payback Methods (LO3, LO4)

Otthar's Amusement Center contains a number of electronic games as well as miniature golf course and various rides located outside the building. Otthar Luvinson, the owner, would like to construct a water slide on one portion of his property. Otthar has gathered the following information about the slide:

a. Water slide equipment could be purchased and installed at a cost of $500,000. The slide would be usable for 10 years, after which it would have no salvage value.

b. Otthar would use straight-line depreciation on the slide equipment.

c. To make room for the water slide, several rides would be dismantled and sold. These rides are fully depreciated, but they could be sold for $40,000 to an amusement park in the nearby city.

d. Otthar has concluded that water slides would increase ticket sales by $320,000 per year.

e. On the basis of experience at other water slides, Otthar estimates that annual incremental operating expenses for the slide would be: salaries, $115,000; insurance $28,200; utilities, $12,000; and maintenance, $32,000.

1. Prepare an income statement showing the expected net operating income each year from the water slide.

2. Compute the simple rate of return expected from the water slide. On the basis of this computation, would the water slide be constructed if Otthar requires a simple rate of return of at least 15% on all investments?

3. Compute the payback period for the water slide. If Otthar accepts any project with a payback period of 5 years or less, would the water slide be constructed?

PROBLEM 12-18A Net Present Value Analysis of Securities (LO1)

Anita Vasquez received $160,000 from her mother's estate. She placed the funds into the hands of a broker, who purchased the following securities on Anita's behalf:

a. Common stock was purchased as a cost of $80,000. The stock paid no dividends, but was sold for $180,000 at the end of 4 years.

b. Preferred stock was purchased at its par value of $30,000. The stock paid a 6% dividend (based on par value) each year for 4 years. At the end of 4 years, the stock sold for $24,000.

c. Bonds were purchased at a cost of $50,000. The bonds paid $3,000 in interest every six months. After 4 years, bonds were sold for $58,500. (Note: In discounting a cash flow that occurs semi-annually, the procedure is to halve the discount rate and double the number of periods. Use the same procedure in discounting the proceeds from the sale.)

The securities were all sold at the end of four years so that Anita would have funds available to start a new business venture. The broker stated that the investments earned more than a 20% return, and he gave Anita the following computation to support his statement.

Common stock:

Gain on sale ($180,000-$80,000)

$100,000

Preferred stock:

Dividends paid (6% x $30,000 x 4 years)

Loss on sale ($24,000 - $30,000)

7,200

(6,000)

Bonds

Interest paid ($3,000 x 8 periods)

Gain on sale ($58,000 - $50,000)

24,000

8,500

Net gain on investments $133,700

($133,700 / 4 years) / $160,000 = 20.9%

1. Using a 20% discount rate, compute the net present value of each of the three investments. On which investment(s) did Anita earn a 20% rate of return? (Round computations to the nearest whole dollar.)

2. Considering all three investments together, did Anita earn a 20% rate of return? Explain.

3. Anita wants to use the $262,500 proceeds ($180,000 + $24,000 + $58,500 = $262,500) from sale of the securities to open a fast-food franchise under a 10-year contract. What net annual cash inflow must the store generate for Anita to earn a 16% return over the 10-year period? Anita will not receive back her original investment at the end of the contract. (Round computations to the nearest whole dollar.)

PROBLEM 12-19A Simple Rate of Return and Payback Analysis of Two Machines (LO3, LO4)

Blue Ridge Furniture is considering the purchase of two different items of equipment, as described below:

1. Machine A. A compacting machine has just come onto the market that would permit Blue Ridge Furniture to compress sawdust into various shelving products. At present the sawdust is disposed of as a waste product. The following information is available about the machine:

a. The machine would cost $780,000 and would have a 25% salvage value at the end of its 10-year useful life. The company uses straight-line depreciation and considers salvage value in computing depreciation deductions.

b. The shelving products manufactured from use of the machine would generate revenues of $350,000 per year. Variable manufacturing costs would be 20% of sales.

c. Fixed expenses associated with the new shelving products would be (per year): advertising, $42,000; salaries, $86,000; utilities, $9,000; and insurance, $13,000.

2. Machine B. A second machine has come onto the market that would allow Blue Ridge Furniture to automate a sanding process that is now done largely by hand. The following information is available:

a. The new sanding machine would cost $220,000 and would have no salvage value at the end of its 10-year useful life. The company would use straight-line depreciation on the new machine.

b. Several old pieces of sanding equipment that are fully depreciated would be disposed of at a salvage value of $7,200.

c. The new sanding machine would provide substantial annual savings in cash operating costs. It would require an operator at an annual salary of $26,000 and $3,000 in annual maintenance costs. The current, hand-operated sanding procedure costs the company $85,000 per year in total.

Blue Ridge Furniture requires a simple rate of return of 16% on all equipment purchases. Also, the company will not purchase equipment unless the equipment has a payback period of 4 years or less.

1. For machine A:

a. Prepare a contribution format income statement showing the expected net operating income each year from the new shelving products.

b. Compute the simple rate or return.

c. Compute the payback period.

2. For machine B:

a. Compute the simple rate or return.

b. Compute the payback period.

3. According to the company's criteria, which machine, if either, should the company purchase?

ANALYTICAL THINKING (LO1)

Wyndham Stores operates a regional chain of upscale department stores. The company is going to open another store soon in a prosperous and growing suburban area. In discussing how the company can acquire the desired building and other facilities needed to open the store, Harry Wilson, the company's marketing vice president, stated, "I know most of our competitors are starting to lease facilities, rather than buy, but I just can't see the economics of it. Our development people tell me that we can buy the building site, put a building on it, and get all the store fixtures we need for $14 million. They also say that property taxes, insurance, maintenance, and repairs would run $200,000 a year. When you figure that we plan to keep a site for 20 years, that's a total cost of $18 million. But then when you realize what the building and property will be worth at least $5 million in 20 years, that's a net cost to us of only $13 million. Leasing costs a lot more than that."

"I'm not so sure," relied Erin Reilley, the company's executive vice president. "Guardian Insurance Company is willing to purchase the building site, construct a building and install fixtures to our specifications, and then lease the facility to us for 20 years for an annual lease payment of only $1 million."

"That's just my point," said Harry, "At $1 million a year, it would cost us $20 million over the next 20 years instead of just $13 million. And what would we have left at the end? Nothing! The building would belong to the insurance company! I'll bet they would even want the first lease payment in advance."

"That's right," replied Erin. "We would have to make the first payment immediately and then one payment at the beginning of each of the following 19 years. However, you're overlooking a few things. For one thing, we would have to tie up a lot of our funds for 20 years under the present alternative. We would have to put $6 million down immediately to buy the property, and then we would have to pay the other $8 million off over four years at $2 million a year."

"But that cost is nothing compared to $20 million for leasing," said Harry. "Also, if we lease, I understand we would have to put up a $400,000 security deposit that we wouldn't get back until the end. And besides that, we would still have to pay all the repair and maintenance costs just like we owned the property. No wonder those insurance companies are so rich if they can swing deals like this."

"Well, I'd admit that I don't have all the figures sorted out yet," relied Erin. "But I do have the operating cost breakdown for the building, which includes $90,000 annually for property taxes, $60,000 for insurance, and $50,000 for repairs and maintenance. If we lease, Guardian will handle its own insurance costs and will pay the property taxes, but we'll have to pay for the repairs and maintenance. I need to put all this together and see if leasing makes any sense with our 12% before-tax required rate of return. The president wants a presentation and recommendation in the executive committee meeting tomorrow."

1. Using the net present value approach, determine whether Wyndham Stores should lease or buy the new store.

2. How will you reply in the meeting if Harry Wilson brings up the issue of the building's future sales value?