2 1 5. Calculating present values - Excel FORMULAS DATA REVIEW FILE Si INSERT HOME VIEW PAGE LAYOUT Calibri 11 A % Cells Editing Paste BIU- Alignment Number Conditional Format as Cell Formatting Table Styles Clipboard Font Styles A B D E F G H 1 2 3 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 100th birthday (assuming you're around to collect), 80 years from now. What is the present value of your windfall if appropriate discount rate is 7.5 percent? 4 $ S 6 7 8 9 Future value Years Discount rate 2,000,000 80 7.5% 10 11 Complete the following analysis. Do not hard code values in your calculations. You answer should be a positive value. Present value 12 13 14 15