Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Net Present Value of Payouts The NPV of a series of values is calculated using a discount rate applied to those values. Apply the NPV

Net Present Value of Payouts The NPV of a series of values is calculated using a discount rate applied to those values. Apply the NPV function to the series of expected benefit payouts using .075 as the discount rate. You can hard-code the discount rate. How would you calculate this in Excel? Please show calculation and logic used in excel, so I understand. Below are the values:

Year Expected Benefit Payouts
2016 NA
2017 $19,661,882,100.00
2018 $19,909,120,629.23
2019 $20,162,051,346.58
2020 $20,420,680,083.92
2021 $20,685,015,994.25
2022 $20,955,071,470.68
2023 $21,230,862,069.61
2024 $21,512,406,437.74
2025 $21,799,726,242.91
2026 $22,092,846,108.56
2027 $22,391,793,551.78
2028 $22,696,598,924.58
2029 $23,007,295,358.62
2030 $23,323,918,712.87
2031 $23,646,507,524.45
2032 $23,975,102,962.33
2033 $24,309,748,783.82
2034 $24,650,491,293.79
2035 $24,997,379,306.50
2036 $25,350,464,110.00
2037 $25,709,799,432.87
2038 $26,075,441,413.41
2039 $26,447,448,571.04
2040 $26,825,881,779.94
2041 $27,210,804,244.76
2042 $27,602,281,478.45
2043 $28,000,381,281.99
2044 $28,405,173,726.15
2045 $28,816,731,135.01
2046 $29,235,128,071.33

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Economics Of Money Banking And Financial Markets

Authors: Frederic S. Mishkin

6th Edition

0321113624, 978-0321113627

More Books

Students also viewed these Finance questions