Excel Forum

Excel Finance Class 94: Period (Holding) Returns For Less Than 1 Year, APR and EAR

Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to calculate the Holding (Period) Rate for a stock held for 3 months and 32 days, and then calculate the APR and Ear (Effective Annual Rate) for a Stock. See that the EFFECT function does not calculate correctly when the exponent for number of periods per year is not an integer.

Got a Question? Ask it Here in the Forum.