Exercise $5-2($Algo$)$ Future value; single amount $($LO $5-2)$

The four people below have the following investments.

$\backslash$table$[[,\backslash$table$[[$Invested$],[$Amount$]],\backslash$table$[[$Interest$],[$Rate$]],$Compounding$],[$Jerry$,$$$12,500,12\%,$Quarterly$],[$Elaine$,15,500,10,$Semiannually$],[$George$,22,500,6,$Annually$],[$Kramer$,18,500,8,$Annually$]]$

Required:

$1-$a$.$ Calculate the future value at the end of five years. $($FV of $$1$; PV of $$1,$ FVA of $$1,$ and PVA of $$1)$

$1-$b$.$ Who has the greatest investment accumulation?

Complete this question by entering your answers in the tabs below.

Req $1A$

Calculate the future value at the end of five years.

Note: Use Excel or a financial calculator. Round your answers to $2$ decimal places.