The effective annual discount rate is 5% (r = .05) at all maturities. What is the present value of a stream of payments that starts at $100 at t = 1 (time in years) and grows at 3 percent for 5 years (to t = 6), then growing at 10 percent for 10 years (to t = 16), then growing thereafter at 1 percent?  The effective annual discount rate is 5% (r = .05) at all maturities. What is the present value of a stream of payments that starts at $100 at t = 1 (time in years) and grows at 3 percent for 5 years (to t = 6), then growing at 10 percent for 10 years (to t = 16), then growing thereafter at 1 percent?  

How would you set this problem up in excel?