IN EXCEL FORMULA AND BE CLEAR PLEASE. THANK YOU!

A B D E F G H I J 2 " 3 The Brasher doubloon," which was featured in the plot of the Raymond Chandler novel The High Window, was sold at auction 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? 4 5 6 7 8 Original minting year First sale year Second sale year Original value First sale price Second sale price 1787 1979 2014 $ 15 $ 430,000 $ 4,582,500 9 10 11 12 13 14 Complete the following analysis. Do not hard code values in your calculations. 1 2 3 H s sus 9 15 16 17 Rate of return To first sale Between first and second sale To second sale 18 19