Business Finance
QRB501 University of Phoenix Time Value of Money Cases Paper

QRB501

University of Phoenix

Question Description

Purpose of Assignment

The purpose of this assignment is to provide students an opportunity to apply the concepts of time value of money covered in Ch. 13 to integrated case studies.

Assignment Steps

Resources: Financial Valuation (Time-Value of Money) Cases Excel® Template

Save the Financial Valuation (Time-Value of Money) Cases Excel® Template to your computer.

Read the instructions on the first tab.

Complete the three cases located in the template.

Click the Assignment Files tab to submit your assignment.

Note: Grades are awarded based upon individual contributions to the Learning Team assignment. Each Learning Team member receives a grade based upon his/her contributions to the team assignment. Not all students may receive the same grade for the team assignment.

Final Answer

Hi, Please check the attached file for details, let me know if you have any questions, thank you. James,

Barry learned in an online investment course that he should start investing as soon
as possible. He had always thought that it would be smart to start investing after he
finishes college and when his salary is high enough to pay the bills and to have money
left over. He projects that will be 5–10 years from now. Barry wants to compare the
difference between investing now and investing later. A financial advisor who spoke
to Barry suggested that a Roth IRA (Individual Retirement Account) would be a good
investment for him to start.
1. If Barry purchases a $2,000 Roth IRA when he is 25 years old and expects to
earn an average of 6% per year compounded annually over 35 years (until he is
60), how much will accumulate in the investment?
Initial Investment (PV)
Quoted Rate
Compounding Frequency
Number of compoundings (m)
Quoted Rate divided by m = RATE
Number of Years
NPER (Num. of years * m)
Ending Amount (FV)

$2,000
6.00%
Annually
1
6.0000%
35
35
$15,372.17

Choose one
For Quarterly, type 4; for semiannually, type 2; for annu

2. If Barry doesn’t put the money in the IRA until he is 35 years old, how much
money will accumulate in the account by the time he is 60 years old using the same
return of 6%? How much less will he earn because he invested 10 years later?
Initial Investment (PV)
Quoted Rate
Compounding Frequency
Number of compoundings (m)
Quoted Rate divided by m = RATE
Number of Years
NPER (Num. of years * m)
Ending Amount (FV)

$2,000
6.00%
Annually
1
6.0000%
25
25
$8,583.74

Difference in amount earned
FV Part 1 minus FV Part 2

$6,788.43

Choose one
For Quarterly, type 4; for semiannually, type 2; for annu

3. Barry knows that the interest rate is critical to the speed at which your investment grows.
For instance, if $1 is invested at 2% compounded annually, it takes approximately 34.9 years
to double. If $1 is invested at 5% compounded annually, it takes approximately
14.2 years to double.
Determine how many years it takes $1 to double if invested at 10% compounded ...

JamesM847 (3637)
Duke University

Anonymous
Thanks for the help.

Anonymous
Outstanding. Studypool always delivers quality work.

Anonymous
Tutor was very helpful and took the time to explain concepts to me. Very responsive, managed to get replies within the hour.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors