If an engineer invests $10,000 now and $10,000 each year for the next 20 years, which of the following Excel functions should be used to determine how much will be in the account immediately after the last deposit, provided the account grows by 10% per year?
Multiple-choice question.
=PV(0.1,20,-10000)
=PV(0.1,21,-10000)
=FV(0.1,21,-10000)
=FV(0.1,20,-10000)