How to calculate APR on asset appreciation

Question

When I search for APR calculators, I only find mortgage and credit repayment calculators.

I am looking for the opposite. I want to calculate APR on asset appreciation.

I bought something for $15.k in 1993 and it is now estimated at between $31 and $42k. How do I calculate what the APR return on investment is?

Is there a formula? An online calculator? How would I do it in Excel?

score 1 · Accepted Answer · edited Feb 25 '19 at 11:45

1

In 25 years, the asset went from 15 to 31-42.

(31/15)^(1/25)= 1.02946 or 2.946% CAGR
(42/15)^(1/25)= 1.04204 or 4.204% CAGR

Of course, a CAGR to 3 decimal places is absurd when your asset value has a value of $36.5+/- 15%.

Looking at the numbers I'd have guessed "3-4%/yr" The notation I used is what you'd plug into a spreadsheet, FYI.

edited Feb 25 '19 at 11:45

mhoran_psprep

answered Feb 25 '19 at 10:06

Thanks, Joe. That's great. If I can find something paying more, then I will see the asset, else retain it. – Mawg says reinstate Monica Feb 25 '19 at 10:17
1

No problem! Keep in mind, this question may be a duplicate, and members may vote to close. I am on my cell phone and can't easily search. – JTP - Apologise to Monica Feb 25 '19 at 10:31
It didn't look like a duplicate when I searched. – Mawg says reinstate Monica Feb 25 '19 at 10:45

1 Answers1