Excel Forum
Similar Content
OFFSET Function in Excel
Tutorial: The OFFSET function in Excel returns a cell or range reference that is a specified number...
RATE Function - Calculate an Interest Rate in Excel
Tutorial: The Rate function in Excel (RATE) calculates the interest rate for a financial transaction...
FV Function - Get the Future Value in Excel
Tutorial: The Future Value function (FV) in Excel will return the future value of an investment ba...



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.