One year from today you must make a payment of $4,000. To prepare for this payment, you plan to make 2 equal quarterly deposits (at the end of Quarters 1 and 2) in a bank that pays 6% nominal interest, compounded quarterly. How large must each of the two payments be?

calculate in Excel. show all work