On January 1, 2012, the Ford shop issued bonds in the amount of $10,000 that will be paid in three years. Interest of $400 is payable semiannually each January 1 and July 1 with the first interest payment at the end of the period, on July 1 of the current year. The market rate of interest is 10%.

Determine the excel Formula for PV of Single Sum, and PV of ordinary annuity.