Compute the mean monthly returns and standard deviations for the monthly returns of each of the stocks. Convert the monthly statistics to annual statistics for easier interpretation.

Compute the mean and standard deviation of monthly returns for the equally weighted portfolio. Convert these monthly statistics to annual statistics for interpretation.

Today is 6th March 2020. Mia Matthews is 30 years old and holds BSc in Data Science. Currently, she is working as a Tier 2 field service representative for a telephone corporation and earns $38,000 a year after tax. She anticipates her salary will grow by 3% per year. Mia hopes to retire at 65. Mia has $75,000 worth of savings in 10-year Treasury bonds. Mia is considering whether she should advance her education and use her savings to fund it. Mia is considering studying for a certification in network design, which would promote her to a Tier 3 field service representative. The base salary for this position is $9,000 higher than what Mia makes now. Mia expects that this salary differential will grow at a 3.5% rate, as long as she remains employed. To obtain the certificate, Mia needs to complete several courses, which would take one year. The program's cost is $7,000, which is payable on enrolment. As she intends to do the work for the certification in her own time, no loss of income during this time is expected. Mia is also considering doing an MBA degree, which would help promote her to a managerial position, which pays $20,000 a year more than her current one. Mia expects this salary differential to grow at a rate of 4% per year for as long as she keeps working. The evening program will take three years to complete and costs $30,000 per year, payable at the beginning of each year. Mia doesn't expect to lose any income while earning her degree as she will attend evening classes. To determine the interest rate Mia is currently earning on her savings, go to the US Treasury Department Website (www.treasury.gov) and select "data on the main menu. Then select "Daily Treasury Yield Curve Rates" under the interest rate heading and enter the appropriate year, 2020, and then search down the list for 6th March to obtain the closing yield or interest rate that she is earning. Use this interest rate as the discount rate for the remainder of this question. Create a timeline for Mia's current situation, as well as the certification program and MBA degree options, using the following assumptions: Salaries for the year are paid only once, at the end of the year The salary increase becomes effective immediately upon graduating from the MBA program or being certified. Because the increases become effective immediately, but salaries are paid at the end of the year, the first salary increase will be paid precisely one year after graduation or certification. Required: Today is 6th March 2020. Mia Matthews is 30 years old and holds BSc in Data Science. Currently, she is working as a Tier 2 field service representative for a telephone corporation and earns $38,000 a year after tax. She anticipates her salary will grow by 3% per year. Mia hopes to retire at 65. Mia has $75,000 worth of savings in 10-year Treasury bonds. Mia is considering whether she should advance her education and use her savings to fund it. Mia is considering studying for a certification in network design, which would promote her to a Tier 3 field service representative. The base salary for this position is $9,000 higher than what Mia makes now. Mia expects that this salary differential will grow at a 3.5% rate, as long as she remains employed. To obtain the certificate, Mia needs to complete several courses, which would take one year. The program's cost is $7,000, which is payable on enrolment. As she intends to do the work for the certification in her own time, no loss of income during this time is expected. Mia is also considering doing an MBA degree, which would help promote her to a managerial position, which pays $20,000 a year more than her current one. Mia expects this salary differential to grow at a rate of 4% per year for as long as she keeps working. The evening program will take three years to complete and costs $30,000 per year, payable at the beginning of each year. Mia doesn't expect to lose any income while earning her degree as she will attend evening classes. To determine the interest rate Mia is currently earning on her savings, go to the US Treasury Department Website (www.treasury.gov) and select "data on the main menu. Then select "Daily Treasury Yield Curve Rates" under the interest rate heading and enter the appropriate year, 2020, and then search down the list for 6th March to obtain the closing yield or interest rate that she is earning. Use this interest rate as the discount rate for the remainder of this question. Create a timeline for Mia's current situation, as well as the certification program and MBA degree options, using the following assumptions: Salaries for the year are paid only once, at the end of the year The salary increase becomes effective immediately upon graduating from the MBA program or being certified. Because the increases become effective immediately, but salaries are paid at the end of the year, the first salary increase will be paid precisely one year after graduation or certification. Required