Calculate the following items for Sarahs NVDA investment. Do not round intermediate calculations. Round your answers to one decimal place. Complete your calculations Steps to in a wellformatted Excel Spreadsheet and submit your summary Step in Word.
Holding period return HPR and annual HPR assuming she sold her shares on Jan. st
Holding period yield HPY and annual HPY
Indicate how much of her HPY was due to the price change and how much was due to the dividend income
Yield to date YTD in
Arithmetic mean return
Variance and standard deviation risk and coefficient of variation
In a short summary, help Sarah understand her numbers:
How should she think about her levels of risk and return?
How should she think about the changes in her investment due to price vs due to dividend?
Overall, what would you advise her about the strength of her investment?