In an EXCEL Spreadsheet , detail the returns on five Selected Stack's that you will USE as the basis for creating wealth required to support your personal financial initiatives . Select five Key stocks and determine their Expected return from finance . yahoo . com . Presume you would invest 20%/ Equally in these stocks and average the return . Calculate how much you would have to deposit each year until retirement to fund all of your initiatives assuming the rate of return on these equities is constant . Describe your rationale for selecting the stocks in your portfolio , including your own risk tolerance and any considerations for diversification . Complete a calculation of the annual amount required to support any gap between your present wealth and your future need , using the return derived from your portfolio as the realized return . This amount will be represented by an annual annuity funded by your savings drawn from your present income ; assume that Salary increases will be exactly offset by inflation and thus , Your present salary will be static . ( Recall that if you currently have automatic deposits to a 401 ( k) . there will be redirectEd to the portfolio you have developed . ) Determine whether You are able to deposit Enough to fund all of your financial goals according to