Determine the optimal investment portfolio

Assignment Help Financial Management

Reference no: EM131587400

A company is considering investing up to 1.5 million dollars in an investment portfolio consisting of a set of the following five independent capital projects (all of these projects will end at the end of 10 years). The initial investment for Project 1, 2, 3, 4, and 5 is $300k, $400k, $450k, $500k, and $600k, respectively. The annual return for these projects are $80k, $100k, $105k, $125k and $140k and the salvage value for these projects at the end of year 10 are $50k, $50k, $60k, $75k and $75k, respectively. Projects 2 and 4 are mutually exclusive. Also, project 1 is contingent on either or both projects 2 and 3. The company’s MARR is 10%. Determine the optimal investment portfolio given that:

a) The investment opportunities are indivisible.

b) The investment opportunities are divisible.

Please show all steps and formulas used in excel.

Reference no: EM131587400

Questions Cloud

Define plymouth and massachusetts bay : How did Puritan religious fervor and sentiment affect the way they established the colonies, including Plymouth and Massachusetts Bay

Key innovation of crypto-currency : It is well known that the key innovation of crypto-currency (such as Bitcoin, Ethereum) is distributed consensus protocol.

What is financial statement analysis : What is financial statement analysis? Select one of the ratios as your topic for discussion. What ratio is designed for in term of financial statement analysis?

Describe the factors that influenced your choice : Describe the factors that influenced your choice, and explain why you believe the method you've selected would be effective in this scenario.

Determine the optimal investment portfolio : Determine the optimal investment portfolio given that:

Derive the computational complexity of your algorithm : Implement your algorithm above and test its run time to verify your analysis. Remember that CPU time is not a valid measure for testing run time.

Communication diagram would be a better modeling tool : Describe situations when you would use a sequence diagram and when a communication diagram would be a better modeling tool.

What preliminary information would you gather : What preliminary information would you gather before conducting the needs assessment? Provide a rationale for your decision.

Details regarding the celciusconverter demo : Note: Please read this completely before starting the videos, especially the details regarding the CelciusConverter demo.

User Account

All Pages