Please show me how to do this in Excel, and show calculations with any notes that are appropriate to understand the calculation.

In the question, it is given that ESPN is currently paying the NFL $1.1 billion per year for eight year. The net present worth which is discounted at 9% interest rate for eight years is calculated using the following formula: The net present worth of this investment: NPV = A( P / A,i,n) NPV = $1,100, 000, 000 ( P / A, 9%,8) NPV = $1,100, 000, 000 x 5.535 NPV = $6, 088, 500, 000 Therefore, the net present worth of the investment is $6,088,500,000.Home Insert Draw >> ? Tell me Share A - Conditional Format as T Clipboard Font Alignment Number Cell Styles B15 X V fx A B C D E 1 ESPN 2 Discount 9% W 4 Period Cash Flow 5 0 0 1 1100000000 2 1100000000 3 1100000000 10 00 4 1100000000 10 5 1100000000 11 6 1100000000 12 7 1100000000 13 8 1100000000 14 15 INPV 16 17 18