WINE DEPOT Wine Depot has several questions for you that Excel can help answer. 1 The Wine Depot is planning for the future and would like you to prepare a present value analysis. Using the file ch7-07, complete a present value analysis for the following situations. Save the file as ch7-07_student_name (replacing student_name with your name). Print this completed worksheet. The Wine Depot would like to know the following: a. How much they would have to pay at the end of each year, assuming a 3 percent rate of return, to yicld $85,000 at the end of 7 years. b. How much they would have at the end of 7 years if they invested $8,000 today earning 3 percent per year. c. How much they would have at the end of 7 years if they invested $550 at the end of each year earning 3 percent per year. d. How much they would have to invest today to have $12,500 in 7 years, earning 3 percent per year. \begin{tabular}{|c|c|c|c|c|c|c|} \hline 25 & Investment value in future: & & Year & Interest & Annuity & Investment \\ \hline 26 & & & 0 & & & \\ \hline 27 & Term (in years): & 7 & 1 & & & \\ \hline 28 & Current annuity investment: & ($550.00) & 2 & & & \\ \hline 29 & Interest rate: & 3% & 3 & & & \\ \hline 30 & & & 4 & & & \\ \hline 31 & & & 5 & & & \\ \hline 32 & & & 6 & & & \\ \hline 33 & & & 7 & & & \\ \hline 34 & & & & +8 & & \\ \hline 35 & Invest now: & & Year & Interest & Investment & \\ \hline 36 & & & 0 & & & \\ \hline 37 & Term (in years): & 7 & 1. & & & \\ \hline 38 & Futureneed: & $12,500.00 & 2. & & x2 & \\ \hline 39 & Interest rate: & 3% & 3 & & & \\ \hline 40 & & & 4 & & - & \\ \hline 41. & -5 & & 5 & & +1 & \\ \hline 42 & & & 6 & + & & \\ \hline 43 & & & 7 & +1 & x2 & \\ \hline 44 & & & & & & \\ \hline \end{tabular}