must answer everything and show work!
Cupter 17 Asaiganent Excel Template. Dee 10792003 Part2\&3 \begin{tabular}{|c|c|c|c|} \hline lavestincat & 4. NPY & Inital Inveriturent & 1 \\ \hline \multicolumn{4}{|l|}{BA} \\ \hline \multicolumn{4}{|l|}{CB} \\ \hline \multirow{2}{*}{\multicolumn{4}{|c|}{ c }} \\ \hline & & & \\ \hline & Rank & & \\ \hline Qeestion 6 & 01 & 12 & p3 \\ \hline A. Simple Rlake of Return & & & \\ \hline b. Paback Friad & & O & \\ \hline c. Net Resent Value & & & \\ \hline \&. Ieternal Rate of Retura & & & \\ \hline \end{tabular} Quention? Quevision 8 AGEC 271 Chapter 17 Assignment Excel Template Due 1029/2023 Part 1 1. Calculate the Future Value of $1,000 in 10 years with a 5% interest rate compounded yearly, ( 3 points) 2. Calculate the Present Value of $1,000 in 5 years with a 10% discount rate compounded yeurly. ( 3 points) Ch. 17 Assignment Due 10/29/2023 60 points Part I: Present Value verse Future Value Show your work for partial credit. 1. Calculate the Puture Value of $1,000 in 10 years with a 5% interest rate compounded yearly. (3 points) 2. Calculate the Present Value of $1,000 in 5 years with a 10% discount rate compounded yearly. (3 points) Part 2: Investment Analysis For Part 2, open the "Chapter 17 Assignment Bxcel Template". Use the given Net Cash Revenues for each of the $450,000 investments (here is no Terminal Value) to find the following: 1. Find the Gross Revenue, Net Revenue, and Average Net Revenue for each investment using the Net Cash flows given on the on the Chapter 17 Assignment Bxcel Template. ( 9 points) 2. Find the Simple Rate of Retum (SRR) for each investment ( 6 points) 3. Find the Payback Period for each investment. ( 6 points) 4. Find the Net Present Valne (NPV) for each investment using a 12% discount rute. You will need to create a discounted cashflow for each investment. (15 points) 5. Find the Intemal Rate of Retum (IRR) for each investment using the function available in Brcel. (6 points) Answer the following questions: 6. Rank the best investment using: ( 4 points) a. Simple Rate of Retum b. Rayback Period c. Net Present Value d. Internal Rate of Return 7. What does the value calculated for NPV mean? How should we interpret it? (4 points) 8. What does the value calculated for IRR menn? How should wo interpret it? (4 points) A belp video will be released towards the end of the week, but if you bave questions before that please let me know