Calculate the present value of each year's cash flow by dividing by (1 + discount rate)^number of years. Sum all present values to find the total value of projected cash flows, which in this ...

You need to have the zero-coupon yield curve information to calculate forward rates, even in Microsoft Excel.