Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you please help me with part d) with using excel solver function please show me the formulas and explain what the question is asking

can you please help me with part d) with using excel solver function
please show me the formulas and explain what the question is asking
image text in transcribed
image text in transcribed
Part-D Instructions: Solver A. Identify your goal (It could be to maximize the Portfolie ROI or Portfolio Profit or minimize losses). B. Identify which cells should vary to set up the solver model C. Use the following constraints: Initial amount invested in each firm must be at least $5,000 and should not exceed 550,000 Total amount investod across all the five firms should be no less than $95.000 and no greater than $100,000 After you setup the solver parameters and run it, you will see that solver has identified a solution that meet your objective, EXTREMELY IMPORTANT: At this stage, solver will ask you which solution to keep, DO NOT select "Keep Solver Solution". SELECT 2 option of "Retain Original Values", P33 fx D E F G 1 1 K L 204.65 C Sell Price 160.16 163.19 41.09 51.36 66.41 #of Shares 339 36 1104 511 892 Initial $Invested 24,574.11 73674 22,885.92 18,329.57 26,822.44 Profit/Loss 29720.13 - 1492.56 22477.44 7915.39 32415.28 ROIX) 121% -20% 98% 43% 121% ROI = Sale Price-Buy Price/Buy Price 1 Purchase Price 2 Accenture 72.49 3 IBM 4 Cisco 20.73 5 Oracle 35.87 6 Leldos 30.07 7 3 9 Portfolio Analysis >>>> 10 11 12 13 Total Amount invested 99,979.44 Total RO - Total Profit/Loss total amt invested Total Profit/Loss Total ROI 91035.68 0.910544

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Islamic Accounting

Authors: Nabil Baydoun, Maliah Sulaiman, Roger J. Willett, Shahul Ibrahim

1st Edition

1119023297, 9781119023296

More Books

Students also viewed these Accounting questions