4
votes
1answer
385 views

How do we correctly sum up returns

Assume I have done 8 trades and calculated the profit (or loss) of each trade: Balance PnL 100 102 2.00% 105 2.94% 103 -1.90% 101 -1.94% 98 -2.97% 97 ...
5
votes
3answers
568 views

What is the “rule of 70” or “rule of 72” with regards to investment, and how do I apply it?

What is the "rule of 72" (sometimes called the "rule of 70") with regards to investment, and how do I apply it?
4
votes
3answers
118 views

How can I calculate yearly interest of my investment gain?

I'm trying to figure out the yearly interest of a potential investment. Lets say I invested $10 000, 13 days later i cash out and I now have $10 500. The interest here is 4,76% for 13 days. But can I ...
1
vote
0answers
80 views

What are the standard industry practices or disclosures for computing compounded interest on retail deposit accounts in the United States?

I'm seeking to understand how my bank calculates the interest on my various deposit accounts (Money Market, Interest Checking, Savings, Certificate of Deposit) in order to simulate and predict it to a ...
3
votes
3answers
164 views

I'm a programmer and need a formula for calculating overal ROI [duplicate]

I'm programming a web app to track my hedge fund performance. I'd like to find my overall ROI for all time. If I had a beginning balance and my current balance then finding the ROI is easy. For ...
1
vote
1answer
122 views

Calculating required rate of return for an income-generating savings account

Say someone has £1m. They want it to generate an increasing level of income, starting from £25k in year 1, and increasing at a rate 7% + inflation pa, such that the end value of the savings after 20 ...
3
votes
3answers
125 views

What is the theory behind Rick Van Ness's risk calculation in the video about diversification?

In the video, Rick Van Ness states the following scenario: Stock A has a 7% return with +/- 1% risk Stock B has a 3.5% return with +/- 0.5% risk Stock A and B are perfectly negatively correlated. ...
10
votes
2answers
1k views

Is there a term that better describes a compound annual growth rate (CAGR) when it is negative?

When calculating rates of return for an investment or portfolio over time, whether to report or compare performance, one frequently calculates the Compound Annual Growth Rate (CAGR). I've got a ...
4
votes
1answer
1k views

How can I calculate a “running” return using XIRR in a spreadsheet?

I should say that I'm not married to XIRR, I just want to calculate the return on a running basis in a column next to dates, deposits and balances. Here's a screenshot of a simplified spreadsheet in ...
2
votes
6answers
948 views

Help me understand the oddity of percentage gains and losses?

If you start with $100K, and you get a 50% gain, it's $150K. Then, you get a 50% loss: now it's $75K. Reverse the order (i.e. lose 50%, gain 50%), it's the same thing (a 25% loss). So, 50% up then ...
8
votes
2answers
205 views

How do I account for newly added money when computing my rate of return?

I have a simple spreadsheet where I track the balance in my investment account. What should I do to handle new deposits in the account? For example: End of Day 1: balance = $100 End of Day 2: ...
4
votes
2answers
389 views

Discussing real estate appreciation: Compound vs. simple interest?

When people say real estate has appreciated 8 % over the past 5 years, do they mean 8 % compounded annually? or simple interest annually?
3
votes
3answers
2k views

How to calculate the rate of return on selling a stock?

How to calculate the rate of return on selling a stock?