Question 4

Samantha will need $12,000 annually for four years to complete her undergraduate studies. (One year from today, she will withdraw the first $12,000.) Her parents deposit an amount today in an investment paying 6% annual interest, which will provide the needed $12,000 disbursements. How much will be in the account immediately after she makes the first withdrawal? Use excel TVM functions to solve.