*Please post excel formula*

The "Brasher doubloon," which was featured in the plot of the Raymond Chandler novel, The High Window, was sold at auction in 2018 for a reported $5.5 million 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 sale7 At what annual rate did the coin appreciate from 1979 until 20187 At what annual rate did the coin appreciate 2 from its minting to the 2018 sale? 3 4 Input area: 5 6 Original minting year 1787 7 First sale year 1979 8 Second sale year 2018 9 Original value $15 10 First sale price $430,000 11 Second sale price $5,500,000 12 13 (Use cells A6 to 811 from the given information to complete this question.) 14 15 Output area: 16 17 Rate of return 18 From minting to first sale 5.49% 19 Between first and second sale 20 From minting to second sale + 31 A Graded Worksheet +