Please do in excel. Thanks in advance.

3. Find the values of an annuity due of $80 for 5 years with 12% APR and annual compounding. Requirement: Calculation and output sections must update automatically with changes in data input. ? Data Input In this problem a period is a Cash Flow / Period Discount Rate / Period Number of Periods Type your answer in B45. $80 12% 5 Calculation using a time line approach Effective Discount Rate / Period Period Cash Flows Present Value of Each Cash Flow Sum of all PVCFS 12% 0 $80 $80 $322.99 1 $80 $71 2 $80 $64 3 $80 $57 4 $80 $51 5 $0 $0 Output Present Value $322.99 Continue with #3. Use data inputs provided to find the following Use the PMT function to find the payment Use the RATE function to find the discount rate Use the NPER function to find the number of periods $80.00 12% 5 3. Find the values of an annuity due of $80 for 5 years with 12% APR and annual compounding. Requirement: Calculation and output sections must update automatically with changes in data input. ? Data Input In this problem a period is a Cash Flow / Period Discount Rate / Period Number of Periods Type your answer in B45. $80 12% 5 Calculation using a time line approach Effective Discount Rate / Period Period Cash Flows Present Value of Each Cash Flow Sum of all PVCFS 12% 0 $80 $80 $322.99 1 $80 $71 2 $80 $64 3 $80 $57 4 $80 $51 5 $0 $0 Output Present Value $322.99 Continue with #3. Use data inputs provided to find the following Use the PMT function to find the payment Use the RATE function to find the discount rate Use the NPER function to find the number of periods $80.00 12% 5