please follow the instructions and answer the questions with excel formulas for the ones needed.

Chapter 5 Excel Problems ( Sinved You're trying to save to buy a new $225,000 Ferrari. You have $45,000 today that can be, invested at your bank. The bank pays 4.8 percent annual interest on its accounts. How long will it be before you have enough to buy the car? Complete the following analysis. Do not hard code values in your calculations. You have just received notification that you have won the $2 million first prize in the Centennial Lottery. However, the prize will be awarded on your 100 th birthday (assuming you're around to collect), 80 years from now. What is the present value of your windfall if the appropriate discount rate is 7.5 percent? Complete the following analysis. Do not hard code values in your calculations. Your answer should be a positive value. With a Series EE U.S. Treasury bond, you pay a particular amount today of, say, $25, and the bond accrues interest over the time you hold it In an interesting (and important) wrinkle, if you hold the bond for 20 years, the Treasury promises to "step up" the value to double your cost. That is, if the $25 bond you purchased and all the accumulated interest earned are worth less than $50, the Treasury will automatically increase the value of the bond to $50 a. Assume you purchased a $50 face value bond, what is the exact rate of return you would earn if you held the bond for 20 years until it doubled in value? b. If you purchased a $50 face value bond and the current interest rate is 10 percent per year, how much would the bond be worth in 10 years? c. Ten years from now, instead of cashing the bond in for its then current value, you docide to hold the bond unti it doubles in face value. What rate of return will you eam over the last 10 years