TASK I $($Total $5$ points$)$: Present Value of DELAYED Perpetual Annuity

Show your spreadsheet solution for the following problem, using the Time Value of Money $($TVM$)$ Excel

function in no more than two cells.

The Bank Trust will pay $$8,000$ per year indefinitely with the first payment $6$ years from today. If

you earn an annual return of $3\%$ in this account, find the value of these payments today.

An example of a spreadsheet organization for Part II of the assignment is below.TASK I $($Total $5$ points$)$: Present Value of DELAYED Perpetual Annuity

Show your spreadsheet solution for the following problem, using the Time Value of Money $($TVM$)$ Excel

function in no more than two cells.

The Bank Trust will pay $$8,000$ per year indefinitely with the first payment $6$ years from today. If

you earn an annual return of $3\%$ in this account, find the value of these payments today.

An example of a spreadsheet organization for Part II of the assignment is below.