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

Writing a modular program in visual c++. i am new to this and not sure what i am missing. i am getting the following error: baddate.cpp: in function ‘int main()’: baddate.cpp: 50: 3: error: ‘else’ without a previous ‘if’elsehere are the instructions and code: writing a modular program in c++in this lab, you add the input and output statements to a partially completed c++ program. when completed, the user should be able to enter a year, a month, and a day. the program then determines if the date is valid. valid years are those that are greater than 0, valid months include the values 1 through 12, and valid days include the values 1 through 31.notice that variables have been declared for you.write the simulated housekeeping() function that contains the prompts and input statements to retrieve a year, a month, and a day from the user.include the output statements in the simulated endofjob() function. the format of the output is as follows: month/day/year is a valid date.ormonth/day/year is an invalid date.execute the program entering the following date: month = 5, day = 32, year = 2014. record the output of this program.execute the program entering the following date: month = 9, day = 21, year = 2002. record the output of this /* program name: baddate.cppfunction: this program determines if a date entered by the user is valid.input: interactiveoutput: valid date is printed or user is alerted that an invalid date was entered*/#include bool validatedate(int, int, int); using namespace std; int main(){// declare variablesint year; int month; int day; const int min_year = 0, min_month = 1, max_month = 12, min_day = 1, max_day = 31; bool validdate = true; // this is the work of the housekeeping() method// get the year, then the month, then the daycout< < "enter the year"< > year; cout< < "enter the month"< > month; cout< < "enter the day"< > day; // this is the work of the detailloop() method// check to be sure date is validif(year < = min_year) // invalid yearvaliddate = false; else if (month < min_month || month > max_month) // invalid monthvaliddate = false; else if (day < min_day || day > max_day) // invalid dayvaliddate = false; // this is the work of the endofjob() method// test to see if date is valid and output date and whether it is valid or notif(validdate == true); {// output statementcout<

Free points just awnser this. what should i watch on netflix

What role did women fill during world war ii?