accounting/ advanced math question on excel

A. Calculate the compound amount and compound interest. \begin{tabular}{|l|r|} \hline Original Principal & $5,000.00 \\ \hline Rate & 12.4% \\ \hline First Year's Interest & \\ \hline Base Amount for Next Year & \\ \hline Second Year's Interest & \\ \hline Compound Amount & \\ \hline Compound Interest & \\ \hline \end{tabular} Directions: a. In Cell B7, enter the formula to calculate the interest for the first year. b. In Cell B8, enter the formula to calculate the new amount. c. In Cell B9, enter the formula to calculate the interest for the second year. d. In Cell B10, enter the formula to compute the Compound Amount. e. In Cell B11, enter the formula to compute the Compound Interest. f. Format dollar amounts for Currency, 2 Decimal places, and $. B. Compute the compound amount and compound interest. Directions: a. In Cell B29, enter the formula to compute the Quarterly Interest Rate. Copy the formula into Cells C29 through E29. Format rates as Percentage with 0 Decimal Places. b. In Cell B30, enter the formula to calculate the Quarterly Interest Amount. c. In Cell B31, enter the formula to calculate the Quarterly Compound Amount. d. In Cell C26, key the Quarterly Compound Amount shown in Cell B31. e. Copy the formula in Cell B30 into Cell C 30 to calculate the Second Quarterly interest Amount. f. Copy the formula in Cell B31 into Cell C 31 to calculate the Second Quarterly Compound Amount. 9. In Cell D26, key the Quarterly Compound Amount shown in Cell C31. h. Continue the steps to complete the Third and Fourth Quarter calculations. i. In Cell E32, key the Fourth Quarter Compound Amount shown in Cell E31. j. In Cell E33, enter the formula to calculate the Compound Interest. k. Format dollar amounts for Currency, 2 Decimal places, and $. I. Save the file as ch10ex08a.xisx