Use excel formula

Calculating present values - Excel ? X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 A A % Paste BIU - Alignment Number Cells Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A A1 A D E F G H I 1 2 3 You just won the TVM Lottery. You will receive $1 million today plus another 10 annual payments that increase by $450,000 per year. Thus, in one year, you receive $1.45 million. In two years, you get $1.9 million, and so on. If the appropriate interest rate is 7 percent, what is the present value of your winnings? 4 5 6 7 8 9 10 11 Year 0 1 2 3 4 5 6 7 8 9 10 Cash flow 1,000,000 1,450,000 1,900,000 2,350,000 2,800,000 3,250,000 3,700,000 4,150,000 4,600,000 5,050,000 5,500,000 $ $ $ $ $ $ $ $ $ $ $ 12 13 14 15 16 17 18 19 Discount rate 7% 20 21 Sheet1 READY 100% Attempt(s) Hint KIS Calculating present values - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 - A Paste BIU- % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Clipboard Font A A1 fx A B D E F G H I 10 11 12 $ 13 3 4 5 6 7 8 9 10 $ 2,350,000 2,800,000 3,250,000 3,700,000 4,150,000 4,600,000 5,050,000 5,500,000 14 15 16 $ $ $ 17 18 19 Discount rate 7% 20 21 22 Complete the following analysis. Do not hard code values in your calculations. 23 24 Value of all cash flows beyond today 25 26 27 Value of all cash flows including cash flow today 28 29 30 31 32 Sheet1 + READY 100% Attempt(s) Hint