Consider a contract that guarantees a payment of $4,100 2 years and 6 months (30 months) from now, $4,109 32 months from now, and then payments continuing once every two months and growing at the same rate. The contract guarantees a total of 105 payments. If the risk-free interest rate is 1.35% per year with semiannual compounding, what is today's value of the contract?

Create an Excel file with your solution