the excel portion is just a reference . The top portion is the question. Professor did not provide any other information.

You are offered an investment with the following conditions: The cost of the investment is 1,000. The investment pays out a sum X at the end of the first year, t1 rate of 10% per year for 11 years. If your discount rate is 15%, calculate the smallest X which wo the asset. For example, as you can see in the following display, NPV is negative: B D 1 Incremental rate 10% 2 Discount rate 15% 3 Initial Payment $ 100.00 4 NPV $(173.18941) 5 6 Year CFS 7 0 $ (1,000.00) 8 1 $ 100.00 =B3 9 2 $ 110.00 =B8*(1+$B$1) 10 3 $ 121.00 =B9*(1+$B$1) 4 $ 133.10 5 $ 146.41 6 $ 161.05 14 7 $ 177.16 15 8 $ 194.87 16 9 $ 214.36 17 10 $ 235.79 18 11 $ 259.37 12 $ 285.31 0 11 12 13 19