Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Neena wants to accumulate ?$18,000 in a fund earning? 3

Neena wants to accumulate ?$18,000 in a fund earning? 3

Finance

Neena wants to accumulate ?$18,000 in a fund earning? 3.6% compounded? semi-annually. How much must she deposit at the end of each year for eight? years?

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

Computation of Annual Deposit using PMT Function in Excel:

=pmt(rate,nper,pv,-fv)

Here,

PMT = Annual Deposit = ?

Rate = 3.6%/2 = 1.8% compounded semiannually

Nper = 8 Years*2 = 16 Periods 

PV = 0

FV = $18,000

Substituting the values in formula:

=pmt(1.8%,16,0,-18000)

PMT or Annual Deposit = $980.79

So, She must deposit $980.79 at the end of each year for eight years.