Build a spreadsheet that will calculate PV$,$ FV$,$ N$,$ PMT$,$ or r given the other $4$ inputs. The goal is to create something that can be copied to solve the questions below. You will use the following built in functions, PV$,$ FV$,$ PMT$,$ NPER, and RATE.

You place $$5,000$ in an account earning an annual interest rate of $6\%,$ compounded annually.

$($a$)$ How much will you have in $2$ years if all interest is reinvested in the account?

$($b$)$ How would this change if the account was compounded monthly?

$($c$)$ In each case, what amount would you have you instead invested for $4$ years?