F$4$

$fx$

A

B

C

D

E

F

G

Due:

Name:

Down load excel file "excel project $1$ student copy" from blackboard under Excel.

Fill in yellow areas, answers questions and submit in Brightspace.

$$ For $1.$ Use excel formula to calculate FV simple interest formula: $=C_{15}^{**}(1+D15**E15)$

For $6.$ MUST use function key in FORMULAS tab then Fins Create Excel formula to calculate answer to question $3,5,$ and $7.1.$ Assignment: Determine the future value of a deposit of $$1500,$

that is left in a bank for $5$ years at $3\mathrm{.}5\%$ use simple interest

$2.$ Assignment: Determine the future value of a caposit of $$1500,$ that is left in a bank for $5$ years at $3\mathrm{.}5\%$ use compounded annually

$\backslash$table$[[,,,,$dea annuali$],[$End of$,$Principle,Rate,time,Future Value$],[$year$,p_{?},$i$,$n$,$FV or S$],[5,,,,],[$ince$,$tween $F{i}_1,$re Valu,,$]]$

What is the difference between Future Value simple interest and compound interest at the end of $5$ years?

Assignment: Determine the future value of a deposit of $$1500,$ that is left in a bank for $5$ years at $3\mathrm{.}5\%$ compounded semi$-$annually

What is the difference between the future value with $3\mathrm{.}5\%$ compound annually and semi$-$annual at the end of $5$ years?

Assignment: Determine the future value of a deposit of $$1500,$

that is left in a bank for $5$ years at $3\mathrm{.}5\%$ compounded monthly

$($Must use function key in FORMULAS tab then Financial group then fv$.$ ADD negative sign$)$

$\backslash$table$[[$End of$],[\frac{\text{y}\text{e}\text{a}\text{r}}{?}$