Question

You have been accepted into college. The college guarantees that your tuition will not increase for the four years you attend college. The first $10,000 tuition payment is due in six months. After that, the same payment is due every six months until you have made eight payments. The college offers a bank account that allows you to withdraw money every six months and has a fixed APR of 4% (semiannual) guaranteed to remain the same over the next four years. How much money must you deposit today if you intend to make no further deposits and would like to make all the tuition payments from this account, leaving the account empty when the last payment is made?

Answer 1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.