Project Evaluation Assignment | Homework For You

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 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.Homework For You

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

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.

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.

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.

Can you include formulas in excel? This question wasn’t answered because it didn’t have enough information but this is the only information given for the problem. Get Finance homework help today

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Excellent response.
Customer 460653, April 15th, 2022
English 101
Good job
Customer 454209, June 2nd, 2020
Excellent work.
Customer 459155, June 7th, 2022
The work was really good and done on time.
Customer 454439, June 1st, 2020
Business and administrative studies
Thank you!
Customer 453187, January 11th, 2022
Business and administrative studies
This was done very well. Thank you!
Customer 458435, September 10th, 2022
Could have been more through and provided me specific details. Some answers we more of a summary or recap thank analysis.
Customer 464471, August 21st, 2023
Good work!
Customer 463337, March 10th, 2023
Thank you!!!
Customer 454087, June 19th, 2020
Thank You
Customer 462669, March 11th, 2022
English 101
Impeccable output.
Customer 462717, April 20th, 2022
Web Design
Good work. Avoid such revisions.
Customer 452441, April 12th, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat