Beginning three months from now, you want to be able to withdraw $3,700 each qua

Question

Beginning three months from now, you want to be able to withdraw $3,700 each quarter from your bank account to cover college expenses over the next four years. Required: If the account pays .77 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? (Enter rounded answer as directed, but do not use rounded numbers in intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)

Please answer in PV formula in Excel if possible.

Explanation / Answer

Present value of annuity = P×[1-(1÷(1+r)^n))]÷r

r is interest rate

P is payment per period

n is number of payments

= $3,700×[1-(1÷(1+0.77%)^(4×4)))]÷0.77%

= $55,498.02

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.