An Investment Company Currently Has 1 Million Dollars Available for Investment

question 43

Essay

An investment company currently has 1 million dollars available for investment in five different stocks.The company wants to maximize the interest earned over the next year.The five investment possibilities along with the expected interest earned are shown below.To manage risk,the investment firm wishes to have at least 35% of the investment in stocks A and B.Furthermore,no more than 15% of the investment may be in stock E.Model and solve this problem in Excel.
$$\begin{array} { l c } \text { Investment } & \text { Expected Interest Earned (\%) } \\ \text { Stock A } & 7 \\\text { Stock B } & 9 \\\text { Stock C } & 8 \\\text { Stock D } & 10 \\\text { Stock E } & 11\end{array}$$

---

Definitions:

Gross Profit Percentage

A financial metric that represents the proportion of money left over from revenues after accounting for the cost of goods sold (COGS), expressed as a percentage.

Net Profit Margin

Net profit margin is a financial ratio that shows what percentage of a company's revenues remain as net income after all expenses are deducted.

Earnings Per Share

A financial ratio that measures the portion of a company’s profit allocated to each outstanding share of common stock, indicating company profitability.

Time Management

Making effective use of available time.