Question

In: Finance

The Vice President of Finance at Kramerica, Inc. has determined a capital investment budget of $8,000,000...

The Vice President of Finance at Kramerica, Inc. has determined a capital investment budget of $8,000,000 for the next year. Unfortunately, this amount is not sufficient to accept all positive NPV projects available to the firm, which are listed in the table below.

Region

Project

Cost

NPV

Europe

1

$1,200,000

$172,036

Europe

2

$2,000,000

$362,283

Europe

3

$500,000

$147,487

Asia

4

$600,000

$72,076

Asia

5

$700,000

$129,352

Asia

6

$3,000,000

$527,127

Asia

7

$1,500,000

$343,632

Africa

8

$200,000

$52,836

Africa

9

$2,400,000

$275,936

Africa

10

$1,000,000

$175,824

Help the Vice President of Finance to choose which set of investments should be accepted.

a. Using the Solver, determine which projects should be accepted if the firm’s goal is to maximize shareholders wealth, subject to the maximum investment constraint. (Note: Make sure to set the Solving Method to Simplex LP.) Keep this solution on a sheet named 2a. Copy the sheet to start 2b.

b. Now assume that the Vice President of Finance has informed you that the capital budget has been cut to $4,000,000 for the next year, and that at least one project must be accepted for each region. Change your Solver constraints to account for this new information and find the new solution. Keep this solution on one sheet and name it 2b. Copy the sheet to start 2c.

c. In addition to the constraints from part b, the Vice President of Finance has now informed you that projects 3, 5, and 8 are mutually exclusive, so, at most, one of them can be selected. Change your Solver constraints to account for this new information and find the new solution. Keep this solution on one sheet and name it 2c.

Hints for parts b&c. You will need to set up cells on your spreadsheet that would add up the number of projects in the restricted categories. For example, in b, you create a cell to add all the 1's for a region and then have a constraint that requires that cell to be at least one.

Solutions

Expert Solution


Related Solutions

2. The Vice President of Finance at Kramerica, Inc. has determined a capital investment budget of...
2. The Vice President of Finance at Kramerica, Inc. has determined a capital investment budget of $8,000,000 for the next year. Unfortunately, this amount is not sufficient to accept all positive NPV projects available to the firm, which are listed in the table below. Region Project Cost NPV Europe 1 $1,200,000 $172,036 Europe 2 $2,000,000 $362,283 Europe 3 $500,000 $147,487 Asia 4 $600,000 $72,076 Asia 5 $700,000 $129,352 Asia 6 $3,000,000 $527,127 Asia 7 $1,500,000 $343,632 Africa 8 $200,000 $52,836...
Harold Blank, Vice President of Manufacturing for Herr Foods, Inc., was contemplating a capital investment that...
Harold Blank, Vice President of Manufacturing for Herr Foods, Inc., was contemplating a capital investment that could improve production; however, this operations decision would force several of his recently hired employees into new jobs as positions were eliminated by automation. Herr Foods took pride in achieving the highest quality in their finished products. Their top product line was potato chips, and the final physical inspection was a critical step. That was when several employees identified and removed around 75% of...
BQ, Inc., is considering making an offer to purchase iReport Publications. The vice president of finance...
BQ, Inc., is considering making an offer to purchase iReport Publications. The vice president of finance has collected the following information: BQ iReport   Price–earnings ratio 13.5 9.5   Shares outstanding 1,300,000 195,000   Earnings $ 3,300,000 $ 615,000   Dividends $ 830,000 $ 280,000 BQ also knows that securities analysts expect the earnings and dividends of iReport to grow at a constant rate of 5 percent each year. BQ management believes that the acquisition of iReport will provide the firm with some economies...
BQ, Inc., is considering making an offer to purchase iReport Publications. The vice president of finance...
BQ, Inc., is considering making an offer to purchase iReport Publications. The vice president of finance has collected the following information: BQ iReport   Price–earnings ratio 13.8 9.8   Shares outstanding 1,500,000 205,000   Earnings $ 3,500,000 $ 625,000   Dividends $ 850,000 $ 300,000 BQ also knows that securities analysts expect the earnings and dividends of iReport to grow at a constant rate of 5 percent each year. BQ management believes that the acquisition of iReport will provide the firm with some economies...
BQ, Inc., is considering making an offer to purchase iReport Publications. The vice president of finance...
BQ, Inc., is considering making an offer to purchase iReport Publications. The vice president of finance has collected the following information: BQ iReport   Price–earnings ratio 13.5 9.5   Shares outstanding 1,300,000 195,000   Earnings $ 3,300,000 $ 615,000   Dividends $ 830,000 $ 280,000 BQ also knows that securities analysts expect the earnings and dividends of iReport to grow at a constant rate of 5 percent each year. BQ management believes that the acquisition of iReport will provide the firm with some economies...
BQ, Inc., is considering making an offer to purchase iReport Publications. The vice president of finance...
BQ, Inc., is considering making an offer to purchase iReport Publications. The vice president of finance has collected the following information: BQ iReport   Price–earnings ratio 13.8 9.8   Shares outstanding 1,500,000 205,000   Earnings $ 3,500,000 $ 625,000   Dividends $ 850,000 $ 300,000 BQ also knows that securities analysts expect the earnings and dividends of iReport to grow at a constant rate of 5 percent each year. BQ management believes that the acquisition of iReport will provide the firm with some economies...
BQ, Inc., is considering making an offer to purchase iReport Publications. The vice president of finance...
BQ, Inc., is considering making an offer to purchase iReport Publications. The vice president of finance has collected the following information: BQ iReport   Price–earnings ratio 13.5 9.5   Shares outstanding 1,300,000 195,000   Earnings $ 3,300,000 $ 615,000   Dividends $ 830,000 $ 280,000 : BQ also knows that securities analysts expect the earnings and dividends of iReport to grow at a constant rate of 5 percent each year. BQ management believes that the acquisition of iReport will provide the firm with some...
BQ, Inc., is considering making an offer to purchase iReport Publications. The vice president of finance...
BQ, Inc., is considering making an offer to purchase iReport Publications. The vice president of finance has collected the following information: BQ iReport   Price–earnings ratio 13.5 9.5   Shares outstanding 1,300,000 195,000   Earnings $ 3,300,000 $ 615,000   Dividends $ 830,000 $ 280,000 BQ’s outside financial consultants think that the 7 percent growth rate is too optimistic and a 6 percent rate is more realistic. f-1 What is the value of iReport to BQ now? (Do not round intermediate calculations and round...
Plant, Inc., is considering making an offer to purchase Palmer Corp. Plant’s vice president of finance...
Plant, Inc., is considering making an offer to purchase Palmer Corp. Plant’s vice president of finance has collected the following information: Plant Palmer   Price-earnings ratio 16.2 12.5   Shares outstanding 1,670,000 920,000   Earnings $ 4,609,200 $ 1,150,000   Dividends $ 1,067,000 $ 487,000 Plant also knows that securities analysts expect the earnings and dividends of Palmer to grow at a constant rate of 4 percent each year. Plant management believes that the acquisition of Palmer will provide the firm with some economies...
As the vice president of finance for a company producing and selling electronic switchboards, you are...
As the vice president of finance for a company producing and selling electronic switchboards, you are considering a foreign investment to build a plant to assemble electronic components. A source in China advises you that a town near Shenzhen may be an excellent location for a new plant. Chinese are well educated and willing to work for reasonable wages. Projected construction costs are acceptable. Both rail lines and airports are nearby, and the current Chinese government seems politically stable. The...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT