Question: use excel please 2. Constrained Optimization: You have identified 8 independent projects with positive NPVs. But with a budget constraint of $370,000, you can only

use excel please use excel please 2. Constrained Optimization: You have identified 8 independent projects

2. Constrained Optimization: You have identified 8 independent projects with positive NPVs. But with a budget constraint of $370,000, you can only invest in a few of these projects. Show: (10 points) 2.1. which projects you will invest in 2.2. the total investment amount 2.3. the total NPV amount Project Initial Investment 1 $6,000 2 $9,500 3 $65,000 4 $80,000 5 $100,000 6 $135,000 7 $150,000 8 $250,000 NPV $500 $11,000 $15,000 $6,000 $160,000 $40,000 $38,000 $45,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

please include excel inputs 2. Constrained Optimization: You have identified 10 independent projects with positive NPVs. But with a budget constraint of $800,000, you can only invest in a few of...

Please use excel and show formulas. Thank you! 2. Constrained Optimization: You have identified 10 independent projects with positive NPVs. But with a budget constraint of $700,000, you can only...

Hi, please provide detailed solution for these two questions. Thank you. RSM 333 Spring 2017 Assignment #2 Due Monday, February 6th @ 4pm in Commerce Office Problem #1: (20 marks) Project Analysis /...

Hi there! Could I please get help with this assignment please! Thanks Diploma In Accounting Program BUSI 370: Business Finance Section 202 Assignment #3 Capital Budgeting Case Study Chapter 13...

please read the problem, and answer the questions by using the color code the red outline is the problem the green is the questiobs MutoSave 72 OC... ISDS 710 Excel Model 6 - Time Value of Money (Net...

1. You are quoted an interest rate of 8% on an investment of $20 million. What is the value of your investment after five years if interest is compounded: a. Annually? b. Monthly? 2. A factory costs...

CIS 620/B Project Plan For the Global Collaboration Enterprise Information System 1200 12th Avenue, Suite 1200 Seattle, Washington 98114 U.S.A. November 11, 2015 Draft Version 19.0 November 11, 2015...

Complete tabs 10.4, 10.6, 10.11, 10.12, 10.19, and 10.22 in the attached Chapter 10 Excel spreadsheet. An EXAMPLE tab is provided in the spreadsheet for your guidance. You must use formulas in the...

1. What are the advantages and disadvantages of Rosetta Stone going public? 2. What do you think the current value of a share of Rosetta Stone is (at the time of the case)? Justify your valuation on...

Scott Malakoff has asked his executive team to research and propose capital expenditure projects that would significantly improve their respective department as well as create the most value for the...

Let z be a random variable with a standard normal distribution. Find the indicated probability and shade the corresponding area under the standard normal curve. P( 0.82 z 0)

Find the sum of squares of the deviations from the mean.

Which one of the following is NOOT among the traits and factors that define and shape the character of a company's corporate chler The company's standardt of what is ethically acceptable and what is...

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...