In formula please

B D E F G H 1 2 3 You have just received notification that you have won the $1 million first prize in the Centennial Lottery. However, the prize will be awarded on your 100th 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 9 percent? 5 6 7 $ Future value Years Interest rate 1,000,000 80 8 9 9% 10 11 12 Complete the following analysis. Do not hard code values in your answers. Your answer should be a positive value. 13 14 15 Present value =D7/(1+D9) D8 A B D E F G H - 1 2 3 4 You have just made your first $5,000 contribution to your retirement account. Assuming you earn a return of 11 percent and make no additional contributions, what will your account be worth when you retire in 45 years? What if you wait 10 years before contributing? (Does this uggest an investment strategy?) 5 on Complete the following analysis. Do not hard code values in your answers. All answers should be positive values. 7 8 9 10 11 Present value 5,000 5,000 Years 45 35 Interest rate Future value 11% $547,651.21 11% =E12 12 13 14 15 16