|
Featured Tutorial
Featured Macro
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.
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.