Question

Beginning three months from now, you want to be able to withdraw $3,600 each quarter from your bank account to cover college expenses over the next four years. If the account pays .76 percent interest per quarter, how much do you need to have in your bank account today to meet your expense needs over the next four years

Answer 1

$54,042.77

Step-by-step explanation:

For computing the amount need to have in your bank today we need to apply the present value formula i.e to be shown in the attachment

Given that,

Future value = $0

Rate of interest = 0.76%

NPER = 4 quarters × 4 = $3,600

PMT = $3,600

The formula is shown below:

= -PV(Rate;NPER;PMT;FV;type)

So, after applying the above formula, the present value is $54,042.77