合肥生活安徽新聞合肥交通合肥房產生活服務合肥教育合肥招聘合肥旅游文化藝術合肥美食合肥地圖合肥社保合肥醫院企業服務合肥法律

        代寫 GR5280、代做 Java/Python 編程設計
        代寫 GR5280、代做 Java/Python 編程設計

        時間:2024-12-22  來源:合肥網hfw.cc  作者:hfw.cc 我要糾錯



        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 (**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, **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 (**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!

        請加QQ:99515681  郵箱:99515681@qq.com   WX:codinghelp




         

        掃一掃在手機打開當前頁
      1. 上一篇:ITC228編程代寫、代做Java程序語言
      2. 下一篇:CHC5049 代做、代寫 SQL 編程設計
      3. 無相關信息
        合肥生活資訊

        合肥圖文信息
        挖掘機濾芯提升發動機性能
        挖掘機濾芯提升發動機性能
        戴納斯帝壁掛爐全國售后服務電話24小時官網400(全國服務熱線)
        戴納斯帝壁掛爐全國售后服務電話24小時官網
        菲斯曼壁掛爐全國統一400售后維修服務電話24小時服務熱線
        菲斯曼壁掛爐全國統一400售后維修服務電話2
        美的熱水器售后服務技術咨詢電話全國24小時客服熱線
        美的熱水器售后服務技術咨詢電話全國24小時
        海信羅馬假日洗衣機亮相AWE  復古美學與現代科技完美結合
        海信羅馬假日洗衣機亮相AWE 復古美學與現代
        合肥機場巴士4號線
        合肥機場巴士4號線
        合肥機場巴士3號線
        合肥機場巴士3號線
        合肥機場巴士2號線
        合肥機場巴士2號線
      4. 幣安app官網下載 短信驗證碼 丁香花影院

        關于我們 | 打賞支持 | 廣告服務 | 聯系我們 | 網站地圖 | 免責聲明 | 幫助中心 | 友情鏈接 |

        Copyright © 2024 hfw.cc Inc. All Rights Reserved. 合肥網 版權所有
        ICP備06013414號-3 公安備 42010502001045

        主站蜘蛛池模板: 国产精品成人一区无码| 精品一区二区三区四区在线| 暖暖免费高清日本一区二区三区| 中文字幕一区二区三| 在线一区二区三区| 乱精品一区字幕二区| 国产精品一区二区三区免费| 国产成人一区二区三区精品久久| 人妻无码一区二区三区免费| 国产成人久久精品一区二区三区| 日韩毛片一区视频免费| 成人免费视频一区二区三区| 亚洲AV无码一区二区三区网址| 久久精品免费一区二区三区| 中文字幕精品亚洲无线码一区应用| 精品国产区一区二区三区在线观看 | 国产凸凹视频一区二区| 国产日本亚洲一区二区三区| 精品无码一区二区三区爱欲九九| 国产午夜福利精品一区二区三区| 国产激情一区二区三区 | 无码人妻久久一区二区三区蜜桃| 国产成人久久一区二区三区| 日本免费一区二区三区最新| 日本精品视频一区二区三区| 免费无码一区二区三区蜜桃大| 国产一区二区不卡老阿姨| 精品国产日韩亚洲一区91| 国产精品一区电影| 日本一区视频在线播放| 久久久久久一区国产精品| 久久久久久一区国产精品| 亚洲av福利无码无一区二区| 3d动漫精品成人一区二区三| 国产日韩精品视频一区二区三区| 海角国精产品一区一区三区糖心| 另类ts人妖一区二区三区| 激情啪啪精品一区二区| 97久久精品午夜一区二区| 久久精品无码一区二区无码| 亚洲欧美日韩一区二区三区|