repsond must be entered as a formula

The "Brasher doubloon," which was featured in the plot of the Raymond Chandler novel The High Window, was sold at auction in 2014 for $4,582,500. The coin had a face value of $15 when it was first issued in 1787 and had been previously sold for $430,000 in 1979. At what annual rate did the coin appreciate from its minting to the 1979 sale? What annual rate did the 1979 buyer earn on his purchase? At what annual rate did the coin appreciate from its minting to the 2014 sale? 1787 1979 Original minting year First sale year Second sale year Original value First sale price 2014 $ 15 $430,000 Second sale price $4,582,500