Excel Forum
Similar Content
3 Tips for Faster and Better VBA Macros in Excel - Simple to Advanced
Tutorial: Make a 3 minute macro execute in less than 1 second! Learn to make faster, better, and mo...
OFFSET Function in Excel
Tutorial: The OFFSET function in Excel returns a cell or range reference that is a specified number...
Quickly Consolidate and Compare Data in Excel Using a Pivot Chart & Pivot Table
Tutorial:   Visually combine and compare data in Excel in less than 1 minute! This technique takes ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.