In: Finance
Julian was given a gold coin originally purchased for $1 by his great-grandfather 50 years ago. Today the coin is worth $450. The rate of return realized on the sale of this coin is approximately equal to
| Solution: | ||
| The rate of return realized on the sale of this coin is approximately equal to 13% | ||
| Working Notes: | ||
| present value = PV = $1 deposited 50 years ago | ||
| rate = i = ?? =rate of return realized on the sale | ||
| Period=n = nper = 50 is no of years | ||
| FV= Future value at end of 50 years =$450 value after 50 years | ||
| Future value FV =PV x (1+i)^n | ||
| 450 =1 x (1+ i)^50 | ||
| i= 450^(1/50) - 1 | ||
| i= 0.129963071 | ||
| i= 0.1300 | ||
| i= 13.00% | ||
| By Excel method | ||
| present value = PV = -$1 deposited 50 years ago as it was cash outflow | ||
| rate = i = ?? | ||
| Period=n = nper = 50 is no of years | ||
| PMT = $0 the annual deposit which is not done so ZERO | ||
| FV= Future value at end of 50 years =$450 value after 50 years | ||
| EXCEL | ||
| =RATE(nper,pmt,pv,fv) | ||
| =RATE(50,0,-1,450) | ||
| 0.129963071 | ||
| 13.00% | ||
| Please feel free to ask if anything about above solution in comment section of the question. | ||