help if theres a way for me to submit file i can do so, please let me know and complete the questions excel
You will use the spreadsheet Assignment_1.xIsm. There are five (5) worksheets. Submit both the Excel spreadsheet and this Word document in Blackboard. Please add your name to the file extensions when you save the files before you submit them. Sheet 1: Compounding One account increases at a 5% annual rate of return. The second account increases at a 6% annual rate of return. Compare the two account values after 5 years of return compounding. Compare the two account values after 30 years of return compounding a) After 5 years, is the difference in account values SMALL or LARGE? b) After 30 years, Is the difference in account values SMALL or LARGE? c) What conclusion(s) did you draw? Sheet 2: Volatility There are four series of annual returns covering a thirty-year period, with an average annual return of 2%,4%,6% and 8%, respectively. a) What happens to the difference between the average return and geometric return as volatility increases? By "difference", I mean average return minus geometric return. Does the difference INCREASE or DECREASE? b) The return per unit of risk decreases as volatility increases. Does the return per unit of risk decrease at a LINEAR rate or FASTER THAN A LINEAR RATE? c) What conclusion(s) did you draw? In other words, what did you learn? (extra credit question) Sheet 3: Drawdown A $100,000 investment account experiences a drawdown (negative total return. What total return is needed to restore the atcount back to its initial $100,000 value? You need to fill the returns in the gray cells. Use the spreadsheet. You will be submitting the spreadsheet, so if you have trouble entering the returns in this Word document, don't worry, just ensure the returns are in the spreadsheet. a) What conclusion(s) did you draw? In other words, what did you learn? Sheet 4: Discussion Board 1 For the first table, you need to fill the account values in the gray cells. For the first table, you need to fill the average returns and standard deviation of returns in the gray cells. Use the spreadsheet. You will be submitting the spreadsheet, so if you have trouble entering the data in this Word document, don't worry, just ensure data is entered in the cells in the spreadsheet. a) Who had the highest average return? b) Who had the highest account value at the end of 17 years? c) The highest average return and the highest account value were different people. What conclusion(s) did you draw? In other words, what did you learn? H19 ^xfx=H(1+G19) * X If AAVRAGE:CO:C32)
