LinkBack URL
About LinkBacks
HOW DO I FIND THE EFFECTIVE YIELD IN EXAMPLE BELOW:
Investment is known.
Future value is known.
Number of years of growth are know.
Effective yield IS NOT KNOWN.
HOW DO I FIND THE EFFECTIVE YIELD IN EXAMPLE BELOW:
Investment is known.
Future value is known.
Number of years of growth are know.
Effective yield IS NOT KNOWN.
Last edited by Relim; 12-16-2011 at 10:25 AM.
Try with RATE function.
Insert number of periods (years)
Payment - if there is periodic payment/investment (with minus sigh)
PV = 0
FV - future value.
If there is no periodic payment (one time investment) so Yield = (FV/PV) rased to power of 1/number of per.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks