In: Finance
A coin that was featured in a famous novel sold at auction in 2014 for $2,654,800. The coin had a face value of $2 when it was issued in 1793 and had previously been sold for $380,000 in 1972. At what annual rate did the coin appreciate from its first minting to the 1972 sale? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Rate of return % What annual rate did the 1972 buyer earn on his purchase? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Rate of return % At what annual rate did the coin appreciate from its first minting to the 2014 sale? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places
1
Future value = present value*(1+ rate)^time |
380000 = 2*(1+Interest rate/100)^179 |
Interest rate % = 7.03 |
Using Calculator: press buttons "2ND"+"FV" then assign |
FV =380000 |
PV =-2 |
N =179 |
PMT = 0 |
CPT I/Y |
Using Excel |
=RATE(nper,pmt,pv,fv,type,guess) |
=RATE(Interest rate/100,,-2,380000,,) |
2
Future value = present value*(1+ rate)^time |
2654800 = 380000*(1+Interest rate/100)^42 |
Interest rate % = 4.74 |
Using Calculator: press buttons "2ND"+"FV" then assign |
FV =2654800 |
PV =-380000 |
N =42 |
PMT = 0 |
CPT I/Y |
Using Excel |
=RATE(nper,pmt,pv,fv,type,guess) |
=RATE(Interest rate/100,,-380000,2654800,,) |
3
Future value = present value*(1+ rate)^time |
2654800 = 2*(1+Interest rate/100)^221 |
Interest rate % = 6.59 |
Using Calculator: press buttons "2ND"+"FV" then assign |
FV =2654800 |
PV =-2 |
N =221 |
PMT = 0 |
CPT I/Y |
Using Excel |
=RATE(nper,pmt,pv,fv,type,guess) |
=RATE(Interest rate/100,,-2,2654800,,) |