Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / How much will you have saved after 6 years by contributing $1,200 at the end of each year if you expect to earn 11% on the investment?

How much will you have saved after 6 years by contributing $1,200 at the end of each year if you expect to earn 11% on the investment?

Finance

How much will you have saved after 6 years by contributing $1,200 at the end of each year if you expect to earn 11% on the investment?

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

Computation of Accumulated Amount using FV Function in Excel:

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

Here,

FV = Future Value or Accumulated Amount = ?

Rate = 11%

Nper = 6 years

PMT = $1,200

PV =

Substituting the values in formula:

=-fv(11%,6,1200,0)

FV or Future Value or Accumulated Amount = $9,495.43

So, you will have saved $9,495.43 after 6 years by contributing $1,200 at the end of each year if you expect to earn 11% on the investment.