homework help
kanecia22
investment_portfolio_project_template.xlsxPorifolio
| Portfolio Manager | ||||||||||
| Profolio | Stocks | Real Estate | Bonds | CD | ||||||
| Profit Percentage: | 0.1 | 0.07 | 0.04 | 0.01 | Resources | |||||
| Resources: | Investments | Constraint | Available | Left over | ||||||
| Total Investments | 1 | 1 | 1 | 1 | <= | $1,000,000.00 | ||||
| VaR percentage on Stocks | 0.06 | -- | -- | -- | <= | $25,000.00 | ||||
| VaR percentage on Real Estate | -- | 0.02 | -- | -- | <= | $15,000.00 | ||||
| VaR percentage on Bonds | -- | -- | 0.01 | -- | <= | $2,500.00 | ||||
| Stocks minimum holding | 1 | -- | -- | -- | >= | $50,000.00 | ||||
| Real Estate minimum holding | -- | 1 | -- | -- | >= | $50,000.00 | ||||
| Bond minimum holding | -- | -- | 1 | -- | >= | $50,000.00 | ||||
| CD minimum holding | -- | -- | -- | 1 | >= | $50,000.00 | ||||
| CD & Bonds for liquidity | -- | -- | 1 | 1 | >= | $200,000.00 | ||||
| Liquidity constraint on Real Estate holding | -- | 1 | -- | -- | <= | $300,000.00 | ||||
| Decision Variables | ||||||||||
| Stocks | ||||||||||
| Real Estate | ||||||||||
| Bonds | ||||||||||
| CD | ||||||||||
| Objective | ||||||||||
| Maximized Profits |
Sensitivity Report _Portfolio
| Microsoft Excel 14.0 Sensitivity Report | |||||||
| Worksheet: [Investment_portfolio_project.xlsx]Sheet1 | |||||||
| Report Created: 8/14/2014 3:25:33 PM | |||||||
| Variable Cells | |||||||
| Final | Reduced | Objective | Allowable | Allowable | |||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
| $C$18 | Stocks | 416666.666666667 | 0 | 0.1 | 1E+30 | 0.06 | |
| $C$19 | Real Estate | 300000 | 0 | 0.07 | 1E+30 | 0.03 | |
| $C$20 | Bonds | 233333.333333333 | 0 | 0.04 | 0.03 | 0.03 | |
| $C$21 | CD | 50000 | 0 | 0.01 | 0.03 | 1E+30 | |
| Constraints | |||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
| $H$10 | -- Investments | $416,666.67 | 0 | 50000 | 366666.666666667 | 1E+30 | |
| $H$11 | -- Investments | $300,000.00 | 0 | 50000 | 250000 | 1E+30 | |
| $H$12 | -- Investments | $233,333.33 | 0 | 50000 | 183333.333333333 | 1E+30 | |
| $H$13 | -- Investments | $50,000.00 | -0.03 | 50000 | 183333.333333333 | 16666.6666666667 | |
| $H$14 | -- Investments | $283,333.33 | 0 | 200000 | 83333.3333333333 | 1E+30 | |
| $H$15 | -- Investments | $300,000.00 | 0.03 | 300000 | 83333.3333333333 | 16666.6666666667 | |
| $H$6 | Total Investments Investments | $1,000,000.00 | 0.04 | 1000000 | 16666.6666666667 | 83333.3333333333 | |
| $H$7 | -- Investments | $25,000.00 | 1 | 25000 | 5000 | 1000 | |
| $H$8 | -- Investments | $6,000.00 | 0 | 15000 | 1E+30 | 9000 | |
| $H$9 | -- Investments | $2,333.33 | 0 | 2500 | 1E+30 | 166.6666666667 |
Porifolio_500000_more
| Portfolio Manager | ||||||||||
| Profolio | Stocks | Real Estate | Bonds | CD | ||||||
| Profit Percentage: | 0.1 | 0.07 | 0.04 | 0.01 | Resources | |||||
| Resources: | Investments | Constraint | Available | Left over | ||||||
| Total Investments | 1 | 1 | 1 | 1 | <= | $1,500,000.00 | ||||
| VaR percentage on Stocks | 0.06 | -- | -- | -- | <= | $25,000.00 | ||||
| VaR percentage on Real Estate | -- | 0.02 | -- | -- | <= | $15,000.00 | ||||
| VaR percentage on Bonds | -- | -- | 0.01 | -- | <= | $2,500.00 | ||||
| Stocks minimum holding | 1 | -- | -- | -- | >= | $50,000.00 | ||||
| Real Estate minimum holding | -- | 1 | -- | -- | >= | $50,000.00 | ||||
| Bond minimum holding | -- | -- | 1 | -- | >= | $50,000.00 | ||||
| CD minimum holding | -- | -- | -- | 1 | >= | $50,000.00 | ||||
| CD & Bonds for liquidity | -- | -- | 1 | 1 | >= | $200,000.00 | ||||
| Liquidity constraint on Real Estate holding | -- | 1 | -- | -- | <= | $300,000.00 | ||||
| Decision Variables | ||||||||||
| Stocks | ||||||||||
| Real Estate | ||||||||||
| Bonds | ||||||||||
| CD | ||||||||||
| Objective | ||||||||||
| Maximized Profits |
Stock less_yield
| Portfolio Manager | ||||||||||
| Profolio | Stocks | Real Estate | Bonds | CD | ||||||
| Profit Percentage: | 0.06 | 0.07 | 0.04 | 0.01 | Resources | |||||
| Resources: | Investments | Constraint | Available | Left over | ||||||
| Total Investments | 1 | 1 | 1 | 1 | <= | $1,000,000.00 | ||||
| VaR percentage on Stocks | 0.06 | -- | -- | -- | <= | $25,000.00 | ||||
| VaR percentage on Real Estate | -- | 0.02 | -- | -- | <= | $15,000.00 | ||||
| VaR percentage on Bonds | -- | -- | 0.01 | -- | <= | $2,500.00 | ||||
| Stocks minimum holding | 1 | -- | -- | -- | >= | $50,000.00 | ||||
| Real Estate minimum holding | -- | 1 | -- | -- | >= | $50,000.00 | ||||
| Bond minimum holding | -- | -- | 1 | -- | >= | $50,000.00 | ||||
| CD minimum holding | -- | -- | -- | 1 | >= | $50,000.00 | ||||
| CD & Bonds for liquidity | -- | -- | 1 | 1 | >= | $200,000.00 | ||||
| Liquidity constraint on Real Estate holding | -- | 1 | -- | -- | <= | $300,000.00 | ||||
| Decision Variables | ||||||||||
| Stocks | ||||||||||
| Real Estate | ||||||||||
| Bonds | ||||||||||
| CD | ||||||||||
| Objective | ||||||||||
| Maximized Profits |
Sheet2
Sheet3
1
2
3
4
5
6
7
8
A
B
C
Portfolio Manager
Profolio
Profit Percentage:
Resources:
Total Investments
VaR percentage on Stocks
VaR percentage on Real Estate
