Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

You are graduating from college at the end of this semester and after reading the The Business of Life box in this? chapter, you have decided to invest ?$5,900 at the end of each year into a Roth IRA for the next 40years

Finance Oct 09, 2020

You are graduating from college at the end of this semester and after reading the The Business of Life box in this? chapter, you have decided to invest

?$5,900 at the end of each year into a Roth IRA for the next 40years. If you earn 8 percent compounded annually on your? investment, how much will you have when you retire in 40 years? How much will you have if you wait 10 years before beginning to save and only make 30 payments into your retirement? account?

 

How much will you have if you wait 10 years before beginning to save and only make

30 payments into your retirement? account?

Expert Solution

Computation of Accumulated Amount using FV Function in Excel:

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

 

When You retire in 40 years:

Here,

FV = Accumulated Amount or Future Value = ?

Rate = 8%

Nper = 40 years

PMT = $5,900

PV = 0

Substituting the values in formula:

=-fv(8%,40,5900,0)

FV or Accumulated Amount or Future Value = $1,528,433.16

 

When You retire in 30 years:

Here,

FV = Accumulated Amount or Future Value = ?

Rate = 8%

Nper = 30 years

PMT = $5,900

PV = 0

Substituting the values in formula:

=-fv(8%,30,5900,0)

FV or Accumulated Amount or Future Value = $668,370.95

Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment