Hi, Could you please help me calculate the present value of the following cash flow stream, with the following interest rates? IMPORTANT: I really want to understand how to arrive at the answer. Could you please tell me the formula you would use on an Excel spreadsheet to account for the varying interest rates?

a.Year 1 = $100,000 8%

b.Year 2 = $150,000 6%

c.Year 3 = $200,000 10%

d.Year 4 = $200,000 4%

e.Year 5 = $150,000 6%

f.Years 6 =$100,000 4%

g. Year 7 =$100,000 4%

h. Year 8 =$100,000 4%

I. Year 9 =$100,000 4%

j. Year 10 =$100,000 4%