investment using optimmization

6
INVESTMENT MANAGEMENT UNDER TAXATION Stock Data Number Stock Number of Shares 1 Yahoo! 150 2 General Electric 150 3 Microsoft 150 4 Bank of America 150 5 JPMorgan Chase 150 6 Cisco Systems, Inc 150 7 Intel 150 8 Pfizer 150 Decisions: no.of.shares hold sold 1 50 100 2 75 75 3 75 75 4 150 0 5 150 0 6 150 0 7 75 75 8 95.6498848124586 54.3501151875414 Constraints no.of shares <= no.of shares >= Cash amt 10000 =

Upload: msssingh

Post on 10-Nov-2015

22 views

Category:

Documents


0 download

DESCRIPTION

This sheet is used to find optimal no. of stocks to invest to maximize the profit.

TRANSCRIPT

Sheet1INVESTMENT MANAGEMENT UNDER TAXATION

Stock Data

NumberStockNumber of SharesPrice Purchased Last YearCurrent PriceNext Year Price EstimateGain this yearCurrent value1Yahoo!15015.6831.829.516.1210777.40281394562General Electric15022.124.2826.312.18invested amt3Microsoft15030.3932.534.552.118545.30686125854Bank of America1508.9314.1615.235.235JPMorgan Chase15040.5550.9962.4310.446Cisco Systems, Inc15018.5824.1726.685.597Intel15022.5423.6723.851.138Pfizer15024.8428.7731.663.931154.715Decisions:no.of.shares holdsoldObjective15010026507.525353162450100275757575375757575415001500515001500615001500775757575895.649884812554.35011518759654Constraintsno.of shares=0Cash amt10000=10000

Sheet2rawSGRGDFCrude sumGasoline sumConIronoutputQConIronC12400800.00000036388004000.00000036383000120.5SG>=300003000