InClassCase2 - PeopleInvestNew - Microsoft Excel 10.0...

Info icon This preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Excel 10.0 Answer Report Worksheet: [PeopleInvestNew.xls]PeopleInvest Model (with To (2) Report Created: 2/4/2004 12:08:45 PM Target Cell (Max) Cell Name Original Value Final Value $L$6 Objective Function: Total Return 0 61512.73 Adjustable Cells Cell Name Original Value Final Value $B$4 EZ 0 0 $C$4 EG 0 80000 $D$4 E/RF 0 60933.33 $E$4 DW 0 80000 $F$4 DZ 0 0 $G$4 DS 0 10000 $H$4 RG 0 80000 $I$4 MT 0 73066.67 $J$4 MM 0 1000 $K$4 MA 0 15000 Constraints Cell Name Cell Value Formula Status Slack $L$10 (1) Total Invest LHS 400000 $L$10<=$N$10 Binding 0 $L$11 (2) Avg. liquidity factor LHS 28428666.67 $L$11>=$N$11 Not Binding 2428666.67 $L$12 (3) Avg. risk LHS 16000000 $L$12<=$N$12 Binding 0 $L$13 (4) Equity category LHS 140933.33 $L$13<=$N$13 Not Binding 19066.67 $L$14 (5) Debt cateogry LHS 90000 $L$14<=$N$14 Not Binding 70000 $L$15 (6) RE category LHS 140933.33 $L$15<=$N$15 Not Binding 19066.67 $L$16 (7) MM cateory LHS 89066.67 $L$16<=$N$16 Not Binding 70933.33 $L$17 (8) Total Debt LHS 90000 $L$17<=$N$17 Binding 0 $L$18 (9) EZ LHS 0 $L$18<=$N$18 Not Binding 80000 $L$19 (10) EG LHS 80000 $L$19<=$N$19 Binding 0 $L$20 (11) E/RF LHS 60933.33 $L$20<=$N$20 Not Binding 19066.67 $L$21 (12) DW LHS 80000 $L$21<=$N$21 Binding 0 $L$22 (13) DZ LHS 0 $L$22<=$N$22 Not Binding 80000 $L$23 (14) DS LHS 10000 $L$23<=$N$23 Not Binding 70000 $L$24 (15) RG LHS 80000 $L$24<=$N$24 Binding 0 $L$25 (16) MT LHS 73066.67 $L$25<=$N$25 Not Binding 6933.33 $L$26 (17) MA LHS 15000 $L$26<=$N$26 Not Binding 65000 $L$27 (18) Zizzle S&B LHS 0 $L$27<=$N$27 Not Binding 60000 $L$28 (19) MM LHS 1000 $L$28>=$N$28 Binding 0 $L$29 (20) MA LHS 15000 $L$29<=$N$29 Binding 0 $L$30 (21) MT LHS 73066.67 $L$30>=$N$30 Not Binding 63066.67
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Microsoft Excel 10.0 Sensitivity Report Worksheet: [PeopleInvestNew.xls]PeopleInvest Model (with To (2) Report Created: 2/4/2004 12:08:45 PM Adjustable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase $B$4 EZ 0 -0.01 0.15 0.01 $C$4 EG 80000 0 0.17 1.00E+030 $D$4 E/RF 60933.33 0 0.18 0 $E$4 DW 80000 0 0.12 1.00E+030 $F$4 DZ 0 -0.01 0.12 0.01 $G$4 DS 10000 0 0.12 0 $H$4 RG 80000 0 0.22 1.00E+030 $I$4 MT 73066.67 0 0.1 0 $J$4 MM 1000 0 0.11 0 $K$4 MA 15000 0 0.13 1.00E+030 Constraints Final Shadow Constraint Allowable Cell Name Value Price R.H. Side Increase $L$10 (1) Total Invest LHS 400000 0.15 400000 38235.29 $L$11 (2) Avg. liquidity factor LHS 28428666.67 0 0 2428666.67 $L$12 (3) Avg. risk LHS 16000000 0 0 1430000 $L$13 (4) Equity category LHS 140933.33 0 0 1.00E+030 $L$14 (5) Debt cateogry LHS 90000 0 0 1.00E+030 $L$15 (6) RE category LHS 140933.33 0 0 1.00E+030 $L$16 (7) MM cateory LHS 89066.67 0 0 1.00E+030 $L$17 (8) Total Debt LHS 90000 0 0 70000 $L$18 (9) EZ LHS 0 0 0 1.00E+030 $L$19 (10) EG LHS 80000 0 0 65285.71 $L$20 (11) E/RF LHS 60933.33 0 0 1.00E+030 $L$21 (12) DW LHS 80000 0 0 10000 $L$22 (13) DZ LHS 0 0 0 1.00E+030 $L$23 (14) DS LHS 10000 0 0 1.00E+030 $L$24 (15) RG LHS 80000 0.07 0 26021.43 $L$25 (16) MT LHS 73066.67 0 0 1.00E+030 $L$26 (17) MA LHS 15000 0 0 1.00E+030 $L$27 (18) Zizzle S&B LHS 0 0 0 1.00E+030 $L$28 (19) MM LHS 1000 0 1000 72769.23 $L$29 (20) MA LHS 15000 0.03 15000 30358.33 $L$30 (21) MT LHS 73066.67 0 10000 63066.67
Image of page 2
Allowable Decrease 1.00E+030 0 0 0 1.00E+030 0 0.07 0 1.00E+030 0.03 Allowable Decrease 165384.62 1.00E+030 520000 19066.67 70000 19066.67 70933.33 9811.32 80000 20428.57 19066.67 70000 80000 70000 20800 6933.33 65000 60000 1000 6933.33 1.00E+030
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
People's Investment Decision Variables: EZ EG E/RF DW DZ DS RG MT MM MA 0 0 0 0 0 0 0 0 0 0 Objective Function: 0.15 0.17 0.18 0.12 0.12 0.12 0.22 0.1 0.11 0.13 Constraints: (1) Total Invest 1 1 1 1 1 1 1 1 1 1 (2) Avg. liquidity factor 100 100 100 95 92 79 80 100 (3) Avg. risk 60 70 75 20 30 22 50 10 (4) Equity category 1 1 1 (5) Debt cateogry 1 1 1 (6) RE category 1 1 (7) MM cateory 1 1 1 (8) Total Debt 1 1 1 (9) EZ 1 (10) EG 1 (11) E/RF 1 (12) DW 1 (13) DZ 1 (14) DS 1 (15) RG 1 (16) MT 1 (17) MA 1 (18) Zizzle S&B 1 1 (19) MM 1 (20) MA 1 (21) MT 1
Image of page 4
Total Return 0 LHS Type RHS 0 <= 400000 0 >= 0 0 <= 0 0 <= 0 0 <= 0 0 <= 0 0 <= 0 0 <= 75000 0 <= 0 0 <= 0 0 <= 0 0 <= 0 0 <= 0 0 <= 0 0 <= 0 0 <= 0 0 <= 0 0 <= 60000 0 >= 1000 0 <= 15000 0 >= 10000
Image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Microsoft Excel 10.0 Answer Report Worksheet: [PeopleInvestNew.xls]PeopleInvest Model Report Created: 2/4/2004 12:17:02 PM Target Cell (Max) Cell Name Original Value Final Value $L$6 Objective Function: Total Return 61512.73 61493.08 Adjustable Cells
Image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern