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

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
1,262
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Nov 20, 2010

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.

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (0)

Sign In or Sign Up now to post a comment!
Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more