# Compounded rate of return on land?

#### gidsy

##### Board Regular
Hi There,

I am trying to work out the best way to return the Compounded rate of return for the increase in land value.

So for a property purchased for 64,000 35 years ago is now worth 1,900,000. That's an increase of 52,457 pa. What is the Compounded rate of return?

There must be a function, I just can't find it.

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

#### acw

##### MrExcel MVP
Hi

Compound Annual Growth Rate (CAGR)

(Vtn/Vt0)^(1/tn)-1

Where Vtn is the value at time n (1900000)
Vt0 is the starting value (64000)
tn is the number of years (35)

I get 10.17%

HTH

Tony

#### gidsy

##### Board Regular
Thanks for that....Is that a standard function...I do not have that one...I'm on version 2002

#### acw

##### MrExcel MVP
Hi

I just gave you the formula required to calculate from the data given. If you look up compound annual growth rate in Excel help, it will give you the XIRR function, but I don't think it will work for you example data.

Tony

Replies
0
Views
1K
Replies
0
Views
742
Replies
6
Views
961
Replies
1
Views
185
Replies
7
Views
381

1,191,196
Messages
5,985,230
Members
439,950
Latest member
Xearo96

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back