show calculations in excel

What is the present value of a 5-year ordinary annuity of $100 plus an additional $500 at the end of Year 5 if the interest rate is 6%? 4 6 Interest rate Year Ann Pmt $100 $100 $100 $100 $100 S500 $600 U Lump Sum Total CFs $100 $100 $100 $100 2 NPV 6 What is the present value of the following uneven cash flow stream: S0 at Time 0, $100 at the end of Year 1 (or at 8 s 8%? 0Interest rate Time 1), $200 at the end of Year 2, $0 at the end of Year 3, and $400 at the end of Year 4, assuming the interest rate 896 Year CFs SO $100 $200 SO $400 3 4 8