Optimum portfolio of fully-partially selected investments

Assignment Help Financial Management

Reference no: EM131585499

A pharma company is considering five divisible projects with the following details

Choices 1 2 3 4 5

Initial Investment $300,000.00 $400,000.00 $450,000.00 $500,000.00 $600,000.00

Annual Receipts $205,000.00 $230,000.00 $245,000.00 $260,000.00 $290,000.00

Annual Disbursements $125,000.00 $130,000.00 $140,000.00 $135,000.00 $150,000.00

Salvage Value $50,000.00 $50,000.00 $60,000.00 $75,000.00 $75,000.00

The company uses a 10 year planning horizon and a MARR of 10% and has a capital limit of 1 million dollars. Determine the optimum portfolio of fully and partially selected investments. Perform a sensitivity analysis on plus or minus 10% on the capital investment. If project 3 has to be fully funded, will it change the funding selection and or the percentages? Please answer in excel

Reference no: EM131585499

Questions Cloud

Why is the file kept inaccessible to the web server : Why is the file kept inaccessible to the Web server? Discuss this issue, but assume that the attacker is on the internal network.

Choosing a decision alternative : As a new manager, what would you do to prevent yourself from choosing a decision alternative just to correct or validate a previous decision?

Capital investment decisions or capital budgeting decisions : Explain and discuss different methods for capital investment decisions or capital budgeting decisions criteria.

List the organizations business objectives : BSBINN601 Lead and Manage Organisational Change Assignment. Write a list of possible needs for change. List the organization's business objectives

Optimum portfolio of fully-partially selected investments : Determine the optimum portfolio of fully and partially selected investments. will it change the funding selection and or the percentages?

What is the objective of a good presentation strategy : What is the objective of a good presentation strategy? Give a brief description of the six main parts of the presentation plan?

How many lines intersect a given line at exactly one point : Let us generalize Problem. Suppose we wish to create a geometric structure from k points in the plane and that we consider a set of points to be a line.

Appointed manager of a production team : Mariel Espinoza has just been appointed manager of a production team operating the 11 p.m. to 7 a.m. shift in a large manufacturing firm.

Is password sharing an acceptable behavior : Is Password Sharing an Acceptable Behavior? Write a 1- to 2-page paper discussing whether you agree or don't agree with him.

User Account

All Pages