if anyone can help me out it would be greatly appreciated. This assignment is basically hieroglyphs to me and the rest of my class.

Cools Table Window Help G D Assignment 2--HPR calculations with Excel due Feb 27 (1) out References Mailings Review View . A- A A A E + 1 AaCeDdE: AaBbCcDc ABCDE X, x A..A. E . . . FIL 242 Investments-Norton Assignment #2 Due 6pm (submit to ReggieNet) Thursday Feb 27, 2020 25 points Note: Ser Excel to show 4 decimal places in your answers, whether decimal format (0.0123) or percentage format (1.234599) is used Note: neatness and good spreadsheet layout are important. All analysis is to be done using Excel and Excel functions whenever possible Hardwire your formulas--that is, se cell references, of numbers, whenever possible. And use Excel functions: Average, Geomean, etc., whenever possible and Excel math formulas when necessary (..T+C5 to compute the return relative for the HPR that is in cell CS). Points will be deducted if appropriate Excel functions or formulas are not used Upload the spreadsheet onto ReggieNet: use the following filename convention! yourlastname. FIL242Assignment2.xls (L point penalty if not labeled correctly) 1. You will be doing analysis using four of the following ten firms: "ABCD" digit 0 1 2 3 4 5 6 AAA BBB CCC DDD EEE FFF GGG HHH III Which four? What I am calling the "ABCD number is the last four digits of your University ID (UD) 888-88-ABCD. JJJ 2. Get the assignment data in the ReggieNet assignment folder for the monthly "close" prices and dividends from January 31 through December 31 for the firms corresponding to the last four digits of your UID this is your ABCD number. If the last 4 digits of your ABCD contains a double digit, then use the next firm on the list. For example: if the last 4 digits of your UID number ends with: 7890: You'll be using HHH, III, JJJ, and AAA in your project 7789: You'll be using HHH (7), III (18, taking the place of the second 7"'), JUU (you are already using firm 8 so we go to the next firm, #9) and AAA (again, #9 is used so we go back to the beginning to 0). 7770: You will use HHH, III, JJJ, and AAA 3382: You will use DDD (3), EEE 84, since #3 was already used), III (8), and CCC (for #2) 3. (8 points) Place your four firms in alphabetical order by ticker symbol (in columns) showing the month end prices and dividends. Compute holding period returns, in percents, for each month for each stock. With 12 months of data you will compute 11 HPRs for each of your four stocks. If a dividend is paid on. say, March 31, it should be included in the March HPR calculation. Set Excel to show decimal places English (US) 08 t Tools Table Window Help B E D Assignment 2--HPR calculations with excel due Feb 27 (1) Layout References Mailings Review View 10.AA ASA E .E..+ DE ABECEDC be X, X A. A. 2 . . . Imphasis reading Bocaba 7770: You will use HHH, III, JJJ, and AAA 3382: You will use DDD (13), EEE4, since #3 was already used). III (18), and CCC (for #2) 3.8 points) Place your four firms in alphabetical order by ticker symbol (in columns) showing the month end prices and dividends. Compute holding period returns, in percents, for each month for each stock. With 12 months of data you will compute 11 HPRs for cach of your four stocks. If a dividend is paid on, say, March 31, it should be included in the March HPR calculation. Set Excel to show 4 decimal places in your answers, Hint: the Excel formula for calculating HPR should be the same for each firm that is, the formula shouldn't change whether a dividend was paid that month or not. ber 4. (6 points) a. For each of your stocks, use the shortcut Excel functions to compute the average HPR and standard deviation of the HPR and display your answer in percents, b. (2 points) For each of your stocks, use the shortcut Excel function to compute the variance of the HPR and show/label it in units of percent squared (see example below). Note you will need to use VAR in a formula and use math to adjust it to have variance properly display in percent squared format. For example, if Excel computes a standard deviation of 10%, it will display a variance of 1% and that isn't correct! It should be 100, of course. Think how you need to adjust the formula for variance so it is displayed correctly. Time HPR 1 10.0000% 2 0.0000% 3 -10.0000% Average Std Dev Variance 0.0000% 10.0000% 1.0000 100.0000 100 0000 NOT THIS percent squared squared (note: you add the labels) You want this Or this 5. Compute the return relative for each of your four stocks to four decimal places a. Use the return relatives to compute the geometric mean return for each of your stocks in English (US) B E D out References O. A A A X2 X A A Assignment 2--HPR calculations with Excel due Feb 27 (1) Mailings Review View A E E. . + 1 Aa Bb C DdB AaBbCcDc AaBbcede , & Heading 1 Emphasis Normal (note: you add the labels) 5. Compute the return relative for each of your four stocks to four decimal places. a. Use the return relatives to compute the geometric mean return for each of your stocks in percents. (2 points) Use the shortcut Excel formula (GEOMEAN) in your formula for computing the geometric mean don't write a long line of calculations to multiply 11 return relatives together! b. Among your four firms, identify the firm with the smallest difference between its arithmetic and geometric mean return and the firm with the largest difference between its arithmetic and geometric mean return. Explain why the difference between the arithmetic and geometric mean return is larger for one firm than the other. Use the wrap text feature and/or merge cells) so your response doesn't stretch out in one line for many columns(3 points) (Hint: if you need help answering this, on another "scrap paper" spreadsheet (no need to turn it in), find the arithmetic mean, geometric mean, and their difference when all the HPRs are the same-e.g., 5%, 5%, 5%, 5%, 5%....what happens to the difference in means if you change two of these numbers to 6%? To 8%? To 14%?). c. Suppose $100 was invested in each of your four stocks at the beginning of the project time frame as shown on the data spreadsheet. How much would the investment in each stock be worth on Dec 31? Assume any dividends are re-invested in the stock. Report the ending wealth in each stock to 2 decimal places that is, the nearest penny). HINT: this involves compounding the returns and will use the GEOMEAN function again). (4 points) Grades will be affected by the ability to follow instructions, the accuracy of analysis, the correctness of your answers, and your spreadsheet format (readability). The work you turn in must only be your own. This is not a group/team/shared project. IX English (US) Cools Table Window Help G D Assignment 2--HPR calculations with Excel due Feb 27 (1) out References Mailings Review View . A- A A A E + 1 AaCeDdE: AaBbCcDc ABCDE X, x A..A. E . . . FIL 242 Investments-Norton Assignment #2 Due 6pm (submit to ReggieNet) Thursday Feb 27, 2020 25 points Note: Ser Excel to show 4 decimal places in your answers, whether decimal format (0.0123) or percentage format (1.234599) is used Note: neatness and good spreadsheet layout are important. All analysis is to be done using Excel and Excel functions whenever possible Hardwire your formulas--that is, se cell references, of numbers, whenever possible. And use Excel functions: Average, Geomean, etc., whenever possible and Excel math formulas when necessary (..T+C5 to compute the return relative for the HPR that is in cell CS). Points will be deducted if appropriate Excel functions or formulas are not used Upload the spreadsheet onto ReggieNet: use the following filename convention! yourlastname. FIL242Assignment2.xls (L point penalty if not labeled correctly) 1. You will be doing analysis using four of the following ten firms: "ABCD" digit 0 1 2 3 4 5 6 AAA BBB CCC DDD EEE FFF GGG HHH III Which four? What I am calling the "ABCD number is the last four digits of your University ID (UD) 888-88-ABCD. JJJ 2. Get the assignment data in the ReggieNet assignment folder for the monthly "close" prices and dividends from January 31 through December 31 for the firms corresponding to the last four digits of your UID this is your ABCD number. If the last 4 digits of your ABCD contains a double digit, then use the next firm on the list. For example: if the last 4 digits of your UID number ends with: 7890: You'll be using HHH, III, JJJ, and AAA in your project 7789: You'll be using HHH (7), III (18, taking the place of the second 7"'), JUU (you are already using firm 8 so we go to the next firm, #9) and AAA (again, #9 is used so we go back to the beginning to 0). 7770: You will use HHH, III, JJJ, and AAA 3382: You will use DDD (3), EEE 84, since #3 was already used), III (8), and CCC (for #2) 3. (8 points) Place your four firms in alphabetical order by ticker symbol (in columns) showing the month end prices and dividends. Compute holding period returns, in percents, for each month for each stock. With 12 months of data you will compute 11 HPRs for each of your four stocks. If a dividend is paid on. say, March 31, it should be included in the March HPR calculation. Set Excel to show decimal places English (US) 08 t Tools Table Window Help B E D Assignment 2--HPR calculations with excel due Feb 27 (1) Layout References Mailings Review View 10.AA ASA E .E..+ DE ABECEDC be X, X A. A. 2 . . . Imphasis reading Bocaba 7770: You will use HHH, III, JJJ, and AAA 3382: You will use DDD (13), EEE4, since #3 was already used). III (18), and CCC (for #2) 3.8 points) Place your four firms in alphabetical order by ticker symbol (in columns) showing the month end prices and dividends. Compute holding period returns, in percents, for each month for each stock. With 12 months of data you will compute 11 HPRs for cach of your four stocks. If a dividend is paid on, say, March 31, it should be included in the March HPR calculation. Set Excel to show 4 decimal places in your answers, Hint: the Excel formula for calculating HPR should be the same for each firm that is, the formula shouldn't change whether a dividend was paid that month or not. ber 4. (6 points) a. For each of your stocks, use the shortcut Excel functions to compute the average HPR and standard deviation of the HPR and display your answer in percents, b. (2 points) For each of your stocks, use the shortcut Excel function to compute the variance of the HPR and show/label it in units of percent squared (see example below). Note you will need to use VAR in a formula and use math to adjust it to have variance properly display in percent squared format. For example, if Excel computes a standard deviation of 10%, it will display a variance of 1% and that isn't correct! It should be 100, of course. Think how you need to adjust the formula for variance so it is displayed correctly. Time HPR 1 10.0000% 2 0.0000% 3 -10.0000% Average Std Dev Variance 0.0000% 10.0000% 1.0000 100.0000 100 0000 NOT THIS percent squared squared (note: you add the labels) You want this Or this 5. Compute the return relative for each of your four stocks to four decimal places a. Use the return relatives to compute the geometric mean return for each of your stocks in English (US) B E D out References O. A A A X2 X A A Assignment 2--HPR calculations with Excel due Feb 27 (1) Mailings Review View A E E. . + 1 Aa Bb C DdB AaBbCcDc AaBbcede , & Heading 1 Emphasis Normal (note: you add the labels) 5. Compute the return relative for each of your four stocks to four decimal places. a. Use the return relatives to compute the geometric mean return for each of your stocks in percents. (2 points) Use the shortcut Excel formula (GEOMEAN) in your formula for computing the geometric mean don't write a long line of calculations to multiply 11 return relatives together! b. Among your four firms, identify the firm with the smallest difference between its arithmetic and geometric mean return and the firm with the largest difference between its arithmetic and geometric mean return. Explain why the difference between the arithmetic and geometric mean return is larger for one firm than the other. Use the wrap text feature and/or merge cells) so your response doesn't stretch out in one line for many columns(3 points) (Hint: if you need help answering this, on another "scrap paper" spreadsheet (no need to turn it in), find the arithmetic mean, geometric mean, and their difference when all the HPRs are the same-e.g., 5%, 5%, 5%, 5%, 5%....what happens to the difference in means if you change two of these numbers to 6%? To 8%? To 14%?). c. Suppose $100 was invested in each of your four stocks at the beginning of the project time frame as shown on the data spreadsheet. How much would the investment in each stock be worth on Dec 31? Assume any dividends are re-invested in the stock. Report the ending wealth in each stock to 2 decimal places that is, the nearest penny). HINT: this involves compounding the returns and will use the GEOMEAN function again). (4 points) Grades will be affected by the ability to follow instructions, the accuracy of analysis, the correctness of your answers, and your spreadsheet format (readability). The work you turn in must only be your own. This is not a group/team/shared project. IX English (US)