InClassCase2 - PeopleInvestNew

# InClassCase2 - PeopleInvestNew - Microsoft Excel 10.0...

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

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

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

View Full Document
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
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

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

View Full Document
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
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

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

View Full Document
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
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• 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.

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

• 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.

Dana University of Pennsylvania ‘17, Course Hero Intern

• 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.

Jill Tulane University ‘16, Course Hero Intern