Computers and Technology, 24.09.2020 07:01 sugar1014

Consolidate all excel spreadsbeets from part1 in a single Exoel file. Please make a cover page (name and ID) in Sheet in your EXCEL file. To submit this project electronically, use Blackboard. DO NOT send me it via email. Please subanit yur project in a single EXCEL file. ONLY an EXCEL FILE will be accepted. You have write up with your own words. Do not copy fron others' work. In the last page, you have to show all your references for your project in the last sheet in your Excel. Part 1 Portfolio Return and Risk Instruction: You are a portfolio investment analyst at Goldman Sachs. Your investment unit manages two equity portolios one portfolio, named PI, consists of two stock assets (Bank of America (BAC) and Mc- Donald Ticker: MCD)) and the other portfolio, named P2, consists of five stocks (Aetnal Ticker:AET), Boe- inglTicker:BA), AmazonTicker AMZN), TeslalTicker:TSLA), DisoerTicker:DFS)). Now you are asked to compute two portfolio returns and risk measures. To do this, first download monthly stock prices from Jan 2010 to Dec.2017 from Bloomberg and compute monthly stock returns from Feb.2010 to Dec.2017.1 Problem 1. Compute the respective average, standard deviation, and covariance of monthly stock returns,2 Problem 2. Maloe two covariance matrices using two portfolio components. Note that you have to make a completed form of a matrix as below. ơhAC = Ơ BAC, BAC ƠMCD. BAC ƠBAC. MCD Ơ B AC. MCD = ƠMCD. BAC ơSdCD.: ƠMCD. MCD OXET ƠAET. BA ƠAET. A.l12N ƠAET. TLSA ƠAET, DFS ƠBA. AET Ơ A ƠBA. AMZN ƠBA. TLSA dyBA. DFS ΣΡ2 ƠAMZN. AET ƠAM ZN. BA ƠAMZN ƠAMZN. TLSA ƠAMZN. DFS (2) ƠTLSA. AET ƠTLSA. BA ƠTLSA. AM ZN ƠTLSA ƠTLSA..DFS ơDFS. AET ƠDPS, BA ƠDFS. AM ZN ƠDFS, TLSA ƠbFS
Problem 3. Using the obtained statistics from problem 1, caleulate an equal weighted portfolio return and portfolio variance for the first portfolio using the below equations. ch-tOBACƠBAC + urMCDƠNCD + 2UBACUMCOƠBAC. MCD R, = A where R, represents stock return at time t. P is a stock price at time t. Use STDEV P in Exoel, not STDEV. S. Note that the formula for standard deviation based a sample is given by amsée- , W1 LK while the formula for standard deviation based on a population is written as σ2pulation Σ Data Analysis Toolpak to compate a covariance matrix

Answers: 1

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 01:00

)a grad student comes up with the following algorithm to sort an array a[1..n] that works by first sorting the first 2/3rds of the array, then sorting the last 2/3rds of the (resulting) array, and finally sorting the first 2/3rds of the new array. 1: function g-sort(a, n) . takes as input an array of n numbers, a[1..n] 2: g-sort-recurse(a, 1, n) 3: end function 4: function g-sort-recurse(a, `, u) 5: if u â’ ` â‰¤ 0 then 6: return . 1 or fewer elements already sorted 7: else if u â’ ` = 1 then . 2 elements 8: if a[u] < a[`] then . swap values 9: temp â† a[u] 10: a[u] â† a[`] 11: a[`] â† temp 12: end if 13: else . 3 or more elements 14: size â† u â’ ` + 1 15: twothirds â† d(2 â— size)/3e 16: g-sort-recurse(a, `, ` + twothirds â’ 1) 17: g-sort-recurse(a, u â’ twothirds + 1, u) 18: g-sort-recurse(a, `, ` + twothirds â’ 1) 19: end if 20: end function first (5 pts), prove that the algorithm correctly sorts the numbers in the array (in increasing order). after showing that it correctly sorts 1 and 2 element intervals, you may make the (incorrect) assumption that the number of elements being passed to g-sort-recurse is always a multiple of 3 to simplify the notation (and drop the floors/ceilings).

Answers: 3

Answer

Computers and Technology, 22.06.2019 22:00

Perform the following tasks: a. create a class named testclass that holds a single private integer field and a public constructor. the only statement in the constructor is one that displays the message “constructing”. write a main()function that instantiates one object of the testclass. save the file as testclass.cpp in the chapter 08 folder. run the program and observe the results. b. write another main()function that instantiates an array of 10 testclass objects. save the file as test class array.c . run this program and observe the results.

Answers: 1

Answer

Computers and Technology, 23.06.2019 02:00

In the context of an internet connection, llc stands for leased line connection liability limited company local loop complex local loop carrier

Answers: 1

Answer

Computers and Technology, 23.06.2019 08:00

What is a scenario where records stored in a computer frequently need to be checked

Answers: 2

Answer

You know the right answer?

Consolidate all excel spreadsbeets from part1 in a single Exoel file. Please make a cover page (name...