Using Excel, Create a new worksheet for each problem. You must construct a timeline for each problem in Excel. The timeline must include a column for the period, a column for the given cash flow and a column for the present value or future value. Each row represents a period. You must solve each problem two different ways. The first is using a formula (for example, PV = FV/(1+r)^t). The second is using the Excel function (for example, =PV(...) Time line needed!!!!

Question: You inherit $10,000 from your grandparents on your 21st birthday. How much money will you have on your 67th birthday if you invest the money and earn 8.25% per year?

Examples of what needed:

\begin{tabular}{lrc|} \hline Eture Value & 250,000 & PV=FV/(1+i)t \\ \hline interest Rate & 5% & 132580.34 \\ Number of Periods & 13 & \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline Period & CF & PV or FV & & \\ \hline 1 & 5000 & 4,545.45 & PV(0.1,A2,0 & 0,82,0 \\ \hline 2 & 6000 & & & Shen \\ \hline 3 & 7000 & & & \\ \hline 4 & 0 & & & \\ \hline 5 & 0 & & & \\ \hline \end{tabular}