what excel formula should i use to solve this problem? Your client has been accumulating money on college fund for years to be able to pay for his son's education. This year his son is accepted to college and he might continue his education after graduation. Leaving aside issues of inflation and annual increase in the cost of tuition and fees, the funds would last 7 years with equal semi-annual beginning-of-the-period payments of $35,236 each, with the first payment to be made today. If the annual interest rate is 14.49 percent compounded semi-annually, how much has your client accumulated on college fund? (You need to calculate present value of college payments)