Hi, please provide steps and formulas for Excel and check if these are correct. I need to understand this well for class so please explain well why some can be negative lile PMT pr how FV is different and thanks. Application Time! Facts about lessica - Complete the following TVM questions (Q3-Q7). Here you will be provided with additional guidance, use the dropdown boxes for '
a-c
' to help calculate the TVM problem.\ \\\\table[[\\\\table[[Here you],[te the TVM]],,\\\\table[[Hint A negative sign can also result in],[what you're solving for]],\\\\table[[Hint:
1=
Annually,],[
2=
Semi-Annually,],[
4=
Qte.,
12=
Application Time! Facts about ressica - Complete the following TVM questions (Q3-Q7). Here you will be provided with additional guidance, use the dropdown boxes for ' a - c ' to help calculate the TVM problem. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \begin{tabular}{l} Here you \\ te the TVM \end{tabular} & & \begin{tabular}{c} Hint A negative sign can also result in \\ what you're solving for \end{tabular} & \begin{tabular}{l} Hint 1= Annuolly, \\ 2= Semi-Annually, \\ 4= Ote. 12= \\ Monthly \end{tabular} & \begin{tabular}{l} Note RATE =%/ \\ Compounding \end{tabular} & \begin{tabular}{l} Note NPER * \\ Compounding \# \end{tabular} & & & & \\ \hline \multirow[t]{2}{*}{\begin{tabular}{l} in value at \\ restment be \end{tabular}} & \begin{tabular}{l} a) Solving For? (select \\ from dropdown) \end{tabular} & \begin{tabular}{l} b) Which input is negative? (type \\ TVM input(s) below) \end{tabular} & \begin{tabular}{l} c) Compounding \\ Number (select \\ from dropdown) \end{tabular} & RATE & NPER & PMT & & PV & FV \\ \hline & FV & PV & 1 & 3.50% & 5.00 & 10 & 5 & 6,000.00 & =FV(F24,G24,H24 \\ \hline \begin{tabular}{l} $4000 to \\ iterest on \end{tabular} & \begin{tabular}{l} a) Solving For? (select \\ from dropdown) \end{tabular} & \begin{tabular}{l} b) Which input is negative? (type \\ TVM input(s) below) \end{tabular} & \begin{tabular}{l} c) Compounding \\ Number (select \\ from dropdown) \end{tabular} & RATE & NPER & PMT & & PV & \\ \hline & RATE & FV & 1 & 5.74% & 4 & 0 & 5 & 3.200 .00 & 4,000.00 \\ \hline \end{tabular} LG2-Q5 Jessica would like to open a savings account. How many years will it take $2500 to grow to \$4500 with an interest rate of 3.0% ? a) Solving For? (select from dropdown) b) Which input is negative? (type TVM input(s) below) = RATE (G27,H27, = NPER(F30, H30,- 130,130)