PLEASE PROVIDE THE EXCEL FORMULA

You have an investment opportunity that promises to pay you $$20,000$ at a future date. You can earn $5\%$

compounded semiannually on similar investments. How much would you be willing to invest assuming you will

receive the amount at the end of $($a$)$ three years, $($b$)$ four years, or $($c$)$ five years?

Formulas should include the $=$ PV function and return a POSITIVE value.

Future value

Additional amount received at the end of each semiannual period

Interest rate

Compounded semiannually

Compounding periods per year

If$,$ in addition to the $$20,000$ future value, you receive an additional $$1,000$ at the end of each semian

period, how much would you be willing to invest assuming the investment spans $($a$)$ three years, $($b$)$ four years, or

$($c$),$ five years?

Formulas should include the $=$ PV function and return a POSITIVE value.

Additional amount received at the end of each semiannual period

$$1,000$