Scribd Logo
Upload

Welcome to Scribd!

  • 0 views

    Data-8 - 12 - 2024-2 - 31 AM

    Uploaded by

    Rahul Kumar N
    unknow data 2

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Data-8 - 12 - 2024-2 - 31 AM

    Uploaded by

    Rahul Kumar N
    0 views3 pages
    unknow data 2

    Original Title

    data-8_12_2024-2_31 AM

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    unknow data 2

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    0 views3 pages

    Data-8 - 12 - 2024-2 - 31 AM

    Uploaded by

    Rahul Kumar N
    unknow data 2

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 3

    Dara's Investments Sensitivity Report

    Variable Cells
    Final
    Cell Name Value
    $B$17 1 Large cap blend Amount Invested 0
    $B$18 2 Small cap growth Amount Invested 14600
    $B$19 3 Green fund Amount Invested 20400
    $B$20 4 Growth & income Amount Invested 0
    $B$21 5 Multi-cap growth Amount Invested 0
    $B$22 6 Mid-cap index Amount Invested 0
    $B$23 7 Multi-cap core Amount Invested 5900
    $B$24 8 Small cap international Amount Invested 19600
    $B$25 9 Emerging international Amount Invested 19600
    $B$26 10 Money market fund Amount Invested 13800
    $B$27 11 Savings account Amount Invested 5300

    Constraints
    Final
    Cell Name Value
    $E$15 Total Amount Invested 99200
    $E$16 Total International Amount Invested 39200
    $E$17 Current Holdings Amount Invested 35000
    $E$18 New Investments Amount Invested 64200
    Reduced Objective Allowable Allowable
    Cost Coefficient Increase Decrease
    -0.0361 0.1615 0.0358 1E+030
    0 0.1991 0.0576 0.0359
    0.0577 0.2586 1E+030 0.0571
    -0.0512 0.1461 0.0519 1E+030
    -0.0796 0.1903 0.0802 1E+030
    -0.0507 0.2197 Coefficient
    0.0507 1E+030
    0 0.2684 0.4 0.0758 0.0506
    0.0755 0.3419 0.3 1E+030 0.0757
    0.2
    0.0797 0.3489 1E+030 0.0806
    0.1
    -0.2231 0.0489 0.2234 1E+030
    0
    -0.2595 0.0103 0.2619 1E+030
    Coefficient

    Shadow Constraint Allowable Allowable


    Price R.H. Side Increase Decrease
    0.2677 99200 15000 6000
    0 16000 23200 1E+030
    -0.0767 35000 5000 15000
    0 30000 35000 1E+030
    min max
    -1E+030 0.1973
    0.1632 0.2567
    0.2015 1E+030
    -1E+030 0.198
    -1E+030 0.2705
    -1E+030 0.2704
    0.2178 0.3442
    0.2662 1E+030
    0.2683 1E+030
    -1E+030 0.2723
    Coefficient -1E+030 0.2722

    You might also like