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.
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? Get Finance homework help today
We aim at 100% customer satisfaction. As such, we never compromise on the quality of our assignment services and strive to maintain the highest standards of work for all our clients. Our writers craft each paper carefully to match the requirements on the instructions form while at the same time being surgical and objective while handling client work.
We receive many applications from writers around the world daily. Nevertheless, we only choose the cream of the crop to tackle your “help with homework” requests. Hence, our homework helpers are highly-qualified individuals who adhere to our quality policy.
We maintain a fair pricing policy for all our homework help services. Our pricing system generates quotations based on the requirements of each paper. Hence regardless of the complexity or duration of a paper, our system determines the most accurate and pocket-friendly price for all our clients.
At MyHomeworkWriters, we guarantee all students swift delivery of their assignments. We understand that time is an essential factor in the academic world. We, therefore, ensure that all assignments are delivered on or before the agreed deadline. This leaves room for editing to incase the client wants changes done to the work delivered by our writers.
We maintain a zero-plagiarism policy in all our papers. Our writers stick to the instructions to deliver plagiarism-free work. Other than that, they extensively research the work they are handling and are keen to avoid any chance of similarities with previously written papers. Our editors check every completed work to ascertain it’s at the set standards.
Our main objective is to assist you through every step of your academic journey. Thus, we completely understand that you might run into trouble once in a while when interacting with our system. If you do run into trouble, please get in touch with our support agents and they will immediately provide you with assistance. Feel free to contact us via the Chat window or email us.
Follow these simple steps to get your homework done
Fill in the order form and provide all details of your assignment.
Choose the payment system that suits you most.
You will be able to track the progress of your paper from our system.
Once your paper is ready, we will email it to you.
Myhomeworkwriters holds a reputation for providing high-quality assignment writing services. You only need to give us all the requirements for your “do my homework” order, and our writers will give you the best results.
Our team is skilled and equipped in searching for information required to complete work handed over to them. Regardless of the complexity of the work, we are determined to get the job done. Extensive research when handling client requests makes it possible for us to be able to stick to the boundaries and guidelines set by the clients. Thus enabling us to keep the work original and plagiarism free.
We have highly qualified writers to assist you whenever you place in "help with my homework" order. Our essay writing service is designed to not only help students get good grades but also excel in their studies. Our writers are highly experienced and educated specialists and professionals who want to do more than creating a difference in the academic field.
Our editors have a keen eye when going through work. They can capture even the smallest of errors. This has been made possible by the fact that we have been in the academic field for more than 5 years now. Thus, they bring with them previous experience when going through work to be able to capture everything. These unique skills make it possible for us to deliver error-free work to our clients.
Our team has very experienced specialists and professionals. This gives us a competitive edge over our competitors. Whenever we receive work that needs to be redone, everyone gets involved. That’s inclusive of our editors. This collective involvement in doing work makes it possible for us to deliver high-quality work to all our clients. Other than that it makes it possible for us to adhere to our originality and plagiarism-free policies.