After purchasing the apartment, Seth receives a street, sewer, and gutter assessment for $12,500 due in 2 years. How much would he have to invest today in a CD paying, 2%, compounded semiannually, to fully pay the assessment in 2 years (Write your answer in this cell.) Show each step taken to obtain your answer. Press ALT + Enter to insert a line break within each cell. A = p*(1+R) R= 2/2 = 1 or 0.01 A=p*(1+R) Fill in the information from the Case Study in cells D63 - D66. Use Excel's Present Value equation to determine how much he will need to invest to pay the assessment in 2 years