Question: Make up an example, as described in Problem 54, with 20 possible investments. However, do it so that the ratios of NPV to cash requirement

Make up an example, as described in Problem 54, with 20 possible investments. However, do it so that the ratios of NPV to cash requirement are in a very tight range, from 3.0 to 3.2. Then use Solver to find the optimal solution when the Solver tolerance is set to its default value of 5%, and record the solution. Next, solve again with the tolerance set to zero. Do you get the same solution? Try this on a few more instances of the model, where you keep tinkering with the inputs. The question is whether the tolerance matters in these types of narrow-range problems.

Step by Step Solution

★★★★★

3.31 Rating (180 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

415-M-S-S-M (142).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!

Are all monopolies large firms? Make up an example of a monopoly that is a small firm.

Make up an example showing how residual income is calculated. What information is used in computing residual income that is not used in computing ROI?

Make up an example to show clearly and completely that you can develop an IE Matrix for a 3-division company, where each division has $10, $20, and $40 in revenues, and $2, $4, and $1 in profits....

Make up an example, as described in Problem 7, with 20 possible investments. However, do it so the ratios of NPV to cash requirement are in a very tight range, from 3 to 3.2. Then use Solver to find...

Make up an example, as described in Problem 8, with 20 possible investments. However, do it so the ratios of NPV to cash requirement are in a very tight range, from 3.0 to 3.2. Then use Solver to...

Make up an example, as described in the previous problem, with 20 possible investments. However, do it so the ROIs are in a very tight range, such as from 12% to 13%. Then use Solver to find the...

Expand the capital budgeting model in Figure 14.40 so that there are now 20 possible investments. You can make up the data on cash requirements, NPVs, and the budget. However, use the following...

Please help with the discussion below: ** Each of the 3 questions below only need to beabout two-threepara graphs but packed full of information, no fluff. **Attached below are a few readings from...

Please answer this question.. Very easy. -What sources of value most plausibly account for the differences between buyer and seller? -Structure and execute a discounted cash flow valuation of all of...

BLC Inc. is a medium-sized manufacturing company based in the UK. The company operates mainly in the London area and is based in Peterborough. At a recent board meeting, the company decided to expand...

Check the formula for S o T in Example 3.60, by performing the suggested direct substitution.

A 2-year-old child is brought to the physician for a routine examination. Physical examination shows a low- pitchedcardiac murmur. An echocardiogram shows the presence of ostium secundum, with a 1-cm...

iuppose the real rate is 1 . 8 % and the inflation rate is 2 . 7 % . What rate would you expect to see on a Treasury bill? a . 5 . 1 2 % b . 4 . 5 5 % c . 2 . 9 7 % d . 3 . 8 6 %

1.4 Use the Starbucks Corporation financial statements to answer the following questions. Visit www.pearsonglobaleditions.com/Horngren to view a link to Starbucks Corporations Fiscal 2011 annual...

Construct a two-way table with 60 women and 80 men in which there is a higher percentage of right-handed women.

A famous study by Amos Tversky and Nobel laureate Daniel Kahneman asked people to consider two hospitals. Hospital A is small and has 15 babies born per day. Hospital B has 45 babies born each day....

Suppose a student takes a 10-question multiple-choice quiz, and for each question on the quiz there are five possible options. Only one option is correct. Now suppose the student, who did not study,...

a. Calculate the after-tax cost of borrowing from the motorcycle dealership. b. Calculate the after-tax cost of borrowing through a second mortgage on Bella's home. c. Which source of borrowing is...

Please answer! DIY Inc. has is evaluating a 12 -year project. The project requires a machine that costs $125,000 and has a CCA rate of 25%. The machine is the only asset in the asset class and its...

Company A has a P / E of 5 x and Company B has a P / E of 8 x . Company A ' s cost of debt is 5 % , its cost of cash interest is 2 % and its tax rate is 5 0 % . If A purchases B using 5 0 % stock, 2...