How to do this on excel using FV/PV functions: You need to have $3,000 in order to make a down payment on a car in 3 years. In order to achieve that goal, how much do you need to deposit in a bank today if the bank pays 3% interest compounded semiannually?