Question: PLEASE just give me the final answer, whatever I am supposed to write in each boxes only. Thank you! International City Trust (ICT) invests in

PLEASE just give me the final answer, whatever I am supposed to write in each boxes only. Thank you!

International City Trust (ICT) invests in short-term trade credits, corporate bonds, gold stocks, and construction loans. The board of directors has placed limits on how much can be invested in each area as follows. ICT has $5 million to invest and wants to maximize the return on investment over the next year while satisfying the diversification requirements set by the board. The board has also decided that at least 55% of the funds must be invested in gold stocks and construction loans and no less than 15% be invested in trade credit. After formulating the LP model, build the model in Excel and use Solver to find the optimal solution. The optimal protfolio (in \$) that maximizes the ROI in Trade Credit in Corporate Bonds in Gold Stocks in Construction Loans the maximum ROI is Please round your answer to each value to the nearest integer; do not enter the $ sign and do not include the comma separating the thousand. For example, if your answer is $250,000, enter ONLY 250000

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 General Management Questions!

Investment Interest return Maximum investment 1,000,000s Trade Credits 8% 1.0 Corporate Bonds 10% 2.5 Gold Stocks 20% 1.5 Construction Loans. 15% 1.8 a) Formulate the problem in a MS-Excel...

1,000,000s Trade Credits 8% 1.0 Corporate Bonds 10% 2.5 Gold Stocks 20% 1.5 Construction Loans 15% 1.8 a) Formulate the problem in a MS-Excel spreadsheet, use the Solver Command to solve the problem....

please show work and write big and clearly. do not use excel ILAR PROGRAMMING APPLICATIONS 3) International City Trust (ICT) invests in short-term trade credits, corporate bonds, gold stocks, and...

answer should be in excel Investment Portfolio Problem Description International City Trust (ICT) invests in short-term trade credits, corporate bonds, gold stocks, and construction loans. The board...

.I SELECTED ! Schedule D:Net Long-Term Capital Gains or Losses only its a team work. I need in 3-4 just just scehdule D I. Title: Preparation of a Corporate Income Tax Return Using IRS Form 1120 II....

Your end-of-semester assignment is as follows: (a) (i) read the two Economist articles entitled ?Debt is Good for You? (dated 01/25/2001) and ?Debtors? Prison? (dated 02/09/2009), which discuss the...

hello got to fill out schedule k for Jim corporation 2011 Instructions for Form 1120 Department of the Treasury Internal Revenue Service U.S. Corporation Income Tax Return Section references are to...

(Questions from Lecture and Article) - Discussion Board Activity I need to read the following Lecture Note and the ?Wall Street Journal? articles that I uploaded, and writeanswers for theDiscussion...

Prepare the couples federal income tax return, Form 1040 for the year ended December 31, 2021 , plus any additional schedules necessary. Forms are available at the IRS website Links to an external...

Hello, I 1.Research the capacity of municipalities in Bosnia and Herzegovina for issuing a bonds? 2.What are pros and cons of bond financing? Compare long-term source of financing between Bosnia and...

(Adjusting Entries) A review of the ledger of Oklahoma Company at December 31, 2005, produces the following data pertaining to the preparation of annual adjusting entries. 1. Salaries Payable $0....

1. Prepare manual entries and complete the general and subsidiary ledgers. 2. Prepare an account receivable and account payable reconciliation of the subsidiary ledger accounts to the control...

AreaWhich of the following employee fringe benefits may be excluded from income? a . Pre - tax health care flexible expense spending account up to $ 5 , 0 0 0 b . Cost of group term life insurance...

What is an example of constructive feedback? provide reference