Question: 2. Use Linear programming function in excel You are the Investment Portfolio Manager and one of your responsibilities is to comply with the Investment Policy

2. Use Linear programming function in excel You are the Investment

2. Use Linear programming function in excel You are the Investment Portfolio Manager and one of your responsibilities is to comply with the Investment Policy for the fund's resources A recent Financial Audit found that the portfolio was not complying with the Internal Investment policy's cap (25%) As the party responsible you must submit a proposal to adjust the portfolio to comply with the cap. Financial Institution Financial Institution 1 Financial Institution 2 Financial Institution 3 Financial Institution 4 Financial Institution 5 Financial Institution 6 Total general Monto 221 520 930,00 1 000 000 000,00 693 653 490,00 515 000 000,00 692 000 000,00 75 000 000,00 3 197 174 420,00 With the information supplied: Build a model to determine the Fund's compliance with the investment cap. . . Determine the total size of the portfolio and the size of the cap. Prepare a proposal to adjust the portfolio taking into consideration the Liquid funds that should also be invested in fixed-rate assets. 2. Use Linear programming function in excel You are the Investment Portfolio Manager and one of your responsibilities is to comply with the Investment Policy for the fund's resources A recent Financial Audit found that the portfolio was not complying with the Internal Investment policy's cap (25%) As the party responsible you must submit a proposal to adjust the portfolio to comply with the cap. Financial Institution Financial Institution 1 Financial Institution 2 Financial Institution 3 Financial Institution 4 Financial Institution 5 Financial Institution 6 Total general Monto 221 520 930,00 1 000 000 000,00 693 653 490,00 515 000 000,00 692 000 000,00 75 000 000,00 3 197 174 420,00 With the information supplied: Build a model to determine the Fund's compliance with the investment cap. . . Determine the total size of the portfolio and the size of the cap. Prepare a proposal to adjust the portfolio taking into consideration the Liquid funds that should also be invested in fixed-rate assets

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Using the formula of solver in excel ( please screenshots step by step of the number that were put in the solver to get the new amounts) determining the new amounts and the adjustments ps solver...

Case Questions: Be Our Guest, Inc. 1. A. Reformat the income statement to clearly indicate EBITDA and EBIT. B. See footnote A Exhibit 3. Remove from "Other General and Administrative Expenses the...

You've graduated from college, landed a great job, and are ready to invest some of your income. Understanding that a diversified portfolio, that is, not putting all of your eggs in one basket, is an...

Using Probability Distributions. Suppose the returns on long-term corporate bonds and T-bills are normally distributed. Based on the historical record, use the NORMDIST function in Excel to answer...

aste BI U = A 191 > $ % ) 88-98 Format as Table Cell Styles 0 x & fx B D E F G - L M N 0 Money Growth Income 14% 7% 4% LP Formulation (16 points) The IAF Company is an investment advisory firm. IAF...

1. Using Probability Distributions. Suppose the returns on long-term corporate bonds and T-bills are normally distributed. Based on the historical record, use the NORMDIST function in Excel to answer...

uantitative Analysis BA 452 Homework 3 Questions Homework 3 covers the theory and applications in Lessons I-6 and I-7. This document has four parts: Objectives of doing your homework. Assignment of...

Please help me make an Executive Summary. Explain what you will examine in the case study. Write an overview of the field you are researching. Make a thesis statement and sum up the results of your...

ADM 2302 -Assignment #1 Problem 1 (15 points) The price of oil has been dropping significantly recently. This urges fund managers to adjust their investment portfolios. In particular, many fund...

Managerial Decision Making Six Decision Stages in Chapter 5 I. Identify and Diagnose the Problem Consider the following questions when identifying and diagnosing the problem: Is there a difference...

SP13. Kate is very pleased with the results of the first year of operations for Kate's Cards. She ended the year on a high note, with the company's reputation for producing quality cards leading to...

A direct current I flows along a lengthy straight wire. From the point O (Fig. 3.64) the current spreads radially all over an infinite conducting plane perpendicular to the wire. Find the magnetic...

The declaration of a cash dividend created a liability as of the daye of record. True or false?

Up - to - date standard costs provide a benchmark by which to evaluate actual costs and operations. True False Up - to - date standard costs provide a benchmark by which to evaluate actual costs and...