InvestorsHub Logo
Boards
News
Market Data
Markets
Discover
Discover
Subscribe Login/Register
S&P 500
5,304.72
(
0.70%
)
US TECH 100
18,318.00
(
0.95%
)
Dow Jones
39,069.59
(
0.01%
)
Brent Oil
82.01
(
0.03%
)
Bitcoin
68,644.69
(
0.20%
)
Post# of 796
Next 10
Reply Private New
Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

lostcowboy

Send PM Follow Ignore
Followers 23
Posts 1677
Boards Moderated 1
Alias Born 01/31/2002

lostcowboy

Member Level

Re: BowlerBob post# 712

Monday, 07/29/2013 8:50:10 AM

Monday, July 29, 2013 8:50:10 AM

Post# of 796
Hi Bob, not sure you can get 9% gain per year, I have not run the numbers.
Are you sure you want to sell at 30%, why not 50%, just wondering.

About your ARR, in excel you would want to use the IRR function, but I don't know how to set that up.
I ran your numbers on my financial calculator.
I put in a positive $245,188.26 as the FV(future value,) -$1,000.00 as the pmt(payment), 156 as N(number of payments), and calculated for I/Y(interest rate per year).
I got a interest of 6.56% for the 13 years.
Hope that helps.

Come see me at Systematic Investing group #board-966 lets talk formula plans.

Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Last Read Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

Join the InvestorsHub Community

Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.

Sign Up