Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose a new investment instrument F with an annual rate of return of 0.063 and a risk of 2 becomes available and the planner invests

image text in transcribed

Suppose a new investment instrument F with an annual rate of return of 0.063 and a risk of 2 becomes available and the planner invests 100000(of the 3 million) in this investment instrument. Then the optimal total return decreases ( a negative number) or increase ( a positive number) by: ___

Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 1000000 0 0.084 1E+30 0.026 1000000 0 0.074 1E+30 0.016 250000 o 0.053 0.005 1E+30 500000 0 0.058 0.016 0.005 250000 0 0.039 0.019 1E+30 Shadow Price Allowable Allowable Increase Decrease Variable Cells Cell Name $C$3 (0) total return R $D$3 (0) total return P $E$3 (0) total return T $F$3 (0) total return E $G$3 (0) total return G Constraints Cell Name $H$5 (1) total investment SH$6 (2) risk $H$7 (3a) max R SH$8 (3b) max P $H$9 (3c) max T $H$10 (3d) max E $H$11 (3e) max G $H$12 (4a) min R $H$13 (4b) min P $H$14 (4c) mint $H$15 (4d) min E $H$16 (4e) min G 0.058 0 0.026 0.016 0 500000 1E+30 125000 250000 1E+30 1E+30 1E+30 750000 750000 250000 250000 250000 250000 250000 500000 500000 750000 500000 750000 0 0 0 0 1E+30 1E+30 250000 -0.005 0 -0.019 1E+30 250000 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 1000000 0 0.084 1E+30 0.026 1000000 0 0.074 1E+30 0.016 250000 o 0.053 0.005 1E+30 500000 0 0.058 0.016 0.005 250000 0 0.039 0.019 1E+30 Shadow Price Allowable Allowable Increase Decrease Variable Cells Cell Name $C$3 (0) total return R $D$3 (0) total return P $E$3 (0) total return T $F$3 (0) total return E $G$3 (0) total return G Constraints Cell Name $H$5 (1) total investment SH$6 (2) risk $H$7 (3a) max R SH$8 (3b) max P $H$9 (3c) max T $H$10 (3d) max E $H$11 (3e) max G $H$12 (4a) min R $H$13 (4b) min P $H$14 (4c) mint $H$15 (4d) min E $H$16 (4e) min G 0.058 0 0.026 0.016 0 500000 1E+30 125000 250000 1E+30 1E+30 1E+30 750000 750000 250000 250000 250000 250000 250000 500000 500000 750000 500000 750000 0 0 0 0 1E+30 1E+30 250000 -0.005 0 -0.019 1E+30 250000

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

Applied Valuation A Pragmatic Approach

Authors: Clifford S. Ang

1st Edition

3110771748,3110771837

More Books

Students also viewed these Finance questions