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?

mhoran_psprep · Accepted Answer · 2019-02-25 11:45:03Z

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.

mhoran_psprep

145k15 gold badges198 silver badges410 bronze badges

answered Feb 25, 2019 at 10:06

173k34 gold badges297 silver badges560 bronze badges

Thanks, Joe. That's great. If I can find something paying more, then I will see the asset, else retain it.
– Mawg
Commented Feb 25, 2019 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 ♦
Commented Feb 25, 2019 at 10:31
It didn't look like a duplicate when I searched.
– Mawg
Commented Feb 25, 2019 at 10:45

Add a comment |

1 Answer 1