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.

In each of the past 30 years, Sam has deposited $4,500 in his savings account at the beginning of each year

Finance Jun 22, 2021

In each of the past 30 years, Sam has deposited $4,500 in his savings account at the beginning of each year. A risk-averse investor, during that period his conservative investment choices averaged a 4.65% annual return. Hugo made the same sized deposits in his own account at the beginning of each year, but he was more of a risk-seeker. Over the same 30 year period, due to his more aggressive investment choices Hugo averaged an investment return of 6.12%. How did Sam's account fare compared to Hugo's, in terms of future value? Did Sam make poor choices? Discuss. 

 

Expert Solution

First we calculate Future Value using FV Function in Excel:

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


For Sam:

Here,

FV = Future Value = ?

Rate = 4.65%

Nper = 30 years 

PMT = 4500

PV = 0

Type = 1 (at the beginning) 

Substituting the values in formula:

=fv(4.65%,30,-4500,0,1)

FV or Future Value = 294,708.11

 

 

For Hugo:

Here,

FV = Future Value = ?

Rate = 6.12%

Nper = 30 years 

PMT = 4500

PV = 0

Type = 1 (at the beginning) 

Substituting the values in formula:

=fv(6.12%,30,-4500,0,1)

FV or Future Value = 385,604.90

 

As we can see, Sam account has lower future value compared to Hugo. It is because of Lower rate of return for Sam's account.

High expected returns in the market are almost always accompanied by a lot of risk. So, Sam seems to have less tolerance for risk than Hugo does. But we can not say that Sam made a poor choice.

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