QRB501 University of Phoenix Time Value of Money Cases Paper

User Generated

Wpnzc1

Business Finance

QRB501

University of Phoenix

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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & 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 ...

Similar Content

Related Tags