Help with "rate" function

[Colson Whitehead]

I'm trying to calculate the rate of return on an investment in bitcoin.
The purchase was made in 2010 when the price was 0.0008 (8/100 of a cent). 10 years later it was worth $21,000.
Using the rate function, NPER 10; PV (0.0008); FV 21000. The result is #NUM!.
I believe the the answer is 315% but excel cant solve it?
The help function says to change the Iterative Calculation, but I'm still getting #NUM! Any thoughts?

 

[Colson Whitehead]

I'm trying to calculate the rate of return on an investment in bitcoin.
The purchase was made in 2010 when the price was 0.0008 (8/100 of a cent). 10 years later it was worth $21,000.
Using the rate function, NPER 10; PV (0.0008); FV 21000. The result is #NUM!.
I believe the the answer is 315% but excel cant solve it?
The help function says to change the Iterative Calculation, but I'm still getting #NUM! Any thoughts?

NPER	10
Rate	#NUM!​
PV	(0.0008)
PMT	-
FV	21,000

 

[StephenCrump]

Welcome to the Forum!

	A	B	C
1	Start value	0.0008
2	End value	21,000
3	No of years	10
4
5	Compound growth rate	452%	p.a.
6		452%	p.a.
Sheet1

Cell Formulas
Range	Formula
B1	B1	=0.08/100
B5	B5	=RRI(B3,B1,B2)
B6	B6	=(B2/B1)^(1/B3)-1

(Although your start price looks a little low?)

 

[Peter_SSs]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Help with "rate" function
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.