Not sure how to solve this question preparing for a test in financial modeling excel sheet is a must with this question You are valuing an investment...

Not sure how to solve this question preparing for a test in financial modeling excel sheet is a must with this question

You are valuing an investment that willpay you $12,000 the first year, $14,000 the second year,

$17,000 the third year, $19,000 the four

th year, $23,000 the fifth year, and $29,000 the sixth year (all

payments are at the end of each year). What it the va

lue of the investment to you now is the appropriate

annual discount ra

te is 11.00%?