Purchase Solution

Portfolio Optimizations

Not what you're looking for?

Ask Custom Question

I have the three funds below with their own return and standard deviation. I want to find the optimal/efficient portfolio in Excel. Can you help me with this? (basically varying the weights of the 3 funds in the portfolio I want to find the best combination for the highest portfolio return and lower risk for instance). In Excel please. (If you need this info, suppose I have $2M to invest in this portfolio and you wan to maximize return for a targeted risk)

NU Bond E(r) 12.04% Stdev 15.6%
NU Equity E(r) 8.55% Stdev 5.76%
NU Cash E(r) 4.96% Stdev 0.98%.

Purchase this Solution
Solution Summary

This posting helps with portfolio optimizations. The solution describes how to arrive at optimal asset portfolio using linear programming/Excel Solver in the attachment. It contains mathematical formulation also. The explanation is given in 102 words.

Solution Preview

Please find attached Excel file for the help on your posting. There are two sheets.

1. Max Return - Maximizing returns for a target ...

Purchase this Solution
Free BrainMass Quizzes
Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

View More Free Quizzes
Related BrainMass Solutions

  • Systems of Linear Equations (10 Examples) : Equalities, Inequalities and Optimizations

    Systems of linear equations represented by equalities, inequalities and optimizations are presented in detail. Graph diagrams are included. The solution is detailed and well presented.

  • Supply Chain Management

    Internet has enabled collaboration with suppliers which has led to even better supply chain optimizations. Technology has also played a big role. Software has also played a big role and made supply chain optimization relatively easy.

  • Storage in Computer Systems

    These include optimizations for dealing with open files and live data sources as well as compression, encryption, and de-duplication, among others.

  • sensitivity analysis

    Thank you for your question Thank you, Jacob After finishing the posting I found a very useful tool in Excel to solve optimizations like when you want Present Worth equal to Zero. In the Tools menu, choose Add-ins. Choose Solver, click OK.

  • E-business mini project.

    APPLICATION-LEVEL OPTIMIZATIONS

    After system-level bottlenecks have been alleviated, developers of ABC's site can further increase performance through changes in the application, including caching, data access optimizations, and application

  • Children and gun safety

    The other variable you will be examining is the safety of children (specifically concerning guns) The optimizations you have identified for the safety training are valid. I believe that firearm storage is apart of that training.

  • Intermodal Logistical Facilities

    Whereas corporations initiate logistics optimizations with respect to transport avoidance, modal shift and efficiency improvement by intelligent consolidation strategies to utilize their network structure sustainably and sufficiently, transport policy

  • Optimizations, Limits, Concavity and Derivatives

    236505 Optimizations, Limits, Concavity and Derivatives Hi, Can you help me with the following questions of this Assignment: Q. 7, 8, 11, 12, 13 11.

  • Operating system

    EIGRP Enhanced Interior Gateway Routing Protocol - (EIGRP) is an advanced distance-vector routing protocol, with optimizations to minimize both the routing instability incurred after topology changes, as well as the use of bandwidth and processing power

View More Related Solutions