Question: please answer in EXCEL FORMULA begin{tabular}{|c|c|c|c|c|c|c|c|c|} hline 4 & A & B & D & E & F & G & H & I
\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline 4 & A & B & D & E & F & G & H & I \\ \hline \multicolumn{9}{|l|}{1} \\ \hline & \multicolumn{4}{|c|}{Beginningthreemonthsfromnow,youwanttobeabletowithdraw$3,000eachquarterfromyourbankaccounttocovercollegeexpensesoverthenextfouryears.Iftheaccountpays.57percentinterestperquarter,howmuchdoyouneedtohaveinyourbankaccounttodaytomeetyourexpenseneedsoverthenextfouryears?} & O & & & \\ \hline 3 & & & & & & & & \\ \hline 4 & Input area: & & & & & & & \\ \hline \multicolumn{9}{|c|}{ Quarterly withdrawal } \\ \hline 6 & Quarterly withdrawal & $3,000 & 3 & & & & & \\ \hline 7 & Periods per year & 4 & & & & & & \\ \hline 8 & Number of years & 4 & & & & & & \\ \hline 9 & Interest rate per quarter & 0.57% & & & & & & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
