首页
网站开发
桌面应用
管理软件
微信开发
App开发
嵌入式软件
工具软件
数据采集与分析
其他
首页
>
> 详细
代写 GR5280、代做 Java/Python 编程设计
项目预算:
开发周期:
发布时间:
要求地区:
Start date: 12/7/2024
Due date: 12/21/2024
MATH GR5280, Capital Markets & Investments
Final Project
Note: All files and information related to the final project are uploaded into the Modules starting with “Final Project” prefix on CourseWorks.
The aim of this Final Project is to practically implement the ideas from the course, specifically from Chapters 7 and 8 of [BKM13]. Using Bloomberg, you will be given a recent 20 years of recent historical daily total return data for ten stocks, which belong in groups to three-four different sectors (according to Yahoo!finance), one (S&P 500) equity index and a proxy for risk-free rate (1-month Fed Funds rate). Additionally, you will be given contemporaneous ESG [ESG3] scores data also from Bloomberg for all of your companies with detailed explanations to them. In order to reduce the non-Gaussian effects, you will need to aggregate the daily data to the monthly observations, and based on those monthly observations, you will need to calculate all proper optimization inputs for the full Markowitz Model (“MM”), alongside the Index Model (“IM”). Using these optimization inputs for MM and IM you will need to find the regions of permissible portfolios (efficient frontier, minimal risk portfolio, optimal portfolio, and minimal return portfolios frontier) for the following four cases of problems:
1. This optimization is designed to simulate the typical limitations existing in the U.S. mutual fund industry: a U.S. open-ended mutual fund is not allowed to have any short positions, for details see the Investment Company Act of 1940, Section 12(a)(3) (https://www.law.cornell.edu/uscode/text/15/80a-12):
wi ≥0,for∀i;
2. Now, having the efficient risky portfolio {wˆ }10 for the solution for the above problem 1, you will
i i=1
need to solve the problem 1 above with the following constraint on ESG:
10
( E + S + G ) w ≤ 0 . 9 ×
10
i=1
(https://www.finra.org/rules-guidance/key-topics/margin-accounts), which allows broker-dealers to allow their customers to have positions, 50% or more of which are funded by the customer’s account equity:
iiii
( E + S + G ) wˆ ; iiii
i=1
3. This optimization constraint is designed to simulate the Regulation T by FINRA
4. Lastly, having the efficient risky portfolio {wˆ }10 for the solution for the above problem 3, you i i=1
will need to solve the problem 3 above with the following constraint on ESG:
10
( E + S + G ) w ≤ 0 . 9 ×
10
i=1
iiii
i=1
( E + S + G ) wˆ . iiii
You will need to numerically solve the above problems using the template “FinalProject AlexeiChekhlov Group0.xlsx” and submit your numerical solutions as such file, with filename adjusted with your “FinalProject FirstnameLastname Group(your group#).xlsx”. Please, do not insert or delete any cells, keep the existing format – it is very nicely done and the graphs will allow you to “see” your solutions. The areas of cells that you will need to fill-in with your numerical solutions are as follows. The points for MM:
1
10
w ≤2;
i i=1
Start date: 12/7/2024
Due date: 12/21/2024
MATH GR5280, Capital Markets & Investments
P2:AC3, P5:AC6, P8:AC9, P11:AC12. The curves (frontiers) for MM: C33:F113, I33:L113, O33:R153. The points for IM: AI2:AV3, AI5:AV6, AI8:AV9, AI11:AV12. The curves (frontiers) for IM: AM33:AP113, AS33:AV113, AY33:BB153. The grading will be done by comparing your tabulated results to exact solutions. The calculations should be done on a Windows computer with licensed Microsoft Office installed.
Again, you will be given 20 years of daily data of total returns for the S&P 500 index (ticker symbol “SPX”), and for ten stocks (ticker symbols see the table below) such that there are three-four sectors of stocks with stocks in each group belonging to one (Yahoo!finance) sector and an instrument representing risk-free rate, 1-month annual Fed Funds rate (ticker symbol “FEDL01”). Note that stocks in each group are completely different. Therefore, each group will have its own results and conclusions.
Below, please, find the table of stock ticker symbols (aka, tickers) for each group to work with:
Group #1
ADBE
IBM
SAP
BAC
C
WFC
TRV
LUK FDX PG KO ALK JBHT JNJ PEP
HA LSTR CL MCD
Group #2
Group #3
Group #4
Stock #1 Stock #2 Stock #3 Stock #4 Stock #5 Stock #6 Stock #7 Stock#8 Stock #9 Stock #10
AMZN AAPL CTXS JPM BRK/A PGR UPS
NVDA CSCO INTC GS USB TD CN ALL
QCOM AKAM ORCL MSFT CVX XOM IMO
Below, please, find the table which shows the details for each of the stocks and which stocks belong to the same sector in each group.
2
Start date: 12/7/2024
Due date: 12/21/2024
MATH GR5280, Capital Markets & Investments
# Group #1
1 ADBE
2 IBM
3 SAP
4 BAC
5 C
6 WFC
7 TRV
8 LUV
9 ALK
10 HA
# Group#2
1 AMZN
2 AAPL
3 FFIV
4 JPM
5 BRK/A
6 PGR
7 UPS
8 FDX
9 JBHT
10 LSTR
# Group#3
1 NVDA
2 CSCO
3 INTC
4 GS
5 USB
6 TDCN
7 ALL
8 PG
9 JNJ
10 CL
# Group#4
1 QCOM
2 AKAM
3 ORCL
4 MSFT
5 CVX
6 XOM
7 IMO
8 KO
9 PEP
10 MCD
Full Name
Adobe Inc.
International Business Machines Corporation SAP SE
Bank of America Corporation
Citigroup Inc.
Wells Fargo & Company
The Travelers Companies, Inc.
Southwest Airlines Co.
Alaska Air Group, Inc.
Hawaiian Holdings, Inc.
Full Name
Amazon.com, Inc.
Apple Inc.
F5 Networks, Inc.
JPMorgan Chase & Co.
Berkshire Hathaway Inc.
The Progressive Corporation United Parcel Service, Inc. FedEx Corporation J.B.HuntTransportServices,Inc. Landstar System, Inc.
Full Name
NVIDIA Corporation
Cisco Systems, Inc.
Intel Corporation TheGoldmanSachsGroup,Inc. U.S.Bancorp TheToronto-DominionBank TheAllstateCorporation TheProcter&GambleCompany Johnson & Johnson Colgate-Palmolive Company
Full Name
Sector (Yahoo!finance)
Technology Technology Technology Financial Services Financial Services Financial Services Financial Services Industrials Industrials Industrials
Sector (Yahoo!finance)
Consumer Cyclical Technology Technology Financial Services Financial Services Financial Services Industrials Industrials Industrials Industrials
Sector (Yahoo!finance)
Technology Technology Technology FinancialServices FinancialServices FinancialServices FinancialServices ConsumerDefensive Healthcare Consumer Defensive
Sector (Yahoo!finance)
Technology Technology Technology Technology
Energy
Energy
Energy
Consumer Defensive ConsumerDefensive Consumer Cyclical
QUALCOMM Incorporated Akamai Technologies, Inc. Oracle Corporation Microsoft Corporation Chevron Corporation Exxon Mobil Corporation ImperialOilLimited
The Coca-Cola Company PepsiCo,Inc. McDonald's Corporation
3
Start date: 12/7/2024
Due date: 12/21/2024
MATH GR5280, Capital Markets & Investments
Using this data and the template Excel spreadsheet you will need to make all the necessary calculations to produce the Permissible Portfolios Region, which combines the Efficient Frontier, the Minimal Risk or Variance Frontier, and the Minimal Return Frontier for a given set of constraints (1-4 above). The Minimal Return Frontier and the Efficient Frontier together are forming the Minimal Risk or Variance Frontier – it is just a matter of reformulating the optimization problem, as follows:
Minimal Risk or Variance Frontier:
Minimal Return Frontier:
Efficient Frontier:
;
Two unique points that you need to find on the Efficient Frontier are of special interest:
Minimal Risk Portfolio:
and
Efficient Risky Portfolio:
This Final Project in an open-book which means that you can and should use the Instructor’s handouts and the corresponding Chapter copy reading material provided by the Instructor, as well as any additional materials provided to you. Instructor and TAs have performed all these calculations for each of the group’s portfolios and will be able to compare your numbers, specific points to theirs. If your spreadsheet calculations are done correctly, you and we should be able to match the results with sufficient accuracy.
The main tool that we would like you to use to solve the optimization problems for each point on the Minimal Risk or Variance Frontier is the Excel Solver. Please, try to learn how to use it on your own, if you have not done so already. The TAs will be helping you to address any issues related to Solver during the TAs sessions. To calculate large numbers of multiple points on any of the required frontiers, you will need to use the Excel Solver Table, which the TAs will teach you how to install and use. Both Excel
r
r
σ(w)→min r
w
s u b j e c t t o : r ( w ) = c o n s t
;
;
r
r(w)→min
w
s u b j e c t t o : σ ( w ) = c o n s t
r
r
r(w)→max
r
r
w
s u b j e c t t o : σ ( w ) = c o n s t
r
{σ ( w ) → m i n ; r
w
w
r
r(w) → max . rr
r
σ(w)
4
Start date: 12/7/2024
Due date: 12/21/2024
i i=1
MATH GR5280, Capital Markets & Investments
Solver and Excel Solver Table will also be covered in lectures with illustrations which are very similar to your Final Project.
For your calculations, you need to use the full available historical data range:
• start date 2/28/2003;
• end date 3/6/2023.
As it was mentioned above, you will need to calculate the solutions to two optimizations covered in lectures:
• The full Markowitz Model (MM);
• The Index Model (IM).
As we have described this in detail above, each of these optimization problems MM and IM you will need to implements and solve with the following additional four optimization constraints:
1. wi ≥0,for∀i;
2. wi ≥0,for∀i,and (E +S +G )w ≤0.9× (E +S +G )wˆ
10
3. w ≤2;
10
10
i=1
iiii
i=1
( E + S + G ) wˆ , iiii
10 10 10
i=1 i=1
i=1
4 . w ≤ 2 a n d i
( E + S + G ) w ≤ 0 . 9 × iiii
where {wˆ }10 in each case corresponds to the efficient risky portfolio solution of the corresponding non i i=1
ESG-constrained problem.
As we have already mentioned, your task is to produce the following objects on the Permissible Portfolios Region in the numerical (and the template spreadsheet does it in the graphical for you) form:
• Minimal Risk or Variance Frontier (a curve), range for portfolio returns: from -10% to 50% with step of 0.5%;
• Global Minimal Risk or Variance Portfolio (a point);
• Maximal Sharpe Ratio or Efficient Risky Portfolio (a point);
• Maximal Return or Efficient Frontier (a curve), range for portfolio standard deviation: from 10%
to 50% with step of 0.5%;
• Capital Allocation Line or CAL (a straight line);
• Minimal Return or Inefficient Frontier (a curve), range for portfolio standard deviation: from 10%
to 50% with step of 0.5%.
The curves above must be produced in tabular form (Excel), using the template provided, preserving the formats in the template, with which comparison to exact solution will be made for grading, using specifically the above ranges. If a numerical solution cannot be found, just leave the corresponding cell empty. The points above should also be tabulated. All the tabulation should be done similar to example provided by the Instructor (see the file “Final Project Group0.xlsx” provided).
5
iiii
MATH GR5280, Capital Markets & Investments
Start date: 12/7/2024 Due date: 12/21/2024
Do not hesitate to ask TAs, Lecturer any questions.
You are given two weeks to complete the Final Project and to submit the work in the form of .xlsx file through the portal. We encourage you not to delay starting the work as workload is meant for several days of work and not as a one-night effort.
Final Project is due on December 21st, 2024 at 7:00 PM EST.
Your spreadsheet should be named using the following convention which is similar to the homework naming convention: “FinalProject AlexeiChekhlov Group0.xlsx”. Here “0” is the number of your Final Project Group, and instead of “Alexei Chekhlov” should be your name in the following format: “FirstNameLastName”.
Good luck!
References:
[BKM13] Z. Bodie, A. Kane, A. J. Marcus, “Investments”, Thirteenth Edition, McGraw Hill, 2024.
[CFA3] “Certificate in ESG Investing Curriculum”. CFA Institute. Edition 3. CFA Society of the UK, 2021.
6
软件开发、广告设计客服
QQ:99515681
邮箱:99515681@qq.com
工作时间:8:00-23:00
微信:codinghelp
热点项目
更多
代做 program、代写 c++设计程...
2024-12-23
comp2012j 代写、代做 java 设...
2024-12-23
代做 data 编程、代写 python/...
2024-12-23
代做en.553.413-613 applied s...
2024-12-23
代做steady-state analvsis代做...
2024-12-23
代写photo essay of a deciduo...
2024-12-23
代写gpa analyzer调试c/c++语言
2024-12-23
代做comp 330 (fall 2024): as...
2024-12-23
代写pstat 160a fall 2024 - a...
2024-12-23
代做pstat 160a: stochastic p...
2024-12-23
代做7ssgn110 environmental d...
2024-12-23
代做compsci 4039 programming...
2024-12-23
代做lab exercise 8: dictiona...
2024-12-23
热点标签
mktg2509
csci 2600
38170
lng302
csse3010
phas3226
77938
arch1162
engn4536/engn6536
acx5903
comp151101
phl245
cse12
comp9312
stat3016/6016
phas0038
comp2140
6qqmb312
xjco3011
rest0005
ematm0051
5qqmn219
lubs5062m
eee8155
cege0100
eap033
artd1109
mat246
etc3430
ecmm462
mis102
inft6800
ddes9903
comp6521
comp9517
comp3331/9331
comp4337
comp6008
comp9414
bu.231.790.81
man00150m
csb352h
math1041
eengm4100
isys1002
08
6057cem
mktg3504
mthm036
mtrx1701
mth3241
eeee3086
cmp-7038b
cmp-7000a
ints4010
econ2151
infs5710
fins5516
fin3309
fins5510
gsoe9340
math2007
math2036
soee5010
mark3088
infs3605
elec9714
comp2271
ma214
comp2211
infs3604
600426
sit254
acct3091
bbt405
msin0116
com107/com113
mark5826
sit120
comp9021
eco2101
eeen40700
cs253
ece3114
ecmm447
chns3000
math377
itd102
comp9444
comp(2041|9044)
econ0060
econ7230
mgt001371
ecs-323
cs6250
mgdi60012
mdia2012
comm221001
comm5000
ma1008
engl642
econ241
com333
math367
mis201
nbs-7041x
meek16104
econ2003
comm1190
mbas902
comp-1027
dpst1091
comp7315
eppd1033
m06
ee3025
msci231
bb113/bbs1063
fc709
comp3425
comp9417
econ42915
cb9101
math1102e
chme0017
fc307
mkt60104
5522usst
litr1-uc6201.200
ee1102
cosc2803
math39512
omp9727
int2067/int5051
bsb151
mgt253
fc021
babs2202
mis2002s
phya21
18-213
cege0012
mdia1002
math38032
mech5125
07
cisc102
mgx3110
cs240
11175
fin3020s
eco3420
ictten622
comp9727
cpt111
de114102d
mgm320h5s
bafi1019
math21112
efim20036
mn-3503
fins5568
110.807
bcpm000028
info6030
bma0092
bcpm0054
math20212
ce335
cs365
cenv6141
ftec5580
math2010
ec3450
comm1170
ecmt1010
csci-ua.0480-003
econ12-200
ib3960
ectb60h3f
cs247—assignment
tk3163
ics3u
ib3j80
comp20008
comp9334
eppd1063
acct2343
cct109
isys1055/3412
math350-real
math2014
eec180
stat141b
econ2101
msinm014/msing014/msing014b
fit2004
comp643
bu1002
cm2030
联系我们
- QQ: 9951568
© 2021
www.rj363.com
软件定制开发网!