Find the future values of the following ordinary annuities: A. FV of $400 paid each 6 months for 5 years at a nominal rate of 12% compounded semiannually. B. FV of $200 paid each 3 months for 5 years at a nominal rate of 12% compounded quarterly. C. These annuities receive the same amount of cash during the 5-year period and earn interest at the same nominal rate, yet the annuity in part b ends up larger than the one in part A. Why does this occur?

**Please answer on EXCEL SPREADSHEET.

PLEASE USE THE MEATHOD BELOW.

Note: According to the equation shown in cell C8, the input values must be entered in a spench order: I/Y, N, PMT, FV, and PMT type. PVA(D) As describ the BGN1 PV of an Annuity Due-PVA(DUE)