In: Finance
Calculate the total return for a stock with a market price on January 1 of $20 and $16 on December 31 that pays quarterly dividend of 50 cents
Use the Rate function in excel to solve this. nper=1, PMT= 0.5*4 = 2 , PV=$20, FV=$16
the screenshot for formula is below
Thus the stock is providing a return of -10.00%.